defi__joshToken Activity Timeline Check
    Updated 2025-03-28
    WITH token_transfers AS (
    SELECT
    contract_address,
    symbol,
    MIN(block_timestamp) as first_transfer,
    MAX(block_timestamp) as last_transfer,
    COUNT(*) as total_transfers
    FROM base.core.ez_token_transfers
    WHERE contract_address = LOWER('0x9c632E6Aaa3eA73f91554f8A3cB2ED2F29605e0C')
    GROUP BY 1,2
    ),
    price_check AS (
    SELECT
    token_address,
    MIN(hour) as first_price,
    MAX(hour) as last_price,
    COUNT(*) as price_records
    FROM base.price.ez_prices_hourly
    WHERE token_address = LOWER('0x9c632E6Aaa3eA73f91554f8A3cB2ED2F29605e0C')
    GROUP BY 1
    )
    SELECT
    t.*,
    p.first_price,
    p.last_price,
    p.price_records
    FROM token_transfers t
    FULL OUTER JOIN price_check p
    ON t.contract_address = p.token_address;





    QueryRunArchived: QueryRun has been archived