SocioAnalyticaTVL by ATOM
Updated 2023-11-16
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
›
⌄
-- forked from BlockTracker / Price -- market cap -- TVL --trading volume @ https://flipsidecrypto.xyz/BlockTracker/q/qUSljkb--MGd/price----market-cap----tvl---trading-volume
with price_Stride as (
SELECT 'Stride (STRD)' as network,
TO_TIMESTAMP(value[0]::string) as date,
value[1] as price,
((price - LAG(price)over(ORDER BY date))/LAG(price)over(ORDER BY date))*100 as daily_change
FROM (
SELECT livequery.live.udf_api(
'https://api.coingecko.com/api/v3/coins/stride/market_chart?vs_currency=usd&days=max&interval=daily&precision=3') as response
),LATERAL FLATTEN (input => response:data:prices)
)
,
market_cap as (
SELECT
TO_TIMESTAMP(value[0]::string) as date,
value[1] as market_cap_usd
FROM (
SELECT livequery.live.udf_api(
'https://api.coingecko.com/api/v3/coins/stride/market_chart?vs_currency=usd&days=max&interval=daily&precision=3') as response
),LATERAL FLATTEN (input => response:data:market_caps)
)
,
trading_volume as (
SELECT
TO_TIMESTAMP(value[0]::string) as date,
value[1] as trading_volume_usd
FROM (
SELECT livequery.live.udf_api(
'https://api.coingecko.com/api/v3/coins/stride/market_chart?vs_currency=usd&days=max&interval=daily&precision=3') as response
),LATERAL FLATTEN (input => response:data:total_volumes)
),
price_atom as (
SELECT date_Trunc('d',recorded_hour) as date,
median (price) as atom_price
FROM osmosis.price.ez_prices
Run a query to Download Data