(SELECT

date_trunc('d',hour) AS dt,

symbol,

avg(price)

FROM optimism.core.fact_hourly_token_prices

WHERE SYMBOL='OP'

AND date_trunc('d',hour)>CURRENT_DATE-60

GROUP BY 1,2

ORDER BY 1 DESC)

SELECT

date_trunc('d',block_timestamp) as dt1,

COUNT(DISTINCT(tx_hash)) as daily_u_tx,

FROM optimism.core.fact_transactions