Within the Beanstalk Subgraph, there are many key areas where point in time snapshots are updated and saved for ease of access in the future. These entities contain the current point in time values for their respective period, along with the delta values from the previous snapshot. Delta values are represented as distinct fields. There are both hourly and daily period snapshots for the following base entities:
Silo
SiloAsset
Field
PodMarketplace
These Snapshot entities are not currently included in the parameter tables below.
SiloHourlySnapshot
SiloDailySnapshot
SiloAssetHourlySnapshot
SiloAssetDailySnapshot
FieldHourlySnapshot
FieldDailySnapshot
PodMarketplaceHourlySnapshot
PodMarketplaceDailySnapshot
Metadata about Beanstalk and the subgraph.
Information about Season level data.
Silo level data for either Beanstalk or individual Farmers is stored here. Use the Beanstalk contract address to view protocol level values.
This entity holds asset specific totals and data for tokens found within the Silo.
Data on what was used and the resulting vAPYs found within the Silo are stored here.
Field level data. Each Farmer and Beanstalk as a whole has their own Field.
The Farmer entity is unique in the fact that it is comprised completely of derived fields. This is to aid in the exploration and querying of the information on a specific address.
Individual Silo Deposit data. Updated upon Withdrawals for the net Deposited amounts and BDV.
Withdrawal level data. Updated to flag whether a Withdrawal has been claimed.
All details related to a specific Plot.
Aggregated data surrounding the Pod Market.
Details regarding a specific Pod Listing.
Details regarding a specific Pod Order.
Fill data for both Listings and Orders.
Global Fertilizer data.
ID level information for Fertilizer tokens. BPF = Beans Per Fertilizer.
Balance details by Farmer and Fertilizer token.
Field | Type | Description |
---|---|---|
Field | Type | Description |
---|---|---|
Field | Type | Description |
---|---|---|
Field | Type | Description |
---|---|---|
Field | Type | Description |
---|---|---|
Field | Type | Description |
---|---|---|
Field | Type | Description |
---|---|---|
Field | Type | Description |
---|---|---|
Field | Type | Description |
---|---|---|
Field | Type | Description |
---|---|---|
Field | Type | Description |
---|---|---|
Field | Type | Description |
---|---|---|
Field | Type | Descriptoin |
---|---|---|
Field | Type | Description |
---|---|---|
Field | Type | Description |
---|---|---|
Field | Type | Description |
---|---|---|
Field | Type | Description |
---|---|---|
Field | Type | Description |
---|---|---|
id
ID!
Smart contract address of the protocol's main contract (Factory, Registry, etc)
name
String!
Name of the protocol, including version. (e.g. Uniswap v3)
slug
String!
Slug of protocol, including version. (e.g. uniswap-v3)
schemaVersion
String!
Version of the subgraph schema, in SemVer format (e.g. 1.0.0)
subgraphVersion
String!
Version of the subgraph implementation, in SemVer format (e.g. 1.0.0)
methodologyVersion
String!
Version of the methodology used to compute metrics, loosely based on SemVer format (e.g. 1.0.0)
lastUpgrade
BigInt!
Timestamp of the latest diamondCut call
seasons
[Season!]!
Season specific data
silo
Silo!
Silo level data
field
Field!
Field level data
lastSeason
Int!
Last Season
activeFarmers
[String!]!
Array of the addresses for all active Farmers in the Silo
farmersToUpdate
[String!]!
Array of the addresses for all Farmers that had Silo transfers and need Stalk/Seeds/Roots updated
id
ID!
Season number
beanstalk
Beanstalk!
Beanstalk contract address
season
Int!
Season number in Int
form for sorting
createdAt
BigInt!
Block timestamp when sunrise
was called
price
BigDecimal!
Bean price during last sunrise
beans
BigInt!
Total Bean supply
marketCap
BigDecimal!
Bean market cap
deltaB
BigInt!
Time weighted deltaB
deltaBeans
BigInt!
Change in Bean supply
rewardBeans
BigInt!
Amount of Beans minted during sunrise
incentiveBeans
BigInt!
Amount of Beans paid to sunrise
caller
harvestableIndex
BigInt!
New Harvestable index for the Season
id
ID!
Address for the Farmer or Beanstalk
beanstalk
Beanstalk!
Beanstalk contract address
farmer
Farmer
Farmer address if applicable
whitelistedTokens
[String!]!
Tokens on the Deposit Whitelist
assets
[SiloAsset!]!
Derived field linking to SiloAsset
depositedBDV
BigInt!
Current BDV of Deposited assets in the Silo
stalk
BigInt!
Current Stalk in the Silo
plantableStalk
BigInt!
Current Stalk not yet claimed via Plant
seeds
BigInt!
Current total Seeds
roots
BigInt!
Current total Roots
beanMints
BigInt!
Cumulative total of all Bean mints sent to the Silo
activeFarmers
Int!
Current number of active Farmer addresses with non-zero Stalk
hourlySnapshots
[SiloHourlySnapshot!]!
Derived field linking to SiloHourlySnapshot
dailySnapshots
[SiloDailySnapshot!]!
Derived field linking to SiloDailySnapshot
id
ID!
Silo ID - Asset token address
silo
Silo!
Silo ID for which this asset belongs
token
String!
Token address of the asset
depositedBDV
BigInt!
Current BDV of Deposits
depositedAmount
BigInt!
Current token amount of Deposits
withdrawnAmount
BigInt!
Current token amount of Withdrawals
farmAmount
BigInt!
Current token amount held as an Internal Balance
hourlySnapshots
[SiloAssetHourlySnapshot!]!
Derived field linking to SiloAssetHourlySnapshot
dailySnapshots
[SiloAssetDailySnapshot!]!
Derived field linking to SiloAssetDailySnapshot
id
ID!
The Season of the yield
season
Int!
Season when calculated
beta
BigDecimal!
Beta used for EMA
u
Int!
u value used for EMA
beansPerSeasonEMA
BigDecimal!
Bean EMA for the season
twoSeedBeanAPY
BigDecimal!
Bean APY for two Seeds per BDV
twoSeedStalkAPY
BigDecimal!
Stalk APY for two Seeds per BDV
fourSeedBeanAPY
BigDecimal!
Bean APY for four Seeds per BDV
fourSeedStalkAPY
BigDecimal!
Stalk APY for four Seeds per BDV
createdAt
BigInt!
Block timestamp of creation
id
ID!
Address for the Farmer or Beanstalk
beanstalk
Beanstalk!
Beanstalk contract address
farmer
Farmer
Farmer address if applicable
season
Int!
Latest Season updated
temperature
Int!
Current Temperature offered for Sowing
realRateOfReturn
BigDecimal!
Temperature / Bean Price
numberOfSowers
Int!
Cumulative number of Sowers
numberOfSows
Int!
Cumulative number of Sows
sownBeans
BigInt!
Cumulative number of Sown Beans
plotIndexes
[BigInt!]!
Array of Unharvestable Plot indexes. Used when updating Harvestable amounts during sunrise
.
unharvestablePods
BigInt!
Current number of Unharvestable Pods
harvestablePods
BigInt!
Current number of Harvestable Pods
harvestedPods
BigInt!
Current number of Harvested Pods
soil
BigInt!
Current amount of available Soil
podIndex
BigInt!
Current Pod index for new Plots
podRate
BigDecimal!
Current Pod Rate: Unharvestable Pods / Bean supply
hourlySnapshots
[FieldHourlySnapshot!]!
Derived field linking to FieldHourlySnapshot
dailySnapshots
[FieldDailySnapshot!]!
Derived field linking to FieldDailySnapshot
id
ID!
Farmer's address
silo
Silo
Derived field to Silo
deposits
[SiloDeposit!]!
Derived field to SiloDeposit
withdraws
[SiloWithdraw!]!
Derived field to SiloWithdraw
field
Field
Derived field to Field
plots
[Plot!]!
Derived field to Plot
listings
[PodListing!]!
Derived field to PodListing
orders
[PodOrder!]!
Derived field to PodOrder
fills
[PodFill!]!
Derived field to PodFill
fertilizers
[FertilizerBalance!]!
Derived field to FertilizerBalance
id
ID!
Account - Token Address - Season
farmer
Farmer!
Farmer address
token
String!
Token contract address
season
Int!
Season of Deposit
amount
BigInt!
Current token amount Deposited
depositedAmount
BigInt!
Originally Deposited token amount
withdrawnAmount
BigInt!
Withdrawn token amount
bdv
BigInt!
Current BDV of Deposit
depositedBDV
BigInt!
Original BDV of a Deposit
withdrawnBDV
BigInt!
Withdrawn BDV of Deposit
hashes
[String!]!
Transaction hashes included in original Deposit
createdAt
BigInt!
Block timestamp of first Deposit
updatedAt
BigInt!
Block timestamp of last update
id
ID!
Account - Deposit Token - Current Season
farmer
Farmer!
Farmer address
token
String!
Token contract address
withdrawSeason
Int!
Season withdraw initiated
claimableSeason
Int!
Season when claimable
claimed
Boolean!
Flag for if withdrawal has been claimed
amount
BigInt!
Token amount being withdrawn
hashes
[String!]!
Transaction hashes included in this season's withdrawal
createdAt
BigInt!
Block timestamp of first withdrawal
id
ID!
Plot index
field
Field!
Field to which this Plot belongs
farmer
Farmer!
Farmer that owns this Plot
source
PlotSource!
Enum for the source of this Plot:
SOW
, HARVEST
, TRANSFER
listing
PodListing
Any associated listing of this Plot
season
Int!
Season of creation
creationHash
String!
Transaction hash of creation
createdAt
BigInt!
Block timestamp of creation
updatedAt
BigInt!
Block timestamp when updated
index
BigInt!
Plot index
beans
BigInt!
Beans used to Sow, if any
pods
BigInt!
Total Pods in the Plot
sownPods
BigInt!
Total Pods Sown, if any
temperature
Int!
Temperature when Plot was sown
harvestablePods
BigInt!
Number of Pods that are Harvestable
harvestedPods
BigInt!
Number of Pods that have been Harvested
fullyHarvested
Boolean
Flag for if a Plot has been fully Harvested
id
ID!
Contract address of Beanstalk
season
Int!
Current Season of the Pod Market
listingIndexes
[BigInt!]!
Indexes of Listed {lots
orders
[PodOrder!]!
Active Pod Order IDs
allListings
[PodListing!]!
Derived field for all historical PodListing
entities
allOrders
[PodOrder!]!
Derived field for all historical PodOrder
entities
listedPods
BigInt!
Current cumulative Pods Listed for sale
filledListedPods
BigInt!
Current cumulative Pod Listings Filled
expiredListedPods
BigInt!
Current cumulative Pod Listings that expired
cancelledListedPods
BigInt!
Current cumulative Pod Listings that are Cancelled
availableListedPods
BigInt!
Current total of Pods available for purchase
orderedPods
BigInt!
Current cumulative Pod Orders created
filledOrderedPods
BigInt!
Current cumulative Pod Orders that were Filled
cancelledOrderedPods
BigInt!
Current cumulative Pod Orders that were Cancelled
podVolume
BigInt!
Current cumulative Pod volume
beanVolume
BigInt!
Current cumulative Bean volume
hourlySnapshots
[PodMarketplaceHourlySnapshot!]!
Derived field to PodMarketplaceHourlySnapshot
dailySnapshots
[PodMarketplaceDailySnapshot!]!
Derived field to PodMarketplaceDailySnapshot
id
ID!
Account - Plot Index
podMarketplace
PodMarketplace!
Pod Market where this Listing was made
historyID
String!
Unique string to pull and display all historical activity
plot
Plot!
Plot being Listed
farmer
Farmer!
Farmer Listing this Plot
createdAt
BigInt!
Block timestamp at creation
updatedAt
BigInt!
Block timestamp of last update
status
MarketStatus!
Enum for valid status:
ACTIVE
, FILLED
, FILLED_PARTIAL
, CANCELLED
, CANCELLED_PARTIAL
, EXPIRED
fill
PodFill
Any associated Fill
originalIndex
BigInt!
Original index of the Plot Listed
index
BigInt!
Current index of Plot Listed
start
BigInt!
Start within Plot for Listing
amount
BigInt!
Amount of Pods Listed
originalAmount
BigInt!
Total amount of original Listing
remainingAmount
BigInt!
Remaining amount left to be Filled
filledAmount
BigInt!
Amount Filled on this Listing
filled
BigInt!
Total amount Filled from original Listing
cancelledAmount
BigInt!
Amount Cancelled
pricePerPod
Int!
Market v1 price per Pod
minFillAmount
BigInt!
Minimum amount needed to Fill this Listing
maxHarvestableIndex
BigInt!
Max Harvestable index before Listing expires
pricingFunction
Bytes
Market v2 pricing function
mode
Int!
Sale Bean mode (Internal/External)
pricingType
Int
Market v2 pricing type
creationHash
String!
Transaction hash at time of initial entity creation.
id
ID!
Order ID emitted by event
podMarketplace
PodMarketplace!
Marketplace used for Order
historyID
String!
Unique string to pull and display all historical activity
farmer
Farmer!
Farmer placing the Order
createdAt
BigInt!
Block timestamp at creation
updatedAt
BigInt!
Block timestamp at last update
status
MarketStatus!
Enum for valid status:
ACTIVE
, FILLED
, FILLED_PARTIAL
, CANCELLED
, CANCELLED_PARTIAL
, EXPIRED
fills
[PodFill!]!
Any associated PodFill
IDs
podAmount
BigInt!
V1 - Original amount of the Ordered Pods
beanAmount
BigInt!
V2 - Original amount of Beans used to Order Pods
podAmountFilled
BigInt!
Current Filled amount
beanAmountFilled
BigInt!
Bean amount Filled
minFillAmount
BigInt!
Minimum amount needed to Fill this Order
maxPlaceInLine
BigInt!
Max Place in Line for Pods to Fill the Order
pricePerPod
Int!
Market v1 price per Pod
pricingFunction
Bytes
Market v2 pricing function
pricingType
Int
Market v2 pricing type
creationHash
String!
Transaction hash at time of initial entity creation.
id
ID!
Beanstalk address - Order/Listing index - transaction hash
podMarketplace
PodMarketplace!
Marketplace associated with this Fill
createdAt
BigInt!
Block timestamp at creation
listing
PodListing
Associated Listing, if any
order
PodOrder
Associated Order, if any
from
String!
Account Filling the Listing/Order
to
Farmer!
Account Filling the Listing/Order
amount
BigInt!
Number of Pods Filled
index
BigInt!
Index of Plot transferred
start
BigInt!
Start of Plot transferred
costInBeans
BigInt
Total Beans used to Fill Listing/Order
id
ID!
Contract address for Fertilizer
supply
BigInt!
Total overall supply for Fertilizer tokens
tokens
[FertilizerToken!]!
Derived field to FertilizerToken
id
ID!
Total BPF for purchase
fertilizer
Fertilizer!
Fertilizer contract address
supply
BigInt!
Total supply for this humidity
humidity
BigDecimal!
Humidity paid for this ID
endBpf
BigInt!
Ending BPF on creation
startBpf
BigInt!
Starting BPF on creation
season
Int!
Season created
balances
[FertilizerBalance!]!
Derived field to FertilizerBalance
id
ID!
Fertilizer Token - Farmer address
fertilizerToken
FertilizerToken!
ID of Fertilizer token
farmer
Farmer!
Farmer that owns the Fertilizer
amount
BigInt!
Current balance of the token
id
ID!
Season being calculated
season
Int!
Current season
humidity
BigDecimal!
Current humidity for new fertilizer
outstandingFert
BigInt!
Current total fertilizer still outstanding
beansPerSeasonEMA
BigDecimal!
Current Bean EMA
deltaBpf
BigDecimal!
Current new beans per outstanding fertilizer
simpleAPY
BigDecimal!
Simplified APY adjusted for the length of time needed to return total principal and yield based on humidity
createdAt
BigInt!
Block timestamp at creation