mrnnptrcSMP OKR
    Updated 2023-11-16
    select platform_name, currency_symbol, count(*)
    -- nft_address,
    -- project_name,
    -- platform_name,
    -- case
    -- when block_timestamp >= getdate() - interval '7 days' then 'L7D'
    -- else 'P7D'
    -- end as interval_tag,
    -- count(*) as sales_count,
    -- sum(price) as sales_volume_eth,
    -- min(price) as min_price_eth,
    -- count(distinct seller_address) as sellers,
    -- count(distinct buyer_address) as buyers,
    -- max(block_number) as latest_block
    from
    ethereum.nft.ez_nft_sales
    where
    nft_address = '0x5cc5b05a8a13e3fbdb0bb9fccd98d38e50f90c38'
    -- and currency_symbol in ('ETH', 'WETH')
    and block_timestamp >= getdate() - interval '14 days'
    group by
    1,
    2
    -- 3,
    -- 4,
    -- 5
    -- order by
    -- 1,
    -- 2,
    -- 3,
    -- 4,
    -- 5
    Run a query to Download Data