theericstoneUniswap TVL for Selected Pools
Updated 2021-02-08
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
›
⌄
⌄
SELECT
balance_date,
address_name as pool,
sum(amount_usd) as tvl
FROM gold.ethereum_erc20_balances
WHERE user_address IN (
'0x0d4a11d5eeaac28ec3f61d100daf4d40471f1852', --ETH/USDT
'0xb4e16d0168e52d35cacd2c6185b44281ec28c9dc', --ETH/USDC
'0xa478c2975ab1ea89e8196811f51a7b7ade33eb11', -- ETH/DAI
'0xbb2b8038a1640196fbe3e38816f3e67cba72d940' --ETH/WBTC
)
AND
/*symbol in (
'USDT','WETH','USDC','DAI','WBTC'
)*/
contract_address IN (
'0xdac17f958d2ee523a2206206994597c13d831ec7', --USDT
'0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2',--WETH
'0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48',--USDC
'0x6b175474e89094c44da98b954eedeac495271d0f',--DAI
'0x2260fac5e5542a773aa44fbcfedf7c193bc2c599'--WBTC
)
AND balance_date > '2020-09-12' AND balance_date < '2020-12-17'
GROUP BY 1,2
ORDER BY 1,2 DESC
Run a query to Download Data