Vertex GMX Arb perp v2 copy

Pine AnalyticsVertex GMX Arb perp v2 copy

Updated 2024-02-12

-- forked from Vertex GMX Arb perp v2 @ https://flipsidecrypto.xyz/edit/queries/dac36565-194c-4de1-a564-fda5f9d497a3

with tab1 as (

SELECT tx_hash

FROM arbitrum.core.fact_transactions

WHERE TO_ADDRESS LIKE lower('0xb87a436B93fFE9D75c5cFA7bAcFff96430b09868')

)

SELECT

origin_from_address as user,

'GMX' as Protocol,

'Arbitrum' as chain,

'V1 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('0xb87a436B93fFE9D75c5cFA7bAcFff96430b09868')

AND amount_usd > 1000

GROUP BY 1,2,3,4

Last run: about 1 year ago

	USER	PROTOCOL	CHAIN	TRADE_TYPE	EVENTS
1	0xc10e9980e28d1236551746b6efecd44678a1a6b6	GMX	Arbitrum	V1 Perp	19
2	0x7509de50d028e2ce2da1d0555dd502d3ccb50d09	GMX	Arbitrum	V1 Perp	60
3	0x43f9e122eca200698b600e86898f425bc814b919	GMX	Arbitrum	V1 Perp	1
4	0x1f662de505a342178d5aaba794155d301cbd5236	GMX	Arbitrum	V1 Perp	198
5	0x6b6e2523ec28f04e6aa83853900dd73774d9a860	GMX	Arbitrum	V1 Perp	4
6	0xa84b3cacb5647c905a3396c308be027428b7b7f6	GMX	Arbitrum	V1 Perp	1
7	0x592ace9a70cb507aa887a97009bdf38f92f8d881	GMX	Arbitrum	V1 Perp	3
8	0x7ee9033aad1d11a80f1c1e8d769feacbc97416db	GMX	Arbitrum	V1 Perp	8
9	0xf32e2901759c7eddd26d19fc135c8dfab71fd41e	GMX	Arbitrum	V1 Perp	78
10	0x396dc3e4d1051837bb559810d2b1ea7977775899	GMX	Arbitrum	V1 Perp	39
11	0xc0dad93e21d823c073e137883d51a214f590cdac	GMX	Arbitrum	V1 Perp	10
12	0x7d7c319a929f95c9371333ac7cbb5787ec31d6bf	GMX	Arbitrum	V1 Perp	15
13	0x02535f81854b731a185a765286f7196c6c2b63a4	GMX	Arbitrum	V1 Perp	29
14	0x9716dbbc717a31f2724e11d4bd1d61241beda18c	GMX	Arbitrum	V1 Perp	10
15	0x85a230f1b39c679d84307de0184b839c2655951a	GMX	Arbitrum	V1 Perp	23
16	0xb16ef1ed893a86e756e21009fc8ed305d191623f	GMX	Arbitrum	V1 Perp	59
17	0x2f19883a1f8212e8f3b7f72f2b37f8440df55d23	GMX	Arbitrum	V1 Perp	17
18	0x2a3dcc5e8bd5ceada454835cb60e3b4b2a2dbb5d	GMX	Arbitrum	V1 Perp	1
19	0x3164d79a977cd6542f7cf9bb4ec6df66f4e4c0b5	GMX	Arbitrum	V1 Perp	4
20	0x2f670a086b5b426ba56086149ca1904027e403b9	GMX	Arbitrum	V1 Perp	83

...

10242

763KB

20s