NET_STAKE_IN_SOL | |
|---|---|
1 | 9336313.88538416 |
datavortexMsol prices
Updated 2025-02-18
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 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
),
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
Last run: 2 months ago
1
20B
3s