sinahosseinzadehUntitled Query
Updated 2022-08-10
99
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
›
⌄
with ETH as
(
SELECT
BLOCK_TIMESTAMP AS DATE,
"TO_ADDRESS" AS violator_wallet,
RAW_AMOUNT/POW(10,decimals) AS amount,
CASE "FROM_ADDRESS"
WHeN '0xd96f2b1c14db8458374d9aca76e26c3d18364307' then '1,000 USDC'
WHeN '0x4736dcf1b7a3d580672cce6e7c65cd5cc9cfba9d' then '100 USDC'
WHeN '0xd4b88df4d29f5cedd6857912842cff3b20c8cfa3' then '100 DAI'
WHeN '0x910cbd523d972eb0a6f4cae4618ad62622b39dbf' then '10 ETH'
WHeN '0xa160cdab225685da1d56aa342ad8841c3b53f291' then '100 ETH'
WHeN '0xfd8610d20aa15b7b2e3be39b396a1bc3516c7144' then '1,000 DAI'
WHeN '0xf60dd140cff0706bae9cd734ac3ae76ad9ebc32a' then '10,000 DAI'
WHeN '0x22aaa7720ddd5388a3c0a3333430953c68f1849b' then '5,000 cDAI'
WHeN '0xba214c1c1928a32bffe790263e38b4af9bfcd659' then '50,000 cDAI'
WHeN '0xb1c8094b234dce6e03f10a5b673c1d8c69739a00' then '500,000 cDAI'
WHeN '0xd691f27f38b395864ea86cfc7253969b409c362d' then '10,000 USDC'
WHeN '0xaeaac358560e11f52454d997aaff2c5731b6f8a6' then '5,000 USDC'
WHeN '0x1356c899d8c9467c7f71c195612f8a395abf2f0a' then '50,000 cUSDC'
WHeN '0xa60c772958a3ed56c1f15dd055ba37ac8e523a0d' then '500,000 cUSDC'
WHeN '0x169ad27a470d064dede56a2d3ff727986b15d52b' then '100 USDT'
WHeN '0x0836222f2b2b24a3f36f98668ed8f0b38d1a872f' then '1,000 USDT'
WHeN '0xf67721a2d8f736e75a49fdd7fad2e31d8676542a' then '10,000 USDT'
WHeN '0x9ad122c22b14202b4490edaf288fdb3c7cb3ff5e' then '100,000 USDT'
WHeN '0x07687e702b410fa43f4cb4af7fa097918ffd2730' then '10,000 DAI 2'
WHeN '0x12d66f87a04a9e220743712ce6d9bb1b5616b8fc' then '0.1 ETH'
WHeN '0x47ce0c6ed5b0ce3d3a51fdb1c52dc66a7c3c2936' then '1 ETH'
WHeN '0x23773e65ed146a459791799d01336db287f25334' then '100,000 DAI'
WHeN '0xd21be7248e0197ee08e0c20d4a96debdac3d20af' then '5,000,000 cDAI'
WHeN '0x610b717796ad172b316836ac95a2ffad065ceab4' then '1 WBTC'
WHeN '0x178169b423a011fff22b9e3f3abea13414ddd0f1' then '0.1 WBTC'
WHeN '0xbb93e510bbcd0b7beb5a853875f9ec60275cf498' then '10 WBTC'
WHeN '0x2717c5e28cf931547b621a5dddb772ab6a35b701' then '500,000 cDAI 2'
WHeN '0x03893a7c7463ae47d46bc7f091665f1893656003' then '50,000 cDAI 2'
END as token_withdrawn
Run a query to Download Data