winnie-fs2023-11-30 01:23 PM copy
    Updated 2023-12-04
    -- forked from 2023-11-30 01:23 PM @ https://staging.flipsidecrypto.xyz/edit/queries/6a229864-1dad-467d-9971-f815bdad5c95

    select
    platform_name,
    count(*) as sales_count,
    SUM(DISTINCT(price_usd)) as sales_volume
    from
    ethereum.nft.ez_nft_sales
    where block_timestamp > current_date - interval '30 days'
    group by platform_name
    order by sales_volume desc
    limit {{numRows}}


    QueryRunArchived: QueryRun has been archived