FIRST_HALF_STAKED | SECOND_HALF_STAKED | GROWTH_PERCENTAGE | |
|---|---|---|---|
1 | 6838230.56214239 | 10839081.2900642 | 58.507104895 |
permary current staked
Updated 2025-02-28
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 dates as (
select
date_trunc('week', date_day) as date
from crosschain.core.dim_dates
where date_day between '2024-01-01' and '2024-12-31'
group by date
),
prices_raw as (
select
(
select response as core_price
from (
select livequery.live.udf_api(
'https://api.coingecko.com/api/v3/simple/price?ids=coredaoorg&vs_currencies=usd'
):data:"coredaoorg":usd as response
)
) as core_price,
(
select response as stcore_price
from (
select livequery.live.udf_api(
'https://api.coingecko.com/api/v3/simple/price?ids=coredao-staked-core&vs_currencies=usd'
):data:"coredao-staked-core":usd as response
)
) as stcore_price
),
prices as (
select
core_price,
stcore_price
from prices_raw
),
mints as (
Last run: about 1 month ago
1
50B
9s