nsa2000total volume
Updated 2022-11-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
›
⌄
with priceTb as (
select block_hour::date as p_date,
avg (price_usd) as algo_Price
from algorand.core.ez_price_pool_balances
group by 1
)
select
NFT_MARKETPLACE,
count(distinct tx_group_id) as "Sales Cnt",
count(distinct purchaser) as "Buyers Cnt",
count(distinct collection_name) as "Collections Cnt",
count(distinct nft_asset_id) as "NFTs Cnt",
sum(total_sales_amount) as "Sales Volume(Algo)",
sum(total_sales_amount*algo_Price) as "Sales Volume($)",
avg(total_sales_amount) as "Avg Sales Volume(Algo)",
avg(total_sales_amount*algo_Price) as "Avg Sales Volume($)",
median(total_sales_amount) as "Med Sales Volume(Algo)",
median(total_sales_amount*algo_Price) as "Med Sales Volume($)",
min(total_sales_amount) as "Min Sales Volume(Algo)",
min(total_sales_amount*algo_Price) as "Min Sales Volume($)",
max(total_sales_amount) as"Max Sales Volume(Algo)",
max(total_sales_amount*algo_Price) as "Max Sales Volume($)"
from algorand.nft.ez_nft_sales a join priceTb b on a.block_timestamp::date = b.p_date
where total_sales_amount > 0
AND block_timestamp >= CURRENT_DATE - INTERVAL '{{Past_Weeks}} week'
GROUP by 1
ORDER by 2 DESC
Run a query to Download Data