Flipside Docs
Search…
Market Stats
Market Stats exist within the compound schema, as compound.market_stats
Field
Type
Description
block_hour
string
Market stats are aggregated by hour in UTC. date_trunc(‘hour’,block_timestamp) for joins on other tables
contract_name
string
market/cToken name
ctoken_address
address
market/cToken address (i.e. cUSDC)
underlying_contract
address
Address of the underlying token the market serves (i.e. USDC)
underlying_symbol
string
Symbol of the underlying token the market serves
token_price
number
Price of the underlying token (i.e. USDC)
ctoken_price
number
Price of the cToken (i.e. cUSDC)
reserves_token_amount
number
Reserves are amounts set aside by the market that can be used/affected by governance actions through proposals voted on by COMP holders
borrows_token_amount
number
Amount borrowed from the market
supply_token_amount
number
Amount (in terms of the cToken) supplied to the market through suppliers
supply_usd
number
Supply converted to USD values as of the hour recorded
reserves_usd
number
Reserves converted to USD values as of the hour recorded
borrows_usd
number
Borrows converted to USD values as of the hour recorded
comp_speed
number
COMP is a governance token distributed equally to both suppliers and borrowers (the idea being the users of the protocol are also the ones who should be able to vote on governance actions). Comp speed controls the rate at which comp is distributed to users of the market, per block
supply_apy
number
The supplier’s APY in terms of the underlying asset. It depends on the exchange rate between the cToken/underlying token (cUSDC/USDC). This is interest paid to the supplier for their stake
borrow_apy
number
The borrower’s APY in terms of the underlying asset. It depends on the exchange rate between the cToken/underlying token (cUSDC/USDC). This is interest paid by the borrower on their loan
comp_price
number
The price of the COMP governance token
comp_speed_usd
number
Comp distributed to markets converted to USD
comp_apy_borrow
number
The APY one can expect based on COMP governance tokens distributed (which in turn can be staked elsewhere, or used in voting)
Copy link