select avg(price) as price ,avg(price) * sum(gas_used/1e9) as gas_usd , block_timestamp::date
from osmosis.core.dim_prices inner join osmosis.core.fact_transactions
on recorded_at::date=block_timestamp::date
where
symbol ='OSMO'
and recorded_at::date > current_date - interval '30 days'
and block_timestamp::date > current_date - interval '30 days'
group by 3