Spiltadavid[QD] Transactions after christmas
    Updated 2023-01-11
    select
    avg(total_transactions) as avg_daily_transactions,
    avg(total_blocks) avg_daily_blocks,
    avg(total_fee) avg_daily_total_fees,
    avg(average_fee) avg_daily_average_fees,
    avg(TPS) average_daily_tps,
    avg(users) average_daily_users
    from (
    select
    date_trunc(day,block_timestamp) as day,
    count(distinct tx_id) as total_transactions,
    count(distinct block_id) as total_blocks,
    sum(fee) as total_fee,
    avg(fee) as average_fee,
    count(distinct tx_sender) as users,
    DATEDIFF('second',min(block_timestamp) , current_timestamp) as seconds,
    total_transactions / seconds as TPS
    from terra.core.fact_transactions
    where block_timestamp::date < '2022-12-25'
    group by 1
    )

    Run a query to Download Data