freemartian2023-11-21 09:59 PM
    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'
    )


    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-20'
    GROUP BY day, symbol
    Run a query to Download Data