par_rnMantle 03
    Updated 2025-03-28
    SELECT
    from_address,
    COUNT(DISTINCT tx_hash) AS total_transactions
    FROM
    mantle.core.fact_transactions
    WHERE
    block_timestamp >= CURRENT_DATE - 30
    AND from_address != '0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001'
    GROUP BY
    from_address
    ORDER BY
    total_transactions DESC
    LIMIT 100

    Last run: 14 days ago
    FROM_ADDRESS
    TOTAL_TRANSACTIONS
    1
    0x57ebc56ee2903784c73e880b6aed1921baac3376246350
    2
    0x588846213a30fd36244e0ae0ebb2374516da836c135724
    3
    0x03ac0b1b952c643d66a4dc1fbc75118109cc074c84612
    4
    0x0000004eba872864a71b957180eb17dff71bb8f157749
    5
    0x339d413ccefd986b1b3647a9cfa9cbbe70a3074957125
    6
    0x8a7821cef573fb764b7aae1d5ace2d38f878b22d39622
    7
    0x600a2bf59962554ec8dc642d57911a5db216372037316
    8
    0x000000000e86f1e840b28948545b4371c78cd5e734595
    9
    0xff4ad15fc21c33ad86d51aed871ffc4bef95297a33746
    10
    0x7cbd5a3ff8e8879577213a49c725dd433c1a6e1430617
    11
    0xab97925eb84fe0260779f58b7cb08d77dcb1ee2b25202
    12
    0x3a32b9c50191cbea09879779ae5078e46cfd6b2424640
    13
    0x0599fca8c7a6c0c6ce4dea90024839b2823e071724403
    14
    0x2aa6845f7e84b2cc1619c823bf4f6b04ec733f2c22841
    15
    0x1322bb56ed2b4d4e4bf05347447de82ac831bd9022602
    16
    0xe93685f3bba03016f02bd1828badd6195988d95022353
    17
    0xdde3a0e55ad28420dca42d4b67864e18e8f3295621473
    18
    0x5c4368f728dc348ef1b4396843fc3101870782ce21196
    19
    0x4a811fc4150b0dacf5eeb9e826b56279254b733320097
    20
    0xb8ff877ed78ba520ece21b1de7843a8a57ca47cb19698
    100
    5KB
    4s