TOTAL_STAKED_IN_SOL | TOTAL_CLAIMED_IN_SOL | |
|---|---|---|
1 | 33372365.7463921 | 24000717.3593128 |
datavortexabsent-lavender
Updated 2025-02-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 msol_data AS (
SELECT livequery.live.udf_api(
'https://api.coingecko.com/api/v3/coins/msol/market_chart?vs_currency=usd&days=365'
) AS market_data
),
sol_data AS (
SELECT livequery.live.udf_api(
'https://api.coingecko.com/api/v3/coins/solana/market_chart?vs_currency=usd&days=365'
) AS market_data
),
msol_prices AS (
SELECT
DATEADD('millisecond', data.value[0]::bigint, '1970-01-01 00:00:00')::DATE AS date,
data.value[1]::FLOAT AS price_usd
FROM msol_data, LATERAL FLATTEN(input => market_data:data:prices) data
),
sol_prices AS (
SELECT
DATEADD('millisecond', data.value[0]::bigint, '1970-01-01 00:00:00')::DATE AS date,
data.value[1]::FLOAT AS price_usd
FROM sol_data, LATERAL FLATTEN(input => market_data:data:prices) data
),
latest_sol_per_msol AS (
SELECT
sol_prices.price_usd / msol_prices.price_usd AS sol_to_msol
FROM sol_prices
JOIN msol_prices ON sol_prices.date = msol_prices.date
ORDER BY sol_prices.date DESC
LIMIT 1
),
stake_data AS (
SELECT
BLOCK_TIMESTAMP::DATE AS date,
ACTION_TYPE,
COALESCE(DEPOSIT_AMOUNT, 0) AS stake_amount,
COALESCE(CLAIM_AMOUNT, 0) AS unstake_amount
Last run: 3 months ago
1
37B
3s