sepehrmhz8Untitled Query
Updated 2022-09-29
9
1
2
3
4
5
6
7
›
⌄
select case when block_timestamp >= '2022-09-01' and block_timestamp < '2022-09-15' then 'Before Merge'
when block_timestamp >= '2022-09-15' then 'Post Merge' else null end as scheduling,
block_timestamp::date as day,
count (distinct origin_to_address) as Contracts_Count
from ethereum.core.fact_event_logs
where tx_status = 'SUCCESS' and scheduling is not null
group by 1,2
Run a query to Download Data