from solana.transactions

where succeeded = 'TRUE' and block_timestamp >= '2022-01-01'),

sol_p as (select date_trunc('day', hour) as dt, avg(price) as sol_usd

from ethereum.token_prices_hourly

where symbol = 'SOL'

group by 1),

fees as (select date_trunc('day', block_timestamp) as dt, sum(fees_sol) as fees, avg(fees_sol) as average_fee

from raw

group by 1)

select a.dt, a.fees, b.sol_usd, a.average_fee, (a.fees*b.sol_usd) as fees_usd

from fees a

left outer join sol_p b on a.dt = b.dt