select

tx.tx_hash,

tx.from_address,

tx.tx_fee,

tx.block_timestamp,

p.price as eth_price,

tx.tx_fee * p.price as tx_fee_usd

from blast.core.fact_transactions tx

left join ethereum.price.ez_prices_hourly p

on date_trunc('hour', tx.block_timestamp) = p.hour

and p.symbol = 'ETH'

and p.blockchain = 'ethereum'

and p.is_native = true

where tx.TX_SUCCEEDED = 'TRUE'

and tx.block_timestamp >= DATEADD(day, -30, CURRENT_TIMESTAMP)

count(DISTINCT TX_HASH) as "Transactions",

count(distinct FROM_ADDRESS) as "Active Users",

sum(tx_fee) as "Fees (ETH)",

sum(tx_fee_usd) as "Fees (USD)"

from hourly_fees;