with optimism_fee_transactions as (

select

block_timestamp,

tx_hash,

block_number,

(gas_price / 1e9) as gas_price,

(gas_price / 1e9) * gas_used as fee,

from_address

from optimism.core.fact_transactions

where block_timestamp::date > current_date - 31

),

eth_price_usd as (

select

hour::date as days,

avg(price) as price_usd

from ethereum.core.fact_hourly_token_prices

where token_address is null

and hour::date > current_date - 31

group by days

),

op_price_usd as (

select

hour::date as days,

avg(price) as price_usd

from optimism.core.fact_hourly_token_prices

where symbol = 'OP'

and hour::date > current_date - 31

group by days

),

optimism_fee_transactions_with_price as (

select

gas.*,

price.price_usd

from optimism_fee_transactions gas