flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
tvl usdc
theericstone
tvl usdc
Updated 2021-04-22
Copy Reference
Fork
9
1
2
3
4
5
6
›
⌄
select
balance_date
,
sum
(
balance
)
from
ethereum
.
erc20_balances
where
balance_date
>
'2021-01-01'
and
contract_address
=
'0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'
and
label_type
in
(
'dex'
,
'defi'
)
group
by
1
order
by
1
desc
;
Results
Run a query to Download Data