flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
2023-08-22 05:51 PM
Afonso_Diaz
2023-08-22 05:51 PM
Updated 2023-08-22
Copy Reference
Fork
9
1
2
3
4
5
6
7
›
⌄
select
date_trunc
(
'month'
,
date
)
::
date
as
month
,
avg
(
tvl_usd
)
as
average_tvl_usd
from
external
.
defillama
.
fact_chain_tvl
group
by
1
having
month
is
not
null
order
by
1
Results
Run a query to Download Data