SELECT TO_TIMESTAMP(value[0]::string) as date,

value[1] as trading_volume_usd

FROM (

SELECT livequery.live.udf_api(

'https://api.coingecko.com/api/v3/coins/klay-token/market_chart?vs_currency=usd&days=120&interval=daily&precision=3') as response

),LATERAL FLATTEN (input => response:data:total_volumes)

WHERE date < current_date

ORDER BY date DESC