WEEK | PLATFORM | ORIGIN_TO | VOLUME | |
|---|---|---|---|---|
1 | 2024-12-02 00:00:00.000 | trader-joe-v2 | UNKNOWN_BOTS | 125297009.89 |
2 | 2024-11-17 00:00:00.000 | trader-joe-v2 | UNKNOWN_BOTS | 94289875.97 |
3 | 2024-11-18 00:00:00.000 | trader-joe-v2 | UNKNOWN_BOTS | 90121376.91 |
4 | 2024-12-03 00:00:00.000 | trader-joe-v2 | UNKNOWN_BOTS | 80738052.33 |
5 | 2024-11-12 00:00:00.000 | trader-joe-v2 | UNKNOWN_BOTS | 79434215.72 |
6 | 2024-08-05 00:00:00.000 | trader-joe-v2 | UNKNOWN_BOTS | 73098807.83 |
7 | 2024-11-25 00:00:00.000 | trader-joe-v2 | UNKNOWN_BOTS | 70694772.79 |
8 | 2024-11-16 00:00:00.000 | trader-joe-v2 | UNKNOWN_BOTS | 70251887.41 |
9 | 2024-12-09 00:00:00.000 | trader-joe-v2 | UNKNOWN_BOTS | 61455184.82 |
10 | 2024-11-13 00:00:00.000 | trader-joe-v2 | UNKNOWN_BOTS | 59695313.42 |
11 | 2024-11-22 00:00:00.000 | trader-joe-v2 | UNKNOWN_BOTS | 58944747.29 |
12 | 2024-12-04 00:00:00.000 | trader-joe-v2 | UNKNOWN_BOTS | 57765664.39 |
13 | 2024-11-11 00:00:00.000 | trader-joe-v2 | UNKNOWN_BOTS | 55983900.57 |
14 | 2025-01-19 00:00:00.000 | trader-joe-v2 | UNKNOWN_BOTS | 52995643.86 |
15 | 2024-11-23 00:00:00.000 | trader-joe-v2 | UNKNOWN_BOTS | 52380934.94 |
16 | 2025-01-20 00:00:00.000 | trader-joe-v2 | UNKNOWN_BOTS | 51582137.96 |
17 | 2024-12-10 00:00:00.000 | trader-joe-v2 | UNKNOWN_BOTS | 49360116.64 |
18 | 2024-11-26 00:00:00.000 | trader-joe-v2 | UNKNOWN_BOTS | 48186861.17 |
19 | 2024-12-02 00:00:00.000 | uniswap-v3 | UNKNOWN_BOTS | 47791351.49 |
20 | 2024-12-20 00:00:00.000 | trader-joe-v2 | UNKNOWN_BOTS | 46989856.35 |
pecio222TOTAL AVAX-USDC Q3 Q4 with bots
Updated 2025-03-28
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
›
⌄
-- forked from TOTAL AVAX-USDC Q3 Q4 without bots @ https://flipsidecrypto.xyz/studio/queries/fc5ca42f-4766-4e06-9765-c3ea1906b5df
WITH ALL_DATA as (
SELECT
DATE_TRUNC('DAY', block_timestamp) AS WEEK,
CASE
WHEN ORIGIN_TO_ADDRESS = '0x45a62b090df48243f12a21897e7ed91863e2c86b' THEN 'LFJ Aggregator' --Joe Aggregator
WHEN ORIGIN_TO_ADDRESS = '0xad3b67bca8935cb510c8d18bd45f0b94f54a968f' THEN '1inch' -- resolver
WHEN ORIGIN_TO_ADDRESS = '0xe3ffc583dc176575eea7fd9df2a7c65f7e23f4c3' THEN 'LBRouter' --'LB_ROUTERV_2.0'
WHEN ORIGIN_TO_ADDRESS = '0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30' THEN 'LBRouter' --'LB_ROUTERV_2.1'
WHEN ORIGIN_TO_ADDRESS = '0x18556da13313f3532c54711497a8fedac273220e' THEN 'LBRouter' --'LB_ROUTERV_2.2'
WHEN ORIGIN_TO_ADDRESS = '0x60ae616a2155ee3d9a68541ba4544862310933d4' THEN 'JOE_ROUTER_V1'
WHEN ORIGIN_TO_ADDRESS = '0xdef1c0ded9bec7f1a1670819833240f027b25eff' THEN '0x exchange'
WHEN ORIGIN_TO_ADDRESS = '0x111111125421ca6dc452d289314280a0f8842a65' THEN '1inch' --'1inch v6'
WHEN ORIGIN_TO_ADDRESS = '0x1111111254eeb25477b68fb85ed929f73a960582' THEN '1inch' --'1inch v5'
WHEN ORIGIN_TO_ADDRESS = '0x1111111254fb6c44bac0bed2854e76f90643097d' THEN '1inch' --'1inch v4'
WHEN ORIGIN_TO_ADDRESS = '0xdef171fe48cf0115b1d80b88dc8eab59176fee57' THEN 'Paraswap' --'Paraswap'
WHEN ORIGIN_TO_ADDRESS = '0x6a000f20005980200259b80c5102003040001068' THEN 'Paraswap' --'Paraswap 6.2'
WHEN ORIGIN_TO_ADDRESS = '0x1f772fa3bc263160ea09bb16ce1a6b8fc0fab36a' THEN 'Hashflow'
WHEN ORIGIN_TO_ADDRESS = '0x973bf562407766e77f885c1cd1a8060e5303c745' THEN 'LLamazip'
WHEN ORIGIN_TO_ADDRESS = '0x0c6134abc08a1eafc3e2dc9a5ad023bb08da86c3' THEN 'FireBirdRouter'
WHEN ORIGIN_TO_ADDRESS = '0x88de50b233052e4fb783d4f6db78cc34fea3e9fc' THEN 'OdosRouterV2'
WHEN ORIGIN_TO_ADDRESS = '0x6131b5fae19ea4f9d964eac0408e4408b66337b5' THEN 'Kyberswap aggr'
WHEN ORIGIN_TO_ADDRESS = '0x1a1ec25dc08e98e5e93f1104b5e5cdd298707d31' THEN 'Metamask Swap Router'
WHEN ORIGIN_TO_ADDRESS = '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae' THEN 'LiFi'
WHEN ORIGIN_TO_ADDRESS = '0xc4729e56b831d74bbc18797e0e17a295fa77488c' THEN 'Yield Yak'
WHEN ORIGIN_TO_ADDRESS = '0x1dac23e41fc8ce857e86fd8c1ae5b6121c67d96d' THEN 'OKX router' -- WHEN ORIGIN_TO_ADDRESS = '0x22c81c051a134c81ce370d82fa26975ae9d100b4' THEN 'unknown echange/aggregator?'
WHEN ORIGIN_TO_ADDRESS = '0xaaa9f93572b99919750fa59c33c0946bc5fc0e90' THEN 'Pharaoh Router'
WHEN ORIGIN_TO_ADDRESS = '0xaaae99091fbb28d400029052821653c1c752483b' THEN 'Pharaoh Router'
WHEN ORIGIN_TO_ADDRESS = '0xbb00ff08d01d300023c629e8ffffcb65a5a578ce' THEN 'Uniswap' -- 'SwapRouter02'
WHEN ORIGIN_TO_ADDRESS = '0x4dae2f939acf50408e13d58534ff8c2776d45265' THEN 'Uniswap' --'UniversalRouter'
WHEN ORIGIN_TO_ADDRESS = '0xba12222222228d8ba445958a75a0704d566bf2c8' THEN 'Balancer Vault'
WHEN ORIGIN_TO_ADDRESS = '0x4a88c44b8d9b9f3f2ba4d97236f737cf03df76cd' THEN 'Wombat Exchange'
WHEN ORIGIN_TO_ADDRESS = '0x794a61358d6845594f94dc1db02a252b5b4814ad' THEN 'AAVE'
WHEN ORIGIN_TO_ADDRESS = '0x2cf641f7c0eac2788a7924b82d6ca8eb7baa4e3a' THEN 'AAVE'
WHEN ORIGIN_TO_ADDRESS = '0xeed3c159f3a96ab8d41c8b9ca49ee1e5071a7cdd' THEN 'Dexalot'
Last run: 21 days ago
...
10365
643KB
4s