scottincryptoYearn current production query
Updated 2021-08-10
999
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
›
⌄
with vdata as (
select '{
"vault_data": [
{
"vault_address": "0x986b4aff588a109c09b50a03f42e4110e29d353f",
"vault_symbol": "yvCurve-sETH",
"vault_name": "Curve sETH Pool yVault",
"asset_address": "0xa3d87fffce63b53e0d54faa1cc983b7eb0b74a9c",
"asset_symbol": "eCRV",
"pricing_address": "0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2",
"pricing_symbol": "WETH",
"exposure": "eth"
},
{
"vault_address": "0x5f18c75abdae578b483e5f43f12a39cf75b973a9",
"vault_symbol": "yvUSDC",
"vault_name": "USDC yVault",
"asset_address": "0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48",
"asset_symbol": "USDC",
"pricing_address": "0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48",
"pricing_symbol": "USDC",
"exposure": "stablecoin"
},
{
"vault_address": "0x3b96d491f067912d18563d56858ba7d6ec67a6fa",
"vault_symbol": "yvCurve-USDN",
"vault_name": "Curve USDN Pool yVault",
"asset_address": "0x4f3e8f405cf5afc05d68142f3783bdfe13811522",
"asset_symbol": "usdn3CRV",
"pricing_address": "0x674c6ad92fd080e4004b2312b45f796a192d27a0",
"pricing_symbol": "USDN",
"exposure": "stablecoin"
},
{
"vault_address": "0x7da96a3891add058ada2e826306d812c638d87a7",
Run a query to Download Data