Sbhn_NPprinted-aquamarine
    Updated 2025-03-16
    select
    symbol as "Token",
    count(distinct origin_from_address) as "Traders",
    sum(ethereum.public.udf_hex_to_int(regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}')[5]) / pow(10,18)) as "Trading Volume"
    from ink.core.fact_event_logs
    join ink.core.ez_token_transfers using(tx_hash)
    where topic_0 in ('0x4b5824a0f21039d7160b2a57d8c140cae3ba13e4f15bcd879cc63e4964681a9e','0x0d29d7b2727600087ca17290038d4c09dc340440df666c931e739ad49594669e')
    and origin_to_address = '0x1d74317d760f2c72a94386f50e8d10f2c902b899'
    and concat('0x', right(regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}')[4],40)) != '0x1d74317d760f2c72a94386f50e8d10f2c902b899'
    and amount>0
    group by 1
    order by 2 desc

    Last run: about 1 month ago
    Token
    Traders
    Trading Volume
    1
    BECK7534855361763.59914
    2
    CHAD3334554250720.51031
    3
    BabyKraken3253128380954.81981
    4
    AK472751254534299.62566
    5
    WAGMI1981285621858.00567
    6
    INKR1561764745357.83218
    7
    FEZ1523159801284.08073
    8
    MILADY1382249333542.59512
    9
    MYST1281148296403.37319
    10
    RCN109953238291.623838
    11
    INKU1073192212418.9713
    12
    PIN1012264929738.35115
    13
    KRET1001881634773.73229
    14
    INKDOG981344174230.35216
    15
    H1N1969393294.53945077
    16
    SQWARD911086645702.44329
    17
    POKE862249261250.18902
    18
    SEX86993978716.71277
    19
    $HANK841838038276.9852
    20
    Arch791188172946.10959
    ...
    271
    8KB
    11s