Vertex GMX Arb perp v2

Pine AnalyticsVertex GMX Arb perp v2

Updated 2024-02-12

with tab1 as (

SELECT tx_hash

FROM arbitrum.core.fact_transactions

WHERE TO_ADDRESS LIKE lower('0x7c68c7866a64fa2160f78eeae12217ffbf871fa8')

)

SELECT

origin_from_address as user,

'GMX' as Protocol,

'Arbitrum' as chain,

'v2 Perp' as trade_type,

count(*) as events

FROM arbitrum.core.ez_token_transfers

WHERE tx_hash in (SELECT * from tab1)

AND to_address LIKE lower('0x31ef83a530fde1b38ee9a18093a333d8bbbc40d5')

AND amount_usd > 1000

GROUP BY 1,2,3,4

Last run: about 1 year ago

	USER	PROTOCOL	CHAIN	TRADE_TYPE	EVENTS
1	0x47e2a4294a84cdd045921a4478e377d2eceb49d5	GMX	Arbitrum	v2 Perp	5
2	0x78cb8f4cb7dce4f05655ce682fb9cb9b56384611	GMX	Arbitrum	v2 Perp	103
3	0xa720df18625320ddea94b7489cfcbcd907ff90ed	GMX	Arbitrum	v2 Perp	26
4	0xe49f2cac8839bf905d5bdc930ba201188511ff56	GMX	Arbitrum	v2 Perp	7
5	0x339b80acb72b95261f88cf725cb2fa5d512cc9d5	GMX	Arbitrum	v2 Perp	3
6	0x3245a608bd54c9a34bd56264f403c71127d140a3	GMX	Arbitrum	v2 Perp	51
7	0xa431476f0dcfb530fa5aef1af7f10f73a985fbf6	GMX	Arbitrum	v2 Perp	5
8	0x87e5df4826e8201506e26efa8dada64f40af5756	GMX	Arbitrum	v2 Perp	14
9	0x6662304e3198c8d54530fbdf02a869fa84537639	GMX	Arbitrum	v2 Perp	48
10	0x88d72be9c7218378d36f1de1c873d1272d3e6616	GMX	Arbitrum	v2 Perp	50
11	0xe004767560d91d452d64b036b4446c8e288b8b60	GMX	Arbitrum	v2 Perp	20
12	0x0cbb34975e52eccc55fd19b9224d53059cfa084f	GMX	Arbitrum	v2 Perp	10
13	0xab5d7e77106d24646d41f0a65d9d15054643b78a	GMX	Arbitrum	v2 Perp	26
14	0x287046aa39c414a16e33b64580f11a630e1b59fc	GMX	Arbitrum	v2 Perp	17
15	0xb25c53df79bc7c2444aee5d715762e81032d5112	GMX	Arbitrum	v2 Perp	4
16	0x4ce838b36263191b566fc62cbc71795e4fca3273	GMX	Arbitrum	v2 Perp	3
17	0x10376fbc611ba48b6b75fe39d5bcc855b0595624	GMX	Arbitrum	v2 Perp	3
18	0x1dccb7e86cb6bb92b326dab5384655b8190aed7b	GMX	Arbitrum	v2 Perp	10
19	0xcf9ecd940458e6b35f98376147314a75adb0bdac	GMX	Arbitrum	v2 Perp	7
20	0xd7f1e1d5c8f91d611f8393c55bb51361212c3c17	GMX	Arbitrum	v2 Perp	33

...

5912

440KB

11s

flipside