SELECT
date_trunc('day', block_timestamp) as date,
sum(event_inputs:token_amounts[1] / pow(10,18)) as steth_amount,
sum(event_inputs:token_amounts[0] / pow(10,18)) as eth_amount,
count(*)
from flipside_prod_db.ethereum_core.fact_event_logs
-- where tx_hash = '0x69bcc7fff118d6c94a3e4db4d909a12a8e689ffe24dd3cee93a30fcc780d8d87'
where contract_address = '0xdc24316b9ae028f1497c275eb9192a3ea0f67022'
and event_name = 'RemoveLiquidity'
and block_timestamp >= CURRENT_DATE - interval '365 days'
group by 1
order by 1 desc
-- limit 3