theericstoneUntitled Query
    Updated 2021-10-05
    select sum(price_usd) as volume_usd,
    sum(price) as volume_eth
    --date_trunc('day',block_timestamp) as date,
    --coalesce(project_name,'unlabeled') as project_name
    from ethereum.nft_events
    where event_platform = 'opensea'
    and project_name = 'BoredApeYachtClub'
    and block_timestamp > '2021-01-01'
    and tx_currency in ('ETH','ETH')
    --group by 2,3;
    Run a query to Download Data