theericstoneUniswap TVL
Updated 2020-12-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
WITH uniswap as (
select address as pool_address,
project_name,
symbol from public.ethereum_address_labels_updates
where project_name = 'uniswap'
and symbol like '%LP'
)
select
--bals.balance_date,
--bals.symbol,
bals.address_name,
sum(amount_usd) as tvl
from
gold.ethereum_erc20_balances bals
join uniswap
on uniswap.pool_address = bals.user_address
where bals.balance_date > '2020-12-02'
group by 1
order by tvl desc;
Run a query to Download Data