(With Arbitrum as (with arbitrum_fees as

date_trunc('day',BLOCK_TIMESTAMP) as date,

FROM_ADDRESS as address,

sum (TX_FEE) as gas_paid

from arbitrum.core.fact_transactions

where FROM_ADDRESS = lower('{{ADDRESS}}')

group by 1,2),

ETH as (select date_trunc ('day',HOUR) as date, avg(PRICE)as price

from ethereum.core.fact_hourly_token_prices

where SYMBOL = 'WETH'

group by 1)

select a.date, address,gas_paid as gas_paid_ETH, (gas_paid*price) as gas_paid_USD

from arbitrum_fees a left join ETH e on a.date=e.date)

select 'Arbitrum' as network , sum(gas_paid_ETH)as Token , sum(gas_paid_USD)as USD, (USD/Token) as Average_Price

from Arbitrum)

(With optimism as (with optimism_fees as

date_trunc('day',BLOCK_TIMESTAMP) as date,

FROM_ADDRESS as address,

sum (TX_FEE) as gas_paid

from optimism.core.fact_transactions

where FROM_ADDRESS = lower('{{ADDRESS}}')

group by 1,2),

ETH as (select date_trunc ('day',HOUR) as date, avg(PRICE)as price

from ethereum.core.fact_hourly_token_prices

where SYMBOL = 'WETH'

group by 1)

select a.date, address,gas_paid as gas_paid_ETH, (gas_paid*price) as gas_paid_USD

from optimism_fees a left join ETH e on a.date=e.date)

select 'Optimism' as network, sum(gas_paid_ETH)as Token , sum(gas_paid_USD)as USD, (USD/Token) as Average_Price