Updated 2025-01-25
    ------CREADIT https://flipsidecrypto.xyz/pietrekt/q/C23a7MRpVhNd/untitled-query-o3x6Eq
    SELECT
    DATE_TRUNC('day', DAY) AS date,
    AVG(asset_liquidity * asset_price_usd + rune_liquidity * rune_price_usd) AS tvl,
    SPLIT_PART(pool_name, '-', 1) AS pool_name
    FROM
    thorchain.defi.fact_daily_pool_stats
    WHERE pool_name ilike '%BASE%'
    GROUP BY
    date,
    SPLIT_PART(pool_name, '-', 1)



    Last run: 24 days ago
    DATE
    TVL
    POOL_NAME
    1
    2025-01-12 00:00:00.00074608.846888155BASE.ETH
    2
    2025-01-12 00:00:00.000417.508645828BASE.USDC
    3
    2025-01-12 00:00:00.000417.681819034BASE.CBBTC
    4
    2025-01-13 00:00:00.00072994.663917514BASE.ETH
    5
    2025-01-15 00:00:00.000501769.051887063BASE.ETH
    6
    2025-01-15 00:00:00.000324.646446401BASE.CBBTC
    7
    2025-01-16 00:00:00.00031114.370698555BASE.CBBTC
    8
    2025-01-17 00:00:00.000452421.558066321BASE.USDC
    9
    2025-01-17 00:00:00.000551778.877655226BASE.ETH
    10
    2025-01-18 00:00:00.000293657.167864506BASE.CBBTC
    11
    2025-01-19 00:00:00.000461271.054778214BASE.USDC
    12
    2025-01-19 00:00:00.000331283.858365976BASE.CBBTC
    13
    2025-01-20 00:00:00.000319185.031035191BASE.CBBTC
    14
    2025-01-16 00:00:00.000511426.346750338BASE.ETH
    15
    2025-01-19 00:00:00.000519199.411561074BASE.ETH
    16
    2025-01-21 00:00:00.000324772.500540507BASE.CBBTC
    17
    2025-01-21 00:00:00.000504665.805493753BASE.ETH
    18
    2025-01-23 00:00:00.000366328.837791326BASE.CBBTC
    19
    2025-01-22 00:00:00.000445335.319900807BASE.USDC
    20
    2025-01-24 00:00:00.000468965.701793521BASE.ETH
    42
    2KB
    2s