binhachonUntitled Query
    Updated 2022-05-04
    with blocks as (
    select
    date_trunc('day', block_timestamp) as time,
    count(distinct block_id) as number_of_blocks
    from polygon.transactions
    group by 1
    )
    select
    date_day,
    coalesce(number_of_blocks, 0) as number_of_blocks
    from ethereum_core.dim_dates
    left join blocks on (date_day = time)
    where date_day >= '2021-01-01'
    and date_day < getdate()
    Run a query to Download Data