Hessishuni - tokens arb traders lvl
    Updated 2024-09-17

    with

    tokens_list as
    (SELECT block_timestamp,
    PLATFORM,
    TOKEN_IN as token,
    TX_HASH,
    origin_from_address as trader
    from arbitrum.defi.ez_dex_swaps
    where
    PLATFORM ilike '%uniswap%'

    union


    SELECT block_timestamp,

    PLATFORM,
    TOKEN_out as token,
    TX_HASH,
    origin_from_address as trader
    from arbitrum.defi.ez_dex_swaps
    where
    PLATFORM ilike '%uniswap%'),

    valid_tokens as (
    select DISTINCT token
    from tokens_list
    GROUP by 1
    having count(distinct tx_hash) > 9),

    tokensx as (
    SELECT
    DISTINCT token ,
    QueryRunArchived: QueryRun has been archived