select live.udf_api('https://api-mainnet.magiceden.dev/v3/rtp/ethereum/collections/v7?id=0xde76ad8998310dd4c6ca9fdb03a5f20bbf01ce96&includeMintStages=false&includeSecurityConfigs=false&normalizeRoyalties=false&useNonFlaggedFloorAsk=false&sortBy=allTimeVolume&limit=20') as resp

select resp:data:collections[0]:floorAsk:price:amount:native as Floor

, resp:data:collections[0]:onSaleCount::float as on_sale

from api_table