flipside

    2024-05-28 03:15 PM
    marosi2024-05-28 03:15 PM
    Updated 2024-05-28
    SELECT *
    FROM ethereum.core.ez_current_balances
    WHERE ethereum.core.ez_current_balances.user_address in (
    SELECT ethereum.core.dim_contracts.address
    FROM ethereum.core.dim_contracts
    WHERE ethereum.core.dim_contracts.CREATED_BLOCK_NUMBER > 19908593
    AND ethereum.core.dim_contracts.symbol != 'UNI-V2'
    LIMIT 100
    )
    ORDER BY ethereum.core.ez_current_balances.usd_value_now ASC
    LIMIT 100
    QueryRunArchived: QueryRun has been archived