flipside

    Total $AR Users ACTIVITY
    freemartianTotal $AR Users ACTIVITY
    Updated 2025-01-06

    WITH
    prices AS (
    SELECT
    hour::date AS price_day, AVG(price) AS price
    FROM base.price.ez_prices_hourly
    WHERE token_address = '0x3e43cb385a6925986e7ea0f0dcdaec06673d4e10'
    GROUP BY 1
    ),
    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 = '0x3e43cb385a6925986e7ea0f0dcdaec06673d4e10'
    AND tx_hash = '0xd4cdb3c9e5c74f1ab3f783d8b48c196a225d7421760939fec811d64fbdf3de1f'
    ORDER BY event_index ASC
    ),

    token_in_out AS(
    SELECT
    to_address AS user,
    SUM(amount) AS amount,
    FROM base.core.ez_token_transfers
    WHERE contract_address = '0x3e43cb385a6925986e7ea0f0dcdaec06673d4e10'
    GROUP BY 1
    UNION ALL
    SELECT
    from_address AS user,
    SUM(-amount) AS amount,
    FROM base.core.ez_token_transfers
    WHERE contract_address = '0x3e43cb385a6925986e7ea0f0dcdaec06673d4e10'
    GROUP BY 1
    ),
    current_user_amount AS(
    SELECT
    user,
    sum(amount) AS current_balance