select sum(fee_usd) as fee_paid_usd, sum(tx_fee) as fee_paid_eth, count(tx_id)*50, avg(price) as price, date_trunc('week', block_timestamp::date) as DATE
from flipside_prod_db.ethereum.transactions t
inner join flipside_prod_db.ethereum_core.fact_hourly_token_prices p on t.block_timestamp::date = p.hour::date
where t.to_label = 'sushiswap'
and p.symbol = 'WETH'
and t.block_timestamp::date > '2022-01-01'
group by DATE