permarymarket cap
Updated 2025-02-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with core_data as (
select
to_timestamp(value[0]::number/1000)::timestamp_ntz as date,
value[1]::float as market_cap
from (
select livequery.live.udf_api(
'https://api.coingecko.com/api/v3/coins/coredaoorg/market_chart?vs_currency=usd&days=180&interval=daily&precision=full'
) as response
),
lateral flatten(input => response:data:market_caps)
)
select
date,
market_cap,
avg(market_cap) over (
order by date
rows between 30 preceding and current row
) as moving_avg_30d_mcap,
((select market_cap from core_data where date = current_date())) as current_market_cap
from core_data
order by date desc;
QueryRunArchived: QueryRun has been archived