Swap Stats Breakdown by Pairs

0xHaM-dSwap Stats Breakdown by Pairs

Updated 2025-01-22

-- forked from Swaps Over Time @ https://flipsidecrypto.xyz/studio/queries/aa92dc5f-6d41-4ff3-828d-56dd5e9fa8d5

WITH token_map AS (

SELECT

COLUMN1 AS TOKEN_CONTRACT, COLUMN2 AS SYMBOL, COLUMN3 AS DECIMALS

FROM

(VALUES

('0xf1815bd50389c46847f0bda824ec8da914045d14', 'USDC.e', 6),

('0x2a1bce657f919ac3f9ab50b2584cfc77563a02ec', 'AK47', 18),

('0x1b184de5952d11fe3e821fc58e6ef73d545f733e', 'CYPHER', 18),

('0x21c97338b1ea81a0b49930483c70d5b79abcf041', 'DBI', 18),

('0xae44bac3814ecc4f5ac3fee16eb06bff1b74fe82', 'PENK', 8),

('0x145922e65ceaf0e4cf6e37e3a0e5bb57d9e1ff09', 'SQWARD', 18),

('0x2e1ac42aef8dc9fb4c661d017273e93ba82d3d0e', 'IAGENT', 18),

('0xd43e76ff8f95035e220070bddfd3c0c2bdd3051b', 'SINK', 18),

('0xe169c0cad1f9e5884c30db1976a39ebc40f8865f', 'WAGMI', 18),

('0xee73d2f34d66f0f07af6ab37b42713520e33119c', 'MYST', 18),

('0x1514c65c751d16bf253a9e82715771c5557e568b', 'INKYME', 18),

('0xec2d096221bf7f599d1b1581dd73eb6b245807ee', 'LIT', 18),

('0x67314f6a5732a308408969269618f38132777a45', 'SQUI', 18),

('0x232e0fef23dc0d6371ac2e59a6b7bfac2b971fe5', 'SHARK', 18),

('0xd0eca4bd623bad9a3872d31b6ac7065e4fa9344d', 'OCTOPEPE', 18),

('0x82ae03bbe6ec576bbd7496cbd67917cc21af097c', 'IKA', 18),

('0x75e7a5316e44755ff4ad724ee45337d1eef6895e', 'PRL', 18),

('0x4e7942a72dcfcc72fa0872068b0dba3921c1bb8a', 'CHAD', 18),

('0x084c4cafb176536b62d56a2f17ed1213d5b7b140', 'LANDWOLF', 9),

('0x2dc2b752f4c6dffe2dbcf60b848b8357a8879a01', 'Worm', 18),

('0x2e3b82891d1b2b90655597110cca9b6587607e0c', 'SQUID', 18),

('0x4200000000000000000000000000000000000006', 'WETH', 18),

('0xbf0cafcbaaf0be8221ae8d630500984edc908861', 'SQUIDS', 18),

('0x6814b9c5dae3dd05a8dbe9bf2b4e4fbb9cef5302', 'ISWAP', 18),

('0x19eb460d4155e204b054de78661f9aa556b50874', 'OCTO', 18),

('0xca5f2ccbd9c40b32657df57c716de44237f80f05', 'Kraken', 18),

('0x870657fd6372262f5b0ef90e0ae5ddf9bf585d09', 'OSSY', 18)

)

Last run: 3 months ago

	PAIR	N_SWAPS	N_SWAPPERS	AMOUNT_IN	AMOUNT_OUT
1		3160	819	309706515.706647	9157363923.70587
2	USDC.e / WETH	1239	806	55755.143369833	16.588950971
3	WETH / USDC.e	1236	768	17.688285496	59568.288474667
4	WETH / AK47	928	560	14.696523456	143124993.406196
5	AK47 / WETH	870	523	168556216.896497	16.96305778
6	WETH / IAGENT	562	359	9.959847071	153428953.362039
7	IAGENT / WETH	510	332	188745869.334736	11.792697155
8	DBI / WETH	407	221	293921761.690363	0.81535704
9	WETH / DBI	399	237	0.881113376	317953868.194239
10	PRL / WETH	398	215	220003236.120351	17.033763691
11	WETH / PRL	394	198	12.424022229	160795718.065527
12	MYST / WETH	379	181	235282772.912104	5.439807235
13	WETH / CHAD	362	263	0.9596399264	383104577.88076
14	CHAD / WETH	333	254	390378874.763624	0.9719839038
15	WETH / MYST	319	180	5.56628185	257624624.204345
16	LIT / WETH	316	212	655503568.55498	7.669097856
17	WETH / LIT	307	205	7.475018965	741765790.983332
18	WAGMI / WETH	302	201	177376004.265659	2.614176655
19	WETH / CYPHER	298	227	8.075864921	492012638.391451
20	WETH / WAGMI	288	209	1.796397942	127989337.575324

...

198

10KB