elsinadaily activity
Updated 2024-11-01
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
›
⌄
SELECT
date_trunc('day', block_timestamp) as date,
count(DISTINCT buyer_address) as buyer_count,
count(DISTINCT seller_address) as seller_count,
count(DISTINCT tx_hash) as tx_count,
count(distinct project_name) as collection_count,
sum(price_usd) as total_vol,
sum(TOTAL_FEES_USD) as total_total_fee,
avg(TOTAL_FEES_USD) as avg_total_fee,
sum(PLATFORM_FEE_USD) as total_platform_fee,
avg(PLATFORM_FEE_USD) as avg_platform_fee,
sum(CREATOR_FEE_USD) as total_creator_fee,
avg(CREATOR_FEE_USD) as avg_creator_fee,
sum(TX_FEE_USD) as total_tx_fee,
avg(TX_FEE_USD) as avg_tx_fee,
avg(price_usd) as avg_nft_price,
min(price_usd) as min_nft_price,
median(price_usd) as median_nft_price,
max(price_usd) as max_nft_price,
sum(total_vol) over (order by date) as cum_total_vol,
sum(tx_count) over (order by date) as cum_tx_count
from
base.nft.ez_nft_sales
where
date between '2024-10-01' and '2024-10-31'
group by
date
order by
date asc
QueryRunArchived: QueryRun has been archived