Tables
BatchSender_BatchSend_event
Batch token distribution events from GMX v2 protocol on Arbitrum recording bulk transfers to multiple recipient accounts. Used for tracking reward distributions, airdrops, and automated payment batches with associated ARB token amounts and transaction metadata.Columns
Columns
| Column | Type | Description |
|---|---|---|
block_timestamp | TIMESTAMP | Timestamp when the block was produced. UTC timezone, millisecond precision. |
block_number | INT64 | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain. |
transaction_hash | STRING | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
log_index | INT64 | Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission. |
address | STRING | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
removed | BOOL | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
in_typeId | STRING | Type identifier for the batch send operation, typically indicating the category or purpose of the distribution. Commonly observed value is ‘1004’ based on sample data. |
in_token | STRING | Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_accounts | ARRAY<STRING> | Wallet addresses receiving token distributions in this batch send event. Array of Ethereum addresses (0x-prefixed) corresponding to the amounts in in_amounts. |
in_amounts | ARRAY<STRING> | Array of token amounts involved in the operation. String-encoded integers representing amounts in the token’s smallest unit (e.g., wei for ETH). |
Sample Data
Sample Data
| address | removed | in_token | in_typeId | log_index | in_amounts | in_accounts | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|
| 0x5384e6cad96b2877b5b3337a277577053bd1941d | false | 0x912ce59144191c1204e64559fe8253a0e49e6548 | 1004 | 162 | [“107973279325907714”,“111226129923761366”,“112039325074350112”,“117534719315885634”,“133416724869691502”,“205248788803000137”,“248642802772751377”,“303304088765037061”,“341899568112069578”,“371276541939329000”,“502647024718698217”,“526524089118876823”,“706336861646591328”,“941830787290653975”,“1080373914071973650”,“1261711056525887785”,“1458567008088674796”,“1738385806188237114”,“1764793558811725297”,“1839302601709495427”,“2764404952247514053”,“2980692781392178423”,“3036827843514146709”,“3279487536113397421”,“3331944729142173359”,“3453403896206829403”,“4059440167873044778”,“4061375313028320866”,“4160760110189503545”,“4194626371214021958”,“4295894335623758611”,“4308283294894294502”,“4852508850009154003”,“5253847617134251916”,“5293976290266876762”,“6840812756611616716”,“6856520747818527563”,“7585285540633971036”,“7713931749294951484”,“8616601932784259583”,“10801294389358103155”,“10841379039216676244”,“11190476827386263012”,“11265998180990889806”,“11309846381102613201”,“11530095331801695682”,“11716121861427104584”,“13968198962264445821”,“14564751926573613686”,“16223293024533793065”,“19265038912066050738”,“19351009259347270835”,“20286301016964720612”,“20313613988810928248”,“21219721903396361616”,“21580950509819855326”,“23764659849945718100”,“29426129494429162533”,“30354205204257625539”,“30886769752431021468”,“61205375732539984797”,“63329816977167188275”,“69048107516804873847”,“82545501193871194161”,“88539396522905663108”,“95336238798598469094”,“107486481362048425615”,“108708503037374183680”,“114618577879342581149”,“140229050936236335000”,“194075203254339380341”,“254994823370221050729”,“266943812172236234839”,“441914951628267443184”,“627850911709753636589”] | [“0x12dd2044d23d7fc5b187d66a1cf79fee3a501482”,“0x2a99721c251d2fd3584a0be06544a8c3b65de45b”,“0x40ddea0b984ef32ac7e8b673f5fe28ff8fb6ea96”,“0x803cbfdf9eaea2bbd367359d359d6c963334a154”,“0x262771fb3fe938229fbeb1896a350a7a9d431817”,“0x16fe89c973fd6a4ba47441962075ab2cc3dbd03f”,“0x42ec34f87ee253fa49357e6ce3fd05a30834fa85”,“0xfbb486c53f209b3f0991a6e77233d367630697f2”,“0x5688d6bf4e6b49b83f017aaf4f76224b0cbca41b”,“0x92f4129b38f9fb2f584b9e501f8ee62f2ca23d4e”,“0xf55ec984218aff3648e5176fabb03f7dbc6c4696”,“0xc28d2946962652ce2e82d0edfe19cde33df1c6a0”,“0xa951d4fce3e6ee209c855421aec8a37af33b8c07”,“0xf6c01d14adead16c6a9d62349e5a0679f0dfbfbe”,“0x28f17bd6ba2dfa8308f7fd03ba3fb656ae57d540”,“0xb56699dc5e3f543446488ae92e6169555fb6e854”,“0xda0747f3201d741dde59792ff354d8d9ece05759”,“0x1a4b7919932b1bfb01c57b9e7f4489df3c0a073f”,“0xe699db9fb8e824c56de52784ff3412c49a823c0c”,“0x7251e4ac90d9f2622c64c78b984a81c6be777411”,“0xff94a4c17cc1007166072e209a9c30d30403b04a”,“0x4f5b6b87713003b204e1fc743a3fb3c13fe47228”,“0x81762e633e2ff343422e65a5d67ec6ace60bbe65”,“0x26cb1dbad7349b57af814a22718d04d0fcdfbeb1”,“0xaeb055edd6b843aff4843af84c687ab25c9cc885”,“0xee339ae28a1287a44df75f1e1c6acebbbd148c09”,“0x7676b134e88bacb4e0c6c9b34d80c94c77e89232”,“0x3462e50cf7e5d8c5fae4570cd3891f032b48bde8”,“0xacf19e0cb91017e74c5b788110e0b203736235fe”,“0x5fb26bc79a361ef36a7b4eae36fee62cfa52f64e”,“0x83bacd979a331a97d65fe5bf3fd1373f5c27b372”,“0x97c53a310a94bad23877e950b9ec26c1c7d19f4b”,“0x4978030925b7d44747d7745d6ec030703855cdff”,“0x862ca2609b4ccb48a654c7293e5036241a01b94b”,“0x0aaf0d1eaa181131b9cd4cd9b8b9440e2cd57bb2”,“0xc80a5430d22e8f96b9fbf0d4d0925bc9e60daa1c”,“0x751f8c7e73c98c84e6ba63a349368666a6a245d8”,“0x7ba3c3bfc0f95cc5ef4aa0b58b51f6eecc24ce45”,“0xd113e00039d6fc9536b2c7c796efe019b4b19739”,“0xd7be32e32347d8c21e50280a521a037c05b45fae”,“0x44ccb1c2e035520889f241bd5ef2c5e63e636a57”,“0x4b670646aee81273780be150ccd03e7436a36ab1”,“0xec62f25f0db55ea086c476fa695dd56dc2b2bef2”,“0x3e92d661bd5063f7df955d68e123b96d069069e9”,“0xbce2bd513714d294ded39c7e6a5bc52020588289”,“0xba8d35b178c8cb9f1f29d86c94b5fd8aa5eff462”,“0xd100b6645eb05bd88ff6491cb9f1c2688948b838”,“0xd3ddc8461663e8ec49a4d6bcf54c70734167db1c”,“0x0000000000004f3d8aaf9175fd824cb00ad4bf80”,“0x335e667e86c10633d200dc1645d6bd2e25988300”,“0x9d6dfa973d4d6c52ab52ec08c9ccc398e79aad37”,“0x81fe712bacd1a1f06601946469ad1ab631abea04”,“0x17ae2f9eb1bb329c0f0b56187f76e9400ddcf172”,“0x402904e954aebee2e78b7b09595393cf05571333”,“0x9cfea55791123da6a32e1972c919008a35db99ab”,“0x3055d1826c6c5d292e4d4b1e5b0d9759ffa9410a”,“0x5c5082ee760e4f4e6da47bee7311137b593c077b”,“0xc1272aa47b2b0fbfca527da221f02c7b274a02e8”,“0xcef13daa45ca6ca8b1af80e20280c7e5f6016b3c”,“0x15ea23caa5a7285651929251c3c711f456e209e1”,“0xbd3df1969b930ac3521552af2947cef0c1638107”,“0x90f34091c5330db3bda70e728707879c64e28713”,“0xe6bf40e81038050d76d658281ed6bcdf752d23bb”,“0x508172d285591fe723366bf03ad3611982949368”,“0xe0075cb3a1a45c3061cd636f9f69cb7c223823c9”,“0xc9c0c7e9d6423a61a82a872b2496f685212e0a56”,“0x838c80b3fe376b4043781507d76f57c6db0d7d19”,“0xff0b6ffc4507812f5380062d91a79e464508bde1”,“0x0000000000000f25a072efa232d8efc0b5ce2436”,“0x49519579d9d7f1e782daff0d1139c6f6c7b51235”,“0x7811df09c3415e99beb22122123932e2fe1ef0b0”,“0x7d41be7b63db524a57a59e2c8565cff78e9ca5a8”,“0x642008d8244304e37e50f291a77ae483a408198b”,“0x9d64191d2928fcfcacf98a0c2ae28c078b28f8c4”,“0x723f4b524012157d427a1487b49347bfe16a981b”] | 286068710 | 2024-12-18T14:05:07.000Z | 0x354e8e6eead1cb93499e66378c8d04b8ca9121b8cd3de8d7794ec99df4ea3d93 |
| 0x5384e6cad96b2877b5b3337a277577053bd1941d | false | 0x912ce59144191c1204e64559fe8253a0e49e6548 | 1004 | 377 | [“1787657095681141938”,“1789505283608629250”,“1791082951630622290”,“1796418226881058963”,“1796604949331921426”,“1799512633072789816”,“1803629994826806799”,“1803651669100833829”,“1809213113593409164”,“1811153659574200522”,“1812396042121660827”,“1817379858192492753”,“1820234673948802689”,“1823705694361293266”,“1827322726916187611”,“1832451701624896734”,“1834712146435765373”,“1836665625892032268”,“1837551402964047375”,“1840731598655479859”,“1846311380664792244”,“1848022835156032202”,“1850886392170646553”,“1851703882363071753”,“1852360614473632231”,“1855513978931346620”,“1858350805954126961”,“1863392021759706795”,“1864117778386096273”,“1866418002490033063”,“1872822350343406613”,“1874879575111704840”,“1875424937756484497”,“1879184861837080751”,“1880773253161305907”,“1884988351511743112”,“1887381791933710823”,“1895180314007200234”,“1899050520145616386”,“1899568519712076739”,“1905683142534352319”,“1907909634918823073”,“1910866880944296642”,“1911253661227122902”,“1912871190070224299”,“1915530641870973843”,“1924307479659178622”,“1926064766215877863”,“1930560064295237459”,“1931462824848973613”,“1936471390506398317”,“1936681697594298419”,“1936987034042182038”,“1944597929423445703”,“1946712053710462210”,“1947761854113103281”,“1949027566318004185”,“1954612010325380221”,“1967462987697143827”,“1976557856773735688”,“1982528295635903856”,“1987338734472502844”,“1990145938695729162”,“1992314844836942760”,“1994718961054984003”,“2005574378857047981”,“2005646206305083403”,“2006793949224010926”,“2007415568810360149”,“2010956878170547502”,“2011546606868275555”,“2013788814998873496”,“2019696758266605153”,“2021470256296084911”,“2022173235638448193”,“2024241461466916864”,“2028043383192437875”,“2030653361105460680”,“2031358784923264473”,“2036550942084933481”,“2039599431417812374”,“2043508514822113569”,“2050062637205470096”,“2051215170138108576”,“2051775958107608740”,“2051819872551584191”,“2052154176274451608”,“2064489396424323447”,“2071679295848088354”,“2071792078700108540”,“2080778551793376789”,“2081211162961168442”,“2082343555852644256”,“2089209295050279304”,“2091246508497506645”,“2097344645169648543”,“2099459424950507013”,“2108347578058823484”,“2109041482669367690”,“2119701276907112735”,“2121546536241445654”,“2122561301595447324”,“2123694241559464131”,“2128035869892475461”,“2129090565458751457”,“2132464410672380517”,“2135474022798737107”,“2137817780435182620”,“2139087792400111576”,“2142407039701604225”,“2151683597742967533”,“2154643001210320634”,“2160659144539188784”,“2163952206155123644”,“2174887294401418150”,“2177716003754479968”,“2181986087904780433”,“2183899248184719975”,“2184591204745296146”,“2186528504736573080”,“2194781305364251516”,“2201650207855218872”,“2202943878086099441”,“2218766772888960011”,“2224905472423772871”,“2227699025396912466”,“2238630870336547796”,“2243719995649005007”,“2249837751963897049”,“2249913783101271176”,“2253130523494779802”,“2262720995121583453”,“2265602052620440876”,“2269176194238461633”,“2273491258300572588”,“2276415591470908866”,“2277219660494677198”,“2282455385959578892”,“2285220368602632862”,“2292341379992133902”,“2292844317702476494”,“2294097596910952043”,“2294414486728935763”,“2299594510766385571”,“2306776690201896376”,“2307256192246452040”,“2308854430194374327”,“2313973448498916699”,“2314655570408617878”,“2315031208122179007”] | [“0x99f6eb1ec5da3f205ac1aacc410366c7005cabfc”,“0xb0f3e3f5c52ece66fe44ac7ecedbd06b7aec11b2”,“0x3984ac5256b1b389de81d51414567ef66f8f5bcc”,“0xf7e326856009c52e9842b135723194eeba53a5df”,“0xc8728ae130381eb77fc9a8b715564b00e83e19df”,“0x79d7d549b3e93aabcfc0088970af98ca148bbdeb”,“0x605e39d307bad8c70f0124da9f604434d8067488”,“0x9775df2bcd3eb099ecdf04e61e96429f2cab6cb2”,“0xcf862744719159d5a76f96d07c2566a268b2a5e6”,“0xfb61f642af3d00547e0d0577270d78e8512086d2”,“0x9acd14328badd3645b3a1b83e52200f28cdd133f”,“0x262771fb3fe938229fbeb1896a350a7a9d431817”,“0x8e660fa80af7b2cc87bfb0ea1e92dbe040303d69”,“0x9d58d6e5e95f32c356917d2f05da9ae93ce259f0”,“0xe87fa5af548b1c221c48a18893ce709e810e89fe”,“0x73b3bc77ea1647cd15af9b1ba787583c7bd5bea3”,“0x0795e54fe9afa333cb9b88471241ee5329262b3c”,“0x0c6d4818f16c026d536196ffa27fbca18770da83”,“0xc8d3adf62d8c71805ab11bbaa0e0d8d6e686daa7”,“0x79f563398ff8a5a5ff18650e56b9bac8be84bfa5”,“0xb7c68afffa311fe6fdd8a8d95bf9b419399f244c”,“0x4417dcb75b949ca95eb8ddd7af9737852dd27211”,“0x0bc9116796243ddb385d28457c47028154b46d9a”,“0x00a48b1754c2f89e14fa8b916d97cd30aeb319d2”,“0xbee45ef2deb682657759a1d4e42ab51e3799a775”,“0x1fe8de2172f79e1a622dc41e47d67e81b2087eb6”,“0xdc7885d97602481c47a068c511ce8c4a7b7e8740”,“0x9af8618591067b80e2ee6202795c5d799335b79f”,“0xf95b24e8ff2ec71a76fb2d7495153efae0c622ca”,“0xdaf273d37a0b4d81817e3e465d6710fd50efc6f6”,“0x8b836103d18df585d2898d145ce7e69080c72376”,“0xb130306c41d6a4df278dd41bfde0b24b2a4ba715”,“0x2d539ba0a66d45696664600bc6300c58b25a6322”,“0xa12ae3ebf9a3ebbeb0fa77d56848209ced868f60”,“0x41d2f4a36592c395c963d9ab0892fc6636b0eca5”,“0x6798611f316bbc5c7b629cdeac7ac89d62b8cd3b”,“0x65f50d366ba0866d030910c6e16f516d1b3eab5b”,“0x4d7164e49bf16b53be8c3fc07bd3b8d8bca18907”,“0x51c93cfb6aff13ef8dfa6de3637d29fff5734189”,“0xb696417a40ab59919c8ff6e81f5963e108ca271a”,“0x6c79837a6f08e1df4a2971795f67a1849c122a05”,“0x31632636d664895f1bd9d03f5f7c162a2a6980eb”,“0x1992693a0bc5ffb6b46802cb9b67281307fba0ef”,“0x89689b2b2adbf1ac749be87308f5eba28602444e”,“0x5c9f835a93b71ce6cb266199ef0060e277164a47”,“0x2329347977320a9907d84d062bb4db6cd346045e”,“0x89a8487860965d053bbddeceff17f43db2bb696a”,“0x234bf92e8c979eabe498c604b4bf3b1016b25037”,“0xdf8df3c234cc4e223b7eb8260754313eaeb93bdd”,“0xf2825f5aa3f2bf65eb6d0a44372656ea2017a4ca”,“0xdd9189f9cb498f5dc729baa19734475c22b36981”,“0x0e8b0cdf27b9dd2ddec656ed31bb086b8aed495c”,“0x4f13d27229815c5de7acaf1202b403ff5dbc962b”,“0x8a56c882f1495405b8729c6b432e1f88927f2721”,“0xa8f8ed04ca3bc89d0b09ad5f0a3707f90729e233”,“0xc1b42e3f44ae0c758d5b2908d1afa25752ef9ffe”,“0x64d1f2d7810b0df104ef78fcd673245b44384c1e”,“0xbd1b3513bb0ce1529242cfb28926618809592362”,“0x6de7a643df497a859c3cb321da7cf13775236b85”,“0x196d44adcdf5083a1effd9a8922683fcfc110f5e”,“0x6e4f6144b0726190150ddcd6d384bca2306643c0”,“0xef2b926b43f971cc0ef243876a7aaa4b2aae1f40”,“0x05f2a82ed3dfd7ee72b6e3cbbf611194e22c42b8”,“0x0af600f3364e917b0c19829a78e4c729b5365d67”,“0xefebf8207853e938e6eb5135930ef7f12712cfe5”,“0x93c19db36fa14188f153613610c2d44e6566bf35”,“0x2ff6fd7a71c393bb65e61c62b5d0b91015689cc2”,“0xae83219720b9f2daee0f733cc2dd26629c4a552c”,“0xcb331e0898139acbb82fe6d31d5ddf57668ce2b6”,“0x071ccaaaf3c9405b08789054399acd1d7b46b5bb”,“0x7927d4a80400bca93f3251db8f0772ed80b26c27”,“0xacad027ec3f4746f052345a5d058591c81fbb925”,“0x505e5ea6b384ea9c18e2313f2cf13c28af576e0a”,“0xbc08be802540eb7eb3d270d16e42eb0ee5fd23d0”,“0xde062f280a73c2ee35da37200ed9b552ff261abf”,“0x84f35268cb9d9b9bad653c2b28aa7675d1906e6d”,“0x4232be5337ff21105225348750ec261a9d7b3c7f”,“0xc693b4ffb338579467a541b2bf267b1955870920”,“0xa8598870dbd93703a6909b2f76f0f1d4b3a6d3df”,“0x1880215de28ada8b702e7292ba601a273471eb8c”,“0x23a6a13f8c46c34ec32ea8f2697de189e6971a66”,“0x192adb1816f389b4c53da2fb793961d32d9043ac”,“0x4df80a1a2151ef447f1549a59489852ea94d7789”,“0x9d679691b24fd881a1c2a0dd0a8aa862bf96687b”,“0xeeb4de2fb9bad3e989f6312d19344a1bc9062c81”,“0xbef8959568c07467b6463abbab935698f95144fb”,“0x1a8321056f8cb4106eea5aa7110153c5c97170a6”,“0x8b67e2f16598d8fc8cb9431a534b5eb77bd10ace”,“0xa510980f27491de16efc63e21262501f214bd8c8”,“0x53c723a150f2a9e8fd2c1579021bd86f20d2b6bf”,“0x6a56e65b91e253c90c4ac818c5f6a176afb4a7c9”,“0xab2438a0fe1c7f4a4e293bc3cf5832a8d1326a22”,“0xc9dd92a1807f4409487e252c1f45c10851752c3b”,“0xfab783f85269b614ff41c80d8f46aef107ae3a90”,“0x8b04c2c12fca0e299cdba8a1ff41d27f11e82143”,“0xbe815f797f82d91a9399e8d76fa6f4548a274241”,“0xb97e9fa617c5ef5cbb5e1aceeb6d6e9ce0f52aa1”,“0x1889bfb5569821db9108b0412fbaf4db5711bc5e”,“0xee1cd2cd8906a5e03b879fd1a05e9d08e592125c”,“0xdf2d105bb6485ee61e453076b7a1114c270d6511”,“0xf58738234646a4b725b6edd57e8fa8a5c7cb315b”,“0x5b46de6901fd09c5b28022418294e83a1d6f0929”,“0x779a1af272a6dd982636d31fd489de7bc6527607”,“0xa190ecf09815bb8d118bf3d7c3d4040242f36280”,“0x887e25fb6e7e3eca05e771f096aee0f615b1bc81”,“0xd3ddc8461663e8ec49a4d6bcf54c70734167db1c”,“0x1ac5b85d320e8c722f18872d7c5e7064c77bd263”,“0xaebcc707edac413af8782c5bb1a29a6b2d904719”,“0xb4e4afc2d2eec24bba6287715f53e6c2c5b40900”,“0xdcd024536877075bfb2ffb1db9655ae331045b4e”,“0xc279de38a6b5d70aab8c32a25eb00b454bb8336f”,“0xcd8c77df32bfda6c0d655894cc054ece616cc179”,“0xf9b31ee6653ec28eb2d1476e4beffd8e67300dfc”,“0xf8dbf1a81650ca44944e433f7b91656a8b10e64e”,“0x8ea2c40fef0cb4cae8d81e3b4e217faf3a8bebec”,“0x834ffcb267152b49e16ff87608be14c35173be62”,“0x4f18e143eed12c33c7e3efe276a2b42bddbac2c6”,“0x5d7166ee0c633021cb502fa5302866316d86f701”,“0xa32af4a7908827bcef54c877afb072a777f8556d”,“0xf318a2f77816c166181597e53ec95773c7d70262”,“0x97e7d3e53dcdaddbe062a2c96089f7352aa2e3b1”,“0x5d2a382480db167a67276d88c39f5a755f28fec7”,“0x8b78eb724a22b422891d048012606b5563e62924”,“0xe0b7891a022582a00fbe4babb38ffcd283acf1d7”,“0xc41be2a5f828519f4095f1e1425cc62b686059b6”,“0x92c43859db0f3e03eea0f05529775f4612f5de33”,“0xc08286680596564bc01731de08e704804696a413”,“0x9bc24a2cc7786fce90dc72d473f42fba797d5a81”,“0x71fad3357c786312d7a2e65623c592d434f3c9ef”,“0x48bb1a99f2631ca19b5a6cc493054ae88c55fdc0”,“0x15bdca717930a841022be81bb0f6e796c4465f4f”,“0x233f681ff98e18fa46fd9d6203520a6a301aeaa1”,“0xbb8151d891ae8b3ee3696944652ef2308edc8d65”,“0x39bf89b3b858124e3b1100f9ab2c5c008bed54bc”,“0xc972a4ba4b10555171f2c08f185e05571e129cd7”,“0x1342eac4e837380e66b916de678dc7efd210c595”,“0x18c529e97297c7d7da79779714b288f5c034ebe1”,“0xabd3fe78d53d04a791f2e955f88520af70602937”,“0x9459eda837626a5d7f929baf7d3ac1df60e26239”,“0x74e13a0820e434d0b9cd6587221bd05ce839668a”,“0x819ab507138b2d0111459535bec435916253bb08”,“0x1235277f86d2ca84fe10e92e43942635c022c2ec”,“0xf74e806568a1b7e3ec604bbff7191a839f94cb5f”,“0xf7162f470bf2d6bd068b95d05b7404bba47e4ddc”,“0x6e043e68f0d67b2fdcbaf50b14ba50c94a83578c”,“0xc19510eea3b3c6e71d890f072bf6ab6ea54d4c40”,“0xd3ec8b471b14207fc9da79acb26c6adc41c16b40”,“0x366bf4c8a1517e2ea6cb5085679742ff92f14b54”,“0xf577b31016ff0ceba34f37739d38d8a82ba07f32”,“0xeac73930a507d81ea54644b0873daaef5c8dcede”] | 242720883 | 2024-08-14T08:33:01.000Z | 0x8f39d38e53424ccbb3ceead1084174b1f16c942439fe430b7db91a3bf649502e |
| 0x5384e6cad96b2877b5b3337a277577053bd1941d | false | 0x912ce59144191c1204e64559fe8253a0e49e6548 | 1004 | 354 | [“1335280256000889053”,“1336942453052755809”,“1337489067721890787”,“1337843646557542979”,“1338442377064857032”,“1339481696195508644”,“1342890347710813580”,“1344574456268358834”,“1347694369106562557”,“1355697208805260269”,“1356128580049891713”,“1360977460859230855”,“1362053192533499381”,“1364279815654881701”,“1369031085766980700”,“1371428205543739964”,“1372179227766348544”,“1374883628578467216”,“1377298682153204189”,“1378072653931280476”,“1381165649933027241”,“1382437662777434160”,“1384930409452693935”,“1390497616823008808”,“1390923103807757355”,“1392044952136188460”,“1402085703535515140”,“1406064372663414592”,“1411417525677672817”,“1414200646758813146”,“1419469872882909082”,“1420729917005496172”,“1422089089775605342”,“1427948203057654035”,“1428562459501650942”,“1429545658753884436”,“1430667526737519893”,“1853255012347693865”,“1441187459166903123”,“1441430950745748975”,“1443969894882413833”,“1454310597808106467”,“1457167956548655240”,“1458332579827709153”,“1461601649448431299”,“1465891481808104562”,“1470946574498630927”,“1475026376437805681”,“1476374735984603138”,“1479349789337844835”,“1480157793823998594”,“1480639799910372760”,“1481059178241615163”,“1481460253799924161”,“1481920971372461784”,“1485412562853577403”,“1486949581238166343”,“1488958845730723425”,“1490646064280366021”,“1491924556227778412”,“1494809189492218574”,“1497216548731815591”,“1502542694187083996”,“1510213777069970807”,“1510979509675143869”,“1515003567119415434”,“1517678819850991486”,“1518254910272761939”,“1518702092344122990”,“1520055328404251878”,“1523026062618528135”,“1526393841534040900”,“1528993617606911217”,“1529123261264076448”,“1544363684102339425”,“1546695426105253650”,“1549137714047065836”,“1549844256052918908”,“1550773778147678965”,“1550778060714403088”,“1551095365360052508”,“1552346943943058581”,“1561157327227806805”,“1569856537556300936”,“1574076864825801206”,“1576662916794883380”,“1578458212665571491”,“1579765485068650476”,“1581193604131446531”,“581564472837032505338”,“1586688553054096120”,“1589224662999073856”,“1589552337251637308”,“1593947414599388654”,“1595861186973120083”,“1595970462606907867”,“1597077192599342959”,“1604031979495279718”,“1605033178623618570”,“1606429387280332663”,“1608003289881312629”,“1608835929854765708”,“1610431125303657106”,“1611899862723214309”,“1612182732042702586”,“1621778132990369993”,“1622866640759077015”,“1623113557653093598”,“1626759127654648750”,“1639123783665559613”,“1640161364888158469”,“1649362251572259233”,“1651796625124209899”,“1654160964030967983”,“1654615965004225545”,“1655052845041161534”,“1656717284219995837”,“1657632811044548584”,“1666622667692223148”,“1668248814064050617”,“1678101297027625431”,“1696831709831610701”,“1696844920652352775”,“1699725826733280912”,“1702694504091440869”,“1709063247530052958”,“1715547773344528110”,“18614844802809954217”,“1720010991892601170”,“1723632187221120966”,“1724355144410068925”,“1729105095723003732”,“1729616163637805852”,“1734326031797411222”,“1740358528641691361”,“1742078925216549892”,“1743191550496785015”,“1744443269563711723”,“1746116125522666272”,“1746876113045540907”,“1749702589245999601”,“1752451401160873133”,“1763561300957224357”,“1766128306570213213”,“1767173580631870059”,“1769348908609602630”,“1773141569000718113”,“1775402164368059326”,“1781621860458329075”,“1786075789968638745”] | [“0x85218bd2da1ad9e351bf3dd4f9e0263cc4a1f463”,“0x8b90bcab74b9ac8469d6eda92f9c3e17cedbc095”,“0x0c1ba58479985bdad5141f29e82f0a198337b9d7”,“0x4bda4855bbb87c041910ffd683401688660f8e1e”,“0x0820e772d10af46bf808c76aa26977a0e6c9e006”,“0x96e843c8a7fc24312cf0a81045e9d940e9f891d2”,“0xaa70a9103c368383825f5998de65f57a81e86580”,“0x7ae603069ea864a88b747471efd4135e9e9a1fcb”,“0xd9c1f799a8e7cad70ccfcb7422afed32f71d0783”,“0xd69e78b2bf4b79d89af6f46dec7f319060a78157”,“0x9833156e2636e8c218252ed5caa62a62463bc768”,“0x002d5727ed4243368a90bae8177fbb3f665efe8b”,“0x8ca5ea4fb208c600981effbfa907982ec45a4dd6”,“0x6b0dcabbf305b91a8e77f1d9f9a62936e2e4aae7”,“0xdd70995447f309ef03c52aee6721063aa72b500e”,“0x30558d6e343f2044ac04928cdfe6e75f4bd1a052”,“0x9457eec3fb68292266a129a0ea78251fc8324f23”,“0x50c7f58b02d594f97f72821766654f603ccb8e52”,“0x9e22d88191846e9c591bf4902ff8415d2d4f0361”,“0x1794ca36ad1755b1505779f5a1f9217fb5290aad”,“0x28c28beec16a7132431e97660536ae53b6cbd00c”,“0xd6b8eb7256e24d27712f12a6fbf2b4c34df0cad2”,“0x5a8088179782f46bde30259542f60d79fd058371”,“0x8c4d2ddbdbeb7d909ef45283d0f54a09432c4b39”,“0x591520a77c8b781c4d4ee189f0fb7f88a257d6f4”,“0x4c77cebeac4321a14cb5175baa1218be3f2accfd”,“0xc000b7d1df7f0c31b01daa7483cb55ca67f62ab3”,“0x7f5890dac960a6eaed7fc41798e7369aef42ab1d”,“0x6def7d938d919a3336791f3a00e8b2d92c174767”,“0x840964bab2e3bf55f67ceb283bc9753068735eca”,“0xdb387db4d39353543c93643a9a328e8d0ee482a9”,“0xfcbbae9be6be2b6de264643dd0ee3d9a0e2e8733”,“0xd7da23e91608e92f7ee90b7015bdafc03ef0c709”,“0x8120c35781572b58df6e92d45f2f797a5dbfadcd”,“0x5a72bfaf8dd5b251bd008fdc0b4656319ac0509b”,“0xb4ba89b96af3181f1b13ea0936773662577dd9d0”,“0x3e3e03f3ee0e1a7f4af89be3822c8c7538e432c3”,“0x5e53ce97fcd3abe46f1ab45abb3e9a9c5e19f193”,“0x83adec058b026475a5c3f212986d9c3dc27fceff”,“0xe685c0dd124efe27b3d48d0d555075a9fc5835d7”,“0xf3c94a43d12fd3b278b788e54cbac0b3c503091c”,“0x347b6ebe89f015da9fd15782b6cb4649eacc0ef7”,“0xfbf3bf1ffe79f59cb58958288f0dfb596098ab6f”,“0x2d5cf6a8d819459e1c47a950b0369904c85a72b5”,“0x32b219b6da8eeca28a99d0ad33f2c4aaa188f761”,“0x05aa6ba76a24fc531ab876bb4395baf7129ad14c”,“0x5294d94ef186b4c19b49a8a6f00a1166d30850b2”,“0x0ee4e42b1096530f80a589cb13461930704517d0”,“0x229d809516f9c4cd64e3b765682687f9c7e3f0fb”,“0xc661aca09e6c495bcd8f8076eda1798188d9edf8”,“0x96b319655f88a30b6f966b52566cfe28302c7b75”,“0x735ba3df7c70fefa144ae5ce9396053167c3aca6”,“0x7c637a2ef4ebb8bb143c32843910965f16742ccd”,“0x4a15805d28d5ebd13c120f5a5e7be4194512d96b”,“0x15cd34be39d43a3592c12d2d487eff2d3c10fc58”,“0x9bbe0d8bdca9a25a1f84c70609e7634d2d99ca09”,“0x9ce23ec9119e6976099a28367dafb9d8e9173a91”,“0x247f4890b903b1a09311b1eee989d1966ab695a2”,“0xefbdeec864d5c10ea2e546c536e446b7acfc8708”,“0x8f2cd1f840e1b00e6d58409db063817b33c44087”,“0x56d673596dbed989c556ea88d3e72c4e9dff7d81”,“0x81d368dd27b78eb3d6dab340ee309f0733dd26f4”,“0x28431a1446c86434ded04f7f8ba6808649329f4d”,“0x474b860c7fe5f7975293f6e0479a7416aa20a61f”,“0x90a05b19aff7e719173718dab9c79295e5237c06”,“0x5c4eab549a528bf15c47a01e174500010997235c”,“0xa92b00a0d6bb17dd04228d18d91065f756f3648b”,“0x4dc5cd9f0de75f1b15be4abe4ee6c23e60b722c6”,“0xa0d3c3bdc8302ef1e6724de2af614e0cf384cf34”,“0xffdfe6db1b1ce1bb22c2c5740d261837e0ed3360”,“0x5abb7b0f20178b559fad01fe0a749b9642674f09”,“0xa57d9b6a6fe3f2a0e907d4932fb94f4d3426e2b5”,“0x332d30553814fcd319d574677a85692f45889ee6”,“0xebba09ab07c5fb1b152167b05bf2ef06a8eec945”,“0xd9b33732acbff5e540e5d53edbc846c418848413”,“0xf7014883c58b6bc512719571b9d810959c1b6372”,“0xda3e393936cd9a70371ce96f240e565a915e6491”,“0x3ee5c6d8c0a23c0156ae6eddbc980a5bdee4c7ed”,“0x8a0a3b6acdb914e203529dff1ece534fcccb0e93”,“0xd71a686037878aa15ef219add5c2b0f150313f47”,“0xe7f8fa0e692d84b2f29fed9d810566d3a43f6d8f”,“0xb598ebf5d1b331317f748df5d97a1d2c8ebc2369”,“0x1a767eff74f0d2222662a838e886eac0a389b0ba”,“0x05964b52ac27f081277fcf12f1da66211c01e880”,“0x1267c70faf3cf7f0193f639a0bbc0d114b1459d6”,“0x5d1ce649f2e209c897a54cfcbda2ae89a5ef53f2”,“0x4106cb0cdfa10ab7264cf5a07455391a1e3ff2be”,“0xd6fb642d550c65e3f8306ced3bfeee1caae0e72b”,“0xc910c21d2b7db36d8ff20b6fbe618dbdf8e3f283”,“0xdcb906044452856242401323e4c76df9f15690e1”,“0xad219a51e78094b9ec967c48e478705bfd4df61b”,“0x6a665546e8083e48470a1fbff1f290bcbc0d97b3”,“0x119edf4bc354abb805e60a5767550306d3f091a8”,“0x60318b16c32edf4c1a88395656209700cc093872”,“0xb900d23ec39e668272bea2d7122a004bf1974d8a”,“0x5e96bc7970480721ed20cc2daf4bb128bf184c76”,“0x421db94fb2c9f86db1e90ede1b190e567fd15d71”,“0xbcfb1035a6cf5245080c6b67a93f17a7a066a464”,“0x3a61bf185bc519748efcc543c3339bed6112cce7”,“0x454c1e919f889b1598c06c7ddc6eb9fde0463a12”,“0xcc51f354f2a2597a752bbd168996d1079a772242”,“0xd76a9cba16b91f4a5927bd496f20de108ff445a7”,“0x444bf6a3e5aa52f3acee316d87b38160aafd249c”,“0x08f518870ec33bc96cc251692b79a745c1af78b5”,“0x591af2f3e0d368fa72261e32b772093be9047411”,“0x5df6dc106d402b22568d6b9398ad092a05d7a347”,“0xb4dd724abdfa0eed18b1d2a2e5a1c3b75b461a5b”,“0x23cf0b12bd08b539e2f4142a711a32fb0cfa919b”,“0x8edaf05f31fdd020fd982a9576b0a5b3aa454690”,“0xbb7a86d410ac2f4af22c29ca035ad24bb928179e”,“0x0dc3bea115678a05286b30c9b708aa72d80b208b”,“0x387632b035de498c2d9a9b944063244a820c094c”,“0xc9575c4b18fa882690e5be492ac4f5a9b2e845c2”,“0x794dca7b7e854b6cddd7ede2272868d9e6bdc226”,“0xcae6d3a7bbb2112a308d347563cabe28c0666db1”,“0x1263434e113c744d23947ea19206617151865002”,“0xdb02b13c79636044e11e137ded177f4058b4d6a3”,“0x46ab4488a9c932dc429e8583de41f97315ea1003”,“0x9614798821cdcca942fb7280bb15072b61768253”,“0x552b4ce13804e68353454ab50b9f0bc1240b7bab”,“0x8557a36cc5c0a48c3316439ddf31a15ec1f90c2e”,“0x9293061a1f08da6c64c72b05b25f5bbeb9c47279”,“0x9a89e877065d51c55c88dbb06f27f20978c72f05”,“0x72b978aeadd5a76c5a8500c0baad5f9b42f49bc3”,“0xde5d18131c379aa3acccf23afed660d70dc4119f”,“0xcffb39005a8dab478ef4188ae1b912f6e28ee3d3”,“0x705acf1397b2710698bcc4bce346c2c7e5ed5da4”,“0xa07d83334758af046dbcee6991e341c0e061d121”,“0xd18c96b6cd70987189b95e02b27d98e681bba100”,“0x3a3328adb038683dfd3cff030e7cbb8300e20fbd”,“0x7d725449fa17c4659e5625dc57a2c5e3c0091411”,“0xa47e21befa69f9f0d093749581872fad441984f3”,“0x96322357c2633dba5eb947db0306658b5633ac04”,“0x5e05bd32098593d1272d70d266f3f9b790010c45”,“0xffd0e5edf84f44b088865fbed18a826630495e16”,“0xe9209faffd85a25637232ad6f1ac6bced2081513”,“0x2d4c05dc0a43f3044b5ea860b1dcb88b89da43cc”,“0xc4fac8ceb6eb7aa97d3c173ecdaaffbf85cbee83”,“0xdb8f4cbba56f912588856a0c337a65a90d1d83c9”,“0x91f2eca71370adff23494660e738b01057cd988b”,“0xfb628af6499738700a460a8d6fc2d414688f211c”,“0xd4d290947a71ca6627ecedb9834c8adae6eb898d”,“0x78a70ebd11aa5023f6b73070912c0b837d529cb8”,“0x0ea21ce04a7446ea71e64ee7eff2c91edd51ed71”,“0x3751703d260439482daf05eed4105087ebf5ee28”,“0xb155f637b88ff5818e265159f3f329652ec8b266”,“0xc85ca407b61129ab62a2cdec176035e6fecf153e”,“0x943672e80419027ccdc7dd4633cd6f1d643db427”,“0xcdacca602161c0089d3e6522d853c47cad0f9b2f”,“0xd550aad0bf0401c779e6d9055c41446fec42b6e0”] | 242720854 | 2024-08-14T08:32:54.000Z | 0x607c1868fdeb7f755cffe4889e72a65fe1dc3d24f52f52f51876a824c46c456e |
Example Query
Example Query
Query with partition filter
SELECT *
FROM `tt-contracts.gmx_v2_arbitrum.BatchSender_BatchSend_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
EventEmitter_EventLog_event
Raw event logs from GMX v2’s EventEmitter contract on Arbitrum, containing structured event data including order cancellations, position closures, and configuration updates. Used for detailed protocol event analysis and tracking state changes across deposits, trades, and system parameters.Columns
Columns
| Column | Type | Description |
|---|---|---|
block_timestamp | TIMESTAMP | Timestamp when the block was produced. UTC timezone, millisecond precision. |
block_number | INT64 | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain. |
transaction_hash | STRING | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
log_index | INT64 | Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission. |
address | STRING | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
removed | BOOL | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
in_msgSender | STRING | Address of the contract or account that triggered the event emission. Hex-encoded, 0x-prefixed, 42-character string. |
in_eventName | STRING | Name of the event emitted by the GMX v2 EventEmitter contract. String value identifying the specific event type such as OrderCreated, SetUint, SwapInfo, or DepositExecuted. |
in_eventNameHash | STRING | Keccak-256 hash of the event name. 66-character hex string including 0x prefix. |
in_eventData | STRUCT<addressItems STRUCT<items ARRAY<STRUCT<key STRING, value STRING>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<STRING>>>>, uintItems STRUCT<items ARRAY<STRUCT<key STRING, value STRING>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<STRING>>>>, intItems STRUCT<items ARRAY<STRUCT<key STRING, value STRING>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<STRING>>>>, boolItems STRUCT<items ARRAY<STRUCT<key STRING, value BOOL>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<BOOL>>>>, bytes32Items STRUCT<items ARRAY<STRUCT<key STRING, value STRING>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<STRING>>>>, bytesItems STRUCT<items ARRAY<STRUCT<key STRING, value STRING>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<STRING>>>>, stringItems STRUCT<items ARRAY<STRUCT<key STRING, value STRING>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<STRING>>>>> | Structured event parameter data organized by data type. Contains nested structs for addressItems, uintItems, intItems, boolItems, bytes32Items, bytesItems, and stringItems, each with items arrays of key-value pairs and arrayItems for array values. |
Sample Data
Sample Data
| address | removed | log_index | block_number | in_eventData | in_eventName | in_msgSender | block_timestamp | in_eventNameHash | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|
| 0xc8ee91a54287db53897056e12d9819156d3822fb | false | 2 | 111080385 | {“intItems”:{“items”:[],“arrayItems”:[]},“boolItems”:{“items”:[],“arrayItems”:[]},“uintItems”:{“items”:[],“arrayItems”:[]},“bytesItems”:{“items”:[{“key”:“reasonBytes”,“value”:“0x”}],“arrayItems”:[]},“stringItems”:{“items”:[{“key”:“reason”,“value”:“USER_INITIATED_CANCEL”}],“arrayItems”:[]},“addressItems”:{“items”:[],“arrayItems”:[]},“bytes32Items”:{“items”:[{“key”:“key”,“value”:“0x0fa8adca6752282021b0be97849ea0b3e9e9b81c341c50ae21516285a570b2f4”}],“arrayItems”:[]}} | DepositCancelled | 0xefbbcda3f586b0f79273fc1a1eddbfc00aef8928 | 2023-07-14T09:34:04.000Z | 0x70056e709adf36c0cb909b41ebecb620a44a31b6dc3867b92c2acf971785cdb5 | 0x980c1fbd523a7f81643e632eb79fad03a721b7e0f550e2b80f046530fbb181e5 |
| 0xc8ee91a54287db53897056e12d9819156d3822fb | false | 229 | 266302286 | {“intItems”:{“items”:[{“key”:“basePnlUsd”,“value”:“-39751372269603665815582020000000”}],“arrayItems”:[]},“boolItems”:{“items”:[],“arrayItems”:[]},“uintItems”:{“items”:[{“key”:“positionCollateralAmount”,“value”:“40242424”},{“key”:“remainingCostUsd”,“value”:“27617876315628304917830000000”}],“arrayItems”:[]},“bytesItems”:{“items”:[],“arrayItems”:[]},“stringItems”:{“items”:[{“key”:“step”,“value”:“pnl”}],“arrayItems”:[]},“addressItems”:{“items”:[],“arrayItems”:[]},“bytes32Items”:{“items”:[{“key”:“orderKey”,“value”:“0x547b06dfa84381b224abdb325d516ebea1972412d424485671f12917fea72e5a”}],“arrayItems”:[]}} | InsolventClose | 0x08a902113f7f41a8658ebb1175f9c847bf4fb9d8 | 2024-10-22T00:31:11.000Z | 0xcfa5615fee0f8a3be5094b3bca17ec4275ce73d648845f3e7c10226bb9e0eed0 | 0xd70ae763fc9349abc634db24b8a17a2713292d8d5cc899938167e1f25866fe76 |
| 0xc8ee91a54287db53897056e12d9819156d3822fb | false | 51 | 266302290 | {“intItems”:{“items”:[{“key”:“basePnlUsd”,“value”:“-185916356071023960741431230000000”}],“arrayItems”:[]},“boolItems”:{“items”:[],“arrayItems”:[]},“uintItems”:{“items”:[{“key”:“positionCollateralAmount”,“value”:“236836265”},{“key”:“remainingCostUsd”,“value”:“16050640770239868814876500000000”}],“arrayItems”:[]},“bytesItems”:{“items”:[],“arrayItems”:[]},“stringItems”:{“items”:[{“key”:“step”,“value”:“fees”}],“arrayItems”:[]},“addressItems”:{“items”:[],“arrayItems”:[]},“bytes32Items”:{“items”:[{“key”:“orderKey”,“value”:“0xeec98b4816525f3055479c82023c24ba0612fea3dbb6f1415122476b4e9bc8ed”}],“arrayItems”:[]}} | InsolventClose | 0x08a902113f7f41a8658ebb1175f9c847bf4fb9d8 | 2024-10-22T00:31:12.000Z | 0xcfa5615fee0f8a3be5094b3bca17ec4275ce73d648845f3e7c10226bb9e0eed0 | 0x45dfd159aac1f4584493f5d8b464a1fba63f0d92d1d285fb27e95c43125a9bb0 |
Example Query
Example Query
Query with partition filter
SELECT *
FROM `tt-contracts.gmx_v2_arbitrum.EventEmitter_EventLog_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
EventEmitter_EventLog1_event
GMX V2 protocol event logs from the EventEmitter contract on Arbitrum, capturing configuration changes and system parameter updates with typed event data structures. Primary use case is tracking protocol state changes and administrative actions by transaction and event name.Columns
Columns
| Column | Type | Description |
|---|---|---|
block_timestamp | TIMESTAMP | Timestamp when the block was produced. UTC timezone, millisecond precision. |
block_number | INT64 | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain. |
transaction_hash | STRING | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
log_index | INT64 | Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission. |
address | STRING | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
removed | BOOL | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
in_msgSender | STRING | Address of the contract or account that triggered the event emission. Hex-encoded, 0x-prefixed, 42-character string. |
in_eventName | STRING | Name of the event emitted by the GMX v2 EventEmitter contract. String value identifying the specific event type such as OrderCreated, SetUint, SwapInfo, or DepositExecuted. |
in_eventNameHash | STRING | Keccak-256 hash of the event name. 66-character hex string including 0x prefix. |
in_topic1 | STRING | First indexed topic parameter of the event. 66-character hex string including 0x prefix, typically containing a key identifier, market address, or account address depending on the event type. |
in_eventData | STRUCT<addressItems STRUCT<items ARRAY<STRUCT<key STRING, value STRING>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<STRING>>>>, uintItems STRUCT<items ARRAY<STRUCT<key STRING, value STRING>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<STRING>>>>, intItems STRUCT<items ARRAY<STRUCT<key STRING, value STRING>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<STRING>>>>, boolItems STRUCT<items ARRAY<STRUCT<key STRING, value BOOL>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<BOOL>>>>, bytes32Items STRUCT<items ARRAY<STRUCT<key STRING, value STRING>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<STRING>>>>, bytesItems STRUCT<items ARRAY<STRUCT<key STRING, value STRING>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<STRING>>>>, stringItems STRUCT<items ARRAY<STRUCT<key STRING, value STRING>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<STRING>>>>> | Structured event parameter data organized by data type. Contains nested structs for addressItems, uintItems, intItems, boolItems, bytes32Items, bytesItems, and stringItems, each with items arrays of key-value pairs and arrayItems for array values. |
Sample Data
Sample Data
| address | removed | in_topic1 | log_index | block_number | in_eventData | in_eventName | in_msgSender | block_timestamp | in_eventNameHash | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|
| 0xc8ee91a54287db53897056e12d9819156d3822fb | false | 0x39288f227e5db9a793e9f4afb15aa22b77dbb7e410ffc973c816a19a6ed921cd | 4 | 250189210 | {“intItems”:{“items”:[],“arrayItems”:[]},“boolItems”:{“items”:[],“arrayItems”:[]},“uintItems”:{“items”:[{“key”:“value”,“value”:“350315”}],“arrayItems”:[]},“bytesItems”:{“items”:[{“key”:“data”,“value”:“0x”}],“arrayItems”:[]},“stringItems”:{“items”:[],“arrayItems”:[]},“addressItems”:{“items”:[],“arrayItems”:[]},“bytes32Items”:{“items”:[{“key”:“baseKey”,“value”:“0x39288f227e5db9a793e9f4afb15aa22b77dbb7e410ffc973c816a19a6ed921cd”}],“arrayItems”:[]}} | SetUint | 0x8583b878da0844b7f59974069f00d3a9eae0f4ae | 2024-09-05T01:57:43.000Z | 0x16451d757d5863173e04605a5bd6de4cad7710cd78c9cc9cd8a3be2ea73de489 | 0x89655e9fa1a7d0bac68d44b59a36880755003a98e643cc677a9aad69417ebfc4 |
| 0xc8ee91a54287db53897056e12d9819156d3822fb | false | 0xf95915378e4358fb5f51ae0fd75853a15a29a978eb14b73d5c5b7d69d3b9fccc | 7 | 250208437 | {“intItems”:{“items”:[],“arrayItems”:[]},“boolItems”:{“items”:[],“arrayItems”:[]},“uintItems”:{“items”:[{“key”:“value”,“value”:“590759”}],“arrayItems”:[]},“bytesItems”:{“items”:[{“key”:“data”,“value”:“0x”}],“arrayItems”:[]},“stringItems”:{“items”:[],“arrayItems”:[]},“addressItems”:{“items”:[],“arrayItems”:[]},“bytes32Items”:{“items”:[{“key”:“baseKey”,“value”:“0xf95915378e4358fb5f51ae0fd75853a15a29a978eb14b73d5c5b7d69d3b9fccc”}],“arrayItems”:[]}} | SetUint | 0x8583b878da0844b7f59974069f00d3a9eae0f4ae | 2024-09-05T03:18:25.000Z | 0x16451d757d5863173e04605a5bd6de4cad7710cd78c9cc9cd8a3be2ea73de489 | 0x0d5ddad86877b38781fcbef8837dbf27c1b0ba4e773382c0265ec3b28b760386 |
| 0xc8ee91a54287db53897056e12d9819156d3822fb | false | 0x335c1af4f0f3344a478b67aff6e7d3dc526f6aafe3dbd1ba2198c772551210cb | 16 | 250192307 | {“intItems”:{“items”:[],“arrayItems”:[]},“boolItems”:{“items”:[],“arrayItems”:[]},“uintItems”:{“items”:[{“key”:“value”,“value”:“1445954”}],“arrayItems”:[]},“bytesItems”:{“items”:[{“key”:“data”,“value”:“0x”}],“arrayItems”:[]},“stringItems”:{“items”:[],“arrayItems”:[]},“addressItems”:{“items”:[],“arrayItems”:[]},“bytes32Items”:{“items”:[{“key”:“baseKey”,“value”:“0x335c1af4f0f3344a478b67aff6e7d3dc526f6aafe3dbd1ba2198c772551210cb”}],“arrayItems”:[]}} | SetUint | 0x8583b878da0844b7f59974069f00d3a9eae0f4ae | 2024-09-05T02:10:42.000Z | 0x16451d757d5863173e04605a5bd6de4cad7710cd78c9cc9cd8a3be2ea73de489 | 0x87b54f76fa0c5751bcce2f775ab1960b88333961050b494488dec99883da0152 |
Example Query
Example Query
Query with partition filter
SELECT *
FROM `tt-contracts.gmx_v2_arbitrum.EventEmitter_EventLog1_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
EventEmitter_EventLog2_event
Raw event logs from GMX V2’s EventEmitter contract on Arbitrum, capturing all protocol events including order creation, execution, and position updates. Used for reconstructing protocol state changes and analyzing trading activity across GMX V2 markets.Columns
Columns
| Column | Type | Description |
|---|---|---|
block_timestamp | TIMESTAMP | Timestamp when the block was produced. UTC timezone, millisecond precision. |
block_number | INT64 | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain. |
transaction_hash | STRING | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
log_index | INT64 | Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission. |
address | STRING | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
removed | BOOL | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
in_msgSender | STRING | Address of the contract or account that triggered the event emission. Hex-encoded, 0x-prefixed, 42-character string. |
in_eventName | STRING | Name of the event emitted by the GMX v2 EventEmitter contract. String value identifying the specific event type such as OrderCreated, SetUint, SwapInfo, or DepositExecuted. |
in_eventNameHash | STRING | Keccak-256 hash of the event name. 66-character hex string including 0x prefix. |
in_topic1 | STRING | First indexed topic parameter of the event. 66-character hex string including 0x prefix, typically containing a key identifier, market address, or account address depending on the event type. |
in_topic2 | STRING | Address of the user or entity associated with the GMX v2 event, typically the trader initiating the order. Hex-encoded, 0x-prefixed 40-character string padded to 64 characters. |
in_eventData | STRUCT<addressItems STRUCT<items ARRAY<STRUCT<key STRING, value STRING>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<STRING>>>>, uintItems STRUCT<items ARRAY<STRUCT<key STRING, value STRING>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<STRING>>>>, intItems STRUCT<items ARRAY<STRUCT<key STRING, value STRING>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<STRING>>>>, boolItems STRUCT<items ARRAY<STRUCT<key STRING, value BOOL>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<BOOL>>>>, bytes32Items STRUCT<items ARRAY<STRUCT<key STRING, value STRING>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<STRING>>>>, bytesItems STRUCT<items ARRAY<STRUCT<key STRING, value STRING>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<STRING>>>>, stringItems STRUCT<items ARRAY<STRUCT<key STRING, value STRING>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<STRING>>>>> | Structured event parameter data organized by data type. Contains nested structs for addressItems, uintItems, intItems, boolItems, bytes32Items, bytesItems, and stringItems, each with items arrays of key-value pairs and arrayItems for array values. |
Sample Data
Sample Data
| address | removed | in_topic1 | in_topic2 | log_index | block_number | in_eventData | in_eventName | in_msgSender | block_timestamp | in_eventNameHash | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0xc8ee91a54287db53897056e12d9819156d3822fb | false | 0x228769a1733b75648aae02a4ac5ad37492f63dea1b05d70395f340d1e7c522ca | 0x0000000000000000000000000035502c012494172b2bb45117394267700ab6f1 | 2 | 130129289 | {“intItems”:{“items”:[],“arrayItems”:[]},“boolItems”:{“items”:[{“key”:“isLong”,“value”:true},{“key”:“shouldUnwrapNativeToken”,“value”:false},{“key”:“isFrozen”,“value”:false}],“arrayItems”:[]},“uintItems”:{“items”:[{“key”:“orderType”,“value”:“4”},{“key”:“decreasePositionSwapType”,“value”:“1”},{“key”:“sizeDeltaUsd”,“value”:“26346948787344000000000000000000000”},{“key”:“initialCollateralDeltaAmount”,“value”:“1317559250”},{“key”:“triggerPrice”,“value”:“0”},{“key”:“acceptablePrice”,“value”:“246976492774351047434428220”},{“key”:“executionFee”,“value”:“845773500000000”},{“key”:“callbackGasLimit”,“value”:“0”},{“key”:“minOutputAmount”,“value”:“0”},{“key”:“updatedAtBlock”,“value”:“130129289”}],“arrayItems”:[]},“bytesItems”:{“items”:[],“arrayItems”:[]},“stringItems”:{“items”:[],“arrayItems”:[]},“addressItems”:{“items”:[{“key”:“account”,“value”:“0x0035502c012494172b2bb45117394267700ab6f1”},{“key”:“receiver”,“value”:“0x0035502c012494172b2bb45117394267700ab6f1”},{“key”:“callbackContract”,“value”:“0x0000000000000000000000000000000000000000”},{“key”:“uiFeeReceiver”,“value”:“0x0000000000000000000000000000000000000000”},{“key”:“market”,“value”:“0x47c031236e19d024b42f8ae6780e44a573170703”},{“key”:“initialCollateralToken”,“value”:“0xaf88d065e77c8cc2239327c5edb3a432268e5831”}],“arrayItems”:[{“key”:“swapPath”,“value”:[]}]},“bytes32Items”:{“items”:[{“key”:“key”,“value”:“0x228769a1733b75648aae02a4ac5ad37492f63dea1b05d70395f340d1e7c522ca”}],“arrayItems”:[]}} | OrderCreated | 0x51e210dc8391728e2017b2ec050e40b2f458090e | 2023-09-11T14:09:42.000Z | 0xa7427759bfd3b941f14e687e129519da3c9b0046c5b9aaa290bb1dede63753b3 | 0x5ad6b6f604c6904287b31f3aa0e512e96407681a6645570035d0a9107c1a49de |
| 0xc8ee91a54287db53897056e12d9819156d3822fb | false | 0x80651fbeaac565aa5dc089068245b507ab15d2404e6ad7e6573e6e7de28e0b97 | 0x0000000000000000000000000036534c48a754163f0f446601f36bcfda840f57 | 2 | 130162290 | {“intItems”:{“items”:[],“arrayItems”:[]},“boolItems”:{“items”:[{“key”:“isLong”,“value”:false},{“key”:“shouldUnwrapNativeToken”,“value”:true},{“key”:“isFrozen”,“value”:false}],“arrayItems”:[]},“uintItems”:{“items”:[{“key”:“orderType”,“value”:“4”},{“key”:“decreasePositionSwapType”,“value”:“1”},{“key”:“sizeDeltaUsd”,“value”:“1606016202302000000000000000000000”},{“key”:“initialCollateralDeltaAmount”,“value”:“60918084166655777”},{“key”:“triggerPrice”,“value”:“0”},{“key”:“acceptablePrice”,“value”:“1565907619810734”},{“key”:“executionFee”,“value”:“715000000000000”},{“key”:“callbackGasLimit”,“value”:“0”},{“key”:“minOutputAmount”,“value”:“0”},{“key”:“updatedAtBlock”,“value”:“130162290”}],“arrayItems”:[]},“bytesItems”:{“items”:[],“arrayItems”:[]},“stringItems”:{“items”:[],“arrayItems”:[]},“addressItems”:{“items”:[{“key”:“account”,“value”:“0x0036534c48a754163f0f446601f36bcfda840f57”},{“key”:“receiver”,“value”:“0x0036534c48a754163f0f446601f36bcfda840f57”},{“key”:“callbackContract”,“value”:“0x0000000000000000000000000000000000000000”},{“key”:“uiFeeReceiver”,“value”:“0x0000000000000000000000000000000000000000”},{“key”:“market”,“value”:“0x70d95587d40a2caf56bd97485ab3eec10bee6336”},{“key”:“initialCollateralToken”,“value”:“0x82af49447d8a07e3bd95bd0d56f35241523fbab1”}],“arrayItems”:[{“key”:“swapPath”,“value”:[]}]},“bytes32Items”:{“items”:[{“key”:“key”,“value”:“0x80651fbeaac565aa5dc089068245b507ab15d2404e6ad7e6573e6e7de28e0b97”}],“arrayItems”:[]}} | OrderCreated | 0x51e210dc8391728e2017b2ec050e40b2f458090e | 2023-09-11T16:33:05.000Z | 0xa7427759bfd3b941f14e687e129519da3c9b0046c5b9aaa290bb1dede63753b3 | 0x0185c1faef50cf57a90952353dea023f694f4a7c2e23b8dcfc9c661763eaa8b4 |
| 0xc8ee91a54287db53897056e12d9819156d3822fb | false | 0x815defc3ec6adcbd8f6a857b80a3737164ede7f148d5efb9ec97e6da518c1da3 | 0x0000000000000000000000000036534c48a754163f0f446601f36bcfda840f57 | 2 | 130162417 | {“intItems”:{“items”:[],“arrayItems”:[]},“boolItems”:{“items”:[{“key”:“isLong”,“value”:true},{“key”:“shouldUnwrapNativeToken”,“value”:true},{“key”:“isFrozen”,“value”:false}],“arrayItems”:[]},“uintItems”:{“items”:[{“key”:“orderType”,“value”:“2”},{“key”:“decreasePositionSwapType”,“value”:“0”},{“key”:“sizeDeltaUsd”,“value”:“2133408887937600000000000000000000”},{“key”:“initialCollateralDeltaAmount”,“value”:“100000000000000000”},{“key”:“triggerPrice”,“value”:“0”},{“key”:“acceptablePrice”,“value”:“1565930391474711”},{“key”:“executionFee”,“value”:“715000000000000”},{“key”:“callbackGasLimit”,“value”:“0”},{“key”:“minOutputAmount”,“value”:“0”},{“key”:“updatedAtBlock”,“value”:“130162417”}],“arrayItems”:[]},“bytesItems”:{“items”:[],“arrayItems”:[]},“stringItems”:{“items”:[],“arrayItems”:[]},“addressItems”:{“items”:[{“key”:“account”,“value”:“0x0036534c48a754163f0f446601f36bcfda840f57”},{“key”:“receiver”,“value”:“0x0036534c48a754163f0f446601f36bcfda840f57”},{“key”:“callbackContract”,“value”:“0x0000000000000000000000000000000000000000”},{“key”:“uiFeeReceiver”,“value”:“0x0000000000000000000000000000000000000000”},{“key”:“market”,“value”:“0x70d95587d40a2caf56bd97485ab3eec10bee6336”},{“key”:“initialCollateralToken”,“value”:“0x82af49447d8a07e3bd95bd0d56f35241523fbab1”}],“arrayItems”:[{“key”:“swapPath”,“value”:[]}]},“bytes32Items”:{“items”:[{“key”:“key”,“value”:“0x815defc3ec6adcbd8f6a857b80a3737164ede7f148d5efb9ec97e6da518c1da3”}],“arrayItems”:[]}} | OrderCreated | 0x51e210dc8391728e2017b2ec050e40b2f458090e | 2023-09-11T16:33:40.000Z | 0xa7427759bfd3b941f14e687e129519da3c9b0046c5b9aaa290bb1dede63753b3 | 0x6b202222e9ee98cedfd28722a245055fd61d0ed16120845f427cff37fa5d30e9 |
Example Query
Example Query
Query with partition filter
SELECT *
FROM `tt-contracts.gmx_v2_arbitrum.EventEmitter_EventLog2_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100