WEEK | PLATFORM | ORIGIN_TO | VOLUME | |
|---|---|---|---|---|
1 | 2024-08-05 00:00:00.000 | uniswap-v3 | ARB_BOTS | 709057132.77 |
2 | 2025-01-20 00:00:00.000 | uniswap-v3 | ARB_BOTS | 385571940.27 |
3 | 2024-11-12 00:00:00.000 | uniswap-v3 | UNKNOWN_BOTS | 356186191.77 |
4 | 2025-01-20 00:00:00.000 | uniswap-v3 | UNKNOWN_BOTS | 329476623.38 |
5 | 2024-12-18 00:00:00.000 | uniswap-v3 | UNKNOWN_BOTS | 324887513.09 |
6 | 2024-08-05 00:00:00.000 | uniswap-v3 | OTHERS | 313886049.29 |
7 | 2025-01-19 00:00:00.000 | uniswap-v3 | ARB_BOTS | 301539642.36 |
8 | 2024-11-13 00:00:00.000 | uniswap-v3 | UNKNOWN_BOTS | 297646500.84 |
9 | 2024-11-18 00:00:00.000 | uniswap-v3 | UNKNOWN_BOTS | 296822343.77 |
10 | 2025-01-21 00:00:00.000 | uniswap-v3 | UNKNOWN_BOTS | 296705213.2 |
11 | 2024-12-16 00:00:00.000 | uniswap-v3 | UNKNOWN_BOTS | 288336852.25 |
12 | 2024-11-11 00:00:00.000 | uniswap-v3 | UNKNOWN_BOTS | 285899032.07 |
13 | 2024-07-23 00:00:00.000 | uniswap-v3 | UNKNOWN_BOTS | 285396395.79 |
14 | 2024-12-05 00:00:00.000 | uniswap-v3 | UNKNOWN_BOTS | 279996107.53 |
15 | 2024-11-26 00:00:00.000 | uniswap-v3 | UNKNOWN_BOTS | 269008189.97 |
16 | 2024-11-25 00:00:00.000 | uniswap-v3 | UNKNOWN_BOTS | 262802820.6 |
17 | 2025-01-21 00:00:00.000 | uniswap-v3 | ARB_BOTS | 258816445.87 |
18 | 2024-11-14 00:00:00.000 | uniswap-v3 | UNKNOWN_BOTS | 256073824.74 |
19 | 2024-12-19 00:00:00.000 | uniswap-v3 | UNKNOWN_BOTS | 250962866.9 |
20 | 2024-11-17 00:00:00.000 | uniswap-v3 | UNKNOWN_BOTS | 249680043.82 |
pecio222TOTAL WETH-USDC Q3 Q4 with bots
Updated 2025-01-22
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH ALL_DATA as (
SELECT
DATE_TRUNC('DAY', block_timestamp) AS WEEK,
CASE
/*ETH L1 below */
WHEN ORIGIN_TO_ADDRESS = '0x9008d19f58aabd9ed0d60971565aa8510560ab41' THEN 'COWSWAP'
WHEN ORIGIN_TO_ADDRESS = '0x663dc15d3c1ac63ff12e45ab68fea3f0a883c251' THEN 'DEBRIDGE'
WHEN ORIGIN_TO_ADDRESS = '0x881d40237659c251811cec9c364ef91dc08d300c' THEN 'Metamask Swap Router'
WHEN ORIGIN_TO_ADDRESS = '0x87870bca3f3fd6335c3f4ce8392d69350b4fa4e2' THEN 'AAVE'
WHEN ORIGIN_TO_ADDRESS = '0xadc0a53095a0af87f3aa29fe0715b5c28016364e' THEN 'AAVE'
WHEN ORIGIN_TO_ADDRESS = '0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9' THEN 'AAVE'
WHEN ORIGIN_TO_ADDRESS = '0x03f34be1bf910116595db1b11e9d1b2ca5d59659' THEN 'Tokelon DEX'
WHEN ORIGIN_TO_ADDRESS = '0x70bf6634ee8cb27d04478f184b9b8bb13e5f4710' THEN '0x exchange'
WHEN ORIGIN_TO_ADDRESS = '0x12d737470fb3ec6c3deec9b518100bec9d520144' THEN '0x exchange'
WHEN ORIGIN_TO_ADDRESS = '0xce16f69375520ab01377ce7b88f5ba8c48f8d666' THEN 'Squid Router'
WHEN ORIGIN_TO_ADDRESS = '0xf3de3c0d654fda23dad170f0f320a92172509127' THEN 'OKX'
WHEN ORIGIN_TO_ADDRESS = '0xcf5540fffcdc3d510b18bfca6d2b9987b0772559' THEN 'OdosRouterV2'
WHEN ORIGIN_TO_ADDRESS = '0x3c11f6265ddec22f4d049dde480615735f451646' THEN 'mimic.fi' --mimic.fi
WHEN ORIGIN_TO_ADDRESS = '0xad3b67bca8935cb510c8d18bd45f0b94f54a968f' THEN '1inch' -- resolver
WHEN ORIGIN_TO_ADDRESS = '0xfc99f58a8974a4bc36e60e2d490bb8d72899ee9f' THEN 'OKX'
WHEN ORIGIN_TO_ADDRESS = '0x0000000000001ff3684f28c67538d4d072c22734' THEN '0x exchange'
WHEN ORIGIN_TO_ADDRESS = '0xfaa763790b26e7ea354373072bab02e680eeb07f' THEN 'Defi Saver strategy'
WHEN ORIGIN_TO_ADDRESS = '0xf2614a233c7c3e7f08b1f887ba133a13f1eb2c55' THEN 'Sushiswap'
WHEN ORIGIN_TO_ADDRESS = '0x0b8a49d816cc709b6eadb09498030ae3416b66dc' THEN '1inch' --resolver
WHEN ORIGIN_TO_ADDRESS = '0x02e7b8511831b1b02d9018215a0f8f500ea5c6b3' THEN 'AAVE'
WHEN ORIGIN_TO_ADDRESS = '0x23f5a668a9590130940ef55964ead9787976f2cc' THEN 'crvUSD controller'
WHEN ORIGIN_TO_ADDRESS = '0x07e594aa718bb872b526e93eed830a8d2a6a1071' THEN '0x exchange'
WHEN ORIGIN_TO_ADDRESS = '0x51c72848c68a965f66fa7a88855f9f7784502a7f' THEN 'WINTERMUTE'
WHEN ORIGIN_TO_ADDRESS = '0x68d3a973e7272eb388022a5c6518d9b2a2e66fbf' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0x1bf621aa9cee3f6154881c25041bb39aed4ca7cc' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0xd4bc53434c5e12cb41381a556c3c47e1a86e80e3' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0xb6613cc55866e282638006455390207c1d485be9' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0xef97b8a6cbb72feeccf5bc5e897078e9e53ee0a4' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0x767c8bb1574bee5d4fe35e27e0003c89d43c5121' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0x817648d73fd85c802cfde8a29eba9f68b783ca60' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0x8ce3c66b4663090980f6ca05ae3bc390d74731e9' THEN 'UNKNOWN_BOTS'
Last run: 3 months ago
...
24965
1MB
7s