theericstoneAPY TVL
Updated 2020-11-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
-- APY lets you lock DAI, USDC, and USDT for the purposes of options
SELECT
balance_date,
contract_address,
symbol,
sum(amount_usd) as total_value_locked
FROM gold.ethereum_erc20_balances
WHERE
user_address in (
'0x75ce0e501e2e6776fcaaa514f394a88a772a8970', -- APY DAI pool
'0xe18b0365d5d09f394f84ee56ed29dd2d8d6fba5f', -- APY USDC pool
'0xea9c5a2717d5ab75afaac340151e73a7e37d99a7') -- APY USDT pool
AND symbol in ('DAI','USDC','USDT')
AND amount_usd > 0
AND balance_date > '2020-08-30'
GROUP BY 1,2,3
ORDER BY 1,2,3;
Run a query to Download Data