flipside

    Cex Movement - 0. Ethereum Wallets copy
    winnie-fsCex Movement - 0. Ethereum Wallets copy
    Updated 2024-02-19
    -- forked from pinehearst / Cex Movement - 0. Ethereum Wallets @ https://flipsidecrypto.xyz/pinehearst/q/GeIjm3xUPOb5/cex-movement-0-ethereum-wallets

    with all_transfers AS (
    select
    block_timestamp,
    tx_hash,
    origin_from_address,
    from_address,
    to_address,
    contract_address,
    symbol,
    amount,
    amount_usd
    from ethereum.core.ez_token_transfers
    where block_timestamp > '{{date}}'
    union
    select
    block_timestamp,
    tx_hash,
    origin_from_address,
    eth_from_address,
    eth_to_address,
    '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' as contract_address, -- take weth price
    'WETH' as symbol, -- 'weth' but actually eth / for pricing missing tables
    amount,
    amount_usd
    from ethereum.core.ez_eth_transfers
    where block_timestamp > '{{date}}'
    ),
    eth_cex AS (
    SELECT
    block_timestamp,
    from_address,
    to_address,
    a.label as from_label,
    a.label_type as from_label_type,
    Last run: about 1 year ago
    DATE_OUT
    FROM_LABEL
    WITHDRAWAL_WALLETS
    WITHDRAWAL_TX
    USD_OUT
    DATE_IN
    TO_LABEL
    DEPOSIT_WALLETS
    DEPOSIT_TX
    USD_IN
    USD_OUT_NEG
    NET_FLOW
    CUMULATIVE_FLOW
    1
    		2024-02-07 00:00:00.000binance25281334922667359872.188442024-02-07 00:00:00.000binance8467119062259330882.49759-2667359872.18844-408028989.690847-6870352393.74218
    2
    		2024-02-06 00:00:00.000binance30553396172476579352.835712024-02-06 00:00:00.000binance13510192162328806657.92702-2476579352.83571-147772694.90869-6462323404.05133
    3
    		2024-02-05 00:00:00.000binance30146392211867041724.536982024-02-05 00:00:00.000binance11767156401742161062.95872-1867041724.53698-124880661.578261-6314550709.14264
    4
    		2024-02-04 00:00:00.000binance2553632841826605310.6950332024-02-04 00:00:00.000binance755311071790271110.48012-826605310.695033-36334200.214913-6189670047.56438
    5
    		2024-02-03 00:00:00.000binance2597933546552833195.9760692024-02-03 00:00:00.000binance982014623529464455.391945-552833195.976069-23368740.5841246-6153335847.34947
    6
    		2024-02-02 00:00:00.000binance31437400332128323736.257472024-02-02 00:00:00.000binance17407225332388830645.59338-2128323736.25747260506909.335908-6129967106.76534
    7
    		2024-02-01 00:00:00.000binance31072409882000079502.535212024-02-01 00:00:00.000binance11437158911898325428.01672-2000079502.53521-101754074.5185-6390474016.10125
    8
    		2024-01-31 00:00:00.000binance30211404862859892749.79322024-01-31 00:00:00.000binance11848167352745823059.33966-2859892749.7932-114069690.45354-6288719941.58275
    9
    		2024-01-30 00:00:00.000binance28410377684532181353.292142024-01-30 00:00:00.000binance11847166313997710688.15187-4532181353.29214-534470665.140275-6174650251.12921
    10
    		2024-01-29 00:00:00.000binance26824348581765617781.03782024-01-29 00:00:00.000binance9503135841789425745.72765-1765617781.037823807964.6898508-5640179585.98894
    11
    		2024-01-28 00:00:00.000binance3003737407798386894.5241552024-01-28 00:00:00.000binance701110305751417770.363525-798386894.524155-46969124.1606307-5663987550.67879
    12
    		2024-01-27 00:00:00.000binance2600433068802321704.0922432024-01-27 00:00:00.000binance754711056832224082.666602-802321704.09224329902378.5743581-5617018426.51816
    13
    		2024-01-26 00:00:00.000binance29111378762196360116.998292024-01-26 00:00:00.000binance10498149852333348309.5892-2196360116.99829136988192.590903-5646920805.09251
    14
    		2024-01-25 00:00:00.000binance32115411431737389386.926482024-01-25 00:00:00.000binance11520158201789730015.95638-1737389386.9264852340629.0299075-5783908997.68342
    15
    		2024-01-24 00:00:00.000binance26876357432352072489.310942024-01-24 00:00:00.000binance12465178352280930640.09552-2352072489.31094-71141849.215414-5836249626.71333
    16
    		2024-01-23 00:00:00.000binance26582373822335509427.06022024-01-23 00:00:00.000binance11733171992380553599.05439-2335509427.060245044171.9941959-5765107777.49791
    17
    		2024-01-22 00:00:00.000binance28482380551931361505.042752024-01-22 00:00:00.000binance10388157691960129283.19839-1931361505.0427528767778.1556358-5810151949.49211
    18
    		2024-01-21 00:00:00.000binance2281430269535411334.3903832024-01-21 00:00:00.000binance715011100522104972.889279-535411334.390383-13306361.5011046-5838919727.64774
    19
    		2024-01-20 00:00:00.000binance24052321611970904163.419472024-01-20 00:00:00.000binance10390171591909924272.64874-1970904163.41947-60979890.7707231-5825613366.14664
    20
    		2024-01-19 00:00:00.000binance32316434343011601744.739022024-01-19 00:00:00.000binance19670268532950613662.55718-3011601744.73902-60988082.1818423-5764633475.37592
    ...
    372
    67KB
    352s