alessio9567$IXS Metrics
Updated 2025-01-22Copy Reference Fork
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 api_price AS (
select
response:data:prices as response
from
(
SELECT
livequery.live.udf_api(
'https://api.coingecko.com/api/v3/coins/ix-swap/market_chart?vs_currency=usd&days=365'
) as response
)
),
flatten_cmc_data_price AS (
SELECT
*
FROM
api_price,
table(flatten(response, ''))
),
final_api_price as (
select
*,
TO_TIMESTAMP(CAST(value [0] AS BIGINT) / 1000) AS dt
from
flatten_cmc_data_price
),
api_volume AS (
select
response:data:total_volumes as response
from
(
SELECT
livequery.live.udf_api(
'https://api.coingecko.com/api/v3/coins/ix-swap/market_chart?vs_currency=usd&days=365'
) as response
)
),
QueryRunArchived: QueryRun has been archived