market_cap_data AS (

SELECT

coin.value:id::string AS "Coin ID",

coin.value:symbol::string AS "Coin Symbol",

coin.value:name::string AS "Coin Name",

coin.value:market_cap::number AS "Market Capitalization",

coin.value:market_cap_rank::number AS "Market Cap Rank",

coin.value:total_supply::number AS "Total Supply",

coin.value:circulating_supply::number AS "Circulating Supply"

FROM (

SELECT livequery.live.udf_api(

'https://api.coingecko.com/api/v3/coins/markets?vs_currency=usd&category=gaming&order=market_cap_desc&per_page=100&page=1'

) AS coin_data

),

LATERAL FLATTEN(input => coin_data:data) coin

),

price_data AS (

SELECT

coin.value:id::string AS "Coin ID",

coin.value:current_price::string AS "Current Price",

coin.value:price_change_percentage_7d_in_currency::number AS "Price Change in 7 Days (%)",

coin.value:price_change_percentage_24h_in_currency::number AS "Price Change in 24 Hours (%)",

coin.value:price_change_percentage_14d_in_currency::number AS "Price Change in 14 Days (%)"

FROM (

SELECT livequery.live.udf_api(

'https://api.coingecko.com/api/v3/coins/markets?vs_currency=usd&category=gaming&order=market_cap_desc&per_page=100&page=1&price_change_percentage=7d,24h,14d'

) AS coin_data

),

LATERAL FLATTEN(input => coin_data:data) coin

),

image_data AS (

SELECT

coin.value:id::string AS "Coin ID",

coin.value:image::string AS "Image URL"

FROM (