DiamondNFLAD - TEAM COIN (SF)
    Updated 2023-07-25
    -- forked from NFLAD - TEAM COINs @ https://flipsidecrypto.xyz/edit/queries/77eb60c3-b743-4c75-84a4-e268a0505a39

    Select
    date_trunc('day',block_timestamp) as "Date",
    nft_collection as "Wallet",
    count (tx_id) as "Daily Sales",
    sum (price) as "Daily Sales Volume ($USD)",
    sum("Daily Sales Volume ($USD)") over (order by "Date") as "Total Sales ($USD)"
    From flow.core.ez_nft_sales
    where nft_collection ILIKE 'A.329feb3ab062d289.NFL_NFT'
    and tx_succeeded = 'true'
    and block_timestamp between '2022-01-14' and '2022-01-15'
    and currency ilike 'A.ead892083b3e2c6c.DapperUtilityCoin'
    group by 1, 2
    order by 1 desc


    Run a query to Download Data