-- 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