permarybsc &avax tvl
Updated 2024-11-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT
DATE_TRUNC('day', date) AS date,
chain,
SUM(tvl_usd) AS total_tvl
FROM
external.defillama.fact_chain_tvl
WHERE
(LOWER(chain) LIKE '%binance%' OR LOWER(chain) = 'avalanche') -- Use LOWER for case insensitivity
AND date BETWEEN '2024-01-01' AND '2024-12-31' -- Time period
GROUP BY
date,
chain
ORDER BY
date, chain;
QueryRunArchived: QueryRun has been archived