WITH hashes as (
SELECT DISTINCT TX_HASH as tx_hash
FROM aptos.core.fact_events
WHERE EVENT_TYPE = '0x7e783b349d3e89cf5931af376ebeadbfab855b3fa239b7ada8f5a92fbea6b387::event::PriceFeedUpdate'
)
SELECT
date_trunc('day', BLOCK_TIMESTAMP) as day,
sender,
payload,
payload_function
-- count(DISTINCT sender) as distinct_users
FROM aptos.core.fact_transactions t
JOIN hashes h ON t.tx_hash = h.tx_hash
-- GROUP BY 1
-- ORDER BY 1 desc
LIMIT 100