flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
2023-04-19 10:17 AM
winnie-fs
2023-04-19 10:17 AM
Updated 2023-04-19
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
›
⌄
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
Results