By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();
| version() |
|---|
| 8.0.36 |
create table timeseries (id int, object_id int, datetime datetime, sensor1 float default NULL, sensor2 float default NULL);
insert into timeseries values
(1,175,'2022-03-24 22:01:00',0,0),
(2,175,'2022-03-24 22:02:00',0,0),
(3,175,'2022-03-24 22:03:00',5.5699381666667,81.342836833333),
(4,175,'2022-03-24 22:04:00',75.5668366666667,81.281143),
(5,175,'2022-03-24 22:05:00',5.5615361666667,81.152333333333),
(6,175,'2022-03-24 22:06:00',125.5579035,81.014411166667),
(7,175,'2022-03-24 22:07:00',5.55437,80.871362333333),
(8,175,'2022-03-24 22:08:00',0,0),
(9,175,'2022-03-24 22:09:00',5.5494958333333,80.573867833333),
(10,175,'2022-03-24 22:10:00',5.5588905,80.429978833333),
(11,175,'2022-03-24 22:11:00',135.5732071666667,80.2856845),
(12,175,'2022-03-24 22:12:00',5.6017723333333,80.156250833333),
(13,175,'2022-03-24 22:13:00',5.5661683333333,81.265731166667),
(14,175,'2022-03-24 22:14:00',5.560905,81.1317425),
(15,175,'2022-03-24 22:15:00',5.5569496666667,80.9890755),
(16,175,'2022-03-24 22:16:00',5.5539518333333,80.840372166667),
(17,175,'2022-03-24 22:17:00',5.5490508333333,80.695212833333),
(18,175,'2022-03-24 22:18:00',25.5504593333333,80.541868333333),
(19,175,'2022-03-24 22:19:00',5.5630041666667,80.387255666667),
(20,175,'2022-03-24 22:20:00',5.5828961666667,80.238450333333),
(21,175,'2022-03-24 22:21:00',45.5699381666667,81.342836833333),
(22,175,'2022-03-24 22:22:00',5.562909,81.198894666667),
(23,175,'2022-03-24 22:23:00',5.5592885,81.055038833333),
(24,175,'2022-03-24 22:24:00',5.554888,80.907300333333),
(25,175,'2022-03-24 22:25:00',5.5503573333333,80.762887),
(26,175,'2022-03-24 22:26:00',5.5493505,80.610970666667),
(27,175,'2022-03-24 22:27:00',5.556367,80.4566535),
(28,175,'2022-03-24 22:28:00',5.5706435,80.307021),
(29,175,'2022-03-24 22:29:00',5.6005653333333,80.161287666667),
(30,175,'2022-03-24 22:30:00',5.5659011666667,81.260597333333),
(31,175,'2022-03-24 22:31:00',5.5606363333333,81.1162645),
(32,175,'2022-03-24 22:32:00',5.5564683333333,80.973753),
(33,175,'2022-03-24 22:33:00',5.5536733333333,80.824821),
(34,175,'2022-03-24 22:34:00',55.5490416666667,80.679457833333),
Records: 142 Duplicates: 0 Warnings: 0
-- QUERY:1 - find starttime and endtime for sensor 1 where value IS NOT NULL
SELECT datetime, sensor1, sensor2
FROM timeseries
where datetime between '2021-01-20 22:01:00' and '2024-01-20 00:17:00'
| datetime | sensor1 | sensor2 |
|---|---|---|
| 2022-03-24 22:01:00 | 0 | 0 |
| 2022-03-24 22:02:00 | 0 | 0 |
| 2022-03-24 22:03:00 | 5.56994 | 81.3428 |
| 2022-03-24 22:04:00 | 75.5668 | 81.2811 |
| 2022-03-24 22:05:00 | 5.56154 | 81.1523 |
| 2022-03-24 22:06:00 | 125.558 | 81.0144 |
| 2022-03-24 22:07:00 | 5.55437 | 80.8714 |
| 2022-03-24 22:08:00 | 0 | 0 |
| 2022-03-24 22:09:00 | 5.5495 | 80.5739 |
| 2022-03-24 22:10:00 | 5.55889 | 80.43 |
| 2022-03-24 22:11:00 | 135.573 | 80.2857 |
| 2022-03-24 22:12:00 | 5.60177 | 80.1562 |
| 2022-03-24 22:13:00 | 5.56617 | 81.2657 |
| 2022-03-24 22:14:00 | 5.5609 | 81.1317 |
| 2022-03-24 22:15:00 | 5.55695 | 80.9891 |
| 2022-03-24 22:16:00 | 5.55395 | 80.8404 |
| 2022-03-24 22:17:00 | 5.54905 | 80.6952 |
| 2022-03-24 22:18:00 | 25.5505 | 80.5419 |
| 2022-03-24 22:19:00 | 5.563 | 80.3873 |
| 2022-03-24 22:20:00 | 5.5829 | 80.2384 |
| 2022-03-24 22:21:00 | 45.5699 | 81.3428 |
| 2022-03-24 22:22:00 | 5.56291 | 81.1989 |
| 2022-03-24 22:23:00 | 5.55929 | 81.055 |
| 2022-03-24 22:24:00 | 5.55489 | 80.9073 |
| 2022-03-24 22:25:00 | 5.55036 | 80.7629 |
| 2022-03-24 22:26:00 | 5.54935 | 80.611 |
| 2022-03-24 22:27:00 | 5.55637 | 80.4566 |
| 2022-03-24 22:28:00 | 5.57064 | 80.307 |
| 2022-03-24 22:29:00 | 5.60057 | 80.1613 |
| 2022-03-24 22:30:00 | 5.5659 | 81.2606 |
| 2022-03-24 22:31:00 | 5.56064 | 81.1163 |
| 2022-03-24 22:32:00 | 5.55647 | 80.9738 |
| 2022-03-24 22:33:00 | 5.55367 | 80.8248 |
| 2022-03-24 22:34:00 | 55.549 | 80.6795 |
| 2022-03-24 22:35:00 | 5.55107 | 80.5258 |
| 2022-03-24 22:36:00 | 5.56442 | 80.3712 |
| 2022-03-24 22:37:00 | 5.58645 | 80.2228 |
| 2022-03-24 22:38:00 | 5.5689 | 81.3222 |
| 2022-03-24 22:39:00 | 5.56227 | 81.1782 |
| 2022-03-24 22:40:00 | 5.55861 | 81.0347 |
| 2022-03-24 22:41:00 | 5.5547 | 80.8919 |
| 2022-03-24 22:42:00 | 5.54922 | 80.7516 |
| 2022-03-24 22:43:00 | 5.54942 | 80.5898 |
| 2022-03-24 22:44:00 | 5.55788 | 80.4407 |
| 2022-03-24 22:45:00 | 5.57238 | 80.291 |
| 2022-03-24 22:46:00 | 45.6053 | 80.1411 |
| 2022-03-24 22:47:00 | 5.56508 | 81.2452 |
| 2022-03-24 22:48:00 | null | null |
| 2022-03-24 22:49:00 | 5.55578 | 80.9534 |
| 2022-03-24 22:50:00 | 5.55338 | 80.8041 |
| 2022-03-24 22:51:00 | 5.54915 | 80.6659 |
| 2022-03-24 22:52:00 | 5.55203 | 80.5045 |
| 2022-03-24 22:53:00 | 5.56653 | 80.3498 |
| 2022-03-24 22:54:00 | 5.59117 | 80.2021 |
| 2022-03-24 22:55:00 | 15.5678 | 81.3017 |
| 2022-03-24 22:56:00 | 45.5617 | 81.1575 |
| 2022-03-24 22:57:00 | 5.55774 | 81.0093 |
| 2022-03-24 22:58:00 | 5.5543 | 80.8662 |
| 2022-03-24 22:59:00 | null | null |
| 2022-03-24 23:00:00 | 5.54954 | 80.5632 |
| 2022-03-24 23:01:00 | 65.5609 | 80.4086 |
| 2022-03-24 23:02:00 | 5.57827 | 80.2593 |
| 2022-03-24 23:03:00 | 5.61236 | 80.1109 |
| 2022-03-24 23:04:00 | 5.56362 | 81.2143 |
| 2022-03-24 23:05:00 | 5.55959 | 81.0652 |
| 2022-03-24 23:06:00 | 5.55519 | 80.9227 |
| 2022-03-24 23:07:00 | 85.5516 | 80.7732 |
| 2022-03-24 23:08:00 | 5.54931 | 80.6216 |
| 2022-03-24 23:09:00 | 5.55535 | 80.4673 |
| 2022-03-24 23:10:00 | 5.56957 | 80.3177 |
| 2022-03-24 23:11:00 | 5.59938 | 80.1663 |
| 2022-03-24 23:12:00 | 5.56637 | 81.2709 |
| 2022-03-24 23:13:00 | 85.5607 | 81.1266 |
| 2022-03-24 23:14:00 | 0 | 0 |
| 2022-03-24 23:15:00 | 5.56064 | 81.1163 |
| 2022-03-24 23:16:00 | 5.56043 | 81.0855 |
| 2022-03-24 23:17:00 | 5.55731 | 80.9992 |
| 2022-03-24 23:18:00 | 5.55484 | 80.9022 |
| 2022-03-24 23:19:00 | 95.5493 | 80.7525 |
| 2022-03-24 23:20:00 | 5.54939 | 80.6004 |
| 2022-03-24 23:21:00 | 5.55685 | 80.4513 |
| 2022-03-24 23:22:00 | 5.57173 | 80.2963 |
| 2022-03-24 23:23:00 | 5.60297 | 80.1512 |
| 2022-03-24 23:24:00 | 5.56559 | 81.2555 |
| 2022-03-24 23:25:00 | 125.561 | 81.106 |
| 2022-03-24 23:26:00 | 5.55598 | 80.9636 |
| 2022-03-24 23:27:00 | 5.55364 | 80.8196 |
| 2022-03-24 23:28:00 | 5.54912 | 80.6689 |
| 2022-03-24 23:29:00 | 5.55159 | 80.5152 |
| 2022-03-24 23:30:00 | 5.56552 | 80.3606 |
| 2022-03-24 23:31:00 | 5.58879 | 80.2125 |
| 2022-03-24 23:32:00 | 5.56832 | 81.3119 |
| 2022-03-24 23:33:00 | 5.56194 | 81.1679 |
| 2022-03-24 23:34:00 | 5.55823 | 81.0246 |
| 2022-03-24 23:35:00 | 5.55442 | 80.8765 |
| 2022-03-24 23:36:00 | 0 | 0 |
| 2022-03-24 23:37:00 | 5.5495 | 80.5739 |
| 2022-03-24 23:38:00 | 5.55943 | 80.4246 |
| 2022-03-24 23:39:00 | 5.57598 | 80.2698 |
| 2022-03-24 23:40:00 | 335.609 | 80.126 |
| 2022-03-24 23:41:00 | 5.56408 | 81.2246 |
| 2022-03-24 23:42:00 | 5.56037 | 81.0805 |
| 2022-03-24 23:43:00 | 5.55548 | 80.9381 |
| 2022-03-24 23:44:00 | 5.55308 | 80.7886 |
| 2022-03-24 23:45:00 | 65.5492 | 80.6374 |
| 2022-03-24 23:46:00 | 5.55387 | 80.4832 |
| 2022-03-24 23:47:00 | 5.56812 | 80.3338 |
| 2022-03-24 23:48:00 | 5.59587 | 80.1816 |
| 2022-03-24 23:49:00 | 5.56716 | 81.2863 |
| 2022-03-24 23:50:00 | 5.56109 | 81.1369 |
| 2022-03-24 23:51:00 | 5.5571 | 80.9942 |
| 2022-03-24 23:52:00 | 85.5541 | 80.8507 |
| 2022-03-24 23:53:00 | 95.549 | 80.7004 |
| 2022-03-24 23:54:00 | 5.55028 | 80.5472 |
| 2022-03-24 23:55:00 | 5.56246 | 80.3926 |
| 2022-03-24 23:56:00 | 15.5817 | 80.2437 |
| 2022-03-24 23:57:00 | 15.5699 | 81.3428 |
| 2022-03-24 23:58:00 | 15.5629 | 81.1989 |
| 2022-03-24 23:59:00 | 15.5593 | 81.055 |
| 2022-03-25 00:00:00 | 15.5549 | 80.9073 |
| 2022-03-25 00:01:00 | 25.5504 | 80.7629 |
| 2022-03-25 00:02:00 | 25.5494 | 80.611 |
| 2022-03-25 00:03:00 | 25.5559 | 80.462 |
| 2022-03-25 00:04:00 | 25.5701 | 80.3124 |
| 2022-03-25 00:05:00 | 5.59822 | 80.1714 |
| 2022-03-25 00:06:00 | 5.56716 | 81.2863 |
| 2022-03-25 00:07:00 | 35.5614 | 81.1472 |
| 2022-03-25 00:08:00 | 35.5575 | 81.0043 |
| 2022-03-25 00:09:00 | 5.55414 | 80.8559 |
| 2022-03-25 00:10:00 | 5.54906 | 80.7109 |
| 2022-03-25 00:11:00 | 5.54976 | 80.5579 |
| 2022-03-25 00:12:00 | 5.56089 | 80.4086 |
| 2022-03-25 00:13:00 | 45.5794 | 80.2541 |
| 2022-03-25 00:14:00 | 45.6124 | 80.1109 |
| 2022-03-25 00:15:00 | 5.56334 | 81.2092 |
| 2022-03-25 00:16:00 | 35.5596 | 81.0652 |
| 2022-03-25 00:17:00 | 5.55519 | 80.9227 |
| 2022-03-25 00:18:00 | 55.5515 | 80.7732 |
| 2022-03-25 00:19:00 | 65.5493 | 80.6216 |
| 2022-03-25 00:20:00 | null | null |
| 2022-03-25 00:21:00 | 5.56957 | 80.3177 |
| 2022-03-25 00:22:00 | 5.59938 | 80.1663 |
SELECT json_arrayagg(obj) as RESULT FROM ( SELECT
json_object(
"timeseriesdata", json_arrayagg(json_array(
UNIX_TIMESTAMP(datetime)*1000,
sensor1
))
) AS obj
FROM
timeseries
where datetime between '2021-01-20 22:01:00' and '2024-01-20 00:17:00'
UNION ALL
SELECT
json_object(
"timeseriesdata", json_arrayagg(json_array(
UNIX_TIMESTAMP(datetime)*1000,
sensor2
))
) AS obj
FROM
timeseries
where datetime between '2021-01-20 22:01:00' and '2024-01-20 00:17:00'
) x
| RESULT |
|---|
| [{"timeseriesdata": [[1648159260000, 0.0], [1648159320000, 0.0], [1648159380000, 5.5699381828308105], [1648159440000, 75.56683349609375], [1648159500000, 5.5615363121032715], [1648159560000, 125.55790710449219], [1648159620000, 5.554369926452637], [1648159680000, 0.0], [1648159740000, 5.549495697021484], [1648159800000, 5.558890342712402], [1648159860000, 135.57321166992188], [1648159920000, 5.601772308349609], [1648159980000, 5.566168308258057], [1648160040000, 5.5609049797058105], [1648160100000, 5.556949615478516], [1648160160000, 5.553951740264893], [1648160220000, 5.549050807952881], [1648160280000, 25.550458908081055], [1648160340000, 5.563004016876221], [1648160400000, 5.5828962326049805], [1648160460000, 45.56993865966797], [1648160520000, 5.562909126281738], [1648160580000, 5.559288501739502], [1648160640000, 5.554887771606445], [1648160700000, 5.550357341766357], [1648160760000, 5.549350261688232], [1648160820000, 5.556366920471191], [1648160880000, 5.570643424987793], [1648160940000, 5.600565433502197], [1648161000000, 5.565901279449463], [1648161060000, 5.560636520385742], [1648161120000, 5.556468486785889], [1648161180000, 5.553673267364502], [1648161240000, 55.549041748046875], [1648161300000, 5.551068305969238], [1648161360000, 5.5644211769104], [1648161420000, 5.586449146270752], [1648161480000, 5.568903923034668], [1648161540000, 5.562273025512695], [1648161600000, 5.558610916137695], [1648161660000, 5.554698467254639], [1648161720000, 5.54921817779541], [1648161780000, 5.549418926239014], [1648161840000, 5.557878017425537], [1648161900000, 5.572375297546387], [1648161960000, 45.60530090332031], [1648162020000, 5.565082550048828], [1648162080000, null], [1648162140000, 5.555783271789551], [1648162200000, 5.553380966186523], [1648162260000, 5.549147605895996], [1648162320000, 5.552025318145752], [1648162380000, 5.566531658172607], [1648162440000, 5.591169357299805], [1648162500000, 15.567809104919434], [1648162560000, 45.561702728271484], [1648162620000, 5.557740688323975], [1648162680000, 5.5542988777160645], [1648162740000, null], [1648162800000, 5.549540996551514], [1648162860000, 65.5608901977539], [1648162920000, 5.578272342681885], [1648162980000, 5.612355709075928], [1648163040000, 5.5636186599731445], [1648163100000, 5.559593200683594], [1648163160000, 5.555187225341797], [1648163220000, 85.55155181884766], [1648163280000, 5.549312114715576], [1648163340000, 5.5553507804870605], [1648163400000, 5.569574356079102], [1648163460000, 5.5993804931640625], [1648163520000, 5.566373825073242], [1648163580000, 85.56074523925781], [1648163640000, 0.0], [1648163700000, 5.560636520385742], [1648163760000, 5.560427188873291], [1648163820000, 5.557307720184326], [1648163880000, 5.554842472076416], [1648163940000, 95.54927825927734], [1648164000000, 5.5493903160095215], [1648164060000, 5.556851863861084], [1648164120000, 5.571727275848389], [1648164180000, 5.602972030639648], [1648164240000, 5.565587043762207], [1648164300000, 125.56060028076172], [1648164360000, 5.555981159210205], [1648164420000, 5.553638458251953], [1648164480000, 5.549121379852295], [1648164540000, 5.551589012145996], [1648164600000, 5.565524578094482], [1648164660000, 5.5887885093688965], [1648164720000, 5.568319320678711], [1648164780000, 5.561939716339111], [1648164840000, 5.558227062225342], [1648164900000, 5.554418563842773], [1648164960000, 0.0], [1648165020000, 5.549495697021484], [1648165080000, 5.559430122375488], [1648165140000, 5.575981616973877], [1648165200000, 335.6087951660156], [1648165260000, 5.564082622528076], [1648165320000, 5.560367107391357], [1648165380000, 5.555480003356934], [1648165440000, 5.5530805587768555], [1648165500000, 65.5492172241211], [1648165560000, 5.553867816925049], [1648165620000, 5.568118572235107], [1648165680000, 5.595866680145264], [1648165740000, 5.567162990570068], [1648165800000, 5.561091423034668], [1648165860000, 5.557097434997559], [1648165920000, 85.55411529541016], [1648165980000, 95.5490493774414], [1648166040000, 5.550278663635254], [1648166100000, 5.562458038330078], [1648166160000, 15.581743240356445], [1648166220000, 15.569937705993652], [1648166280000, 15.562909126281738], [1648166340000, 15.559288024902344], [1648166400000, 15.554887771606445], [1648166460000, 25.550357818603516], [1648166520000, 25.54935073852539], [1648166580000, 25.55586814880371], [1648166640000, 25.570077896118164], [1648166700000, 5.5982208251953125], [1648166760000, 5.567162990570068], [1648166820000, 35.56136703491211], [1648166880000, 35.55754089355469], [1648166940000, 5.554141521453857], [1648167000000, 5.549057483673096], [1648167060000, 5.549756050109863], [1648167120000, 5.560891151428223], [1648167180000, 45.57941436767578], [1648167240000, 45.61235427856445], [1648167300000, 5.563343048095703], [1648167360000, 35.559593200683594], [1648167420000, 5.555187225341797], [1648167480000, 55.55154800415039], [1648167540000, 65.54930877685547], [1648167600000, null], [1648167660000, 5.569574356079102], [1648167720000, 5.5993804931640625]]}, {"timeseriesdata": [[1648159260000, 0.0], [1648159320000, 0.0], [1648159380000, 81.34283447265625], [1648159440000, 81.28114318847656], [1648159500000, 81.15233612060547], [1648159560000, 81.01441192626953], [1648159620000, 80.8713607788086], [1648159680000, 0.0], [1648159740000, 80.57386779785156], [1648159800000, 80.42997741699219], [1648159860000, 80.28568267822266], [1648159920000, 80.15625], [1648159980000, 81.26573181152344], [1648160040000, 81.13174438476562], [1648160100000, 80.98907470703125], [1648160160000, 80.84037017822266], [1648160220000, 80.6952133178711], [1648160280000, 80.5418701171875], [1648160340000, 80.38725280761719], [1648160400000, 80.23844909667969], [1648160460000, 81.34283447265625], [1648160520000, 81.19889831542969], [1648160580000, 81.05503845214844], [1648160640000, 80.90730285644531], [1648160700000, 80.76288604736328], [1648160760000, 80.61096954345703], [1648160820000, 80.45664978027344], [1648160880000, 80.30702209472656], [1648160940000, 80.16128540039062], [1648161000000, 81.2605972290039], [1648161060000, 81.11626434326172], [1648161120000, 80.9737548828125], [1648161180000, 80.82482147216797], [1648161240000, 80.67945861816406], [1648161300000, 80.52584075927734], [1648161360000, 80.37116241455078], [1648161420000, 80.22283172607422], [1648161480000, 81.32219696044922], [1648161540000, 81.17823028564453], [1648161600000, 81.03472900390625], [1648161660000, 80.89190673828125], [1648161720000, 80.75159454345703], [1648161780000, 80.58979034423828], [1648161840000, 80.44065856933594], [1648161900000, 80.29100036621094], [1648161960000, 80.14114379882812], [1648162020000, 81.24517822265625], [1648162080000, null], [1648162140000, 80.95341491699219], [1648162200000, 80.80411529541016], [1648162260000, 80.6659164428711], [1648162320000, 80.50447845458984], [1648162380000, 80.34982299804688], [1648162440000, 80.2021255493164], [1648162500000, 81.30165100097656], [1648162560000, 81.15748596191406], [1648162620000, 81.00934600830078], [1648162680000, 80.8662109375], [1648162740000, null], [1648162800000, 80.563232421875], [1648162860000, 80.40860748291016], [1648162920000, 80.25933074951172], [1648162980000, 80.1108627319336], [1648163040000, 81.21432495117188], [1648163100000, 81.06523132324219], [1648163160000, 80.92269134521484], [1648163220000, 80.773193359375], [1648163280000, 80.62155151367188], [1648163340000, 80.46729278564453], [1648163400000, 80.31773376464844], [1648163460000, 80.16633605957031], [1648163520000, 81.2708740234375], [1648163580000, 81.1265869140625], [1648163640000, 0.0], [1648163700000, 81.11626434326172], [1648163760000, 81.08554077148438], [1648163820000, 80.99922180175781], [1648163880000, 80.90216064453125], [1648163940000, 80.75254821777344], [1648164000000, 80.60038757324219], [1648164060000, 80.45132446289062], [1648164120000, 80.29632568359375], [1648164180000, 80.15121459960938], [1648164240000, 81.25546264648438], [1648164300000, 81.10596466064453], [1648164360000, 80.96360778808594], [1648164420000, 80.81963348388672], [1648164480000, 80.66890716552734], [1648164540000, 80.51515197753906], [1648164600000, 80.36058044433594], [1648164660000, 80.21247100830078], [1648164720000, 81.31192016601562], [1648164780000, 81.16789245605469], [1648164840000, 81.02457427978516], [1648164900000, 80.87651062011719], [1648164960000, 0.0], [1648165020000, 80.57386779785156], [1648165080000, 80.42464447021484], [1648165140000, 80.26981353759766], [1648165200000, 80.12603759765625], [1648165260000, 81.224609375], [1648165320000, 81.08045196533203], [1648165380000, 80.93806457519531], [1648165440000, 80.78860473632812], [1648165500000, 80.63742065429688], [1648165560000, 80.48320770263672], [1648165620000, 80.33379364013672], [1648165680000, 80.18156433105469], [1648165740000, 81.28626251220703], [1648165800000, 81.13689422607422], [1648165860000, 80.99415588378906], [1648165920000, 80.85072326660156], [1648165980000, 80.70044708251953], [1648166040000, 80.54721069335938], [1648166100000, 80.39259338378906], [1648166160000, 80.24366760253906], [1648166220000, 81.34283447265625], [1648166280000, 81.19889831542969], [1648166340000, 81.05503845214844], [1648166400000, 80.90730285644531], [1648166460000, 80.76288604736328], [1648166520000, 80.61096954345703], [1648166580000, 80.46197509765625], [1648166640000, 80.3123779296875], [1648166700000, 80.17139434814453], [1648166760000, 81.28626251220703], [1648166820000, 81.14718627929688], [1648166880000, 81.00428771972656], [1648166940000, 80.85589599609375], [1648167000000, 80.71088409423828], [1648167060000, 80.55789947509766], [1648167120000, 80.40860748291016], [1648167180000, 80.25410461425781], [1648167240000, 80.1108627319336], [1648167300000, 81.20918273925781], [1648167360000, 81.06523132324219], [1648167420000, 80.92269134521484], [1648167480000, 80.773193359375], [1648167540000, 80.62155151367188], [1648167600000, null], [1648167660000, 80.31773376464844], [1648167720000, 80.16633605957031]]}] |
Query was empty