Flippppppa2023-06-26 01:25 PM
    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