flipside

    Lesson n.4
    adele23Lesson n.4
    Updated 9 days ago
    -- bronze data is the most raw, silver less, and gold the more refined
    -- we want to look at some transactions in base
    select *
    from monad.testnet.fact_transactions sample (25 rows)
    where block_timestamp >= sysdate() - interval '7 days' -- 4 bytes
    -- (open source tool where you put the ORIGIN_FUNCTION_SIGNATURE to see the origin and type of a transaction)
    -- https://beratrail.io/ to check transaction
    -- contract address to see what was transferred

    Last run: 9 days ago
    BLOCK_NUMBER
    BLOCK_TIMESTAMP
    TX_HASH
    FROM_ADDRESS
    TO_ADDRESS
    ORIGIN_FUNCTION_SIGNATURE
    VALUE
    VALUE_PRECISE_RAW
    VALUE_PRECISE
    TX_FEE
    TX_FEE_PRECISE
    TX_SUCCEEDED
    TX_TYPE
    NONCE
    TX_POSITION
    INPUT_DATA
    GAS_PRICE
    GAS_USED
    GAS_LIMIT
    CUMULATIVE_GAS_USED
    EFFECTIVE_GAS_PRICE
    MAX_FEE_PER_GAS
    MAX_PRIORITY_FEE_PER_GAS
    Y_PARITY
    ACCESS_LIST
    R
    S
    V
    FACT_TRANSACTIONS_ID
    INSERTED_TIMESTAMP
    MODIFIED_TIMESTAMP
    1
    		71410562025-03-10 15:04:57.0000x71b6febdc535db0495281fe14e9816940ed8d8da08fb06d06bb9eebe43f4ca150x0815981ddd914fa782d6db29aab3c9b9f096172c0x760afe86e5de5fa0ee542fc7b7b713e1c54257010x2e1a7d4d0000.0018775120.001877512TRUE21069320x2e1a7d4d000000000000000000000000000000000000000000000000016345785d8a000052361063610665668565200000000052521
    []
    		0xf39856131f2a9574204160bee9258a02f4618281770e0eff6d333b8a5813c7640x1887cded7dea060924216e5bbe9b76db55160ae47883b47d590309000189e4721cf05984667fcdef1b25f6345ed9e60482025-03-10 15:53:03.6982025-03-10 15:53:03.698
    2
    		61816532025-03-04 19:13:18.0000x24d1fa8df788b6a4db444109d9cf0f02ccfabea36704f8404d9f08a45ad0b07d0x5030bc567d1dd1b94ff109ec6470d9cac8b8a9fe0x8462c247356d7deb7e26160dbfab16b351eef2420x395ea61b0000.0017328480.001732848TRUE2338690x395ea61b52333243332412773279520000000006221
    []
    		0xb31e029c4bcca5e19526da5a07552d665736ac797aa16d4b31c2ed05ecc5a8ca0x37a60f093ae5ffa59b4bf9d8e36d327270f5b99965b667304d322c24e11e148c1a32f5c5a78f80be8d82b4809527752912025-03-04 20:52:47.7332025-03-04 20:52:47.733
    3
    		66609842025-03-07 20:09:44.0000xe69cedaf4225c9d749d04b293fd88ef6815c119ec6ed85b38a0d125b1a32a5520x04a071c2bd5b7c5420c3acec8bbfe97387427a810x8462c247356d7deb7e26160dbfab16b351eef2420x395ea61b0000.00180250.0018025TRUE2175507610x395ea61b51.53500035000828292451500000000101.51.50
    []
    		0x505b9dfb79767eceb687192df87e6fd524a218c839c85d34531581a81534cca90x39b55a4a6964a170e8ff19b9ae8e8fcbbd5b167d395b452437ca6ae7ea998588019de7cacd975b55fa36a05c2059234822025-03-07 21:52:36.8892025-03-07 21:52:36.889
    4
    		70672542025-03-10 04:48:29.0000xfd7fd3f4759d4cc5be2d17d97de14a94146bc2f4172edf4fa7e14ca5c85cfa070xb2984ca12b08ee7f7edcc526bbdb026835333bbc0xc995498c22a012353fae7ecc701810d673e257940x96f25cbe0.02978227193297822719329501950.0297822719329501950.0096755360.009675536TRUE24010
    0x96f25cbe00000000000000000000000000000000000000000000000000000000000000...
    		521860681860682161633520000000006221
    []
    		0x335968ada82ed10d9ea49a1dda139165c54c1078c144c9df313e1c153e50b4c60x2b03d159d5f68f2da0e2ef7d489690dbac3b47a08394dd1ff7aaa54b71ce6d11b27aebc1b8f252e0730e1494db9281012025-03-10 05:52:31.2942025-03-10 05:52:31.294
    5
    		69897572025-03-09 18:01:27.0000xe2c1ff05c4e0de7ee91549631cb11c7f5d0a6a7098694625bf40cc3c79387af60x04488fcfa466c475774f8c81f21e1d7b492af7bc0x758d80767a751fc1634f579d76e1ccaab3485c9c0xadba7a510.01100000000000000000.010.0197072720.019707272TRUE21124416
    0xadba7a5100000000000000000000000000000000000000000000000000000000000000...
    		5237898637898656716025200000000052521
    []
    		0xe683d038b4e7dbd161c21289d962bb573e78d2208344681f3b314246516e5fe90x6f91f8d947dcb975f4df89534e7b7e0b1d3cd134ec3e91785ebbb4a3f5767b261266b3c1b486cfce1a3dc62c682f0fa812025-03-09 18:52:44.5762025-03-09 18:52:44.576
    6
    		65963602025-03-07 11:07:59.0000x52ef6b147db21f25bc8c454548c79c008a0392f1c2b2d715f710ce268f306b5a0xf722172696595fc85415c2a509e44c6e8864ef920xbb444821e159dd6401bb92fb18c2ac0a371130250x095ea7b30000.0024039170.002403917TRUE2068
    0x095ea7b3000000000000000000000000f9fe044bdd557c76c8eb0bd566d8b149186425...
    		51.54667846678902932951500000000101.51.51
    []
    		0xf7e93767ee65a2daa36c6a06ed89082bb703f34c413b4597124b606780b658fd0x44e16ec84970580daccda46c58c22e96851f296fb110e02c01cbb25425796f0e1f45fb0e5bd840dbddc7bd1455aa5a72f2025-03-07 12:52:39.4352025-03-07 12:52:39.435
    7
    		66198072025-03-07 14:24:40.0000xde9dffc53d17b610644513b1f0bcbf787d399b7739c66b2e144014defc40d0790xef0fa43209158d044a2c8f56fa2a7e959206ba320x88b96af200c8a9c35442c8ac6cd3d22695aae4f00xa15112f90.00011000000000000000.00010.0069129320.006912932TRUE046845
    0xa15112f900000000000000000000000000000000000000000000000000000000000000...
    		52132941132941797446252000000000
    		0xd12015aa0374646459413be22f251d551588323cf58ea27d17d7983e588f4e900x43819f3a410f2c176e3fedd1ecfd3c3c3aa2dfeac029bf7f4a87d90332fc7a1a20322c6165c22347d8d03c2026e133244f6e02025-03-07 15:53:03.5442025-03-07 15:53:03.544
    8
    		72968912025-03-11 13:40:15.0000x4f3c68355349a061a89a83d4c03cbdbe684cdea5801c99140f38ffd03a84fa5b0xc29ce8662a205a6c9ab067560b6d27507a1b1ecc0x2c9c959516e9aaedb2c748224a41249202ca8be70xd55759820.03300000000000000000.030.0049290650.004929065FALSE2261570xd557598251.59571095710177841995150000000061.51.50
    []
    		0x4428109f891caa346385117eef8818613529889192e15e779f759d546b92840a0x516e663e834a2e0985c93ea0e36d84090df05871fea3f0ca3190adb3e5a4d7a40b060b67c9f1456d99949f52fe92f335f2025-03-11 14:53:00.0102025-03-11 14:53:00.010
    9
    		66724142025-03-07 21:45:12.0000xf11f6aa7915e11e77591ab5a1f00f3de68c8aa45f035cac9c43fe4d63f99c1370xaf9fd5bb005c68e76d4ab53dc59d9986b8993bb40x8462c247356d7deb7e26160dbfab16b351eef2420x395ea61b0000.0017328480.001732848TRUE233722430x395ea61b5233324333244931441520000000006221
    []
    		0x6a92e299726acb681d578bb1e75bdda3a56fe64da92f52c871cfd06f9bce52f00x3d733355b0959086eeaedf70b0b20d3b48214bba285bcbb102a6923bd104eb1d10bcf886a62d62852c30054f818d851bf2025-03-07 22:52:59.7852025-03-07 22:52:59.785
    10
    		72752652025-03-11 10:15:32.0000x7c22510d9cc7613b9efbbeb30b721618e7faf19daa53495d7262b643def7bb820xd53fd80dc97d4fb4de7453a18c61e5188634e0d50xc816865f172d640d93712c68a7e1f83f3fa632350xffa5210a0.00192319230000000000000.0019230.0099270080.009927008TRUE292129
    0xffa5210a00000000000000000000000000000000000000000000000000000000000000...
    		52190904190904345436585200000000052521
    []
    		0x43c9f7a537587097c1e9ec5c371ac3484902c3447f4f434e177e648bf7baf5640x6ec7f080744a6669ac77f25969759fa54c9db9306838709f6218f012b0a8e7b2122e1ddd1bacde77a88f14233b640e2932025-03-11 11:52:49.3272025-03-11 11:52:49.327
    11
    		67697242025-03-08 11:19:53.0000x6248338708bbc72966d28f0365bcbfd4d168a70cb3396ccd08ad06ebbec52ac70x8bf3126fb6ffab5f4dd6492d4f541d7e9a0807e20xcbe623d259261ffa0cfaff44484bff46c1b7d6c20x7ab718410000.0520.052TRUE2123160x7ab71841521000000100000052741355200000000052520
    []
    		0xbeb8d55a1313b1c93d06d037481500fae0fa30c5f60d08f39a7ad2189ccd4860x228b9a87fa2438af811f8b98fbcc6ea34e99399825c0b30670720d8e1839833106eea7de0775b4c7a50cf2c7085ec9e2b2025-03-08 12:53:33.1342025-03-08 12:53:33.134
    12
    		65509242025-03-07 04:07:59.0000x4171d188b7da62cb420f27a4a67d250efe5503ae2f4265ee4fb8992e3b42e4d40xd468c388dc5096a288851b5252b645752d107daa0x760afe86e5de5fa0ee542fc7b7b713e1c54257010xd0e30db00.001111000000000000000.00110.00249873750.0024987375TRUE2550xd0e30db052.54759547595121285252500000000102.52.50
    []
    		0x847a7af36e5c529ea727557a089b12f0cde8b1f5169875afef1deb034637b3820x7454b9d51bcdac3c2cb74879d158b4bc17ec2cbf0d3be5fb87c63432ae6cd7c90033867b540d27e51cf7c081e719bca072025-03-07 05:52:38.0622025-03-07 05:52:38.062
    13
    		65321602025-03-07 01:20:29.0000x74a46dc2135e3e99c72efac268d999af1970c411a6af9293eb5f8d26dddd267a0x1de31dcc01b79214c70817e90e825517914ea4ce0x8462c247356d7deb7e26160dbfab16b351eef2420x395ea61b0000.0017328480.001732848TRUE21750230x395ea61b5233324333243705024520000000006220
    []
    		0x8b456351392b1ecec356573dd7238c38be7bf28d0c50b2ab5c4e4559e9e779e70x5fb26cdc3b7bbf06664015de1a11d617a1c00f327d0751fd6cbbfd35c832ff66048b202e33f03bb6cbe8945f4602168112025-03-07 02:53:09.0182025-03-07 02:53:09.018
    14
    		72502342025-03-11 06:35:58.0000x8fb5b4c23a97e326cebbc01d1ee0ad62fc4a57d08f8103dafbd3ee1855a625b00x9f0a709e95fe85938d844f6ed7422676db3514ee0x8462c247356d7deb7e26160dbfab16b351eef2420x395ea61b0000.0017328480.001732848TRUE24072700x395ea61b52333243332411660752520000000006221
    []
    		0x8cd1c2249d49193f5ae7ff4b3661992c54746077866d0b7a6f69883741d091a50x3cc2b957ce172687e2c998ca10df0f66cdaf1f5bea84a57dcb8c1c9122d3fbc112fe79e2ef7a290d9b78dedaa1c830b642025-03-11 07:52:58.7592025-03-11 07:52:58.759
    15
    		61714902025-03-04 17:25:12.0000x43fd8833b6ce37d0dfd6589116747e44b6a4969a2ac818cd4cb82cac48156c770x4bbb57f2349133296eb31b96cf2c67897b2f9cc90x9eaba701a49ade7525dffe338f0c7e06eca7cf070x0c60e0910000.004168850.00416885TRUE23132260x0c60e0917059555595559595557000000000070201
    []
    		0xdfb7c44bb5f8b17f855fff987e0f86270858a0501e0f3b2e4ebfcb8656f37f960x1018843b7f22d0253924b8c86175e8f2981f6fb9db19db5cc289a895945ffaae13fdeae374071ef92006740c6ab13004f2025-03-04 17:52:45.9232025-03-04 17:52:45.923
    16
    		72968962025-03-11 13:40:18.0000x98bb713b6e5d450189d094e5c8afbf0a9b816275f7732a782d7e1d72065bd96c0xff34eafea82f8d9ecaafcd59d8019f6fd7a326880x8462c247356d7deb7e26160dbfab16b351eef2420x395ea61b0000.0017328480.001732848TRUE2478630x395ea61b5233324333248963743520000000006220
    []
    		0xec902252396ab99d87bc4cfeed1b29f6222ce8bb8442b04479feb84a4843c2b20x25427d474a7ff4925dce2c986c4b5947988c54dca9e781ef922e5bacc70539130a80d164418dd7ed347a0a42335f0c6892025-03-11 14:53:00.0102025-03-11 14:53:00.010
    17
    		72367132025-03-11 04:43:05.0000x505ef8036ee9d89e1ea59da53ab49b8db1e2ffaff7bbf9c1134c1a9d741871e10xfcd93e6af03450395ecd0f8f566b470cac98f8b60x8462c247356d7deb7e26160dbfab16b351eef2420x395ea61b0000.0017328480.001732848TRUE217918520x395ea61b52333243332459177733520000000006220
    []
    		0xc52fbd052f1594c1706cfa998fccba7fdcefe2a6672a33c787bc5710af80df5b0xbc83c65afc6bf72341d9d87e46a47c3522e14f030c8a2c2973cbf05e5cc8ce0fad1d857f2cc3386d8a3dec4afb5ac592025-03-11 05:52:43.6172025-03-11 05:52:43.617
    18
    		65887342025-03-07 10:02:11.0000x0fe41e6fb7935d9e32ecc7cc0776dad0152f31fdf0302cd8997e9b4edb87b4ca0x71d7dc178c1aa82ca28457ee177f53c6dfdd99150x668b62966b9c0592532e7ddab837dd060b16cba40x095ea7b30000.0016771560.001677156TRUE058086
    0x095ea7b30000000000000000000000001d30392503203dd42f5516b32daca6b2e11f71...
    		5232253322539029226752000000000
    		0xc551683436b05a992dc824b6c7b0ea5488bc2766406cf90553104fd8956a2d310x2edf6881dc0e0a652a11ba5c30f4532a7e872261df4617ca28296abbba5a39d420322283ff6d72d4e1442c7bc00e070b162672025-03-07 10:52:38.9802025-03-07 10:52:38.980
    19
    		71288152025-03-10 13:22:41.0000x5207ffd752be1ae50a61bd3f74ea07b690196cbcb104f934d6802dad8f61e7f80xb1484891008f6eec40697b644af719bbf09c49c90x4c4eabd5fb1d1a7234a48692551eaecff8194ca70x5ae401dc0000.02080.0208TRUE2161514
    0x5ae401dc0000000000000000000000000000000000000000000000000000000067ceec...
    		524000004000004380495520000000005221
    []
    		0x6996c3cc37f71bc87889c6110f26abb3f823280e9f72d557b03c9b5c0356195a0x2acc97d3462bdb2950efc0a01668cecac2199d76b8d3373ab74b839d48a372fb153e1654933934c0986e2fa8ccf1a9ef92025-03-10 14:53:25.9072025-03-10 14:53:25.907
    20
    		66354232025-03-07 16:36:07.0000x78f5f90eca18abbc661a0b73fe12b9150289a5e6b4c2f7dd1ad5075fd5097ba90xc88557f856cd4a11d4556150eac3d4448a50ba840x101a609e639fbf7c30f58647e99414a43d39a8950x0.05873153174587315317403780470.0587315317403780470.0010785409530.001078540952706TRUE01834670x51.3590929862100021000741137451359092986
    		0xdd7af3f6ec4c378a7f8c9d97df6e389569a0166e28fba5ed3e607f97727152430x319af81d40b89263612e6f948955cd6cbe9f5c9c25707d65615063e869bf6d1320322857f32bc39c63be5bd722caf1b5856492025-03-07 17:52:46.2952025-03-07 17:52:46.295
    25
    23KB
    9s