select block_timestamp,

flipside_prod_db.tokenflow_eth.hextoint(substring(data,1,66)) /1e18 as token0,

flipside_prod_db.tokenflow_eth.hextoint(substring(data,67,130)) /1e6 as token1,

token1 / token0 as velo_price

from optimism.core.fact_event_logs

where 1

and contract_address ilike '0xe8537b6ff1039cb9ed0b71713f697ddbadbb717d'

and origin_function_signature ilike ('0xfdb5a03e')

and topics[0] ilike '0xcf2aa%'

--and block_timestamp = (select block_timestamp, max(1) from optimism.core.fact_event_logs group by 1)

and block_timestamp::timestamp >= current_date - interval '24 hours'

order by 1