niloUntitled Query
Updated 2022-11-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
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