CONTRACT_ADDRESS,

trunc(BLOCK_TIMESTAMP,'day') as time,

COUNT(DISTINCT TX_HASH) as transactions

ethereum.core.fact_decoded_event_logs

time = '2023-03-22'

GROUP BY

CONTRACT_ADDRESS,

time

ORDER BY

transactions DESC;