mz0111ftx 4
    Updated 2022-11-09
    --CREDIT: CarlowsOs https://app.flipsidecrypto.com/velocity/queries/23b11286-fbb5-4c3b-8925-2a35fab3ef0c
    WITH ftx AS (--mirar crosschain
    SELECT
    address
    FROM
    ethereum.core.dim_labels
    WHERE
    address_name ilike '%ftx%'
    AND label_subtype = 'hot_wallet'
    --'0xC098B2a3Aa256D2140208C3de6543aAEf5cd3A94', '0x2faf487a4414fe77e2327f0bf4ae2a264a776ad2'
    ),
    last_date_change AS (
    SELECT
    block_timestamp::DATE AS balance_date,
    user_address,
    CASE
    WHEN symbol = 'ETH' THEN 'ETH'
    ELSE contract_address
    END AS contract_address,
    MAX(block_timestamp) AS last_change
    FROM
    ethereum.core.ez_balance_deltas
    WHERE
    block_timestamp::DATE >= CURRENT_DATE-30
    AND user_address IN (SELECT address FROM ftx)
    GROUP BY
    1, 2, 3
    ),
    base_table AS (
    SELECT
    block_timestamp::DATE AS balance_date,
    CASE
    WHEN b.symbol = 'ETH' THEN 'ETH'
    ELSE b.contract_address
    END AS contract_address,
    b.user_address,
    Run a query to Download Data