SELECT
CONTRACT_ADDRESS,
trunc(BLOCK_TIMESTAMP,'day') as time,
COUNT(DISTINCT TX_HASH) as transactions
FROM
optimism.core.fact_event_logs
-- WHERE
-- time = '2023-03-22' -- `YYYY-MM-DD`
GROUP BY
CONTRACT_ADDRESS,
time
ORDER BY
transactions DESC
LIMIT
1;