flipside

    educational-tomato
    bgbz-8j1pHveducational-tomato
    Updated 5 days ago
    -- SELECT
    -- BLOCK_TIMESTAMP,
    -- LOWER(TO_ADDRESS) AS TO_ADDRESS,
    -- TX_HASH,
    -- value
    -- from
    -- monad.testnet.fact_traces
    -- where
    -- FROM_ADDRESS = '0x07aabd925866e8353407e67c1d157836f7ad923e'
    -- and value > 0.01
    select
    *
    -- DATE(t.block_timestamp) AS transfer_date,
    -- COUNT(*) AS total_transfers,
    -- round(SUM(t.value), 2) AS total_value
    from monad.testnet.fact_traces
    where value > 0 and block_timestamp < '2025-03-11 15:00' and tx_succeeded = 'TRUE'
    AND from_address = LOWER('0x07AabD925866E8353407E67C1D157836f7Ad923e')
    Last run: 5 days ago
    BLOCK_NUMBER
    BLOCK_TIMESTAMP
    TX_HASH
    TX_POSITION
    TRACE_INDEX
    FROM_ADDRESS
    TO_ADDRESS
    INPUT
    OUTPUT
    TYPE
    TRACE_ADDRESS
    SUB_TRACES
    VALUE
    VALUE_PRECISE_RAW
    VALUE_PRECISE
    VALUE_HEX
    GAS
    GAS_USED
    ORIGIN_FROM_ADDRESS
    ORIGIN_TO_ADDRESS
    ORIGIN_FUNCTION_SIGNATURE
    TRACE_SUCCEEDED
    ERROR_REASON
    REVERT_REASON
    TX_SUCCEEDED
    FACT_TRACES_ID
    INSERTED_TIMESTAMP
    MODIFIED_TIMESTAMP
    1
    		72685972025-03-11 09:10:14.0000x67e1ceea36e2a5372a745fabe97d2765415e3b22c41959c5ad4a546bd6318a098410x07aabd925866e8353407e67c1d157836f7ad923e0xfa3d9f9c8856292256834ce91528c262ebf82e5f0xCALL000.50295246775029524677007474020.5029524677007474020x6fad89ac8358c8a292200xfa3d9f9c8856292256834ce91528c262ebf82e5f0x07aabd925866e8353407e67c1d157836f7ad923e0xdb006a75TRUETRUE75f0eb45d6f6a61b89f68500b3f1f3f62025-03-11 10:54:38.1702025-03-11 10:54:38.170
    2
    		72846962025-03-11 11:45:14.0000x0c2ddb0650a3536a986d0ed7ac31e9e102334735d7936320ab444891e5a4989e2110x07aabd925866e8353407e67c1d157836f7ad923e0x1e6371ef56cd03a76bfe1523e50d6a92b8c08acc0xCALL000.30177148063017714806204484410.3017714806204484410x4301b9011b9bab9292200x1e6371ef56cd03a76bfe1523e50d6a92b8c08acc0x07aabd925866e8353407e67c1d157836f7ad923e0xdb006a75TRUETRUE771f54f94ab411f0704a11f11fce54532025-03-11 12:53:41.7402025-03-11 12:53:41.740
    3
    		72665272025-03-11 08:52:20.0000xb2ad2f7f50e34fdc497759380838de613587c1925e2393577c565879b4367bd81810x07aabd925866e8353407e67c1d157836f7ad923e0xb6c34bc8140df849f777650176f019a8a62f534f0xCALL000.03007655757300765575685046940.0300765575685046940x6ada7841eff376292200xb6c34bc8140df849f777650176f019a8a62f534f0x07aabd925866e8353407e67c1d157836f7ad923e0xdb006a75TRUETRUEa70d4927107696e497615d195804a4902025-03-11 09:53:59.3382025-03-11 09:53:59.338
    4
    		69151482025-03-09 07:38:27.0000x8a4e57734d12a1f6434447343caf9e7faa9542f0ab570f0eee598aadf065fecb1010x07aabd925866e8353407e67c1d157836f7ad923e0x6a6016821bb5758f2d6d17d39fcc3f61c9032a8b0xCALL000.03418117707341811770715881890.0341811770715881890x796f99755b535d292200x6a6016821bb5758f2d6d17d39fcc3f61c9032a8b0x07aabd925866e8353407e67c1d157836f7ad923e0xdb006a75TRUETRUE57264679dbdc264a7c478d3d5a9d60b72025-03-09 08:53:20.3102025-03-09 08:53:20.310
    5
    		69830532025-03-09 17:05:27.0000xc75787e59c89c445b5a3dae7b876eb3fbc61f3a7763b6c3d4035c01d277064ee810x07aabd925866e8353407e67c1d157836f7ad923e0x13976c75ef0e21547a7a12383efcd80f2e39da800xCALL000.0482557794482557793951833260.0482557793951833260xab70602d35a2de292200x13976c75ef0e21547a7a12383efcd80f2e39da800x07aabd925866e8353407e67c1d157836f7ad923e0xdb006a75TRUETRUE67e3119ad2e70261eb4ce7f3399b57492025-03-09 17:53:25.0522025-03-09 17:53:25.052
    6
    		70125502025-03-09 21:11:44.0000x57e4d87781e0313c588c1d9dfd713dec38493a4ce6a7f72255c7c92ff1a1b28f2810x07aabd925866e8353407e67c1d157836f7ad923e0x2acf8c88b94a63e7b27833833bf556698b873e470xCALL005.01946562850194656276534590795.0194656276534590790x45a8b964e2914c87814800x2acf8c88b94a63e7b27833833bf556698b873e470x07aabd925866e8353407e67c1d157836f7ad923e0xdb006a75TRUETRUEb167ed8a7bc3a55d45335919cb815c942025-03-09 22:53:07.9942025-03-09 22:53:07.994
    7
    		72122242025-03-11 01:18:33.0000x8ade7d72e4bd9a7150d01b3fec66901820421320048663888f0b1aa8e0ecaaa1910x07aabd925866e8353407e67c1d157836f7ad923e0xa50e7aca263b1ee0f25b1c923bf94b82ee8c7eb40xCALL000.0298582635298582635007696830.0298582635007696830x6a13eeb592c993292200xa50e7aca263b1ee0f25b1c923bf94b82ee8c7eb40x07aabd925866e8353407e67c1d157836f7ad923e0xdb006a75TRUETRUE3fafcbdbd0ad71bf63773965323d26242025-03-11 01:53:24.6992025-03-11 01:53:24.699
    8
    		72139032025-03-11 01:32:35.0000x1fcc39132045f9a6492028ba5096ae5b99861244bb1c5ab72f421ba87d0292522110x07aabd925866e8353407e67c1d157836f7ad923e0x4dbfa32672679830f612838268ed72e43de305a00xCALL000.15088574031508857403102242200.150885740310224220x2180dc808dcdd5c292200x4dbfa32672679830f612838268ed72e43de305a00x07aabd925866e8353407e67c1d157836f7ad923e0xdb006a75TRUETRUE129f70e687d7f52a305877a036784d202025-03-11 01:53:24.6992025-03-11 01:53:24.699
    9
    		71016142025-03-10 09:35:30.0000xa386f5bcd6f43835eaee60cf871c17e3fe0779d8de74a0d50e56faa91f32afeb1010x07aabd925866e8353407e67c1d157836f7ad923e0x16a59681de8a36bf6985f48d49ab7466126d83dc0xCALL000.05029524677502952467700747400.050295246770074740xb2af42ad9ef474292200x16a59681de8a36bf6985f48d49ab7466126d83dc0x07aabd925866e8353407e67c1d157836f7ad923e0xdb006a75TRUETRUE19da0a2745cf099563a985f6aab5ef8e2025-03-10 09:53:43.8362025-03-10 09:53:43.836
    10
    		71012192025-03-10 09:32:13.0000x47e5a52c4f1bbc5bd712472c6351c85d30a8d92eac7426de04243479db797e5b1310x07aabd925866e8353407e67c1d157836f7ad923e0x16a59681de8a36bf6985f48d49ab7466126d83dc0xCALL000.05029524677502952467700747400.050295246770074740xb2af42ad9ef474292200x16a59681de8a36bf6985f48d49ab7466126d83dc0x07aabd925866e8353407e67c1d157836f7ad923e0xdb006a75TRUETRUE465e379ed25c3fc70a62df89d944a4352025-03-10 09:53:43.8362025-03-10 09:53:43.836
    11
    		71010572025-03-10 09:30:52.0000x6e9dc0ed6fc305e3706f81827f2d68451bfcb230744fbaf7d31836ffb9ad260d1210x07aabd925866e8353407e67c1d157836f7ad923e0x16a59681de8a36bf6985f48d49ab7466126d83dc0xCALL000.05029524677502952467700747400.050295246770074740xb2af42ad9ef474292200x16a59681de8a36bf6985f48d49ab7466126d83dc0x07aabd925866e8353407e67c1d157836f7ad923e0xdb006a75TRUETRUE50ad047d3982e7737370da118cc8cdd32025-03-10 09:53:43.8362025-03-10 09:53:43.836
    12
    		71001842025-03-10 09:23:34.0000xd60589edea32a2fae98b3c1046cadb1ab33030958dacba2ebeb4fd6b232db34a3210x07aabd925866e8353407e67c1d157836f7ad923e0x0b977acab5d9b8f654f48090955f5e00973be0fe0xCALL000.13680307121368030712146032930.1368030712146032930x1e605ab1fedcc1d292200x0b977acab5d9b8f654f48090955f5e00973be0fe0x07aabd925866e8353407e67c1d157836f7ad923e0xdb006a75TRUETRUE931b5fbeadb17db310c76b5372e3434e2025-03-10 09:53:43.8362025-03-10 09:53:43.836
    13
    		71634542025-03-10 18:11:56.0000x1257c704386e963782bd33880c6abefdf11d35b18b59c24d6041f69c92a34f761010x07aabd925866e8353407e67c1d157836f7ad923e0x94f6e71c934a6a5e103f9a6b7981711cb41d95690xCALL004.03367879140336787909599941704.033678790959994170x37fa817d3132953a292200x94f6e71c934a6a5e103f9a6b7981711cb41d95690x07aabd925866e8353407e67c1d157836f7ad923e0xdb006a75TRUETRUEa629b318b7d48522aa98e7326e075aea2025-03-10 19:53:08.2862025-03-10 19:53:08.286
    14
    		71071372025-03-10 10:21:37.0000xf475b201f9d136c7787702896bf4ce0060a7f17051eef73a09ebaa54feb026ee1810x07aabd925866e8353407e67c1d157836f7ad923e0x87973c36c7930049422bdaa1f97fbcd0336097200xCALL001.57927074915792707485803468441.5792707485803468440x15eab260e54bfbdc292200x87973c36c7930049422bdaa1f97fbcd0336097200x07aabd925866e8353407e67c1d157836f7ad923e0xdb006a75TRUETRUE210a3a4f4c83496c82b296edbccb79502025-03-10 11:55:29.6362025-03-10 11:55:29.636
    15
    		71184262025-03-10 11:55:58.0000x8ed792c5d3f93471732cd123f34390509d1401ee6d7b3140c0a88c94e08e1bf5110x07aabd925866e8353407e67c1d157836f7ad923e0x51e2d61bb29bd800042f664b7f3619e4e279ae9d0xCALL000.56632447865663244786310415750.5663244786310415750x7dbfd1ce0695a272904700x51e2d61bb29bd800042f664b7f3619e4e279ae9d0x07aabd925866e8353407e67c1d157836f7ad923e0xdb006a75TRUETRUEf42a6267b4d12101f43640a609978e9d2025-03-10 12:53:39.6442025-03-10 12:53:39.644
    16
    		71135352025-03-10 11:15:04.0000x985ba49fc0983485a20cc5125bba335ca3e175738d89230f078b684a18638ef51110x07aabd925866e8353407e67c1d157836f7ad923e0x44b92464f886ef2a3f9b21e1abe0c3a9f24aa5230xCALL000.40313682374031368236972607090.4031368236972607090x5983ace245ac0a5292200x44b92464f886ef2a3f9b21e1abe0c3a9f24aa5230x07aabd925866e8353407e67c1d157836f7ad923e0xdb006a75TRUETRUEd8fa5845c72c99d67b7ce2ad9dd516ea2025-03-10 12:53:39.6442025-03-10 12:53:39.644
    17
    		70000552025-03-09 19:27:28.0000x3a80145d0840f36b3eeb6fda3bb4772ac5f729921b225d97e01691bf8c243eb41110x07aabd925866e8353407e67c1d157836f7ad923e0x04cd13a939afaccfe48e5f7729d2a5190b505d030xCALL001.60944789716094478966423916881.6094478966423916880x1655e855b3de8e88292200x04cd13a939afaccfe48e5f7729d2a5190b505d030x07aabd925866e8353407e67c1d157836f7ad923e0xdb006a75TRUETRUEac3b77b00f539a91767489878a4280f42025-03-09 20:54:30.1652025-03-09 20:54:30.165
    18
    		70081082025-03-09 20:34:38.0000xae2299dc203dea71e3da1fc876e65ea1bab5fa6ef4f2160648c7d80de3512e7c2510x07aabd925866e8353407e67c1d157836f7ad923e0x96ffb029225dd741b7dd53ed070419c2e0a104590xCALL002.01180987120118098708029896112.0118098708029896110x1beb626b20d6322b292200x96ffb029225dd741b7dd53ed070419c2e0a104590x07aabd925866e8353407e67c1d157836f7ad923e0xdb006a75TRUETRUE7d8ecad83e5e969da195322b10af5e1f2025-03-09 20:54:30.1652025-03-09 20:54:30.165
    19
    		72779112025-03-11 10:41:17.0000xa73699f2e81ee8e71296719cba7519dd47e825878913cc48895a4e066511baea8610x07aabd925866e8353407e67c1d157836f7ad923e0x2c97d636ea1ed29d7feaaefb856503e642b49e3a0xCALL000.00502952467750295246770074740.0050295246770074740x11de5377c31872292200x2c97d636ea1ed29d7feaaefb856503e642b49e3a0x07aabd925866e8353407e67c1d157836f7ad923e0xdb006a75TRUETRUE36e442379f25cf10f5cf6c8781980e052025-03-11 11:53:22.0442025-03-11 11:53:22.044
    20
    		67522292025-03-08 08:53:42.0000xf625bfab4c7836fec85f0922f7a2d6fd3abf5bc9214071e0d5af64733936d2523710x07aabd925866e8353407e67c1d157836f7ad923e0xf20772b296bd6404ce845e966f46cd6be8fa384b0xCALL000.01005328737100532873739965260.0100532873739965260x23b7695ec081ee292200xf20772b296bd6404ce845e966f46cd6be8fa384b0x07aabd925866e8353407e67c1d157836f7ad923e0xdb006a75TRUETRUEe0cd2c0838d6bc5ecf644388dd20ca142025-03-08 09:53:38.3902025-03-08 09:53:38.390
    ...
    1007
    508KB
    9s