(select

'Osmosis ' as chain,

count(distinct tx_id) as tx_count,

avg(price) * sum(gas_used/1e9) as total_fee_usd,

total_fee_usd/tx_count as fee_per_tx

from

osmosis.core.dim_prices

inner join osmosis.core.fact_transactions

on recorded_at::date=block_timestamp::date

where symbol ='OSMO' and tx_from is not null

and recorded_at::date >= current_date - 30

and block_timestamp::date >= current_date - 30

and tx_status='SUCCEEDED'

union all

(with

p as (select hour::date as date,

avg (price) as price

from ethereum.core.fact_hourly_token_prices

where symbol ilike 'wETH'

group by 1)

select

'Ethereum ' as chain ,

count(distinct tx_hash) as tx_count,

sum (tx_fee*price) as total_fee_usd,

total_fee_usd/tx_count as fee_per_tx

from Ethereum.core.fact_transactions join p on block_timestamp::Date = date

where block_timestamp >= CURRENT_DATE - 30)

union all