flipside

    smart-aqua
    mamad-5XN3k3smart-aqua
    Updated 2025-02-21
    /*select *
    from monad.testnet.fact_transactions
    where tx_hash = '0xb127dae883afad2ebbbb6694b1ba3b818eba05c47f5c4b809fd51fc9a284c750'

    select
    *,
    regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}') AS segmented_data,
    TRY_TO_NUMBER(ethereum.public.udf_hex_to_int(segmented_data [0] :: STRING)) AS amount0In,
    TRY_TO_NUMBER(ethereum.public.udf_hex_to_int(segmented_data [1] :: STRING)) AS amount1In,
    TRY_TO_NUMBER(ethereum.public.udf_hex_to_int(segmented_data [2] :: STRING)) AS amount2In,
    TRY_TO_NUMBER(ethereum.public.udf_hex_to_int(segmented_data [3] :: STRING)) AS amount3In,
    TRY_TO_NUMBER(ethereum.public.udf_hex_to_int(segmented_data [4] :: STRING)) AS amount4In,
    TRY_TO_NUMBER(ethereum.public.udf_hex_to_int(segmented_data [5] :: STRING)) AS amount5In,
    TRY_TO_NUMBER(ethereum.public.udf_hex_to_int(segmented_data [6] :: STRING)) AS amount6In,
    TRY_TO_NUMBER(ethereum.public.udf_hex_to_int(segmented_data [7] :: STRING)) AS amount7In
    from monad.testnet.fact_event_logs
    where tx_hash = '0xb127dae883afad2ebbbb6694b1ba3b818eba05c47f5c4b809fd51fc9a284c750'
    */
    select
    *
    from monad.testnet.fact_event_logs
    where contract_address = lower('0xE8F0635591190Fb626F9D13C49b60626561Ed145')
    order by BLOCK_TIMESTAMP desc
    limit 2000

    Last run: 22 days ago
    BLOCK_NUMBER
    BLOCK_TIMESTAMP
    TX_HASH
    TX_POSITION
    EVENT_INDEX
    CONTRACT_ADDRESS
    TOPICS
    TOPIC_0
    TOPIC_1
    TOPIC_2
    TOPIC_3
    DATA
    EVENT_REMOVED
    ORIGIN_FROM_ADDRESS
    ORIGIN_TO_ADDRESS
    ORIGIN_FUNCTION_SIGNATURE
    TX_SUCCEEDED
    FACT_EVENT_LOGS_ID
    INSERTED_TIMESTAMP
    MODIFIED_TIMESTAMP
    1
    		42736512025-02-21 07:32:36.0000x94463c595829d711c94abedebf399a0d08e375555b1469688bffc05543994ff52100xe8f0635591190fb626f9d13c49b60626561ed145
    ["0x17307eab39ab6107e8899845ad3d59bd9653f200f220920489ca2b5937696c31","0...
    		0x17307eab39ab6107e8899845ad3d59bd9653f200f220920489ca2b5937696c310x00000000000000000000000066c6d1d1f58c9449f906de0154d81a5e31ba9b6d0x000000000000000000000000fbf166299d3c012de9efec0240d12756c1f4c0fc0x0000000000000000000000000000000000000000000000000000000000000001FALSE0x66c6d1d1f58c9449f906de0154d81a5e31ba9b6d0xe8f0635591190fb626f9d13c49b60626561ed1450xa22cb465TRUEcf77d3bed7a80208141b0b47267114f82025-02-21 07:52:40.4422025-02-21 07:52:40.442
    2
    		42735872025-02-21 07:32:04.0000x1b164688c9ac7f6e1b10a414466c840e99a5169b093e8cefbae5c7881fd275aa19540xe8f0635591190fb626f9d13c49b60626561ed145
    ["0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef","0...
    		0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef0x000000000000000000000000993a86fe852ef0e7a92f9a180f02d03db9e6cafe0x0000000000000000000000002ad688eac0a8ee8d2d86693406869c709eb7e87e0x000000000000000000000000000000000000000000000000000000000000019c0xFALSE0x2ad688eac0a8ee8d2d86693406869c709eb7e87e0x0000000000000068f116a894984e2db1123eb3950xe7acab24TRUEdeeb5c81c382e98980a812cfa00d066e2025-02-21 07:52:40.4422025-02-21 07:52:40.442
    3
    		42698392025-02-21 07:00:50.0000xb4e882517eebfe1b72a8d75e3561ab0248ef84932766b2f4870c8ce65c75148522560xe8f0635591190fb626f9d13c49b60626561ed145
    ["0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef","0...
    		0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef0x000000000000000000000000181f667cc1af03051ea9014f5e7836244a02aec70x000000000000000000000000437aa4c774da5a51a24636732e2daeaf53ba21290x00000000000000000000000000000000000000000000000000000000000001840xFALSE0x437aa4c774da5a51a24636732e2daeaf53ba21290x0000000000000068f116a894984e2db1123eb3950xe7acab24TRUE1461f57b8e35820764641a94004461af2025-02-21 07:52:40.4422025-02-21 07:52:40.442
    4
    		42599712025-02-21 05:38:29.0000x335926a8d23c1f18a99d2cfab566fb3641430839a2ebbca1ed2b521b9c410e5c9450xe8f0635591190fb626f9d13c49b60626561ed145
    ["0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef","0...
    		0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef0x0000000000000000000000006cb787205ba97639e3255f98a698e0da6b016f690x00000000000000000000000049ab965ea7d0fa98714843dbd595f78815d14de60x00000000000000000000000000000000000000000000000000000000000001260xFALSE0x49ab965ea7d0fa98714843dbd595f78815d14de60x0000000000000068f116a894984e2db1123eb3950xe7acab24TRUEdcbb8b1d629ce9ec35cfc21e436a36692025-02-21 06:53:06.9242025-02-21 06:53:06.924
    5
    		42580052025-02-21 05:22:03.0000x25ed8fb2f529f14bae7b5505fe2d1f23b82ec2714e630cdc8ffeccb36649425d19430xe8f0635591190fb626f9d13c49b60626561ed145
    ["0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef","0...
    		0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef0x0000000000000000000000000d1c41d60ef876b3244c9db50ea5c196ced8e07e0x0000000000000000000000007c66f2575ca9d164b20a1915dde02b7df7d886ca0x00000000000000000000000000000000000000000000000000000000000001650xFALSE0x7c66f2575ca9d164b20a1915dde02b7df7d886ca0x0000000000000068f116a894984e2db1123eb3950x87201b41TRUEd85806bb68e5014f3f776b390d963a512025-02-21 06:53:06.9242025-02-21 06:53:06.924
    6
    		42580052025-02-21 05:22:03.0000x25ed8fb2f529f14bae7b5505fe2d1f23b82ec2714e630cdc8ffeccb36649425d19440xe8f0635591190fb626f9d13c49b60626561ed145
    ["0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef","0...
    		0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef0x0000000000000000000000000b24dc8537340dcf4ff89f522f32ceb6395ef3960x0000000000000000000000007c66f2575ca9d164b20a1915dde02b7df7d886ca0x00000000000000000000000000000000000000000000000000000000000001930xFALSE0x7c66f2575ca9d164b20a1915dde02b7df7d886ca0x0000000000000068f116a894984e2db1123eb3950x87201b41TRUE29408414a81a0eff77a3bc0e1317f54c2025-02-21 06:53:06.9242025-02-21 06:53:06.924
    7
    		42568622025-02-21 05:12:33.0000x139cae07b713bb8b0d4664745cd77107d3cf03e2b8d5e2a52fbacc70e5be4ba59390xe8f0635591190fb626f9d13c49b60626561ed145
    ["0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef","0...
    		0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef0x0000000000000000000000002cfae81f5a98eebddbd8a06de89cb1ea7c236d450x000000000000000000000000cac4f9d03002e095df3cabfe625e93bbb72603630x00000000000000000000000000000000000000000000000000000000000001d20xFALSE0xcac4f9d03002e095df3cabfe625e93bbb72603630x0000000000000068f116a894984e2db1123eb3950xe7acab24TRUE26592b1b53733f99a46888771948f8442025-02-21 06:53:06.9242025-02-21 06:53:06.924
    8
    		42554402025-02-21 05:00:41.0000x8d2d264bc50135738abff0ecfbda48b7b9406bc1c9002b194de91d998b9fbdf1270xe8f0635591190fb626f9d13c49b60626561ed145
    ["0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef","0...
    		0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef0x0000000000000000000000007439ce4c3e7d9ad7ce302bd11af28e341d8688370x000000000000000000000000301b67570fe048b8d1c8ffc8206b1c43cbe776740x00000000000000000000000000000000000000000000000000000000000001c20xFALSE0x301b67570fe048b8d1c8ffc8206b1c43cbe776740x0000000000000068f116a894984e2db1123eb3950xe7acab24TRUE3f368f68c93aa3f99528a0aee94e815f2025-02-21 05:52:51.6462025-02-21 05:52:51.646
    9
    		42539572025-02-21 04:48:17.0000x7a133df06d9807ad0400526f2e3f7ab1507fb8efadde9f6a7805f8b423541113130xe8f0635591190fb626f9d13c49b60626561ed145
    ["0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef","0...
    		0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef0x0000000000000000000000006cb787205ba97639e3255f98a698e0da6b016f690x000000000000000000000000fe79f39d1c84ad08670f5b93280dfbc3a0c542290x00000000000000000000000000000000000000000000000000000000000001280xFALSE0xfe79f39d1c84ad08670f5b93280dfbc3a0c542290x0000000000000068f116a894984e2db1123eb3950xe7acab24TRUE9156d77364493011034be03edf47260e2025-02-21 05:52:51.6462025-02-21 05:52:51.646
    10
    		42538812025-02-21 04:47:38.0000xe2d9b50405e3c414994e280bbe900dd5376a3748ab68fe0093e536e1638374c55200xe8f0635591190fb626f9d13c49b60626561ed145
    ["0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef","0...
    		0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef0x0000000000000000000000006cb787205ba97639e3255f98a698e0da6b016f690x00000000000000000000000081a0db45b7595198f71cd2bf7b645b9df99fc4150x00000000000000000000000000000000000000000000000000000000000001290xFALSE0x81a0db45b7595198f71cd2bf7b645b9df99fc4150x0000000000000068f116a894984e2db1123eb3950xe7acab24TRUEc4068a279f7f639ef8f0ac46ab98b5d82025-02-21 05:52:51.6462025-02-21 05:52:51.646
    11
    		42532382025-02-21 04:42:17.0000x258e447749766f3fe35a6b013533f1a1549154cc3af3aaccf690d7f133282bac320xe8f0635591190fb626f9d13c49b60626561ed145
    ["0x17307eab39ab6107e8899845ad3d59bd9653f200f220920489ca2b5937696c31","0...
    		0x17307eab39ab6107e8899845ad3d59bd9653f200f220920489ca2b5937696c310x0000000000000000000000000d1c41d60ef876b3244c9db50ea5c196ced8e07e0x000000000000000000000000fbf166299d3c012de9efec0240d12756c1f4c0fc0x0000000000000000000000000000000000000000000000000000000000000001FALSE0x0d1c41d60ef876b3244c9db50ea5c196ced8e07e0xe8f0635591190fb626f9d13c49b60626561ed1450xa22cb465TRUEa050a386b40bb4411752c56ff9b479cc2025-02-21 05:52:51.6462025-02-21 05:52:51.646
    12
    		42495072025-02-21 04:11:11.0000xd0cc80235e66e8f26b86b564fff143169b79675328b2580c81da314ba1fb9b045140xe8f0635591190fb626f9d13c49b60626561ed145
    ["0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef","0...
    		0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef0x000000000000000000000000668cde0b7680bdd7fd42f706386617e9bee01ca60x0000000000000000000000005d7a86373e3df174e7e6f390ebc5c077701bce3f0x000000000000000000000000000000000000000000000000000000000000017c0xFALSE0x5d7a86373e3df174e7e6f390ebc5c077701bce3f0x0000000000000068f116a894984e2db1123eb3950xe7acab24TRUE520f3236d440a36699e2d65fefcfa9b12025-02-21 05:52:51.6462025-02-21 05:52:51.646
    13
    		42495032025-02-21 04:11:09.0000xcb9e2c55f9f8a75a74636207aa19b9c07e954d9a9b149d1e75cdf4ddaadc4b8f140xe8f0635591190fb626f9d13c49b60626561ed145
    ["0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef","0...
    		0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef0x0000000000000000000000006cb787205ba97639e3255f98a698e0da6b016f690x0000000000000000000000001d814fcd93874df29a737393ed7c7ed2eed7c3a60x00000000000000000000000000000000000000000000000000000000000001780xFALSE0x1d814fcd93874df29a737393ed7c7ed2eed7c3a60x0000000000000068f116a894984e2db1123eb3950xe7acab24TRUE7223d618f9edff059fc3380a1f530b492025-02-21 05:52:51.6462025-02-21 05:52:51.646
    14
    		42490902025-02-21 04:07:42.0000x25ce9bc9480dc71677fbf139c195df37784560fc0ecbc4322fede99e26d18b5b100xe8f0635591190fb626f9d13c49b60626561ed145
    ["0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef","0...
    		0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef0x0000000000000000000000006cb787205ba97639e3255f98a698e0da6b016f690x000000000000000000000000c2d90a10eda449d274c86f205c1cce4cb9039d750x00000000000000000000000000000000000000000000000000000000000001230xFALSE0xc2d90a10eda449d274c86f205c1cce4cb9039d750x0000000000000068f116a894984e2db1123eb3950xe7acab24TRUE7bf7e771abda74ec83dd455e95da92ee2025-02-21 05:52:51.6462025-02-21 05:52:51.646
    15
    		42476552025-02-21 03:55:40.0000x2e9f89cf3c863bf7313a24e542084805cd8d85d49b0eb1d01063b86f2813a6713210xe8f0635591190fb626f9d13c49b60626561ed145
    ["0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef","0...
    		0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef0x000000000000000000000000cff8525c74ae0c6004198b0d72dd9b77cee748ff0x0000000000000000000000006efb8976b4fef89e833ac4517cd957b6c49d34d00x00000000000000000000000000000000000000000000000000000000000001d00xFALSE0x6efb8976b4fef89e833ac4517cd957b6c49d34d00x0000000000000068f116a894984e2db1123eb3950xe7acab24TRUEb6b89d98d590df226c62bef5a7ffa3c22025-02-21 04:52:35.2602025-02-21 04:52:35.260
    16
    		42463912025-02-21 03:45:07.0000xe49fa77bb8b1c4f29abeb8d81e5258715022542d1fd74a7d87564f6ff62adb22000xe8f0635591190fb626f9d13c49b60626561ed145
    ["0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef","0...
    		0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef0x0000000000000000000000000a9173154c1d2f9f840f0eebc8d42165cbbe2a6a0x00000000000000000000000000ecfb2cdbad80b46e8701906d53fdc0cb2fb9430x00000000000000000000000000000000000000000000000000000000000001680xFALSE0x00ecfb2cdbad80b46e8701906d53fdc0cb2fb9430x0000000000000068f116a894984e2db1123eb3950xe7acab24TRUE821fb553b60f36fbd9d7ee7b95a990d42025-02-21 04:52:35.2602025-02-21 04:52:35.260
    17
    		42412172025-02-21 03:01:59.0000x04536b9e5904a0f9f1e1da386973a8c21fc3b40cdfd181efc6a5321b3a3cbaba3320xe8f0635591190fb626f9d13c49b60626561ed145
    ["0x17307eab39ab6107e8899845ad3d59bd9653f200f220920489ca2b5937696c31","0...
    		0x17307eab39ab6107e8899845ad3d59bd9653f200f220920489ca2b5937696c310x000000000000000000000000f4ec1661a9b6229038b51e2ff8ae347f5f2e19010x000000000000000000000000fbf166299d3c012de9efec0240d12756c1f4c0fc0x0000000000000000000000000000000000000000000000000000000000000001FALSE0xf4ec1661a9b6229038b51e2ff8ae347f5f2e19010xe8f0635591190fb626f9d13c49b60626561ed1450xa22cb465TRUE15744ee747f6db1079545be3974fc62d2025-02-21 03:52:42.8052025-02-21 03:52:42.805
    18
    		42380042025-02-21 02:35:13.0000xa931eb7e5846b155357924bec883cc42e63613d1d25f1232242d4b445c0d238510390xe8f0635591190fb626f9d13c49b60626561ed145
    ["0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef","0...
    		0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef0x0000000000000000000000006cb787205ba97639e3255f98a698e0da6b016f690x0000000000000000000000005bcd18db0b04ef0001b21f6a582645cdc1aa0cf00x00000000000000000000000000000000000000000000000000000000000001be0xFALSE0x5bcd18db0b04ef0001b21f6a582645cdc1aa0cf00x0000000000000068f116a894984e2db1123eb3950xe7acab24TRUE7abc14adaa524f2e8fc1778239909eaf2025-02-21 03:52:42.8052025-02-21 03:52:42.805
    19
    		42374982025-02-21 02:31:00.0000xb1b817b0e0405c88a438b5d982f164ec44414ead1cf4692d498ea01804f865098210xe8f0635591190fb626f9d13c49b60626561ed145
    ["0x17307eab39ab6107e8899845ad3d59bd9653f200f220920489ca2b5937696c31","0...
    		0x17307eab39ab6107e8899845ad3d59bd9653f200f220920489ca2b5937696c310x0000000000000000000000000a9173154c1d2f9f840f0eebc8d42165cbbe2a6a0x000000000000000000000000fbf166299d3c012de9efec0240d12756c1f4c0fc0x0000000000000000000000000000000000000000000000000000000000000001FALSE0x0a9173154c1d2f9f840f0eebc8d42165cbbe2a6a0xe8f0635591190fb626f9d13c49b60626561ed1450xa22cb465TRUE62a42ea479a123fe02455e479e3793362025-02-21 03:52:42.8052025-02-21 03:52:42.805
    20
    		42373742025-02-21 02:29:58.0000xf3e17b71891221a51d56e87526153af21469c2515e9855864bf68771e9688c084170xe8f0635591190fb626f9d13c49b60626561ed145
    ["0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef","0...
    		0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef0x0000000000000000000000006cb787205ba97639e3255f98a698e0da6b016f690x0000000000000000000000004d9057eedb6d4397788b4830ec7619451adf99b90x00000000000000000000000000000000000000000000000000000000000001ca0xFALSE0x4d9057eedb6d4397788b4830ec7619451adf99b90x0000000000000068f116a894984e2db1123eb3950xe7acab24TRUE9d22bfbd14f4bba3c637ff10faf693c12025-02-21 03:52:42.8052025-02-21 03:52:42.805
    ...
    1015
    893KB
    5s