WEEK | PLATFORM | ORIGIN_TO | VOLUME | |
|---|---|---|---|---|
1 | 2024-07-16 00:00:00.000 | trader-joe-v2 | LBRouter | 11377868.62 |
2 | 2024-07-15 00:00:00.000 | trader-joe-v2 | LBRouter | 8933463.73 |
3 | 2024-07-08 00:00:00.000 | trader-joe-v2 | LBRouter | 8658670.27 |
4 | 2024-07-13 00:00:00.000 | trader-joe-v2 | LBRouter | 8229247.23 |
5 | 2024-07-05 00:00:00.000 | trader-joe-v2 | LBRouter | 7843975.4 |
6 | 2024-07-21 00:00:00.000 | trader-joe-v2 | LBRouter | 6962987.84 |
7 | 2024-07-14 00:00:00.000 | trader-joe-v2 | LBRouter | 6366408.08 |
8 | 2024-07-09 00:00:00.000 | trader-joe-v2 | LBRouter | 6358814.92 |
9 | 2024-07-23 00:00:00.000 | trader-joe-v2 | LBRouter | 6049590.86 |
10 | 2024-07-17 00:00:00.000 | trader-joe-v2 | LBRouter | 6020373.52 |
11 | 2024-07-24 00:00:00.000 | trader-joe-v2 | LBRouter | 5987814.39 |
12 | 2024-08-05 00:00:00.000 | trader-joe-v2 | LBRouter | 5907915.39 |
13 | 2024-07-11 00:00:00.000 | trader-joe-v2 | LBRouter | 5631568.61 |
14 | 2024-07-22 00:00:00.000 | trader-joe-v2 | LBRouter | 5083360.57 |
15 | 2025-03-08 00:00:00.000 | trader-joe-v2 | Metamask Swap Router | 5065289.99 |
16 | 2024-07-29 00:00:00.000 | trader-joe-v2 | LBRouter | 4945670.85 |
17 | 2024-08-02 00:00:00.000 | trader-joe-v2 | LBRouter | 4899572.09 |
18 | 2025-01-20 00:00:00.000 | trader-joe-v2 | 1inch | 4825102.31 |
19 | 2024-12-19 00:00:00.000 | trader-joe-v2 | LBRouter | 4443880.06 |
20 | 2024-07-31 00:00:00.000 | trader-joe-v2 | LBRouter | 4310094.04 |
pecio222LB AVAX-USDC Q3 Q4 without 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 UNISWAP V3 AVAX-USDC Q3 Q4 without bots @ https://flipsidecrypto.xyz/studio/queries/13a12768-adde-4b2c-93e9-e026d39303d6
-- 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'
Last run: about 1 month ago
...
2580
165KB
4s