freemartianBinance Withdrawals
    Updated 2024-01-30
    WITH
    binance_address as (
    SELECT
    address as wallet_address,
    address_name as wallet_name,
    project_name,
    label_type,
    label_subtype
    FROM crosschain.core.dim_labels
    WHERE project_name = 'binance'
    AND label_subtype = 'hot_wallet'
    ),

    ethereum AS(
    SELECT
    block_timestamp::date AS day,
    COUNT(tx_hash) AS tx_count,
    SUM(amount_usd) AS usd_withdrawn,
    SUM(amount) AS token_amount,
    symbol
    FROM ethereum.core.ez_token_transfers
    WHERE from_address IN (SELECT wallet_address FROM binance_address)
    AND block_timestamp >= '2023-11-18'
    GROUP BY day, symbol
    UNION
    SELECT
    block_timestamp::date AS day,
    COUNT(tx_hash) AS tx_count,
    SUM(amount_usd) AS usd_withdrawn,
    SUM(amount) AS token_amount,
    'ETH' AS symbol
    FROM ethereum.core.ez_eth_transfers
    WHERE eth_from_address IN (SELECT wallet_address FROM binance_address)
    AND block_timestamp >= '2023-11-18'
    Last run: 11 months agoAuto-refreshes every 3 hours
    DAY
    TRANSACTIONS
    USD_WITHDRAWAL
    TOKENS_AMOUNT
    SYMBOL
    1
    2023-11-30 00:00:00.0001926839725.8621108819870792.52717041INCH
    2
    2024-01-05 00:00:00.000153222646.028656733222222.48175855PAX
    3
    2023-12-29 00:00:00.000831304246.1145574314615343.5063756CHZ
    4
    2023-12-28 00:00:00.0002779360.820540359238500.07172026LOKA
    5
    2023-11-21 00:00:00.000242349609.4141546714373650.3681267AERGO
    6
    2023-12-10 00:00:00.0001774870025.266389073460.07638208MKR
    7
    2023-12-27 00:00:00.0001651993261.65119994210135.02491098AXS
    8
    2024-01-11 00:00:00.00082116.79198854773085.283DNT
    9
    2024-01-10 00:00:00.0007987857.608603781165793.25176TOMOE
    10
    2024-01-18 00:00:00.00057222486.9965794143949994.69585535COTI
    11
    2023-12-26 00:00:00.000264452.90793651410712.83030378BEL
    12
    2023-12-18 00:00:00.000119.7111326237626TCT
    13
    2024-01-01 00:00:00.00048228464.8930858364269872.47338562VANRY
    14
    2024-01-22 00:00:00.0003982.91977896610597.81723681OOKI
    15
    2023-12-25 00:00:00.0009766856.882990101404399.90420781API3
    16
    2023-12-05 00:00:00.0003842686.936652183887870.01588836LINA
    17
    2023-12-09 00:00:00.0001337378.7360274063492958.81039313QKC
    18
    2023-12-13 00:00:00.0001365457961.9996008112278604.0372571BLUR
    19
    2023-11-26 00:00:00.0002799615.433078794153051.7021705BEL
    20
    2024-01-07 00:00:00.0001878.8492047170778AKRO
    ...
    24190
    2MB
    167s