DiamondIn the News - 11. New Year, New Activity? Flow - Top 10 Daily Sales copy
    Updated 2023-08-21

    with nft_sales as (
    select
    split(nft_collection,'.')[2] as name,
    *
    from flow.core.ez_nft_sales
    where block_timestamp >= {{start_date}} and block_timestamp <= {{end_date}}
    )

    select
    name,
    count(distinct tx_id) as n_txns,
    sum(price) as sale_volume,
    count(distinct buyer) as n_wallets_daily
    from nft_sales
    group by name
    order by n_txns desc
    limit 10


    Run a query to Download Data