DISTINCT event_name,

contract_address,

contract_name,

sum(event_inputs:amount0In::int) AS amount

FROM ethereum.core.fact_event_logs

WHERE event_name = 'Swap'

AND contract_address = lower('0x397FF1542f962076d0BFE58eA045FfA2d347ACa0')

AND block_timestamp::date BETWEEN '2023-01-01' AND '2023-01-07'

GROUP BY 1,2,3

ORDER BY 1

LIMIT 10