hessTotal Numbers
Updated 2024-09-15
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
›
⌄
with price as ( select hour::date as day,
avg(price) as avg_price
from aptos.price.ez_prices_hourly
where symbol = 'APT'
and day >= '2024-01-01'
group by 1)
select
count(DISTINCT tx_hash) as "Transactions",
count(*) as "Sales",
count(DISTINCT buyer_address) as "Buyers",
count(DISTINCT seller_address) as "Sellers",
count(DISTINCT project_name) as "Collections",
count(DISTINCT platform_address) as "Platforms",
sum(total_price) as "Volume (APT)",
avg(total_price) as "Avg Price (APT)",
median(total_price) as "Median Price (APT)",
max(total_price) as "Max Price (APT)",
min(total_price) as "Min Price (APT)",
sum(platform_fee) as "Platform Fees (APT)"
from aptos.nft.ez_nft_sales
where project_name not in ('Cellana Voting Tokens')
and block_timestamp::date >= '2024-01-01'
QueryRunArchived: QueryRun has been archived