bachipost merge2
Updated 2022-09-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select date(block_timestamp) as day,
count(distinct(buyer_address)) as no_of_buyers,
count(distinct(seller_address)) as no_of_sellers,
case
when day >= '2022-09-15' then 'Post Merge'
when day < '2022-09-15' then 'Pre Merge'
end as time_period
from ethereum.core.ez_nft_sales
where event_type = 'sale'
and price_usd > 0
and block_timestamp >= '2022-09-01'
group by day
order by day desc
Run a query to Download Data