token_transfer_logs AS (

SELECT

tx_hash

, event_index

, block_timestamp

, origin_from_address

, event_inputs['from']::string AS sender

, event_inputs['to']::string AS receiver

, contract_address AS token_address

, event_inputs['value']::bigint AS amount_raw

FROM avalanche.core.fact_event_logs AS transfer

WHERE tx_status = 'SUCCESS'

AND event_name = 'Transfer'

AND block_timestamp >= '2022-06-20 00:00:00.000'

AND try_to_numeric(event_inputs['value']::string) IS NOT NULL

),

token_swap_logs AS (

SELECT

tx_hash

, event_index

, block_timestamp

, origin_from_address

, event_inputs['amount0In']::bigint AS amount_0_in

, event_inputs['amount1In']::bigint AS amount_1_in

, event_inputs['amount0Out']::bigint AS amount_0_out

, event_inputs['amount1Out']::bigint AS amount_1_out

, event_inputs['sender']::string AS sender

, event_inputs['to']::string AS receiver