adriaparcerisasTop Flow tokens by MarketCap
Updated 2025-04-14
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 parsed_data AS (
SELECT
dateadd(ms, market_caps.value[0], to_timestamp('1970-01-01')) AS date,
'FLOW' as token,
avg(market_caps.value[1]) AS market_cap,
avg(prices.value[1]) AS price,
avg(total_volumes.value[1]) AS volume
FROM
(
SELECT livequery.live.udf_api(
'https://api.coingecko.com/api/v3/coins/flow/market_chart?vs_currency=usd&days=30&interval=daily') as resp
),
lateral flatten(input => resp:data:market_caps) AS market_caps,
lateral flatten(input => resp:data:prices) AS prices,
lateral flatten(input => resp:data:total_volumes) AS total_volumes
where date<current_date
group by 1,2
UNION
SELECT
dateadd(ms, market_caps.value[0], to_timestamp('1970-01-01')) AS date,
'REVV' as token,
avg(market_caps.value[1]) AS market_cap,
avg(prices.value[1]) AS price,
avg(total_volumes.value[1]) AS volume
FROM
(
SELECT livequery.live.udf_api(
'https://api.coingecko.com/api/v3/coins/revv/market_chart?vs_currency=usd&days=30&interval=daily') as resp
),
lateral flatten(input => resp:data:market_caps) AS market_caps,
lateral flatten(input => resp:data:prices) AS prices,
lateral flatten(input => resp:data:total_volumes) AS total_volumes
where date<current_date
group by 1,2
QueryRunArchived: QueryRun has been archived