synthquestV3 Parameters
Updated 2023-06-19
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
›
⌄
with thegraph as (
with raw as (
SELECT
livequery.live.udf_api(
'POST',
'https://api.thegraph.com/subgraphs/name/snx-v3/optimism-mainnet',
{'Content-Type': 'application/json'},
{'query':'{
collateralTypes {
issuance_ratio
id
total_amount_deposited
updated_at_block
min_delegation
liquidation_reward
liquidation_ratio
depositing_enabled
updated_at
oracle_node_id
}
}
',
'variables':{}
}
) as rawoutput
)
SELECT
value:id as id
, coalesce(value:issuance_ratio,0) / pow(10,18) as target_ratio
, coalesce(value:total_amount_deposited,0)::int / pow(10,18) as total_deposit
, value:updated_at_block as block_number
, coalesce(value:min_delegation,0) / pow(10,18) as min_delegation
, coalesce(value:liquidation_reward,0) / pow(10,18) as liquidation_reward
Run a query to Download Data