nsa2000evm19
    Updated 2023-01-14
    select
    --distinct PLATFORM_NAME,
    --PROJECT_NAME,
    date_trunc('day', block_timestamp) as date,
    CASE
    when date < '2023-01-01' then 'Before'
    when date >= '2023-01-01' then 'After'
    end as new_year,
    count(distinct TX_HASH) as sales,
    count(distinct seller_address) as sellers,
    count(distinct buyer_address ) as buyers,
    sum(PRICE_USD) as USD
    from ethereum.core.ez_nft_sales
    where event_type = 'sale'
    and date between'2022-12-17' and '2023-01-13'
    and CURRENCY_SYMBOL ilike 'ETH'
    group by 1,2
    order by 1 asc
    Run a query to Download Data