binhachonUntitled Query
Updated 2022-01-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with day_list as (
select
distinct date_trunc('day', block_timestamp) as blocktime
from ethereum.events_emitted
),
day_list_1 as (
select
distinct date_trunc('day', block_timestamp) as blocktime
from ethereum.udm_events
)
select count(*) from day_list
union all
select count(*) from day_list_1
Run a query to Download Data