flipside

    bug_details
    aPrioribug_details
    Updated 2025-03-01
    with bug_address as
    (
    SELECT
    TO_ADDRESS,
    COUNT(DISTINCT TX_HASH) AS tx_count,
    ARRAY_AGG(TX_HASH) AS aggregated_tx_hash_list
    FROM
    (
    SELECT
    TO_ADDRESS,
    TX_HASH
    FROM
    monad.testnet.fact_transactions
    WHERE
    FROM_ADDRESS = LOWER('0xD7a24d1F1435CD314E86736E139f8431D4498D4e')
    AND VALUE = 2
    AND TX_SUCCEEDED
    AND BLOCK_TIMESTAMP > DATEADD(HOUR, -8, CURRENT_TIMESTAMP())
    and BLOCK_TIMESTAMP>'2025-02-28 12:00:00' --select the right BLOCK_TIMESTAMP
    ORDER BY
    TX_HASH
    ) AS sorted_tx
    GROUP BY
    TO_ADDRESS
    HAVING
    COUNT(DISTINCT TX_HASH) > 2
    ORDER BY
    tx_count DESC;
    -- 0x3C85e0b9D0126AD3C8835Dadfd3E8F8C5f914144
    )


    SELECT
    TO_ADDRESS,
    TX_HASH,
    BLOCK_TIMESTAMP,
    Last run: 19 days ago
    TO_ADDRESS
    TX_HASH
    BLOCK_TIMESTAMP
    VALUE
    1
    		0x03335e90e316913ee1d08eaa67de68378c239bab0xed6c8228816d2242818e2a1a1a70f2ab908f6bc444ff0475925d74ef6c76e2552025-02-28 14:04:44.0002
    2
    		0x03335e90e316913ee1d08eaa67de68378c239bab0x2dee0d04226e6fef8f536dab08880b679ce396d9c3a2d8bbfb8284edc470a5bc2025-03-01 04:29:22.0002
    3
    		0x03335e90e316913ee1d08eaa67de68378c239bab0x3603b0cde666d466a8f5218e4c04179c37402ab5b69152066e3069db1ad6fa5e2025-03-01 04:30:30.0002
    4
    		0x03335e90e316913ee1d08eaa67de68378c239bab0x81a7173fffbe86797455eebd13ba5af08b4dccf462ec81fc9a271ca92c5086a42025-03-01 04:30:51.0002
    5
    		0x03335e90e316913ee1d08eaa67de68378c239bab0x53d6fb4e1ede4e2cf51b42ae21029deb24039dd078e566c46f8551bed7bf48d82025-03-01 04:31:07.0002
    6
    		0x0395d99296f220086c1d880217da29eb77c9a4fa0x12c78dbfa6016561698c7b18f5e269bbed3a094da088ee7ca6a032ecaf04deb52025-03-01 07:32:23.0002
    7
    		0x0395d99296f220086c1d880217da29eb77c9a4fa0x779243b423a5c237818686a982306b7cc40fbd9c3ded3f9c20e19780e74fc07d2025-03-01 07:33:07.0002
    8
    		0x0395d99296f220086c1d880217da29eb77c9a4fa0x66fc067ec8b6937404260aa122148f6f896deeb2dc205b6066de676aae86b6522025-03-01 07:33:25.0002
    9
    		0x04e2737a3ecd3a8c4a7d12b0ba8a08059791dd060x865e48ee4036beea2d50fca4ff8c52da154fc07e0393340002f86be5215ffba72025-02-28 14:54:46.0002
    10
    		0x04e2737a3ecd3a8c4a7d12b0ba8a08059791dd060xdd4870324417fcf18897c7df87dc53dcc606bf08616088584b89b8870bb8291e2025-03-01 04:28:28.0002
    11
    		0x04e2737a3ecd3a8c4a7d12b0ba8a08059791dd060xb14e378cf7f8986b2befca71b3ef6d9371845f352ddbd4f3856037a99ddf6dd92025-03-01 04:28:51.0002
    12
    		0x04e2737a3ecd3a8c4a7d12b0ba8a08059791dd060x6e3ad3e2089084f9243fcdbadcf2472f613cec695ba80268e312a59a7efd4a992025-03-01 04:29:54.0002
    13
    		0x064d3de4348c822f90523321559bef2bbf6916530x9917e45c2e7c1f3d7d07fe3767f46d59d2979ee8f6b03f7fb8c231cc5d424b2f2025-03-01 02:31:24.0002
    14
    		0x064d3de4348c822f90523321559bef2bbf6916530x1a6a9467794712d737683f83956a8f09aec4c1c6ae2406ca9988af831347831a2025-03-01 03:05:17.0002
    15
    		0x064d3de4348c822f90523321559bef2bbf6916530x8d6f0f476ed0d14acacb629664dc4d295f19e8f1db272ac082d4cc48c3da83752025-03-01 03:05:29.0002
    16
    		0x0ff63c6c4bfc9f666c0a1e2e10e15fbbaff49f320xb77ce30ba30fbf9bc5565d64c2941e70bc9f39a4c24cd1d606d0e636a930ffe92025-03-01 04:27:44.0002
    17
    		0x0ff63c6c4bfc9f666c0a1e2e10e15fbbaff49f320xa8942bb5abe523ffca035a980e34cf9b5934a92664d2530ef30a5df7763afe502025-03-01 04:30:01.0002
    18
    		0x0ff63c6c4bfc9f666c0a1e2e10e15fbbaff49f320x50d4af2f13a675fed8fbdf6eb0a1f31888826b0d73a831587e36dd6a0348f95c2025-03-01 05:03:00.0002
    19
    		0x24e093d93e58b83350b6cf92bb7f0abb95fded520x0e1acef5d99b151407ee8b91db6ed00539c481a55c23477ebcc1e89fbe4388602025-02-28 14:56:00.0002
    20
    		0x24e093d93e58b83350b6cf92bb7f0abb95fded520xa636b38b8d24404763a0cd08ed4dc78b760bd1c93834c3b24f9ab2e21a40c4a82025-03-01 04:23:46.0002
    ...
    113
    16KB
    2s