pecio222TOTAL WETH-USDC Q3 Q4 without bots
    Updated 2025-01-22
    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 = '0x55084ee0fef03f14a305cd24286359a35d735151' THEN 'Hashflow'
    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'
    Last run: 3 months ago
    WEEK
    PLATFORM
    ORIGIN_TO
    VOLUME
    1
    2024-08-05 00:00:00.000uniswap-v3Uniswap77717974.98
    2
    2024-08-05 00:00:00.000uniswap-v3AAVE50465903.3
    3
    2024-11-13 00:00:00.000uniswap-v3Uniswap49446994.88
    4
    2024-12-20 00:00:00.000uniswap-v3Uniswap42574003.45
    5
    2024-12-19 00:00:00.000uniswap-v3Uniswap36528459.3
    6
    2024-11-14 00:00:00.000uniswap-v3Uniswap33696351.41
    7
    2024-11-11 00:00:00.000uniswap-v3Uniswap31468738.7
    8
    2024-11-12 00:00:00.000uniswap-v3Uniswap31333451.74
    9
    2024-12-10 00:00:00.000uniswap-v3Uniswap31047743.9
    10
    2024-12-09 00:00:00.000uniswap-v3Uniswap30175164.91
    11
    2024-11-25 00:00:00.000uniswap-v31inch26734570.24
    12
    2024-08-05 00:00:00.000uniswap-v31inch25946030.34
    13
    2024-11-25 00:00:00.000uniswap-v3Uniswap25777698.83
    14
    2024-11-23 00:00:00.000uniswap-v3Uniswap25563385.52
    15
    2025-01-19 00:00:00.000uniswap-v3Uniswap25504826.19
    16
    2024-08-05 00:00:00.000uniswap-v3Tokelon DEX25261254.04
    17
    2025-01-06 00:00:00.000uniswap-v31inch25106299.81
    18
    2024-12-18 00:00:00.000uniswap-v3Uniswap25054471.45
    19
    2024-12-05 00:00:00.000uniswap-v3Uniswap24542734.48
    20
    2024-12-06 00:00:00.000uniswap-v3Uniswap24375120.76
    ...
    18973
    1MB
    17s