SocioCryptoVelodrome Protocol Metrics and Velo Token
Updated 2023-12-19
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
›
⌄
-- #3F83F8
-- #EE2524
with price_S as (
SELECT 'velodrome-finance [VELO]' 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/velodrome-finance/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/velodrome-finance/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/velodrome-finance/market_chart?vs_currency=usd&days=max&interval=daily&precision=3') as response
),LATERAL FLATTEN (input => response:data:total_volumes)
)
,
tvl as (
WITH
Run a query to Download Data