alitaslimiList of Top Addresses Interacted by OCA Users
    Updated 6 days ago
    select
    origin_to_address as "Address",
    initcap(project_name) as "Label",
    count(distinct tx_hash) as "Transactions",
    count(distinct origin_from_address) as "Users"
    from
    avalanche.core.ez_decoded_event_logs logs
    join avalanche.core.dim_labels labels on logs.origin_to_address = labels.address
    where
    tx_status = 'SUCCESS'
    and contract_address in (
    '0xc891eb4cbdeff6e073e859e987815ed1505c2acd', -- EURC
    '0x7678e162f38ec9ef2bfd1d0aaf9fd93355e5fa0b', -- VEUR
    '0x228a48df6819ccc2eca01e2192ebafffdad56c19' -- VCHF
    )
    group by
    "Address",
    "Label"
    order by
    "Transactions" desc
    Last run: 6 days ago
    Address
    Label
    Transactions
    Users
    1
    0xc891eb4cbdeff6e073e859e987815ed1505c2acdCircle3302313028
    2
    0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30Trader Joe244574837
    3
    0x88de50b233052e4fb783d4f6db78cc34fea3e9fcOdos14610504
    4
    0xdef171fe48cf0115b1d80b88dc8eab59176fee57Paraswap7824335
    5
    0x1fd108cf42a59c635bd4703b8dbc8a741ff834beDexalot42411523
    6
    0xcd2e3622d483c7dc855f72e5eafadcd577ac78b4Layerzero35371
    7
    0x052af5b8ac73082d8c4c8202bb21f4531a51dc73Beefy Finance29421436
    8
    0x1111111254eeb25477b68fb85ed929f73a9605821inch29012460
    9
    0xeed3c159f3a96ab8d41c8b9ca49ee1e5071a7cddDexalot2564165
    10
    0x794a61358d6845594f94dc1db02a252b5b4814adAave11933
    11
    0x228a48df6819ccc2eca01e2192ebafffdad56c19Vnx912514
    12
    0x7678e162f38ec9ef2bfd1d0aaf9fd93355e5fa0bVnx802175
    13
    0x6131b5fae19ea4f9d964eac0408e4408b66337b5Kyberswap357159
    14
    0xdef1c0ded9bec7f1a1670819833240f027b25eff0x350293
    15
    0x1a1ec25dc08e98e5e93f1104b5e5cdd298707d31Metamask316162
    16
    0x45a62b090df48243f12a21897e7ed91863e2c86bTrader Joe23188
    17
    0x6352a56caadc4f1e25cd6c75970fa768a3304e64Openocean183126
    18
    0xc4729e56b831d74bbc18797e0e17a295fa77488cYield Yak16481
    19
    0x1231deb6f5749ef6ce6943a275a1d3e7486f4eaeLifi10573
    20
    0xc5b8ce3c8c171d506deb069a6136a351ee1629dcGlacier9634
    36
    2KB
    9s