victor-sanzcapdetTop 10 Most Active Wallets by Transaction Count
    Updated 2024-12-23
    SELECT
    account_address,
    COUNT(*) AS transaction_count
    FROM
    aptos.core.fact_transfers AS et
    JOIN
    aptos.core.dim_tokens AS dt ON et.token_address = dt.token_address
    WHERE
    dt.symbol = 'doodoo'
    AND et.success = TRUE
    AND et.block_timestamp >= DATEADD({{Period}}, -1, CURRENT_DATE)
    GROUP BY
    account_address
    ORDER BY
    transaction_count DESC
    LIMIT 10;
    Last run: 19 days ago
    ACCOUNT_ADDRESS
    TRANSACTION_COUNT
    1
    0xa31dfc92a0c42bbd37a255b35b8b7989caa059ec83d2773b705cac8e39e541071160
    2
    0x48271d39d0b05bd6efca2278f22277d6fcc375504f9839fd73f74ace240861af398
    3
    0x149833cfb9cbb56f665b9d637175b06f65b80213a71998ff60f141f0f809b96390
    4
    0x61c2c82337d84545eca0b2cf7c5ea365b217309e04df9bd259e7aba0c78f72f81
    5
    0x576410486a2da45eee6c949c995670112ddf2fbeedab20350d506328eefc9d4f75
    6
    0x67caa4346a2f486b3a5e9a5b4bd2a216b948452bb666ed014c81f28aca82e0d861
    7
    0x75a13f1310edd7d5eec191ffb610866e65b0dffdb2cdadfffce027718804091160
    8
    0xf917612065baf2fe77afbfefea54706bb6de8afcdfda0364c06210b4e485b96b55
    9
    0x6bfa2b755fae50e7bd9e6ad832ff354cdf28699c51a7865231b4b46f9b35947d48
    10
    0x6ddefcef244e364222b686913a8ef71343aa1b5b3a8bb54c74c50895c8c63fbe36
    10
    743B
    1s