Query editor
WITH RecentEntry AS (SELECT"Date","Epoch",SPLIT("data", ',') AS split_dataFROM dune.xnet.dataset_xnet_dataORDER BY"Date" DESC)SELECT*FROM RecentEntryCROSS JOIN UNNEST(RecentEntry.split_data) AS t(data_item)
Query editor
1WITH RecentEntry AS (2SELECT3"Date",4"Epoch",5SPLIT("data", ',') AS split_data6FROM dune.xnet.dataset_xnet_data7ORDER BY8"Date" DESC9)10SELECT11*12FROM RecentEntry13CROSS JOIN UNNEST(RecentEntry.split_data) AS t(data_item)