Deebs-DeFi-j9fRbzTop 50 CEX Swaps (Eth+BSC network) SMART MONEY ONLY
Updated 2023-11-28
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from CEX Swaps (Eth+BSC network) Deebs Data @ https://flipsidecrypto.xyz/edit/queries/b7d6c27e-712a-42e6-a313-22672bea5fe5
-- forked from DEX Swaps Deebs Data @ https://flipsidecrypto.xyz/edit/queries/56180340-5a82-4aee-986d-41bdc9b8a600
-- 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,
--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'
Run a query to Download Data