Links
Comment on page

Entities

All subgraph documentation is in development and not necessarily up to date. The Beanstalk Subgraph schema can be found here. The Bean Subgraph schema can be found here.

Snapshot Entity Note

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.

Overview

Beanstalk

Metadata about Beanstalk and the subgraph.
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

Season

Information about Season level data.
Field
Type
Description
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

Silo

Silo level data for either Beanstalk or individual Farmers is stored here. Use the Beanstalk contract address to view protocol level values.
Field
Type
Description
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

SiloAsset

This entity holds asset specific totals and data for tokens found within the Silo.
Field
Type
Description
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

SiloYield

Data on what was used and the resulting vAPYs found within the Silo are stored here.
Field
Type
Description
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

Field

Field level data. Each Farmer and Beanstalk as a whole has their own Field.
Field
Type
Description
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

Farmer

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.
Field
Type
Description
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

SiloDeposit

Individual Silo Deposit data. Updated upon Withdrawals for the net Deposited amounts and BDV.
Field
Type
Description
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

SiloWithdraw

Withdrawal level data. Updated to flag whether a Withdrawal has been claimed.
Field
Type
Description
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

Plot

All details related to a specific Plot.
Field
Type
Description
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

PodMarketplace

Aggregated data surrounding the Pod Market.
Field
Type
Description
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

PodListing

Details regarding a specific Pod Listing.
Field
Type
Description
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.

PodOrder

Details regarding a specific Pod Order.
Field
Type
Descriptoin
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