KaskoazulAlgorand NFT Marketplaces (2)
Updated 2022-11-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with nft_sales_timeframe as (
select s.*,
datediff('hour', s.block_timestamp, current_timestamp) as hour_diff,
total_sales_amount*p.price_usd as total_sales_amount_usd
from algorand.nft.ez_nft_sales s
left join algorand.defi.ez_price_pool_balances p
on date_trunc('hour', s.block_timestamp) = p.block_hour
where s.block_timestamp > CURRENT_DATE - 1 - {{Last_number_of_days}}
)
select nft_marketplace,
count(distinct tx_group_id) as sales,
count(distinct purchaser) as purchasers,
round(sum(total_sales_amount)) as volume,
round(sum(total_sales_amount_usd)) as volume_usd,
round(avg(total_sales_amount)) as average_price
from nft_sales_timeframe
group by 1
order by 1
Run a query to Download Data