WEEK | PLATFORM | ORIGIN_TO | VOLUME | |
|---|---|---|---|---|
1 | 2025-01-20 00:00:00.000 | uniswap-v3 | UNKNOWN_BOTS | 729535829.46 |
2 | 2025-01-19 00:00:00.000 | uniswap-v3 | UNKNOWN_BOTS | 551918691.07 |
3 | 2024-12-09 00:00:00.000 | uniswap-v3 | UNKNOWN_BOTS | 436989401.21 |
4 | 2024-11-25 00:00:00.000 | uniswap-v3 | UNKNOWN_BOTS | 428857761.81 |
5 | 2024-11-12 00:00:00.000 | uniswap-v3 | UNKNOWN_BOTS | 424315901.58 |
6 | 2024-12-18 00:00:00.000 | uniswap-v3 | UNKNOWN_BOTS | 405744749.47 |
7 | 2024-11-13 00:00:00.000 | uniswap-v3 | UNKNOWN_BOTS | 403525114.66 |
8 | 2024-12-10 00:00:00.000 | uniswap-v3 | UNKNOWN_BOTS | 394886770.2 |
9 | 2024-12-20 00:00:00.000 | uniswap-v3 | UNKNOWN_BOTS | 393390883.1 |
10 | 2024-12-05 00:00:00.000 | uniswap-v3 | UNKNOWN_BOTS | 381455375.65 |
11 | 2024-11-26 00:00:00.000 | uniswap-v3 | UNKNOWN_BOTS | 380784573.74 |
12 | 2024-12-19 00:00:00.000 | uniswap-v3 | UNKNOWN_BOTS | 379840185.45 |
13 | 2024-08-05 00:00:00.000 | uniswap-v3 | UNKNOWN_BOTS | 369815621.94 |
14 | 2024-11-21 00:00:00.000 | uniswap-v3 | UNKNOWN_BOTS | 337919597.99 |
15 | 2024-12-12 00:00:00.000 | uniswap-v3 | UNKNOWN_BOTS | 326359490.94 |
16 | 2024-12-16 00:00:00.000 | uniswap-v3 | UNKNOWN_BOTS | 326120175.18 |
17 | 2025-01-21 00:00:00.000 | uniswap-v3 | UNKNOWN_BOTS | 322338298.78 |
18 | 2024-12-02 00:00:00.000 | uniswap-v3 | UNKNOWN_BOTS | 316093613.6 |
19 | 2024-12-17 00:00:00.000 | uniswap-v3 | UNKNOWN_BOTS | 307405579.64 |
20 | 2024-11-11 00:00:00.000 | uniswap-v3 | UNKNOWN_BOTS | 303069846.23 |
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
WHEN ORIGIN_TO_ADDRESS = '0x45a62b090df48243f12a21897e7ed91863e2c86b' THEN 'LFJ Aggregator' --Joe Aggregator
/* arbitrum below */
WHEN ORIGIN_TO_ADDRESS = '0x63dfa7c09dc2ff4030d6b8dc2ce6262bf898c8a4' THEN 'AAVE' --ParaSwapDebtSwapAdapterV3
WHEN ORIGIN_TO_ADDRESS = '0xad3b67bca8935cb510c8d18bd45f0b94f54a968f' THEN '1inch' -- resolver
WHEN ORIGIN_TO_ADDRESS = '0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45' THEN 'Uniswap' -- 'SwapRouter02'
WHEN ORIGIN_TO_ADDRESS = '0x5e325eda8064b456f4781070c0738d849c824258' THEN 'Uniswap' -- 'Universal Router 4'
WHEN ORIGIN_TO_ADDRESS = '0xe592427a0aece92de3edee1f18e0157c05861564' THEN 'Uniswap' -- 'Uniswap v3: Router'
WHEN ORIGIN_TO_ADDRESS = '0x1f721e2e82f6676fce4ea07a5958cf098d339e18' THEN 'Camelot' -- 'SwapRouter Router v3'
WHEN ORIGIN_TO_ADDRESS = '0xa669e7a0d4b3e4fa48af2de86bd4cd7126be4e13' THEN 'Odos Router v2' --
WHEN ORIGIN_TO_ADDRESS = '0x0843e589bf27911528bf02d7080fa87f40cbabdf' THEN 'dHEDGE' -- DhedgeEasySwapper
WHEN ORIGIN_TO_ADDRESS = '0x80b9411977c4ff8d618f2ac3f29f1e2d623c4d34' THEN 'dHEDGE' -- DhedgeEasySwapper
WHEN ORIGIN_TO_ADDRESS = '0x99d4e80db0c023eff8d25d8155e0dcfb5addec5e' THEN 'CamelotYakRouter' -- CamelotYakRouter
WHEN ORIGIN_TO_ADDRESS = '0x6352a56caadc4f1e25cd6c75970fa768a3304e64' THEN 'OpenOcean' -- from ramses frontend
WHEN ORIGIN_TO_ADDRESS = '0x3e8fb04888700ad28b02eb60c3de40cdeb001042' THEN 'Hashflow' -- SwapFacade
WHEN ORIGIN_TO_ADDRESS = '0x4c4af8dbc524681930a27b2f1af5bcc8062e6fb7' THEN 'Woofi' -- WooRouterV2
WHEN ORIGIN_TO_ADDRESS = '0x6f1fe5b048de0417c4e838b1fc4245aaf254f1dc' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0xe3be1402bdc62d1e4ff4d5658129c5f82745fbad' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0x812db82330d6ddf4e52a66cd4ece95ac4a2adf1e' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0xb4c71b734e7976c90f60566ec24038248ee9c4a7' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0xf3ae7446b8a02550ad10a829ad272d6fb7dbddab' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0xac3b205a2abaf2272d5fae1b92dd124bf573d53a' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0x75010b38696e3045072ea8bebabee8e4b8a3706c' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0x5cfcab4d1546fd0e18f5283c2cc73ed33e472275' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0xccbc738c567425286137ac0eba55778c0287a4b3' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0x05063bb35876cb2321c9237e8e66931857d431a5' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0x05c5f0be2678c17d67e9fad485dd1908f2237413' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0xe04ce28b65d56054372c37a2b7dbe1e75d47450a' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0xe49b558d932d9d1180f6a5fef8ae86ec108f9b18' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0x68f08a7596d2e41f32a60e8a2cc0e673a847794d' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0xb1da9837efb1abf1aeb77be86429fa3cfb118a8b' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0xc7b8d6b0102a591f6187d7831673d1c8f4d027f2' THEN 'UNKNOWN_BOTS'
WHEN ORIGIN_TO_ADDRESS = '0x2187389f86c4a026ddfd9f60782a64bd1acecd06' THEN 'UNKNOWN_BOTS'
Last run: 3 months ago
...
20596
1MB
16s