flipside

    large-peach
    peachycrypttlarge-peach
    Updated 2025-05-29
    WITH first_seen AS (
    SELECT
    from_address,
    MIN(DATE(block_timestamp)) AS first_tx_date
    FROM monad.testnet.fact_transactions
    GROUP BY from_address
    )

    SELECT
    t.from_address,
    f.first_tx_date,
    COUNT(DISTINCT t.tx_hash) AS tx_count,
    COUNT(DISTINCT DATE(t.block_timestamp)) AS active_days
    FROM monad.testnet.fact_transactions AS t
    JOIN first_seen AS f ON t.from_address = f.from_address
    GROUP BY t.from_address, f.first_tx_date
    ORDER BY tx_count DESC;

    Last run: about 1 month ago
    FROM_ADDRESS
    FIRST_TX_DATE
    TX_COUNT
    ACTIVE_DAYS
    1
    		0x1a766a2812af076a870a7e55094db884b2f974e82025-02-21 00:00:00.0002369590636
    2
    		0x051785102854b9b9c93c504d9675ffda7a12e07f2025-02-19 00:00:00.000338357975
    3
    		0x4c6348bf16fea56f3de86553c0653b817bca799a2025-02-12 00:00:00.0002952931104
    4
    		0xc7edfecdd70e330f0849fa00b736a70f977d86782025-02-23 00:00:00.000270280017
    5
    		0x0a215135f235ffcf52b7a2116bcd7e8c5579e2092025-03-07 00:00:00.000249969370
    6
    		0xa5a68ed167431afe739846a22597786ba2da85df2025-01-29 00:00:00.0002129297108
    7
    		0x050eba46265667efe3a64ac709e74b94d7e074e72025-02-21 00:00:00.000173601986
    8
    		0x7d6a2ca771ac7c68d4e2bace94a3926af30d7d832025-01-16 00:00:00.0001697602125
    9
    		0xc6392ad8a14794ea57d237d12017e7295bea23632025-02-20 00:00:00.000148331799
    10
    		0xc0f2bacafbc928be652cb6fbd3caf75d651329b82025-02-19 00:00:00.00013709279
    11
    		0x307d06edcc51d5cf7ca84ab78749209d804699ff2025-01-30 00:00:00.0001346075118
    12
    		0xcc402530ab6a9ce77eba94084b0a2399ba47ac0a2025-04-09 00:00:00.00013433275
    13
    		0x89fc331e7a3eebe3d63c000927b79c47f455399f2025-02-20 00:00:00.000106180235
    14
    		0x7c34da3ca7e10cf47376ef34f04e758374d2d2832025-02-25 00:00:00.000105367342
    15
    		0x985ddbb8dd2c6eba617fa059e75f61c329d7501d2025-02-03 00:00:00.000105154466
    16
    		0x829135bd39d4211af4dc51239ce7f938b302d5e32025-04-21 00:00:00.00076843937
    17
    		0xcf36de4fcb20dfa6f76a14649e8dbdce3a18d0102025-01-16 00:00:00.000687092105
    18
    		0x5790bc75e4d09bb7327f21a90d48ce82aad04d5e2025-01-28 00:00:00.000683090105
    19
    		0x01c2257240ce3ddb5b167dc19a2e7367b459ecf02025-03-16 00:00:00.00067149043
    20
    		0xca8316e1471dbe4080b281ff6ffbc88d00c123a32025-02-20 00:00:00.00064850876
    100
    8KB
    261s