shahdadi-9ptm8YUntitled Query
    Updated 2022-11-17
    with a as(select
    date_trunc('hour',block_timestamp) date,
    count(tx_id) txn,
    sum(fee) hourly_fee_paid,
    hourly_fee_paid/txn average
    from algorand.core.fact_transaction
    where date > CURRENT_DATE - 30
    group by 1
    ),b as(
    select
    block_hour,price_usd
    from algorand.defi.ez_price_pool_balances
    where block_hour >= CURRENT_DATE - 30
    )
    select
    a.date,
    txn,
    hourly_fee_paid,
    average*price_usd average_usd_per_transaction
    from a join b on a.date=b.block_hour
    Run a query to Download Data