Flippppppa2023-06-26 01:25 PM
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
SELECT
block_number,
block_timestamp,
tx_hash,
event_index,
contract_address,
event_name,
event_inputs,
event_inputs :amount0In :: INTEGER AS amount0In,
event_inputs :amount0Out :: INTEGER AS amount0Out,
event_inputs :amount1In :: INTEGER AS amount1In,
event_inputs :amount1Out :: INTEGER AS amount1Out,
event_inputs :sender :: STRING AS sender,
event_inputs :to :: STRING AS to_address
FROM
ETHEREUM.CORE.FACT_EVENT_LOGS
WHERE
block_timestamp >= CURRENT_DATE - 6
AND event_name = ('Swap')
AND contract_address = LOWER('0x397FF1542f962076d0BFE58eA045FfA2d347ACa0')
Run a query to Download Data