picasowelcome-emerald
    Updated 2025-02-14
    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