Query editor
WITH baset AS (SELECTDATE_TRUNC('day', FROM_UNIXTIME(CAST(json_array_get(item, 0) AS double))) AS date,TRY_CAST(json_array_get(item, 2) AS DOUBLE) AS Canonically_Bridged,TRY_CAST(json_array_get(item, 3) AS DOUBLE) AS Externally_Bridged,TRY_CAST(json_array_get(item, 4) AS DOUBLE) AS Natively_MintedFROMUNNEST (TRY_CAST(JSON_EXTRACT(HTTP_GET('https://l2beat.com/api/scaling/tvs/ink'),'$.data.chart.data') AS ARRAY(JSON))) AS t(item)WHERE DATE_FORMAT(FROM_UNIXTIME(CAST(json_array_get(item, 0) AS double)), '%H:%i:%s') = '00:00:00')SELECTdate,Natively_Minted,Canonically_Bridged,Externally_Bridged,Natively_Minted + Canonically_Bridged + Externally_Bridged as total_tvsFROM basetORDER BY 1 DESC