BLOCKCHAIN,

PLATFORM,

BLOCK_TIMESTAMP,

TX_HASH,

TRADER as address,

SYMBOL_IN,

AMOUNT_IN,

AMOUNT_IN_USD,

SYMBOL_OUT,

AMOUNT_OUT,

AMOUNT_OUT_USD

FROM crosschain.defi.ez_dex_swaps

WHERE block_timestamp::date > '2024-01-01'

AND AMOUNT_OUT_USD IS NOT NULL

AND TRADER IN ('0xeab23c1e3776fad145e2e3dc56bcf739f6e0a393', -- active DEX traders and/or whales

'0x79320de2e3a2d1b644f655d990dc5a51cc91d74b',

'0x76423c1f03d6a6689cc11efb4cb86f76867ee17c',

'0x6cd68e8f04490cd1a5a21cc97cc8bc15b47dc9eb',

'0x17bb6b65b7b5bd3651782ccf2e01c2c9c34ea0fb',

'0xbe8f240968a60f8849abbb6838849aa8e96daab4',

'0x5f44fe1c8b5d0802eda2a9b638c6163ad52d633b',

'0xa95a697d48f7c5857bdd229917d66133a5746d4b',

'0x0fda4ac09a12c10fae30e429f4d6b47c9a83c87e',

'0x11197272254ac4814828ad9c4571456b6483908d',

'0xdf5c22996b7858be1b427820cadff605a60f17fc',

'0xd0b53c43d3e0b58909c38487aa0c3af7dfa2d8c0',

'0x9c06064b9f4fa36706868de1d338a3ab1d2c42f5',

'0x15fff7c1231d195fa7b0f589012169e0877f2ea7',

'0xf5dcb2a47f738d8ba39f9fa2ddc7592f268a262a',

'0xd0399766777704e510925c2f078058f8b6086690',

'0x50b3e08d5c3a2386e0c9585031b1152a5f0e2370',

'0x391891af67e29d97e61e30c3036a0874f5da411e',

'0x77583dbe79186c1d2d393e59fe47eb1c7cc07758',

AND SYMBOL_OUT IN ('USDC', 'USDT')