flipside

    Total Initial DR3AM Activities
    freemartianTotal Initial DR3AM Activities
    Updated 2025-03-05
    WITH first_dist AS(
    SELECT block_timestamp, tx_hash, to_address AS user, amount AS first_amount_received,
    FROM base.core.ez_token_transfers
    WHERE contract_address = '0x0521aaa7c96e25afee79fdd4f1bb48f008ae4eac'
    AND tx_hash = '0xe930bba69e4c165a44197088b25f890b37de23c182f992c0834fa8843407c9f0'
    AND to_address not in ('0x0ebcee3165654d9c52dd6d438423be76f2df1b0e','0xb8745dec73f81ea366d7cc672438053c0e97de51')
    ORDER BY event_index ASC
    ),

    prices AS (
    SELECT
    hour::date AS price_day, AVG(price) AS price

    FROM base.price.ez_prices_hourly
    WHERE token_address = '0x0521aaa7c96e25afee79fdd4f1bb48f008ae4eac'
    GROUP BY 1
    ),

    token_in_out AS(
    SELECT
    to_address AS user,
    SUM(amount) AS amount,
    FROM base.core.ez_token_transfers
    WHERE contract_address = '0x0521aaa7c96e25afee79fdd4f1bb48f008ae4eac'
    GROUP BY 1
    UNION ALL
    SELECT
    from_address AS user,
    SUM(-amount) AS amount,
    FROM base.core.ez_token_transfers
    WHERE contract_address = '0x0521aaa7c96e25afee79fdd4f1bb48f008ae4eac'
    GROUP BY 1
    ),
    current_user_amount AS(
    SELECT
    user,
    Auto-refreshes every 1 hour
    QueryRunArchived: QueryRun has been archived