CEX Swaps with Transfers of Native Tokens

Deebs-DeFi-j9fRbzCEX Swaps with Transfers of Native Tokens

Updated 2023-11-29

With buys as(

SELECT

--date_trunc('month', BLOCK_TIMESTAMP) AS DATE,

symbol,

contract_address,

CASE when 2>1 then 'ETHNETWORK'

END AS type,

--FROM_address,

--TO_ADDRESS,

sum(Amount_USD) AS total_bought_USD

--TO_ADDRESS,

--FROM_ADDRESS

FROM ethereum.core.ez_token_transfers

WHERE BLOCK_TIMESTAMP>CURRENT_DATE-{{days}}

AND FROM_ADDRESS IN (select address from ethereum.core.dim_labels WHERE label_type = 'cex')

AND TO_ADDRESS IN(

'0x7d325a9c8f10758188641fe91cfd902499edc782'

,'0x05E793cE0C6027323Ac150F6d45C2344d28B6019'

,'0xf93D43dBB6215963D8E3e3C2aC602bb8311C8503'

,'0x1442b96bfee50deee97c3d5804890adc053ea7d1'

,'0xb944020ec109f54b9899249661cfc09049834a95'

,'0x8608343b7987d903bb720d9425a8be54de48f1d3'

,'0x201d252fa4dd34744162d1dbc9063e2b6fc7ab01'

,'0x4c262bdb0ed4d40f1a7b85075762d6058a3b6fed'

,'0x98d3ed59c5b2ea49b91138890b5b4883f067be1b'

,'0x3c043dbcf713e9c96951815a8bf4b90427f424f7'

,'0x3e0d86c74380c90063724f4c490fddce4387d22b'

,'0x4fa9a9ca290dd01b688c9ed2c1cc61dff0b01bba'

,'0xe516d61ed4415f24606ddc14b3445dabf39d3498'

,'0xe8043f57c4626ba6b5892b89f95bb357ee38be9e'

,'0xe4dce5888216b3d7595764c39ba31c1d910f6a66'

,'0x7cf4077393b8846bdcf60a5890878fc979c39a0a'

,'0xdb6f3e2d9670d45b45082a8a8aea0576305d05c3'

,'0x81451ea5e6ea25829a4af736efceb9e74e09a1b3'

,'0x67a93a3e126afd52ca06bf3b9be722820c9adfc9'

,'0x7f256695627c44e423139ec172393ecdc8a3de24'

Run a query to Download Data

flipside