binhachonUntitled Query
    Updated 2022-01-21
    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