(

select date_trunc('hour',hour) as time, price

from ethereum.core.fact_hourly_token_prices

where symbol='WETH'

),

eth_fee_table as

(

select

'ethereum' as chain,

ft.block_number,

ft.block_timestamp,

ft.tx_hash,

ft.from_address,

ft.to_address,

ft.tx_fee,

p.price,

(ft.tx_fee*p.price) as tx_fee_usd,

ft.status

from ethereum.core.fact_transactions ft

inner join eth_price p

on date_trunc('hour',ft.block_timestamp)=p.time

where 1=1

and ft.block_timestamp > CURRENT_DATE - interval ' 30 days'

-- and tx_hash='0x224bd8c63fe0d9dee11d3ef6ee2e9ee801bdc998bf922d5c4c3a4a26ec62317e'

),

sol_price as

(

select date_trunc('hour',recorded_hour) as time, (close) as price

from solana.core.fact_token_prices_hourly

where symbol='SOL'

and provider='coinmarketcap'

),

sol_fee_table as

(