picasowelcome-emerald
Updated 2025-02-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
SELECT
response:data:market_data:current_price:usd AS "Latest Price",
response:data:market_data:price_change_24h_in_currency:usd AS "24h Price Difference",
response:data:market_data:price_change_percentage_24h_in_currency:usd AS "24h Price Change (%)",
response:data:market_data:high_24h:usd AS "24h Peak Price",
response:data:market_data:low_24h:usd AS "24h Lowest Price",
response:data:market_data:ath:usd AS "All-Time High",
response:data:market_data:ath_change_percentage:usd AS "ATH Change (%)",
response:data:market_data:atl:usd AS "All-Time Low",
response:data:market_data:atl_change_percentage:usd AS "ATL Change (%)",
response:data:market_data:circulating_supply AS "Available Supply",
response:data:market_data:market_cap:usd AS "Total Market Value",
response:data:market_data:market_cap_change_24h_in_currency:usd AS "Market Cap Δ (24h)",
response:data:market_data:market_cap_change_percentage_24h_in_currency:usd AS "Market Cap % Change (24h)",
response:data:market_data:market_cap_rank AS "Market Ranking",
response:data:market_data:fully_diluted_valuation:usd AS "Fully Diluted Valuation",
response:data:market_data:max_supply AS "Maximum Supply",
response:data:market_data:total_supply AS "Overall Supply"
FROM
(SELECT livequery.live.udf_api('https://api.coingecko.com/api/v3/coins/ronin') AS response),
LATERAL FLATTEN(input => response:data)
LIMIT 1;
QueryRunArchived: QueryRun has been archived