winnie-fs2023-04-19 10:17 AM
    Updated 2023-04-19
    SELECT
    tvl.date,
    count(tvl.chain) AS chains,
    sum(tvl.tvl_usd) AS tvl_usd
    FROM
    external.defillama.fact_chain_tvl AS tvl
    WHERE
    tvl.date >= '2023-01-01'
    GROUP BY
    1