Afonso_DiazTop Users
    Updated 2025-04-11
    with

    main as (
    select
    tx_hash,
    block_timestamp,
    from_address as user,
    tx_fee
    from
    mezo.testnet.fact_transactions
    where
    tx_succeeded
    )

    select
    user,
    count(distinct tx_hash) as transactions,
    sum(tx_fee) as fee_volume,
    avg(tx_fee) as average_fee_amount
    from
    main
    group by 1
    order by 2 desc
    limit 100
    Last run: 13 days ago
    USER
    TRANSACTIONS
    FEE_VOLUME
    AVERAGE_FEE_AMOUNT
    1
    0xc2a912d17e0dfae27e17ef0cf3baf5bec659a6ea221493.289457499e-91.485149442e-13
    2
    0x6e80164ea60673d64d5d6228beb684a1274bb01753241.144663469e-82.150006517e-12
    3
    0x24a5f4160d23a34d0a3ac51e4897a23a7909e36312402.490353864e-92.00834989e-12
    4
    0xa86e1e2c719c5731b72a2681e85740b5a86e51a110365.30204885e-105.11780777e-13
    5
    0x73b3126efc32f3147f6a7e757e8df2151d327e2c8328.55303008e-101.028008423e-12
    6
    0xed3af36d7b9c5bbd7ecfa7fb794eda6e242016f52910.00017764523116.104647118e-7
    7
    0xe961066d859d4922b51269801cd26a2351c4f1e32491.41036512e-105.664116948e-13
    8
    0xd15b0342ded129c3bae109f4731ff0ae614592e32251.44146513e-106.406511689e-13
    9
    0xdf03986bebf37bc8a26d4c560a0f272e1834ecca1889.7237175e-115.17219016e-13
    10
    0xa85b80cd8e524331032ac8e58cf8c98a69da80731451.43137592e-109.871558069e-13
    11
    0x15c38c9fa30d8b335dee88ff0a2ccd9a106b2bd21371.64879681e-101.203501321e-12
    12
    0x8cfa84d93e5cd174852c495910cd1aec616745951361.36283061e-101.002081331e-12
    13
    0x537264426c72e68618742b6d54645c0a7ba6f28c1311.8988004e-101.449465954e-12
    14
    0xec8287faef6cd7fc9887be6e40d6abc0ccb29d2f1271.25540256e-109.885059528e-13
    15
    0x28f83689e1463a83482e2ff6ba381fa3047b0f331072.04187095e-101.908290607e-12
    16
    0xb76ef8052acb402e5fbd478232bb41420aa72af3982.68386951e-102.738642357e-12
    17
    0xe45eac0f77576fcd6f01f7c119393e9e0214f743942.22301457e-102.364909117e-12
    18
    0xf0276d7d27a98cbed1635e7079716e9eed73f329925.1587824e-115.607372174e-13
    19
    0x1c6ae2fa7aabcfd393c73d986db7fcccbefb3999921.22803121e-101.334816533e-12
    20
    0xb8f5fd1478f6d0b4c6c7473f749eae9e0f60d309872.05104403e-102.357521874e-12
    100
    8KB
    2s