date_trunc('day', BLOCK_TIMESTAMP) as day,

EVENT_DATA['price_feed']['price_identifier']['bytes'] as feed,

count(*) as number_updates -- fee per price update is always 1 octa

FROM aptos.core.fact_events

WHERE EVENT_TYPE = '0x7e783b349d3e89cf5931af376ebeadbfab855b3fa239b7ada8f5a92fbea6b387::event::PriceFeedUpdate'

GROUP BY 1, 2

ORDER BY 1 desc