Common

Schema: Common

This schema contains datasets shared amongst multiple market sectors.

Sample Query

// Pull Bitcoin's full history for price, market cap, and volume
select 
  date, 
  price, 
  market_cap, 
  h24_volume 
from 
  common.daily_market_data 
where 
  coingecko_id = 'bitcoin' 
ORDER by 
  date DESC

Table name

Descriptions

PreviousBitcoin NextDeveloper Data

Last updated 27 days ago

This schema contains datasets shared amongst multiple market sectors.

Sample Query

// Pull Bitcoin's full history for price, market cap, and volume
select 
  date, 
  price, 
  market_cap, 
  h24_volume 
from 
  common.daily_market_data 
where 
  coingecko_id = 'bitcoin' 
ORDER by 
  date DESC

Table name

Descriptions

DAILY_MARKET_DATA

Price, Market Cap, and 24 hour Volume for all coins in the CoinGecko universe.