Updated 2022-10-16
    with per_day as (
    select
    date_trunc('day',block_timestamp) as day,
    sum(tx_count) as Tx_per_day
    from gnosis.core.fact_blocks
    where DAY >= CURRENT_DATE - 30
    group by 1)

    select
    day,
    tx_per_day
    from per_day
    Run a query to Download Data