SocioAnalyticatotal staking per total supply
Updated 2024-12-12
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 staking as (
select
sum(balance) as total_near_staked
from (
SELECT
address,
block_timestamp,
balance
from near.gov.fact_staking_pool_balances
qualify row_number () over (partition by address order by block_timestamp desc) = 1
)
)
,
circu_supply as (
with near as (
WITH json as (
SELECT
livequery.live.udf_api(
'https://api.coingecko.com/api/v3/coins/markets?vs_currency=usd&ids=near&order=market_cap_desc&per_page=100&page=1&sparkline=false&locale=en'
) as resp
)
SELECT
value:market_cap as market_cap,
value:total_supply as total_supply,
value:circulating_supply as circulating_supply,
value:market_cap_rank as market_cap_rank,
value:total_volume as trading_volume,
value:current_price as current_price,
value:price_change_percentage_24h as price_change_percentage_24h
FROM json,
LATERAL FLATTEN(input => json.resp:data) as value
)
QueryRunArchived: QueryRun has been archived