theericstoneCurve Finance Launch TVL
Updated 2021-02-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
select
crv.balance_date,
crv.pool_address,
crv.pool_name,
crv.asset_address,
crv.symbol,
crv.tvl_usd,
crv.tvl,
coalesce(crv.tvl_usd,crv.tvl) as tvl_full
from (select
balance_date,
user_address as pool_address,
address_name as pool_name,
contract_address as asset_address,
symbol,
sum(amount_usd) as tvl_usd,
sum(balance) as tvl
from
gold.ethereum_erc20_balances
where
user_address in (
LOWER('0xA2B47E3D5c44877cca798226B7B8118F9BFb7A56'),
LOWER('0x52EA46506B9CC5Ef470C5bf89f17Dc28bB35D85C'),
LOWER('0xbEbc44782C7dB0a1A60Cb6fe97d0b483032FF1C7'),
LOWER('0xA5407eAE9Ba41422680e2e00537571bcC53efBfD'),
LOWER('0x45F783CCE6B7FF23B2ab2D70e416cdb7D6055f51'),
LOWER('0x79a8C46DeA5aDa233ABaFFD40F3A0A2B1e5A4F27'),
LOWER('0x06364f10B501e868329afBc005b3492902d6C763'),
LOWER('0x45F783CCE6B7FF23B2ab2D70e416cdb7D6055f51'),
LOWER('0x79a8C46DeA5aDa233ABaFFD40F3A0A2B1e5A4F27'),
LOWER('0x52EA46506B9CC5Ef470C5bf89f17Dc28bB35D85C'),
LOWER('0xbEbc44782C7dB0a1A60Cb6fe97d0b483032FF1C7'),
LOWER('0xA5407eAE9Ba41422680e2e00537571bcC53efBfD'),
LOWER('0xA2B47E3D5c44877cca798226B7B8118F9BFb7A56'),
LOWER('0x52EA46506B9CC5Ef470C5bf89f17Dc28bB35D85C'),
LOWER('0x45F783CCE6B7FF23B2ab2D70e416cdb7D6055f51'),
Run a query to Download Data