ramishoowUntitled Query
    Updated 2022-12-11
    select BLOCK_TIMESTAMP::date TIME, sum(TOTAL_SALES_AMOUNT_USD) volume from algorand.nft.ez_nft_sales_fifa s
    --select BLOCK_TIMESTAMP::date TIME, sum(TOTAL_SALES_AMOUNT_USD) volume from algorand.nft.ez_nft_sales_fifa s
    join algorand.nft.ez_nft_metadata_fifa c on s.NFT_ASSET_ID = c.NFT_ASSET_ID
    where SALE_TYPE = 'mint' group by 1 order by 1

    Run a query to Download Data