Vertex Uniswap ARB

Pine AnalyticsVertex Uniswap ARB

Updated 2024-02-11

-- forked from Vertex Uniswap OP @ https://flipsidecrypto.xyz/edit/queries/d368577f-30ec-461f-b84e-3d2e51a3c8ad

-- forked from Vertex Uniswap Eth @ https://flipsidecrypto.xyz/edit/queries/8fe803e6-45fa-47be-8220-25ab69bc1142

SELECT

-- count(DISTINCT ORIGIN_FROM_ADDRESS)

ORIGIN_FROM_ADDRESS as user,

'Arbitrum' as chain,

'Uniswap' as platform,

count(*) as events

FROM arbitrum.defi.ez_dex_swaps

WHERE platform like '%uniswap%'

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

and ((AMOUNT_IN_USD + AMOUNT_OUT_USD) / 2) > 1000

AND user < '0x2a0b3b4554e017804b19c515fb6a1f64354464d9'

GROUP BY 1,2,3

ORDER by user DESC

Last run: about 1 year ago

	USER	CHAIN	PLATFORM	EVENTS
1	0x2a09f2ccada2ade76810f051363f54df04a35eef	Arbitrum	Uniswap	1
2	0x2a09e43f4d93a2611a6c7b87d907ac35e51d59c6	Arbitrum	Uniswap	39
3	0x2a09a7d3eb5688bd9a5c3ba1af5b61a611aaac54	Arbitrum	Uniswap	2
4	0x2a099ae63fc94d5850d71c5c4f056356291cd345	Arbitrum	Uniswap	1
5	0x2a098ffd6c9bbaa61a2f53aa1da7996a49ae4199	Arbitrum	Uniswap	2
6	0x2a098e77572a7d9911af527ce9e19c90c3addf26	Arbitrum	Uniswap	1
7	0x2a09861d6130f52f94b409b3183515cbde03b0db	Arbitrum	Uniswap	2
8	0x2a097cc3dd14353093cc7fe7ef6ba9c233a0ad95	Arbitrum	Uniswap	2
9	0x2a090a64a11fbe476f1e404acab04c4c77ca3666	Arbitrum	Uniswap	2
10	0x2a08fecb8ac932cb7d3f6a3a0e434a4b9968dd56	Arbitrum	Uniswap	1
11	0x2a08f24df6f9cea79a29e99e62b30cb7b55c32c7	Arbitrum	Uniswap	7
12	0x2a08eaaed1cfb7457d2322f9f5e36e44b23a222d	Arbitrum	Uniswap	44
13	0x2a079a9b669f4fcd93cdb1eae2b8d6cfafa5239e	Arbitrum	Uniswap	3
14	0x2a07805d9e2c4a106497f365e0cb4b4d5b1b6374	Arbitrum	Uniswap	1
15	0x2a07482c1161123112b37ad1f63cee0f7bdcdc2f	Arbitrum	Uniswap	2
16	0x2a070d2e5440a260c0099418413a76aac5fa7a60	Arbitrum	Uniswap	1
17	0x2a06d90d7bf42cc5e5866b8c00adf4e43ea25a7b	Arbitrum	Uniswap	38
18	0x2a06b8f467a65b1ec5bd1eaa18a95e6077e9216c	Arbitrum	Uniswap	30
19	0x2a06913d5b8748b222e1236768c24ca19198b374	Arbitrum	Uniswap	6
20	0x2a06760ae0ddf07daf4e6c279ecdaff01ca9cd84	Arbitrum	Uniswap	1

...

58228

4MB