SELECT
CONTRACT_ADDRESS,
trunc(BLOCK_TIMESTAMP,'day') as time,
COUNT(DISTINCT TX_HASH) as transactions,
EVENT_NAME
FROM
ethereum.core.fact_decoded_event_logs
WHERE
time > '2023-02-01' AND CONTRACT_ADDRESS = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'
GROUP BY
EVENT_NAME,
CONTRACT_ADDRESS,
time
ORDER BY
time DESC;