nickpayiatis_Algorand NFT Marketplaces by ALGO Volume
    Updated 2022-11-16
    -- Click the Fork button in the top right to copy this query
    -- You can add parameters to your query in the bottom left. This allows the public to modify your query from the dashboard.


    select
    sale.nft_marketplace as "Marketplace",
    sum(total_sales_amount) as "ALGO Volume"
    from algorand.nft.fact_nft_sales sale
    where sale.block_timestamp > (CURRENT_DATE() - {{Last_num_of_days}})

    group by sale.nft_marketplace
    HAVING "Marketplace" is not null
    and "ALGO Volume" is not null
    order by "ALGO Volume" desc
    limit 20


    Run a query to Download Data