Cipher009-CpUJ5kOFAC TC Wallets Withdrawing After Sanctions
    Updated 2023-11-04
    -- forked from KARTOD / OFAC TC Wallets Withdrawing After Sanctions 1 @ https://flipsidecrypto.xyz/KARTOD/q/40hrz1RV0oKT/ofac-tc-wallets-withdrawing-after-sanctions-1
    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'
    Run a query to Download Data