WITH event_logs AS(
SELECT BLOCK_TIMESTAMP, EVENT_NAME, event_inputs:value AS eth_value_raw, round(eth_value_raw / pow(10, 18), 10) as eth_value
FROM ethereum.core.fact_event_logs
WHERE ORIGIN_TO_ADDRESS = '0x3b968d2d299b895a5fcf3bba7a64ad0f566e6f88'
AND TX_STATUS = 'SUCCESS'
)
SELECT date_trunc('day', BLOCK_TIMESTAMP) AS date, EVENT_NAME, COUNT(*) AS tx_num
FROM event_logs
GROUP BY 1, 2
ORDER BY 1