SELECT

TX_HASH,

BLOCK_TIMESTAMP,

CONTRACT_ADDRESS,

RAW_AMOUNT / POW(10, 18) AS AMOUNT_ETH,

AMOUNT_ETH * PRICE AS AMOUNT_ETH_USDC

FROM

ethereum.core.fact_token_transfers transfers

LEFT OUTER JOIN ethereum.price.ez_prices_hourly prices ON (

DATE_TRUNC('Hour', transfers.BLOCK_TIMESTAMP) = prices.HOUR

AND TOKEN_ADDRESS = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'

)

WHERE

BLOCK_TIMESTAMP >= '2024-07-30'

AND TX_HASH = '0x68d867a9fed00fb787ec1e802e2c98e9c0357fc4a74303c1aeb2f2561b9c644f'

AND EVENT_INDEX = 61

),

OUTGOING_TX AS (

SELECT

TX_HASH,

BLOCK_TIMESTAMP,

FROM_ADDRESS,

TO_ADDRESS,

CONTRACT_ADDRESS,

NAME,

SYMBOL,

RAW_AMOUNT / POW(10, DECIMALS) AS AMOUNT_TOKEN,

AMOUNT_TOKEN * PRICE AS AMOUNT_TOKEN_USDC

FROM

ethereum.core.fact_token_transfers transfers

LEFT OUTER JOIN ethereum.price.ez_prices_hourly prices ON (

DATE_TRUNC('Hour', transfers.BLOCK_TIMESTAMP) = prices.HOUR

AND prices.TOKEN_ADDRESS = transfers.CONTRACT_ADDRESS

)

WHERE