theericstoneUntitled Query
    Updated 2021-10-05
    select sum(price_usd) as usd_volume,
    sum(price) as eth_volume,
    date_trunc('day',block_timestamp) as date,
    coalesce(project_name,'unlabeled') as project_name
    from ethereum.nft_events
    where event_platform = 'opensea'
    and price_usd < 100000000
    and tx_currency in ('ETH','WETH')
    and block_timestamp > '2021-09-15'
    group by 3,4;
    Run a query to Download Data