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)
comp_apy_supply	number	The APY one can expect based on COMP governance tokens distributed (which in turn can be staked elsewhere, or used in voting)