Query editor
with txs as (selecttransactions.block_time,transactions.block_hash,transactions."from" as user,transactions.to,gas_used,gas_price,gas_price * price as gas_price_usd,gas_used * price as gas_used_usd,index,address as contractfrom boba.transactions as transactionsleft join boba.creation_traces as traceson transactions.to = traces.addressleft join prices.houron (blockchain = 'boba'and contract_address = 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0000and timestamp = date_trunc('hour', transactions.block_time))where transactions.block_time > timestamp '2025-01-01')selectsum(gas_used_usd * gas_price_usd) / 1e18 as gas_usd,COUNT(DISTINCT contract) as contracts,COUNT(DISTINCT user) as user,COUNT(*) as txFROM txs