Vertex GMX Arb swap

Pine AnalyticsVertex GMX Arb swap

Updated 2024-02-12

SELECT

ORIGIN_FROM_ADDRESS as user,

'GMX' as platform,

'Arbitrum' as chain,

'Swap' as trade_type,

count(*) as events

FROM arbitrum.defi.ez_dex_swaps

WHERE platform LIKE 'gmx'

AND (AMOUNT_OUT_USD + AMOUNT_IN_USD) / 2 > 1000

AND ABS(ABS(AMOUNT_IN_USD - AMOUNT_OUT_USD) / ((ABS(AMOUNT_IN_USD) + ABS(AMOUNT_OUT_USD)) / 2)) <= 0.50

GROUP BY 1,2,3,4

--LIMIT 100

Last run: about 1 year ago

	USER	PLATFORM	CHAIN	TRADE_TYPE	EVENTS
1	0x2c0765acf66041fc831a5d5a328e88a05d6f5834	GMX	Arbitrum	Swap	149
2	0xf6ca829ea6f2e44e042ea418596027da435befa4	GMX	Arbitrum	Swap	4
3	0x61205b76e12841a8ac541e56edd4b6adc3f4f64f	GMX	Arbitrum	Swap	769
4	0x6ea311a37f8199e66b761be67bf9240eba30bc8a	GMX	Arbitrum	Swap	682
5	0x5fc1ea951402add65613e0437ce59d8b23442e2a	GMX	Arbitrum	Swap	16
6	0x62f349e190b2d547f7da88e0eca6510b375c2d05	GMX	Arbitrum	Swap	2
7	0xbfc530fe1ec08d4cdd40efca5a419ba9094d68f7	GMX	Arbitrum	Swap	112
8	0x12a3051760ec32abe13d8d45af00e0cc4f292ccd	GMX	Arbitrum	Swap	199
9	0xab61660f93dffca32e3f526b20dad35332080a12	GMX	Arbitrum	Swap	27
10	0x705f8f0eaac561aabb1d5d8f4d0dab36d5a62e86	GMX	Arbitrum	Swap	4
11	0xcac740805fcefc3b0fb0c3d60dffba85888caca7	GMX	Arbitrum	Swap	10
12	0x78414bbf0977b273ea75ab9ffa4880bbc0c59cef	GMX	Arbitrum	Swap	1
13	0x2c2790a366c7d54a4d772389bded4fcc4441e6ff	GMX	Arbitrum	Swap	17
14	0x88f859db067c45b114897db6920f3e4a61a5ca66	GMX	Arbitrum	Swap	23
15	0x10aa2807e7766b3290e6242d78471987d96b9eff	GMX	Arbitrum	Swap	750
16	0x90b30c2befb0d9559ec6f5986a826a325815a806	GMX	Arbitrum	Swap	8
17	0xa369808ef2c2ad96ff76bcabc56ca44db6e94998	GMX	Arbitrum	Swap	1
18	0xb3271df122fdc7381618c19a49dc2a16d500bd6b	GMX	Arbitrum	Swap	2
19	0x0736da5424025fe5dfc5cf84150d04215f00f962	GMX	Arbitrum	Swap	1
20	0x494a95b3bc27f61d65eb6bdec8da6ec674bd69f7	GMX	Arbitrum	Swap	13

...

32421

2MB

flipside