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)
​

Borrows

Cosmos Tables

Last modified 1yr ago

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)