hessTop Collections By Number of Sales (Since January 2024)
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
28
29
30
31
›
⌄
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
project_name,
count(DISTINCT tx_hash) as "Transactions",
count(*) as "Sales",
count(DISTINCT buyer_address) as "Buyers",
count(DISTINCT seller_address) as "Sellers",
count(DISTINCT nft_address) 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','Aptos Subdomain Names V2')
and block_timestamp::date >= '2024-01-01'
group by 1
order by 4 desc
limit 8
QueryRunArchived: QueryRun has been archived