KUJIRA CEX and DEX NET FLOW on ETHEREUM (Smart Money Only) copy copy copy copy

Deebs-DeFi-j9fRbzKUJIRA CEX and DEX NET FLOW on ETHEREUM (Smart Money Only) copy copy copy copy

Updated 2023-11-10

-- forked from ALL TOKENS CEX and DEX NET FLOW on ETHEREUM (Smart Money Only) copy copy copy @ https://flipsidecrypto.xyz/edit/queries/fb84035a-5a54-4934-8010-af0c6e960e2e

With buys as(

SELECT

date_trunc('month', BLOCK_TIMESTAMP) AS DATE,

symbol,

contract_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 symbol LIKE '%kuji%'

OR symbol LIKE '%KUJI%'

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

AND TO_ADDRESS IN(lower('0x7d325a9c8f10758188641fe91cfd902499edc782')

,lower('0x66b870ddf78c975af5cd8edc6de25eca81791de1')

,lower('0x05E793cE0C6027323Ac150F6d45C2344d28B6019')

,lower('0xf93D43dBB6215963D8E3e3C2aC602bb8311C8503')

,lower('0x1442b96bfee50deee97c3d5804890adc053ea7d1')

,lower('0xb944020ec109f54b9899249661cfc09049834a95')

,lower('0x8608343b7987d903bb720d9425a8be54de48f1d3')

,lower('0x201d252fa4dd34744162d1dbc9063e2b6fc7ab01')

,lower('0x4c262bdb0ed4d40f1a7b85075762d6058a3b6fed')

,lower('0x98d3ed59c5b2ea49b91138890b5b4883f067be1b')

,lower('0x3c043dbcf713e9c96951815a8bf4b90427f424f7')

,lower('0x3e0d86c74380c90063724f4c490fddce4387d22b')

,lower('0x4fa9a9ca290dd01b688c9ed2c1cc61dff0b01bba')

,lower('0xe516d61ed4415f24606ddc14b3445dabf39d3498')

,lower('0xe8043f57c4626ba6b5892b89f95bb357ee38be9e')

,lower('0xe4dce5888216b3d7595764c39ba31c1d910f6a66')

,lower('0x7cf4077393b8846bdcf60a5890878fc979c39a0a')

,lower('0xdb6f3e2d9670d45b45082a8a8aea0576305d05c3')

,lower('0x81451ea5e6ea25829a4af736efceb9e74e09a1b3')

,lower('0x67a93a3e126afd52ca06bf3b9be722820c9adfc9')

,lower('0x7f256695627c44e423139ec172393ecdc8a3de24')