Kruys-CollinsBonding Simple Metrics copy
Updated 2024-12-30
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
›
⌄
-- forked from Bonding Simple Metrics @ https://flipsidecrypto.xyz/studio/queries/bd707d61-ae9e-4926-826f-20cf0a32af41
WITH MAIN AS (
SELECT
SUM(olas_amount_usd) AS total_olas_amount_usd,
FROM
crosschain.olas.ez_olas_bonding;
),
olas_price as (select
PRICE
from ethereum.price.ez_prices_hourly
where TOKEN_ADDRESS = lower('0x0001a500a6b18995b03f44bb040a5ffc28e45cb0')
order by HOUR desc
limit 1),
LP_TOKEN_VALUE_IN_USD AS (
select
value: "TOTAL_OWNED_LIQUIDITY" as "TOTAL LP TOKEN_VALUE IN USD",
from (
select livequery.live.udf_api(
'https://flipsidecrypto.xyz/api/v1/queries/36f46800-a9ae-4335-b203-64ee6af82d4a/data/latest'
):"data" as data) responses join lateral flatten (input => responses.data) d
)
SELECT
"TOTAL LP TOKEN_VALUE IN USD",
total_olas_amount_usd - "TOTAL LP TOKEN_VALUE IN USD" as NET_VALUE_RECEIVED_FROM_BONDING_IN_USD,
NET_VALUE_RECEIVED_FROM_BONDING_IN_USD/PRICE AS NET_VALUE_RECEIVED_FROM_BONDING_IN_olas
FROM
MAIN, olas_price, LP_TOKEN_VALUE_IN_USD
QueryRunArchived: QueryRun has been archived