TOKEN | MarketCap 24h | Price 24h | Trading volume 24h | MarketCap 7d | Price 7d | Trading volume 7d | MarketCap 30d | Price 30d | Trading volume 30d | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | FLOW | 569030328.935686 | 0.3851505604 | 818412.903249834 | 569030328.935686 | 0.3851505604 | 166137819.359716 | 690978594.038741 | 0.3851505604 | 688285251.63311 |
2 | RLY | 4513515.24046928 | 0.001001400094 | 2811.981574376 | 4513515.24046928 | 0.001001400094 | 570832.259598372 | 5924552.29191609 | 0.001001400094 | 2364876.5040504 |
3 | REVV | 1412062.06587344 | 0.001264732177 | 4452.765632885 | 1412062.06587344 | 0.001264732177 | 903911.423475716 | 1412062.06587344 | 0.001264732177 | 3744775.89725654 |
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
Last run: 14 days ago
3
456B
45s