theericstoneHot NFT Collections
    Updated 2023-03-09
    select
    project_name,
    sum(price_usd) as sales,
    count(token_id) as token_sales_this_week
    from ethereum.nft_events
    where event_type = 'sale'
    and block_timestamp > current_date - 7
    and event_platform = 'opensea'
    and project_name IS NOT NULL
    and project_name NOT IN ('opensea','ens')
    group by 1
    order by 3 desc;
    Run a query to Download Data