Updated 2022-10-03Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select case when block_timestamp >= '2022-08-15' and block_timestamp < '2022-09-15' then 'Before Merge'
when block_timestamp >= '2022-09-15' then 'Post Merge' else null end as timespan,
block_timestamp::date as date,
count (distinct tx_hash) as tx_count,
count (distinct buyer_address) as Buyers_Count,
count (distinct seller_address) as Sellers_Count,
count (distinct tokenid) as Tokens_Count,
sum (price) as Volume,
sum (price_usd) as Usd_Volume
from ethereum.core.ez_nft_sales
where timespan is not null
and block_timestamp::date != CURRENT_DATE
group by 1,2
Run a query to Download Data