Deebs-DeFi-j9fRbzFINAL CEX Swaps JUST TRADERS
Updated 2023-11-29
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 FINAL CEX Swaps with Transfers of Native Tokens @ https://flipsidecrypto.xyz/edit/queries/c386d0ab-1afb-4e3d-beaa-b5a45461f99e
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(
'0x340ba2bf7ac31f01b03a08720a1366b00658021b'
,'0xaad7e91b1fc92fdf23f5fd85729bedcb0aa6788f'
,'0x170acb0595c1e53f4d7e82c58bc698b7806e58e5'
,'0x45da98984b745a6ba1f4a67c842e63664d7d55f1'
,'0x7a49466992ce68c54a22f4b8808b081b5e64dda2'
,'0x1d283807630ffb876a5d78b8e0788e491449f241'
,'0xb44baea33299f99fa5f7f00757f983e64975b2c5')
Group by 1,2,3
having total_bought_USD>0
Order by total_bought_USD DESC
),
bscbuys AS(
SELECT
--date_trunc('month', BLOCK_TIMESTAMP) AS DATE,
symbol,
contract_address,
CASE when 2>1 then 'BSCNETWORK'
Run a query to Download Data