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 >= '2022-06-15'

select date_trunc('h', block_timestamp) as datetime,

avg(velo_price) as avg_VELO_price,

min(velo_price) as low,

max(velo_price) as high

from price_per_swap

group by 1

order by 1