0-MIDdaily stats volume
Updated 2024-07-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select BLOCK_TIMESTAMP::date as date
,sum(PRICE) as volume
,avg(PRICE) as avg_volume
,count(distinct BUYER_ADDRESS) as buyers
,count(distinct SELLER_ADDRESS) as sellers
,count(distinct TOKENID) as nft_sold
,count(distinct TX_HASH) as sale_count
,sum(volume)over(order by date) as total_sale_volume
from base.nft.ez_nft_sales
group by 1
QueryRunArchived: QueryRun has been archived