winnie-fsNFT platform sales query copy
    Updated 2024-07-12
    -- forked from NFT platform sales query @ https://flipsidecrypto.xyz/edit/queries/3a701680-7353-47d5-85a6-f43750930291

    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 '5 days'
    group by
    platform_name
    order by
    sales_volume desc
    limit
    {{numRows}}


    QueryRunArchived: QueryRun has been archived