WITH pairList AS (

SELECT

'0x30615bec9c1506bfac97d9dbd3c546307987d467a7f95d5533c2e861eb81f3f' AS pairAddress,

'0x030615bec9c1506bfac97d9dbd3c546307987d467a7f95d5533c2e861eb81f3f' AS pairAddressWith0s,

'ETH' AS token0Symbol,

'USDC' AS token1Symbol -- New pair added below

UNION

ALL

SELECT

'0x601f72228f73704e827de5bcd8dadaad52c652bb1e42bf492d90bbe22df2cec' AS pairAddress,

'0x0601f72228f73704e827de5bcd8dadaad52c652bb1e42bf492d90bbe22df2cec' AS pairAddressWith0s,

'USDC' AS token0Symbol,

'USDT' AS token1Symbol

),

balances_ethusdc AS (

SELECT

'ETH/USDC' AS pair,

pl.pairAddressWith0s AS pairAddressWith0s,

ev.PARAMETERS [0] :value AS sender,

ev.PARAMETERS [1] :value AS receiver,

ev.PARAMETERS [2] :value [0] :value AS amount,

ev.TX_HASH AS hash,

ev.TIMESTAMP AS transactionTime,

ev.BLOCK_NUMBER AS block

FROM

external.tokenflow_starknet.decoded_events ev

LEFT JOIN pairList pl ON ev.CONTRACT = pl.pairAddressWith0s

WHERE

ev.CHAIN_ID = 'mainnet'

AND ev.NAME = 'Transfer'

AND CONTRACT = '0x030615bec9c1506bfac97d9dbd3c546307987d467a7f95d5533c2e861eb81f3f'

AND ev.PARAMETERS [0] :value != '0x30615bec9c1506bfac97d9dbd3c546307987d467a7f95d5533c2e861eb81f3f'

AND ev.PARAMETERS [1] :value != '0'