alirsnyk-02
    Updated 2022-11-19
    WITH FTX
    AS (
    SELECT address_name
    ,label
    ,address
    FROM ethereum.core.dim_labels
    WHERE address_name ilike '%ftx%'
    OR label ilike '%ftx%'
    OR label ilike '%alameda research%'
    )
    ,inflow
    AS (
    SELECT block_timestamp::DATE AS DATE
    ,sum(amount_usd) AS vol_in
    ,count(DISTINCT (tx_hash)) AS tx_inflow
    FROM ethereum.core.ez_token_transfers
    WHERE block_timestamp >= CURRENT_DATE -7
    AND to_address IN (
    SELECT DISTINCT address
    FROM ftx
    )
    AND from_address NOT IN (
    SELECT DISTINCT address
    FROM ftx
    )
    AND amount_usd < 100000
    GROUP BY 1
    UNION
    SELECT block_timestamp::DATE AS DATE
    ,sum(amount_usd) AS vol_in
    ,count(DISTINCT (tx_hash)) AS tx_inflow
    FROM ethereum.core.ez_eth_transfers
    WHERE block_timestamp >= CURRENT_DATE -7
    AND eth_to_address IN (
    Run a query to Download Data