flipside

    yummy-violet
    jiachenapryummy-violet
    Updated 2025-03-01
    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, -12, CURRENT_TIMESTAMP())
    and BLOCK_TIMESTAMP>'2025-02-28 16: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



    Last run: about 2 months ago
    TO_ADDRESS
    TX_COUNT
    AGGREGATED_TX_HASH_LIST
    1
    		0xb40689d6ebf4e910b876121d754406d0806271df9
    [ "0xee33430fe9bf5921cde96bf8838f1d70efbe082ad2db4d1c4725b028a60db734", "0x56229f541ae520235999f881cadcb2aae364b2139a32811f8394d1839278c956", "0x6ec9593ea79c841d15a7e864127bf4d19c54f5d44df6e5fa0236f4f83b2c6060", "0x6fb6bf2914860df0e18a610b4dffb977282f0d2e2a9d2c7c29a055891f51197d", "0xc3efece74e1b4e247b056652241b6d822dec365b5813d9226bb1d6d116919033", "0xc9f88f9695e39741f41a92703e61d78ea5d5559666622e8f643bb0580e2a1b8c", "0x06645a58c70081375e25fd18403285ed01b55ea29db7abd24496bd9e47434c2f", "0xb22a321a0e67ebe33f0a2d55fe472e4f059217002a25919638892bc27b383cd3", "0xfa4a4403ce110f683ad6ff02c9e78944f4f0b56153530acf7dfb8e595302b448" ]
    2
    		0xb4dfa4030a977be5ffbd90397332be2a19916b8d6
    [ "0x196be8f38ae78449c8a58f5f74853341b016a2319eeb2a8b43fbebcdad69fb23", "0xccf27c14d6fe80c6e0b99650df5284f323ae1c3941bbefc8fee6f9c00e466f92", "0x2169a5298ab6ab53cb896ec6f288236c119e3f734c886550b93d7b6d2b562bba", "0x281f75c55d8b2aa5cb7c7054107392e2452450c775b32fcefdb70ffc894838a6", "0xcd577389f8b8d88f31e5d0580ff85d2afae812720b05689d6a636b603835bb95", "0xefdf953b10090b348d84d90329f32e8368eb77b1a5a02ba310db38e47dc50c46" ]
    3
    		0x54516e6eed372b2a845f5b426d450c6a9cabdf274
    [ "0x77eb0e2eab4e89022ed4823656101ae88e839572e85f555b5e205f8324ffb1b1", "0x6f2a84c72526a68ec6d3125f6e0907d2129c68846e7d00b2d68cffb137caacad", "0x7c56efecc4e6a03a9285e756f1ce8215c56083af89eb988eff8458cf8be8d4d7", "0xcec993c01dbddcf2177e1fcf41dac99396be098f33ea9be498cad90af878d984" ]
    4
    		0x5f3ed5e867ca660d46adc132ba3e25b3da33545a4
    [ "0x1322244475c10e349bafba3ef3f879c1be79e16fca2de22fe2e071980ff51bc6", "0x509ff86d271590939b0f7c06e381234152b51cedd0fbe20cc59acc65369e1586", "0x62f6852265624558e4fd7cedbd2b050c9afb45cd321d5d45eba55e4ca11438da", "0x8cd23d49d26f5ad461640c80c710d7dd02c2e31bd561f7cafea558156a2b7072" ]
    5
    		0x42a3c37512489365df1c25bc2ce902676a382cbb4
    [ "0xadf559f8a78c466d1d530a47974696b5c059632ac66092cca958ca3237b5c03f", "0x2d17314806507edec32fbf9cabe9fac850576f91677ca1005d5662d37ccb8754", "0x04a3f2b3db2f525f47e8b8e2975816ac8523ba97ae289afb92d22f01b745f0ff", "0x150e5cef61fd8f6d547d124e4d7cc7d9c1f2c8b3dbb6d94bf49df108ab851695" ]
    6
    		0x03335e90e316913ee1d08eaa67de68378c239bab4
    [ "0x81a7173fffbe86797455eebd13ba5af08b4dccf462ec81fc9a271ca92c5086a4", "0x53d6fb4e1ede4e2cf51b42ae21029deb24039dd078e566c46f8551bed7bf48d8", "0x2dee0d04226e6fef8f536dab08880b679ce396d9c3a2d8bbfb8284edc470a5bc", "0x3603b0cde666d466a8f5218e4c04179c37402ab5b69152066e3069db1ad6fa5e" ]
    7
    		0x8bfeff24f607937dbdbdc36032fd71aab76a41f74
    [ "0x6c946c940dd3a013a11198d16daa0d12e8f1ae1d4f95d00c032fd889cb7d3ddb", "0xf0088e02e2d4da4bee5e60986ea8384844c4a51e9d963fa18e8786e7d3efd635", "0x8f4dee02976394611cae9d20b08e3543e1f0f24d2f9fb54656525e5287cae54f", "0xfcf3377c576623b7d89c9225872eb398f7df27d3830baab338d32d5e22becd76" ]
    8
    		0x6e490cdfb898e16fb2e84d9aeffe9d0ac25dd2ba4
    [ "0x1ce239e396865e5a78659549e059079771c047a79f1129abf7b9c51944a03f63", "0x7715edc3dcd851046a86ff065ac8aab2aa5c114e152d0f745e002a4286e935f2", "0xbc04d40ac8f20991ae976678134231a34029a7c15b148914df35f3710eba8502", "0xe68663754b6a4f45961c9f6b44f5d24adf076cc904779fe28879a81edab82279" ]
    9
    		0x9c62215400e981a875bbddb391b45e17a4c4a12e4
    [ "0x7a17a94d504ffd4f0af761d68e1e3db93a23e823500a3885c8151a232f7a307e", "0xbb219954f680d9bf0a6b7f290b80dd5eebbeefc3502407e0aac7df902868af06", "0xa7996ac761c0887aef121aeefb8129675e0194b7d65e7e54c4c6d6e159174567", "0xeb94bd78c5b33f3cb909818ebe983f087957e324b52907ffcb0c46520510558a" ]
    10
    		0x9397dbff1dc706142ed368f354a34b4a7671b1f53
    [ "0x1a046ad66238026ce5203bcf822c04c0f61e5338e01f303acc94b01145491c3e", "0x4086fea762dd3a4f569a3daab9ea60381ec333ec9198c339ee4719617b32aa71", "0x6887cd189eb1898716b5fd9813694d1c7c1ae12fa7e643927a5a33276c516ebe" ]
    11
    		0x506cdb7f7ec9d870c381db424da1b3fd1724cfb13
    [ "0x17b2557908e75f64ab5a473b0085ae13b0295b9e2bd568d8f3122c061ee5cf3b", "0x1af1fffee9364c49a1a47087a24b05e7d796275438ed02b06caeeaed5863a7f1", "0xf0c8b0025c5defe8b6f90da5b949a4e85e972ea72ba26c59345cff3d61b700f0" ]
    12
    		0x04e2737a3ecd3a8c4a7d12b0ba8a08059791dd063
    [ "0x6e3ad3e2089084f9243fcdbadcf2472f613cec695ba80268e312a59a7efd4a99", "0xdd4870324417fcf18897c7df87dc53dcc606bf08616088584b89b8870bb8291e", "0xb14e378cf7f8986b2befca71b3ef6d9371845f352ddbd4f3856037a99ddf6dd9" ]
    13
    		0xd1f45e1c7200793d9cad061eba79335f1120da973
    [ "0xe605a28a3bb8f73215c803a8499c856697d1bb1dfa5763e710c9a0f51fd9bf73", "0x6e903bd40d92c07b6e5edc39d3259b52e30a78ebb0626b0f5f2ac5d4f07ce3a4", "0xc4972a52b9e32b3490f76fe5288b843f4b3b4b8b83cad1be8886f548858f5d47" ]
    14
    		0x322a70b07605fc47d63965c907d4d64c51f458a93
    [ "0xa5d5008dfeba618dab44b60a4cedc87c46f3b515d333650a73cbf50b6c2fd0dc", "0xde7d1fac5986726073cc9452a32c1cc9d9389279ed1dd933ae5283c1f44e64cd", "0x0912109d3da8e4d9094e449fc7e36d5ba7cbf965677014db951799acf6c9dfad" ]
    15
    		0xb880e48354074da827ef17a41416e787d58e38783
    [ "0xdf1d64e9334b63431d210f38c83bd53931c3cb6d3e6283ca6c3aee88569a4e52", "0x683489c03dc28ac3b3103d24a138da02d0514b02e90242a0c9087f9458b6ba8a", "0xf794c5dcad5dcc849dedc023fd633bfcc36674968d6e5456fc0292bd65c1f1fb" ]
    16
    		0xa5470a79c54e688a2f1c005899c41a4b847df98b3
    [ "0x9f3227bd96a76dd2a9ae215c6b33ceb05ffb6ca275b7c38cc8b7d64ec0e0b6e7", "0xf3cb280650c4aab5a4986ad699854360bafe3d24408714c331238f45e390d037", "0x359454d7f906b2fa2ec5550a9d0685bb12848741f3a5e3584c61e43921d559f4" ]
    17
    		0x85460e86511a2665f0089c98725f463222d683aa3
    [ "0xa7e4f9310a23c035c6297751134c212e0377f8e663f7a51a32cc09e237a68cf7", "0xe26481df47894449c4fd14159046c9f1fb8b21e48c9d264a98a62983ded3f9a6", "0xd8dd825f06109115c1fa8c9b011ac8e63fcd266ed4cba1721ceafd2143b2db2a" ]
    18
    		0x3725612fbe5eb040da6d1399b4b8eb3134a80a783
    [ "0x4bc1d7fd05282be79d29be5f5e0fcc0af53470c16a192adcf1b7f64803e860e0", "0x0d195d61ff7e514e73c5945683fde7288cad61d8ed2f1fbeec009a70c9a51f08", "0x657241e64965477b5a01bee98db896253914719cb5cfc4f0a22bc28544504329" ]
    19
    		0xc11eee3cc7f0e9d252366de6bef6d16a13ed26ca3
    [ "0x5d9539363abc602a64e47fe98c2c25a0deb0ff827e40b957cab97c7c0666fe37", "0x8aff649c4c99b0c42ce0f06e4db17367e68bf238351eb69efc3c767ab2dbe27f", "0xe06e11498c442c0433f270b6ba2c63bdcd1ea3f295a7a989a8b022147fbf3a36" ]
    20
    		0x064d3de4348c822f90523321559bef2bbf6916533
    [ "0x8d6f0f476ed0d14acacb629664dc4d295f19e8f1db272ac082d4cc48c3da8375", "0x1a6a9467794712d737683f83956a8f09aec4c1c6ae2406ca9988af831347831a", "0x9917e45c2e7c1f3d7d07fe3767f46d59d2979ee8f6b03f7fb8c231cc5d424b2f" ]
    24
    7KB
    2s