pecio222CAMELOT V3 WETH-USDC Q3 Q4 without 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
›
⌄
-- forked from UNISWAP V3 WETH-USDC Q3 Q4 without bots @ https://flipsidecrypto.xyz/studio/queries/e557b152-f61f-4f7f-96df-facb08956e22
-- forked from TOTAL WETH-USDC Q3 Q4 without bots @ https://flipsidecrypto.xyz/studio/queries/186ff929-ce5c-4642-88a0-bab1ec49f217
-- forked from TOTAL WETH-USDC Q3 Q4 with bots @ https://flipsidecrypto.xyz/studio/queries/d05b230a-35d2-4188-a1e0-6f9c5d13af1f
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'
QueryRunArchived: QueryRun has been archived