livequery.live.udf_api(

'https://dlmm-api.meteora.ag/pair/3msVd34R5KxonDzyNSV5nT19UtUeJ2RF1NaQhvVPNLxL/analytic/pair_trade_volume?num_of_days=20'

) AS resp

flattened.value:day_date::DATE AS date,

flattened.value:trade_volume::DECIMAL(18, 4) AS trade_volume,

flattened.value:fee_volume::DECIMAL(18, 4) AS fee_volume

raw_data,

LATERAL FLATTEN(input => PARSE_JSON(RESP):data) AS flattened;