> ## Documentation Index > Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt > Use this file to discover all available pages before exploring further. # gmx_v2_arbitrum > Tables in tt-contracts.gmx_v2_arbitrum ## 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. | 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` | 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` | Array of token amounts involved in the operation. String-encoded integers representing amounts in the token's smallest unit (e.g., wei for ETH). | | 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 | **Query with partition filter** ```sql theme={null} 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. | 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>, arrayItems ARRAY>>>, uintItems STRUCT>, arrayItems ARRAY>>>, intItems STRUCT>, arrayItems ARRAY>>>, boolItems STRUCT>, arrayItems ARRAY>>>, bytes32Items STRUCT>, arrayItems ARRAY>>>, bytesItems STRUCT>, arrayItems ARRAY>>>, stringItems STRUCT>, arrayItems ARRAY>>>>` | 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. | | 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 | **Query with partition filter** ```sql theme={null} 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. | 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>, arrayItems ARRAY>>>, uintItems STRUCT>, arrayItems ARRAY>>>, intItems STRUCT>, arrayItems ARRAY>>>, boolItems STRUCT>, arrayItems ARRAY>>>, bytes32Items STRUCT>, arrayItems ARRAY>>>, bytesItems STRUCT>, arrayItems ARRAY>>>, stringItems STRUCT>, arrayItems ARRAY>>>>` | 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. | | 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 | **Query with partition filter** ```sql theme={null} 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. | 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>, arrayItems ARRAY>>>, uintItems STRUCT>, arrayItems ARRAY>>>, intItems STRUCT>, arrayItems ARRAY>>>, boolItems STRUCT>, arrayItems ARRAY>>>, bytes32Items STRUCT>, arrayItems ARRAY>>>, bytesItems STRUCT>, arrayItems ARRAY>>>, stringItems STRUCT>, arrayItems ARRAY>>>>` | 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. | | 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 | **Query with partition filter** ```sql theme={null} SELECT * FROM `tt-contracts.gmx_v2_arbitrum.EventEmitter_EventLog2_event` WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY) LIMIT 100 ``` ***