niloUntitled Query
    Updated 2022-11-12
    select
    ---date_trunc('day',block_timestamp) as date,
    NFT_MARKETPLACE as marketplace,
    count(tx_group_id) as num_sale,
    count(distinct purchaser) as num_buyers,
    count (number_of_nfts) as num_nfts,
    count(nft_total_supply) as num_supply,
    sum(total_sales_amount) as volume
    from algorand.nft.ez_nft_sales
    where block_timestamp::date >= '2022-01-01'
    and collection_name = '{{collection}}'
    group by 1
    ---,2
    Run a query to Download Data