SELECT day, COUNT(DISTINCT TX_HASH) as "Daily Transactions" FROM (
SELECT date_trunc('day', a.block_timestamp) as day, a.TX_HASH FROM blast.core.fact_event_logs a
INNER JOIN blast.core.fact_transactions b ON a.TX_HASH = b.TX_HASH
WHERE contract_address = LOWER('0x693B37a9859Ce9465Fb2aAdeB03811a26A0c37C0') -- eth mod
)
GROUP BY 1
ORDER BY 1 ASC