Count Number of Raindays in Month

Drake · August 31, 2021, 8:04am

Hello together,
i have a Measurement called “dailyrain” in my influxDB. In this measurement, the daily amount of rain is logged.

In this example we can see two rain days between 2021-07-26 and 2021-07-28.

> SELECT value from "sainlogic.0.weather.current.dailyrain" WHERE time>='2021-07-26' and time<'2021-07-28'
name: sainlogic.0.weather.current.dailyrain
time                value
----                -----
1627278548198000000 0
1627278779148000000 0
1627278788316000000 0
1627331586887000000 0
1627331746923000000 0.2
1627336706775000000 0.2
1627336866790000000 0
1627354787516000000 0
1627354946390000000 0.3
1627423104735000000 0.3
1627423265564000000 0

Now I want to create a Query that shows me the number of Rain Days in a defined time range.
I don’t want to see how much it has rained in summary, I just want to see on how many days it has rained

A rainy day starts from a value of 0.1

The output should then look like this for the defined time period

name: sainlogic.0.weather.current.dailyrain
value
----         
2

I know I must work with in this case with a Subquery, but I don’t know how to realize this because my knowledge about DB queries is very limited.
I hope you can help me.

Anaisdg · August 31, 2021, 3:13pm

Hello @Drake,
Welcome!

SELECT count("value") AS "rainy days" from "sainlogic.0.weather.current.dailyrain" WHERE time>='2021-07-26' and time<'2021-07-28' and "value" >= 0.1"  GROUP BY time(24h).

You don’t need subqueries the above should work.

Drake · August 31, 2021, 5:04pm

Hello @Anaisdg thank you for the Query. It is working fine

I have now tried to create the query for one month.
For me it looks like it would add up all the values.

SELECT count(value) AS rainydays from "sainlogic.0.weather.current.dailyrain" WHERE time>='2021-07-01' and time<'2021-07-31' and value >=0.1 GROUP BY time(30d)
name: sainlogic.0.weather.current.dailyrain
time                rainydays
----                ---------
1622592000000000000 0
1625184000000000000 289

The values of the rain sensor are always set to zero at midnight and then the count starts by 0 for the next rainy day.
Is it possible to integrate this into the queryProcessing: dailyrain_month.txt…

I can not attach some files because I´m a new User

But I want to share with you the values from one month rain sessions:

> SELECT value from "sainlogic.0.weather.current.dailyrain" WHERE time>='2021-07-01' and time<'2021-07-31'
name: sainlogic.0.weather.current.dailyrain
time                value
----                -----
1625861332770000000 14.8
1625867988587000000 14.8
1625868148551000000 0
1625995649695000000 0
1625995826146000000 0
1625995831670000000 0
1625998545566000000 0
1625998705573000000 0.2
1625999825571000000 0.2
1625999985554000000 0.5
1626000465499000000 0.5
1626000625499000000 0.7
1626000786718000000 0.7
1626000945533000000 1
1626001105490000000 1
1626001265951000000 1.2
1626001585476000000 1.2
1626001745475000000 1.5
1626001905471000000 1.5
1626002065514000000 1.8
1626002369503000000 1.8
1626002529501000000 2
1626002849462000000 2
1626003009497000000 2.3
1626003809476000000 2.3
1626003969456000000 2.5
1626004449449000000 2.5
1626004609451000000 2.8
1626004769425000000 2.8
1626004929418000000 3
1626005249484000000 3
1626005409474000000 3.3
1626005889473000000 3.3
1626006049434000000 3.5
1626006369474000000 3.5
1626006529420000000 3.8
1626006849414000000 3.8
1626007009436000000 4
1626007329353000000 4
1626007489374000000 4.3
1626007649351000000 4.3
1626007809373000000 4.5
1626007969342000000 4.8
1626008129375000000 5.1
1626008929383000000 5.1
1626009089365000000 5.3
1626024288956000000 5.3
1626024471027000000 5.3
1626024477789000000 5.3
1626026449926000000 5.3
1626026464342000000 5.3
1626040704619000000 5.3
1626040864560000000 0
1626195852978000000 0
1626196012974000000 0.8
1626196171061000000 1.8
1626196332949000000 3.3
1626196492955000000 5.1
1626196651070000000 6.4
1626196812953000000 7.6
1626196972964000000 8.4
1626197131067000000 9.2
1626197292932000000 9.7
1626197452984000000 9.7
1626197611074000000 10.2
1626197774114000000 10.4
1626198732918000000 10.4
1626198892905000000 10.7
1626213451034000000 10.7
1626213612577000000 0
1626229612254000000 0
1626229771989000000 0.2
1626231052233000000 0.2
1626231214677000000 0.5
1626234892125000000 0.5
1626235052062000000 0.7
1626284010949000000 0.7
1626284170916000000 1
1626284490932000000 1
1626284651736000000 1.2
1626285130882000000 1.2
1626285290918000000 1.5
1626288010829000000 1.5
1626288170872000000 1.8
1626291531582000000 1.8
1626291690756000000 2.3
1626291850746000000 2.5
1626292012055000000 2.8
1626292170745000000 3.3
1626292330753000000 3.5
1626292810733000000 3.5
1626292970755000000 4.6
1626293130741000000 6.8
1626293290736000000 9.6
1626293450737000000 10.6
1626293610733000000 11.4
1626293770713000000 11.9
1626293930745000000 12.4
1626294090695000000 12.7
1626294250743000000 12.9
1626294410744000000 13.4
1626294570709000000 13.9
1626294730706000000 14.2
1626294890733000000 15
1626295051885000000 15.2
1626295211063000000 15.5
1626295370686000000 16
1626295850648000000 16
1626296010684000000 16.2
1626299850569000000 16.2
1626300010583000000 0
1626325146084000000 0
1626325255070000000 0
1626325291786000000 0
1626354105351000000 0
1626354254305000000 0
1626354265411000000 0
1626360985951000000 0
1626361145161000000 0.3
1626361226616000000 0.5
1626361385182000000 2.3
1626361545202000000 4.6
1626361696142000000 5.6
1626361849205000000 6.6
1626362009157000000 7.9
1626362169156000000 9.9
1626362329204000000 11.2
1626362489172000000 12.5
1626362649139000000 13.8
1626362809170000000 14.3
1626363289150000000 14.3
1626363449152000000 14.8
1626386328608000000 14.8
1626386488653000000 0
1626414024021000000 0
1626414202842000000 0
1626414212510000000 0
1626464566821000000 0
1626464726824000000 0.2
1626466326769000000 0.2
1626466486808000000 0.5
1626468726678000000 0.5
1626468876418000000 0.5
1626468886743000000 0.5
1626472726559000000 0.5
1626472886662000000 0
1626530485205000000 0
1626530645203000000 0.5
1626530805198000000 1
1626530965175000000 1.5
1626531125193000000 1.5
1626531285199000000 1.8
1626531445908000000 1.8
1626531605153000000 2.3
1626531765175000000 2.5
1626531925175000000 3
1626532085170000000 3
1626532245148000000 3.3
1626532405242000000 3.5
1626533205138000000 3.5
1626533365143000000 3.8
1626533525103000000 3.8
1626533685128000000 4.3
1626533845127000000 4.5
1626534005128000000 4.5
1626534165152000000 4.8
1626534325163000000 4.8
1626534486723000000 5.1
1626534805076000000 5.1
1626534965113000000 5.3
1626535605093000000 5.3
1626535765084000000 5.6
1626535925086000000 5.8
1626536085047000000 6.3
1626538004998000000 6.3
1626538165029000000 6.8
1626538325029000000 8.1
1626538485018000000 8.9
1626538644991000000 9.9
1626538805014000000 10.1
1626538965004000000 10.1
1626539125001000000 10.4
1626539284980000000 10.9
1626539445000000000 11.4
1626539604990000000 11.9
1626539924970000000 11.9
1626540084983000000 12.2
1626540244985000000 12.4
1626540404984000000 12.4
1626540566842000000 12.7
1626541044963000000 12.7
1626541204933000000 12.9
1626541364955000000 12.9
1626541524947000000 13.4
1626542164935000000 13.4
1626542324935000000 13.7
1626542484901000000 13.7
1626542644928000000 13.9
1626542804914000000 13.9
1626542964914000000 14.2
1626543284914000000 14.2
1626543444914000000 14.5
1626543606108000000 14.5
1626543764869000000 14.7
1626543924893000000 15.5
1626544084901000000 16
1626544244881000000 16
1626544404875000000 16.2
1626559124524000000 16.2
1626559284537000000 0
1626561524533000000 0
1626561684463000000 0.3
1626562964457000000 0.3
1626563124435000000 0.5
1626563284461000000 0.8
1626566484366000000 0.8
1626566644395000000 1
1626567124364000000 1
1626567284343000000 1.3
1626567444329000000 1.6
1626567604395000000 1.8
1626567764324000000 2.1
1626567925524000000 2.3
1626568084323000000 2.6
1626568244349000000 2.8
1626568404349000000 2.8
1626568564334000000 3.1
1626568884317000000 3.1
1626569044329000000 3.3
1626569204345000000 3.6
1626569364296000000 3.6
1626569524362000000 3.8
1626569844299000000 3.8
1626570004245000000 4.1
1626570164300000000 4.3
1626570324323000000 4.3
1626570484285000000 4.6
1626571124254000000 4.6
1626571284242000000 4.9
1626571604312000000 4.9
1626571764249000000 5.1
1626571924224000000 5.1
1626572084243000000 5.4
1626572244243000000 5.6
1626573044232000000 5.6
1626573204182000000 5.9
1626577044107000000 5.9
1626577204116000000 6.1
1626615923180000000 6.1
1626622029025000000 6.1
1626622035076000000 6.1
1626645474429000000 6.1
1626645630838000000 0
1627210549847000000 0
1627210709795000000 0.3
1627250388807000000 0.3
1627250548830000000 0
1627278548198000000 0
1627278779148000000 0
1627278788316000000 0
1627331586887000000 0
1627331746923000000 0.2
1627336706775000000 0.2
1627336866790000000 0
1627354787516000000 0
1627354946390000000 0.3
1627423104735000000 0.3
1627423265564000000 0
1627438784432000000 0
1627438944386000000 0.2
1627439264393000000 0.2
1627439424387000000 0.5
1627465023804000000 0.5
1627465183782000000 0.8
1627465983758000000 0.8
1627466143785000000 1
1627471903641000000 1
1627472063643000000 1.3
1627472544223000000 1.3
1627472703603000000 1.5
1627473663555000000 1.5
1627473823570000000 5.3
1627473983594000000 7.6
1627474143599000000 8.6
1627474303543000000 9.1
1627474463594000000 9.9
1627474623585000000 11.4
1627474783574000000 11.9
1627474943539000000 12.2
1627475103569000000 12.7
1627475263542000000 13.2
1627475423550000000 13.2
1627475584699000000 13.5
1627475743523000000 13.7
1627475903541000000 13.7
1627476063540000000 14
1627478943479000000 14
1627479103471000000 14.2
1627479743512000000 14.2
1627479903428000000 14.5
1627486303282000000 14.5
1627486463245000000 14.7
1627509502807000000 14.7
1627509662796000000 0
1627676325582000000 0
1627676345385000000 0
1627677434948000000 0
1627677594925000000 0.3
1627677752041000000 0.3
1627677914956000000 0.5
1627678074909000000 0.8
1627678231998000000 1
1627678394950000000 1.5
1627678554895000000 2.1
1627678712004000000 2.3
1627678874923000000 2.8
1627679034877000000 3.3
1627679192002000000 3.6
1627679354870000000 4.3
1627679515853000000 4.6
1627679672072000000 4.8
1627679834886000000 5.4
1627679994853000000 5.6
1627680152021000000 6.1
1627680314878000000 6.4
1627680474865000000 6.6
1627680632062000000 6.9
1627680794858000000 6.9
1627680954870000000 7.1
1627682394892000000 7.1
1627682553268000000 0

Anaisdg · August 31, 2021, 5:20pm

Hello @Drake,
SELECT sum(“rainy days”) AS “rainy days in month” FROM (SLECT SELECT count(value) AS rainydays from “sainlogic.0.weather.current.dailyrain” WHERE time>=‘2021-07-01’ and time<‘2021-07-31’ and value >=0.1 GROUP BY time(24d))

To add up all the values

Drake · August 31, 2021, 8:19pm

Hello @Anaisdg sorry for asking again but it doesn’t work.

If I try this Query

SELECT sum(rainydays) AS "rainydaysinmonth" FROM (SELECT count(value) AS "rainydays" from “sainlogic.0.weather.current.dailyrain” WHERE time>=‘2021-07-01’ and time<‘2021-07-31’ and value >=0.1 GROUP BY time(24d))

I get the following ERR: ERR: error parsing query: found “, expected identifier at line 1, char 91

It looks like the " is no longer accepted with this new query

philb · September 1, 2021, 10:46am

Hello,

It looks like some of your double and single quotes aren’t formatted correctly

If you copied the query from this topic I’d suggest replacing the double and single quotes. If i put that query in an IDE the error starts after the from section of your query

Drake · September 1, 2021, 5:15pm

Hello,

yes I found the problem.
Now the Query is working, but I get the amount from all values during the month now.

SELECT sum(raindays) AS raindaysmonth FROM (SELECT count(value) AS raindays from "sainlogic.0.weather.current.dailyrain" WHERE time>='2021-07-01' and time<'2021-07-31'and value>=0.1 GROUP by time(24d))
name: sainlogic.0.weather.current.dailyrain
time raindaysmonth
---- -------------
0    289

I want to have only the amount of the days were we have had rain in the month, in this case it should be about 12 Rain Days in this month.
This is what i write in my third post.

Anaisdg · September 1, 2021, 8:47pm

Hello @Drake,
You should count() instead of sum()

Drake · September 19, 2021, 7:32pm

Hello all,
Unfortunately, I have not yet made much progress with this topic.
I am considering a different approach.

I have a measurement data table in which only the days on which it rained are stored.

Now I would like to count the number of days in the table.
How can I count the days in this table for time range 2021-08-01 - 201-08-31

SELECT value FROM "sainlogic.0.weather.current.dailyrain" WHERE time>='2021-08-01' and time<'2021-08-31'
name: sainlogic.0.weather.current.dailyrain
time                     value
----                     -----
2021-08-01T01:33:12.544Z 0
2021-08-01T01:35:52.494Z 0.2
2021-08-01T01:38:31.807Z 0.2
2021-08-01T01:41:12.514Z 0.5
2021-08-01T01:43:52.523Z 0.5
2021-08-01T01:46:31.813Z 0.7
2021-08-01T01:49:12.52Z  1.3
2021-08-01T01:51:52.488Z 1.8
2021-08-01T01:54:33.311Z 2
2021-08-01T01:57:12.479Z 2.5
2021-08-01T01:59:52.473Z 3
2021-08-01T02:02:31.727Z 3.3
2021-08-01T02:05:12.504Z 3.5
2021-08-01T02:07:52.43Z  3.8
2021-08-01T02:10:31.741Z 4.3
2021-08-01T02:13:12.459Z 4.6
2021-08-01T02:15:59.467Z 4.8
2021-08-01T02:18:31.802Z 5.3
2021-08-01T02:21:28.546Z 5.8
2021-08-01T02:24:08.455Z 6.3
2021-08-01T02:26:55.722Z 6.6
2021-08-01T02:29:28.429Z 6.6
2021-08-01T02:31:59.63Z  6.8
2021-08-01T02:34:31.756Z 6.8
2021-08-01T02:37:12.425Z 7.1
2021-08-01T02:39:52.396Z 7.1
2021-08-01T02:42:31.721Z 7.4
2021-08-01T02:50:33.114Z 7.4
2021-08-01T02:53:12.432Z 7.6
2021-08-01T02:55:52.43Z  7.6
2021-08-01T02:58:31.743Z 7.9
2021-08-01T03:01:12.428Z 8.1
2021-08-01T03:03:52.393Z 8.6
2021-08-01T03:06:32.461Z 8.9
2021-08-01T03:09:12.404Z 9.1
2021-08-01T03:11:52.377Z 9.1
2021-08-01T03:14:31.738Z 9.4
2021-08-01T03:17:12.378Z 9.6
2021-08-01T03:19:52.394Z 9.6
2021-08-01T03:22:32.922Z 9.9
2021-08-01T03:25:12.388Z 10.1
2021-08-01T03:27:52.393Z 10.1
2021-08-01T03:30:31.728Z 10.4
2021-08-01T03:35:52.354Z 10.4
2021-08-01T03:38:31.746Z 10.7
2021-08-01T03:41:12.367Z 10.9
2021-08-01T03:43:52.331Z 11.2
2021-08-01T03:46:31.741Z 11.7
2021-08-01T03:49:12.346Z 12.2
2021-08-01T03:52:00.822Z 12.4
2021-08-01T03:54:31.753Z 12.9
2021-08-01T03:57:28.446Z 13.2
2021-08-01T04:00:08.303Z 13.4
2021-08-01T04:03:04.42Z  13.7
2021-08-01T04:05:44.356Z 14
2021-08-01T04:08:24.324Z 14.2
2021-08-01T04:11:04.354Z 14.7
2021-08-01T04:13:44.296Z 15.2
2021-08-01T04:16:24.911Z 15.5
2021-08-01T04:19:04.337Z 15.7
2021-08-01T04:21:45.69Z  16.2
2021-08-01T04:24:24.296Z 16.5
2021-08-01T04:27:04.334Z 17
2021-08-01T04:29:44.304Z 17.3
2021-08-01T04:32:24.343Z 17.8
2021-08-01T04:35:04.402Z 18
2021-08-01T04:37:35.013Z 18.3
2021-08-01T04:40:08.351Z 18.5
2021-08-01T04:43:11.293Z 18.8
2021-08-01T04:45:44.258Z 19.3
2021-08-01T04:48:40.372Z 19.5
2021-08-01T04:51:20.26Z  20.1
2021-08-01T04:54:00.276Z 20.3
2021-08-01T04:56:31.705Z 20.6
2021-08-01T04:59:04.275Z 20.8
2021-08-01T05:01:45.082Z 20.8
2021-08-01T05:04:24.269Z 21.1
2021-08-01T05:07:04.229Z 21.3
2021-08-01T05:15:04.217Z 21.3
2021-08-01T05:17:44.616Z 21.6
2021-08-01T05:20:24.236Z 21.8
2021-08-01T05:39:20.171Z 21.8
2021-08-01T05:41:51.662Z 22.1
2021-08-01T05:44:24.201Z 22.1
2021-08-01T05:47:04.227Z 22.3
2021-08-01T05:49:44.185Z 22.3
2021-08-01T05:52:24.198Z 22.6
2021-08-01T05:55:04.202Z 22.8
2021-08-01T05:57:44.202Z 23.1
2021-08-01T06:00:24.194Z 23.4
2021-08-01T06:03:04.241Z 23.9
2021-08-01T06:05:44.175Z 24.4
2021-08-01T06:08:24.217Z 24.9
2021-08-01T06:11:04.149Z 25.4
2021-08-01T06:13:44.174Z 25.6
2021-08-01T06:16:24.164Z 25.9
2021-08-01T06:19:04.147Z 26.1
2021-08-01T06:21:44.153Z 26.9
2021-08-01T06:24:24.144Z 27.2
2021-08-01T06:27:04.143Z 27.7
2021-08-01T06:29:44.181Z 28.2
2021-08-01T06:32:24.138Z 28.4
2021-08-01T06:35:10.891Z 28.4
2021-08-01T06:37:44.125Z 28.7
2021-08-01T06:40:34.33Z  28.7
2021-08-01T06:43:04.099Z 28.9
2021-08-01T06:46:00.221Z 29.7
2021-08-01T06:48:31.743Z 30
2021-08-01T06:51:04.102Z 30.5
2021-08-01T06:53:44.084Z 30.7
2021-08-01T06:56:24.182Z 31
2021-08-01T06:59:04.104Z 31.2
2021-08-01T07:01:44.101Z 31.5
2021-08-01T07:04:24.06Z  31.7
2021-08-01T07:07:04.108Z 32
2021-08-01T07:09:44.297Z 32.2
2021-08-01T07:12:24.075Z 32.5
2021-08-01T07:15:04.051Z 32.5
2021-08-01T07:17:44.071Z 32.8
2021-08-01T07:20:24.086Z 33
2021-08-01T07:23:04.063Z 33.3
2021-08-01T07:25:44.039Z 33.8
2021-08-01T07:28:24.085Z 34
2021-08-01T07:31:04.071Z 34.3
2021-08-01T07:33:44.056Z 34.3
2021-08-01T07:36:24.032Z 34.5
2021-08-01T07:47:04.015Z 34.5
2021-08-01T07:49:44.045Z 34.8
2021-08-01T07:55:04.057Z 34.8
2021-08-01T07:57:44.002Z 35
2021-08-01T08:00:24.095Z 35.3
2021-08-01T08:03:04.168Z 35.3
2021-08-01T08:05:44.028Z 35.5
2021-08-01T08:09:23.561Z 35.5
2021-08-01T08:09:29.946Z 35.5
2021-08-01T08:14:48.087Z 35.5
2021-08-01T08:17:28.033Z 35.8
2021-08-01T09:42:47.96Z  35.8
2021-08-01T09:45:27.925Z 36.1
2021-08-01T21:59:50.903Z 36.1
2021-08-01T22:02:32.251Z 0
2021-08-01T22:08:06.898Z 0
2021-08-01T22:10:46.916Z 0.2
2021-08-02T00:05:26.728Z 0.2
2021-08-02T00:08:06.741Z 0.7
2021-08-02T05:30:30.332Z 0.7
2021-08-02T05:33:10.348Z 1
2021-08-02T12:39:49.713Z 1
2021-08-02T12:42:29.713Z 1.7
2021-08-02T12:45:09.712Z 1.7
2021-08-02T12:47:49.659Z 2
2021-08-02T12:50:29.683Z 2
2021-08-02T12:53:09.684Z 2.7
2021-08-02T17:04:05.354Z 2.7
2021-08-02T17:06:45.294Z 3
2021-08-02T17:12:05.296Z 3
2021-08-02T17:14:45.284Z 3.3
2021-08-02T21:59:49.018Z 3.3
2021-08-02T22:02:28.948Z 0
2021-08-03T22:23:47.044Z 0
2021-08-03T22:26:27.071Z 0.2
2021-08-03T23:17:06.966Z 0.2
2021-08-03T23:19:47.038Z 0.5
2021-08-03T23:41:06.979Z 0.5
2021-08-03T23:43:46.972Z 0.7
2021-08-04T00:34:26.877Z 0.7
2021-08-04T00:37:06.887Z 1
2021-08-04T01:06:26.867Z 1
2021-08-04T01:09:06.869Z 1.2
2021-08-04T03:22:26.7Z   1.2
2021-08-04T03:25:06.694Z 1.5
2021-08-04T03:59:46.697Z 1.5
2021-08-04T04:02:26.648Z 1.7
2021-08-04T04:26:26.574Z 1.7
2021-08-04T04:29:06.6Z   2
2021-08-04T04:37:06.573Z 2
2021-08-04T04:39:46.607Z 2.2
2021-08-04T21:59:29.187Z 2.2
2021-08-04T22:02:10.197Z 0
2021-08-04T22:34:09.063Z 0
2021-08-04T22:36:49.068Z 0.3
2021-08-04T23:06:09.038Z 0.3
2021-08-04T23:08:49.025Z 0.6
2021-08-04T23:14:09.024Z 0.6
2021-08-04T23:16:49.027Z 0.8
2021-08-04T23:22:09.01Z  0.8
2021-08-04T23:24:49.067Z 1.1
2021-08-04T23:32:49.003Z 1.1
2021-08-04T23:35:29.017Z 1.3
2021-08-04T23:46:08.991Z 1.3
2021-08-04T23:48:48.943Z 1.6
2021-08-04T23:56:48.965Z 1.6
2021-08-04T23:59:28.967Z 1.8
2021-08-05T00:04:48.956Z 1.8
2021-08-05T00:07:28.949Z 2.1
2021-08-05T00:10:08.953Z 2.1
2021-08-05T00:12:48.973Z 2.3
2021-08-05T00:20:48.904Z 2.3
2021-08-05T00:23:28.998Z 2.6
2021-08-05T00:28:48.932Z 2.6
2021-08-05T00:31:28.934Z 2.8
2021-08-05T00:36:48.937Z 2.8
2021-08-05T00:39:28.887Z 3.1
2021-08-05T00:44:48.908Z 3.1
2021-08-05T00:47:28.898Z 3.3
2021-08-05T00:55:28.895Z 3.3
2021-08-05T00:58:08.852Z 3.6
2021-08-05T01:06:08.861Z 3.6
2021-08-05T01:08:48.875Z 3.9
2021-08-05T01:14:08.858Z 3.9
2021-08-05T01:16:48.866Z 4.1
2021-08-05T01:22:08.864Z 4.1
2021-08-05T01:24:49.529Z 4.4
2021-08-05T01:32:48.844Z 4.4
2021-08-05T01:35:28.84Z  4.6
2021-08-05T01:54:08.811Z 4.6
2021-08-05T01:56:48.773Z 4.9
2021-08-05T02:18:08.743Z 4.9
2021-08-05T02:20:48.787Z 5.1
2021-08-05T02:31:28.753Z 5.1
2021-08-05T02:34:08.737Z 5.4
2021-08-05T02:42:08.757Z 5.4
2021-08-05T02:44:48.737Z 5.6
2021-08-05T02:52:48.743Z 5.6
2021-08-05T02:55:28.757Z 5.9
2021-08-05T03:06:09.745Z 5.9
2021-08-05T03:08:48.758Z 6.1
2021-08-05T03:16:48.711Z 6.1
2021-08-05T03:19:28.72Z  6.4
2021-08-05T03:22:08.708Z 6.4
2021-08-05T03:24:48.691Z 6.6
2021-08-05T03:27:28.691Z 6.6
2021-08-05T03:30:08.682Z 6.9
2021-08-05T03:35:28.683Z 6.9
2021-08-05T03:38:08.698Z 7.2
2021-08-05T03:40:48.688Z 7.2
2021-08-05T03:43:28.685Z 7.4
2021-08-05T03:48:48.701Z 7.4
2021-08-05T03:51:28.689Z 7.7
2021-08-05T03:54:08.717Z 7.7
2021-08-05T03:56:49.742Z 7.9
2021-08-05T04:04:48.676Z 7.9
2021-08-05T04:07:28.663Z 8.2
2021-08-05T04:12:48.647Z 8.2
2021-08-05T04:15:28.657Z 8.4
2021-08-05T04:20:48.626Z 8.4
2021-08-05T04:23:28.67Z  8.7
2021-08-05T04:31:28.648Z 8.7
2021-08-05T04:34:08.613Z 8.9
2021-08-05T04:44:48.667Z 8.9
2021-08-05T04:47:30.211Z 9.2
2021-08-05T04:55:28.598Z 9.2
2021-08-05T04:58:08.589Z 9.4
2021-08-05T05:00:48.584Z 9.4
2021-08-05T05:03:28.574Z 9.7
2021-08-05T05:08:48.55Z  9.7
2021-08-05T05:11:28.562Z 9.9
2021-08-05T05:14:08.572Z 9.9
2021-08-05T05:16:48.581Z 10.2
2021-08-05T05:19:28.607Z 10.2
2021-08-05T05:22:08.58Z  10.5
2021-08-05T05:24:48.56Z  10.5
2021-08-05T05:27:28.541Z 10.7
2021-08-05T05:30:08.588Z 10.7
2021-08-05T05:32:48.557Z 11
2021-08-05T05:35:28.562Z 11
2021-08-05T05:38:09.968Z 11.2
2021-08-05T05:40:48.525Z 11.5
2021-08-05T05:43:28.534Z 11.5
2021-08-05T05:46:08.57Z  11.7
2021-08-05T05:48:48.526Z 11.7
2021-08-05T05:51:28.568Z 12
2021-08-05T05:54:08.498Z 12.2
2021-08-05T05:56:48.53Z  12.5
2021-08-05T05:59:28.503Z 12.7
2021-08-05T06:02:08.539Z 13
2021-08-05T06:04:48.52Z  13
2021-08-05T06:07:28.526Z 13.3
2021-08-05T06:18:08.512Z 13.3
2021-08-05T06:20:48.453Z 13.5
2021-08-05T06:28:49.32Z  13.5
2021-08-05T06:31:28.474Z 13.8
2021-08-05T06:42:08.457Z 13.8
2021-08-05T06:44:48.465Z 14
2021-08-05T07:30:08.384Z 14
2021-08-05T07:32:48.361Z 14.3
2021-08-05T08:36:48.327Z 14.3
2021-08-05T08:39:28.29Z  14.5
2021-08-05T09:14:08.337Z 14.5
2021-08-05T09:16:48.275Z 14.8
2021-08-05T09:24:48.275Z 14.8
2021-08-05T09:27:28.25Z  15
2021-08-05T09:30:08.292Z 15.3
2021-08-05T09:32:48.358Z 16
2021-08-05T09:35:28.278Z 16.3
2021-08-05T09:38:08.268Z 16.8
2021-08-05T09:40:48.203Z 17.1
2021-08-05T09:43:28.242Z 17.3
2021-08-05T09:46:08.216Z 17.3
2021-08-05T09:48:48.194Z 17.6
2021-08-05T09:51:29.396Z 17.8
2021-08-05T09:54:08.177Z 17.8
2021-08-05T09:56:48.213Z 18.1
2021-08-05T09:59:28.221Z 18.3
2021-08-05T10:02:08.209Z 18.3
2021-08-05T10:04:48.223Z 18.6
2021-08-05T10:07:28.227Z 18.8
2021-08-05T10:23:28.132Z 18.8
2021-08-05T10:26:08.143Z 19.1
2021-08-05T10:42:09.269Z 19.1
2021-08-05T10:44:48.104Z 19.3
2021-08-05T10:52:48.095Z 19.3
2021-08-05T10:55:28.15Z  19.6
2021-08-05T11:38:08.032Z 19.6
2021-08-05T11:40:48.019Z 19.9
2021-08-05T11:56:48.011Z 19.9
2021-08-05T11:59:28.007Z 20.1
2021-08-05T19:08:48.928Z 20.1
2021-08-05T19:11:27.447Z 20.4
2021-08-05T21:59:27.211Z 20.4
2021-08-05T22:02:07.207Z 0
2021-08-05T22:10:07.197Z 0
2021-08-05T22:12:47.183Z 0.2
2021-08-05T23:16:47.106Z 0.2
2021-08-05T23:19:27.084Z 0.5
2021-08-05T23:22:08.645Z 0.5
2021-08-05T23:24:47.24Z  1
2021-08-05T23:27:27.066Z 1.7
2021-08-05T23:30:07.034Z 2
2021-08-06T00:42:06.968Z 2
2021-08-06T00:44:46.939Z 2.2
2021-08-06T09:16:46.3Z   2.2
2021-08-06T09:19:26.297Z 2.5
2021-08-06T09:22:06.31Z  3
2021-08-06T09:32:46.256Z 3
2021-08-06T09:35:26.269Z 3.3
2021-08-06T21:59:25.277Z 3.3
2021-08-06T22:02:05.225Z 0
2021-08-07T07:14:04.604Z 0
2021-08-07T07:18:07.444Z 0
2021-08-07T07:18:20.712Z 0
2021-08-07T07:47:24.639Z 0
2021-08-07T08:06:25.323Z 0
2021-08-07T08:06:31.215Z 0
2021-08-07T08:11:03.431Z 0
2021-08-07T08:11:08.611Z 0
2021-08-07T08:18:09.609Z 0
2021-08-07T08:18:20.61Z  0
2021-08-07T08:22:29.667Z 0
2021-08-07T08:22:36.609Z 0
2021-08-07T08:26:11.299Z 0
2021-08-07T08:26:20.605Z 0
2021-08-07T08:39:24.593Z 0
2021-08-07T08:50:24.91Z  0
2021-08-07T08:50:31.155Z 0
2021-08-07T09:11:56.496Z 0
2021-08-07T09:19:48.572Z 0
2021-08-07T09:19:56.599Z 0
2021-08-07T09:27:56.458Z 0
2021-08-07T09:32:50.207Z 0
2021-08-07T09:33:00.505Z 0
2021-08-07T17:46:03.642Z 0
2021-08-07T17:48:43.642Z 0.2
2021-08-07T17:51:23.629Z 0.2
2021-08-07T17:54:03.68Z  0.5
2021-08-07T18:04:43.63Z  0.5
2021-08-07T18:07:23.622Z 0.7
2021-08-07T18:26:04.41Z  0.7
2021-08-07T18:28:43.62Z  1
2021-08-07T18:31:23.575Z 1
2021-08-07T18:34:03.577Z 1.2
2021-08-07T18:36:43.565Z 1.2
2021-08-07T18:39:23.588Z 1.5
2021-08-07T18:42:03.57Z  1.7
2021-08-07T18:44:43.568Z 1.7
2021-08-07T18:47:23.578Z 2
2021-08-07T19:43:23.502Z 2
2021-08-07T19:46:03.505Z 2.3
2021-08-07T20:15:23.48Z  2.3
2021-08-07T20:18:03.459Z 2.5
2021-08-07T21:00:43.395Z 2.5
2021-08-07T21:03:23.401Z 2.8
2021-08-07T21:22:03.385Z 2.8
2021-08-07T21:24:43.405Z 3
2021-08-07T21:59:23.308Z 3
2021-08-07T22:02:03.311Z 0
2021-08-08T14:01:46.01Z  0
2021-08-08T14:04:25.97Z  0.3
2021-08-08T14:07:06.002Z 0.5
2021-08-08T14:09:46.005Z 0.8
2021-08-08T14:15:06.01Z  0.8
2021-08-08T14:17:46.001Z 1.3
2021-08-08T14:20:25.991Z 1.5
2021-08-08T14:23:05.981Z 1.8
2021-08-08T14:25:45.946Z 2
2021-08-08T14:28:25.969Z 2.3
2021-08-08T14:31:06.018Z 2.6
2021-08-08T14:39:05.951Z 2.6
2021-08-08T14:41:45.948Z 2.8
2021-08-08T18:22:49.629Z 2.8
2021-08-08T18:25:29.617Z 3.1
2021-08-08T19:08:09.627Z 3.1
2021-08-08T19:10:49.742Z 3.3
2021-08-08T21:58:49.379Z 3.3
2021-08-08T22:01:29.385Z 0
2021-08-09T16:04:07.939Z 0
2021-08-09T16:30:43.337Z 0
2021-08-09T16:31:04.513Z 0
2021-08-12T18:59:45.857Z 0
2021-08-12T19:03:24.852Z 0
2021-08-12T19:03:29.945Z 0
2021-08-16T09:10:02.719Z 0
2021-08-16T09:12:42.724Z 0.3
2021-08-16T09:20:39.393Z 0.3
2021-08-16T09:23:22.708Z 0.5
2021-08-16T09:26:02.701Z 1
2021-08-16T09:34:02.698Z 1
2021-08-16T09:36:42.726Z 1.3
2021-08-16T19:41:45.83Z  1.3
2021-08-16T19:43:57.997Z 1.3
2021-08-16T19:44:25.888Z 1.3
2021-08-16T21:57:45.677Z 1.3
2021-08-16T22:00:25.715Z 0
2021-08-16T22:40:25.586Z 0
2021-08-16T22:43:05.634Z 0.2
2021-08-16T22:48:25.61Z  0.2
2021-08-16T22:51:05.57Z  0.5
2021-08-16T22:56:25.598Z 0.5
2021-08-16T22:59:05.593Z 0.7
2021-08-16T23:04:25.598Z 0.7
2021-08-16T23:07:05.594Z 1
2021-08-16T23:15:05.587Z 1
2021-08-16T23:17:45.558Z 1.3
2021-08-16T23:28:25.559Z 1.3
2021-08-16T23:31:05.587Z 1.5
2021-08-16T23:44:25.525Z 1.5
2021-08-16T23:47:05.524Z 1.8
2021-08-16T23:55:05.535Z 1.8
2021-08-16T23:57:45.527Z 2
2021-08-17T00:00:25.566Z 2
2021-08-17T00:03:05.511Z 2.3
2021-08-17T00:05:45.475Z 2.5
2021-08-17T00:08:25.509Z 2.5
2021-08-17T00:11:05.493Z 2.8
2021-08-17T00:16:25.464Z 2.8
2021-08-17T00:19:05.486Z 3
2021-08-17T00:21:45.487Z 3
2021-08-17T00:24:25.504Z 3.3
2021-08-17T00:37:45.434Z 3.3
2021-08-17T00:40:25.453Z 3.5
2021-08-17T01:31:05.42Z  3.5
2021-08-17T01:33:45.387Z 3.8
2021-08-17T21:47:03.915Z 3.8
2021-08-17T21:49:43.902Z 4
2021-08-17T21:57:43.896Z 4
2021-08-17T22:00:23.896Z 0
2021-08-17T22:05:43.88Z  0
2021-08-17T22:08:23.864Z 0.3
2021-08-17T22:24:23.867Z 0.3
2021-08-17T22:27:03.868Z 0.6
2021-08-17T22:32:23.861Z 0.6
2021-08-17T22:35:03.859Z 0.8
2021-08-17T23:49:43.774Z 0.8
2021-08-17T23:52:24.452Z 1.1
2021-08-18T01:41:43.618Z 1.1
2021-08-18T01:44:23.647Z 1.3
2021-08-18T01:49:43.643Z 1.3
2021-08-18T01:52:23.655Z 1.6
2021-08-18T01:57:43.62Z  1.6
2021-08-18T02:00:23.628Z 1.8
2021-08-18T02:05:43.656Z 1.8
2021-08-18T02:08:23.621Z 2.1
2021-08-18T02:11:03.607Z 2.1
2021-08-18T02:13:43.559Z 2.3
2021-08-18T02:21:43.587Z 2.3
2021-08-18T02:24:24.332Z 2.6
2021-08-18T02:40:23.533Z 2.6
2021-08-18T02:43:03.542Z 2.8
2021-08-18T02:53:43.566Z 2.8
2021-08-18T02:56:23.529Z 3.1
2021-08-18T03:04:23.579Z 3.1
2021-08-18T03:07:03.547Z 3.4
2021-08-18T03:12:23.555Z 3.4
2021-08-18T03:15:04.43Z  3.6
2021-08-18T03:23:03.582Z 3.6
2021-08-18T03:25:43.522Z 3.9
2021-08-18T03:28:23.502Z 4.1
2021-08-18T03:31:03.549Z 4.4
2021-08-18T03:33:43.519Z 4.6
2021-08-18T04:48:23.487Z 4.6
2021-08-18T04:51:03.451Z 4.9
2021-08-18T13:23:02.788Z 4.9
2021-08-18T13:27:04.438Z 4.9
2021-08-18T13:27:18.822Z 4.9
2021-08-18T21:59:02.061Z 4.9
2021-08-18T22:01:42.074Z 0
2021-08-22T05:43:27.825Z 0
2021-08-22T05:46:07.904Z 0.2
2021-08-22T05:54:07.809Z 0.2
2021-08-22T05:56:47.824Z 0.5
2021-08-22T13:09:03.211Z 0.5
2021-08-22T13:11:43.203Z 1
2021-08-22T13:14:23.189Z 1.8
2021-08-22T13:17:03.156Z 3
2021-08-22T13:19:43.202Z 5.8
2021-08-22T13:22:23.184Z 9.6
2021-08-22T13:25:03.181Z 10.9
2021-08-22T13:27:43.133Z 11.9
2021-08-22T13:30:23.164Z 14.2
2021-08-22T13:33:03.176Z 15.2
2021-08-22T13:35:43.185Z 15.7
2021-08-22T13:38:23.162Z 16
2021-08-22T13:41:03.15Z  16
2021-08-22T13:43:43.148Z 16.2
2021-08-22T13:46:23.16Z  16.5
2021-08-22T13:51:43.178Z 16.5
2021-08-22T13:54:23.127Z 16.7
2021-08-22T13:57:03.127Z 17.2
2021-08-22T13:59:43.113Z 17.5
2021-08-22T14:02:23.143Z 18
2021-08-22T14:05:03.182Z 18.3
2021-08-22T14:07:43.125Z 18.5
2021-08-22T14:10:23.083Z 19
2021-08-22T14:15:43.103Z 19
2021-08-22T14:18:23.107Z 19.3
2021-08-22T14:37:03.079Z 19.3
2021-08-22T14:39:44.177Z 19.5
2021-08-22T14:47:43.065Z 19.5
2021-08-22T14:50:23.049Z 19.8
2021-08-22T14:55:35.292Z 19.8
2021-08-22T14:58:07.077Z 20
2021-08-22T15:11:27.014Z 20
2021-08-22T15:14:07.029Z 20.3
2021-08-22T15:35:27.594Z 20.3
2021-08-22T15:38:06.97Z  20.5
2021-08-22T18:39:26.722Z 20.5
2021-08-22T18:42:06.723Z 20.8
2021-08-22T18:50:06.748Z 20.8
2021-08-22T18:52:46.709Z 21.1
2021-08-22T18:58:07.325Z 21.1
2021-08-22T19:00:46.697Z 21.3
2021-08-22T19:03:26.677Z 21.3
2021-08-22T19:06:06.782Z 21.6
2021-08-22T19:14:06.684Z 21.6
2021-08-22T19:16:46.679Z 21.8
2021-08-22T19:32:46.643Z 21.8
2021-08-22T19:35:26.635Z 22.1
2021-08-22T19:38:06.651Z 22.1
2021-08-22T19:40:46.638Z 22.3
2021-08-22T19:43:26.679Z 22.6
2021-08-22T19:46:06.632Z 23.1
2021-08-22T19:48:47.663Z 23.3
2021-08-22T19:51:26.67Z  23.6
2021-08-22T21:59:26.48Z  23.6
2021-08-22T22:02:06.478Z 0
2021-08-23T08:44:45.661Z 0
2021-08-23T08:47:25.661Z 0.3
2021-08-23T09:51:25.583Z 0.3
2021-08-23T09:54:05.592Z 0.8
2021-08-23T09:56:45.55Z  1
2021-08-23T12:50:05.3Z   1
2021-08-23T12:52:45.302Z 1.3
2021-08-23T13:06:05.285Z 1.3
2021-08-23T13:08:45.277Z 1.5
2021-08-23T13:22:05.258Z 1.5
2021-08-23T13:24:45.263Z 1.8
2021-08-23T13:40:45.252Z 1.8
2021-08-23T13:43:25.255Z 2
2021-08-23T13:54:05.236Z 2
2021-08-23T13:56:45.228Z 2.3
2021-08-23T14:12:45.226Z 2.3
2021-08-23T14:15:25.207Z 2.5
2021-08-23T14:20:45.181Z 2.5
2021-08-23T14:23:25.19Z  2.8
2021-08-23T14:26:05.179Z 3
2021-08-23T14:31:25.241Z 3
2021-08-23T14:34:05.214Z 3.3
2021-08-23T14:39:25.167Z 3.3
2021-08-23T14:42:05.178Z 3.6
2021-08-23T14:58:05.119Z 3.6
2021-08-23T15:00:45.122Z 3.8
2021-08-23T17:22:04.971Z 3.8
2021-08-23T17:24:44.936Z 4.1
2021-08-23T20:04:44.739Z 4.1
2021-08-23T20:07:24.75Z  4.3
2021-08-23T21:59:24.576Z 4.3
2021-08-23T22:02:04.584Z 0
2021-08-24T02:55:24.245Z 0
2021-08-24T02:58:04.228Z 0.3
2021-08-24T03:22:04.182Z 0.3
2021-08-24T03:24:44.212Z 0.5
2021-08-24T09:11:23.761Z 0.5
2021-08-24T09:14:03.767Z 0.8
2021-08-24T21:59:22.757Z 0.8
2021-08-24T22:02:02.756Z 0
2021-08-26T05:53:28.47Z  0
2021-08-26T05:56:08.464Z 0.2
2021-08-26T06:01:28.443Z 0.2
2021-08-26T06:04:08.455Z 0.5
2021-08-26T06:14:48.445Z 0.5
2021-08-26T06:17:28.435Z 0.7
2021-08-26T06:33:28.414Z 0.7
2021-08-26T06:36:08.414Z 1
2021-08-26T06:46:48.397Z 1
2021-08-26T06:49:28.413Z 1.2
2021-08-26T07:34:48.349Z 1.2
2021-08-26T07:37:28.314Z 1.5
2021-08-26T07:45:28.318Z 1.5
2021-08-26T07:48:09.718Z 1.8
2021-08-26T07:53:28.322Z 1.8
2021-08-26T07:56:08.325Z 2
2021-08-26T08:01:28.322Z 2
2021-08-26T08:04:08.346Z 2.3
2021-08-26T08:22:48.27Z  2.3
2021-08-26T08:25:28.29Z  2.5
2021-08-26T17:02:47.554Z 2.5
2021-08-26T17:05:27.55Z  2.8
2021-08-26T17:10:47.528Z 2.8
2021-08-26T17:13:27.54Z  3
2021-08-26T17:16:07.506Z 3.3
2021-08-26T18:17:27.479Z 3.3
2021-08-26T18:20:07.441Z 3.5
2021-08-26T20:09:27.332Z 3.5
2021-08-26T20:12:07.318Z 3.8
2021-08-26T20:46:47.3Z   3.8
2021-08-26T20:49:27.281Z 4
2021-08-26T21:16:07.269Z 4
2021-08-26T21:18:47.86Z  4.3
2021-08-26T21:21:27.242Z 4.3
2021-08-26T21:24:07.256Z 4.5
2021-08-26T21:26:47.241Z 4.8
2021-08-26T21:29:27.253Z 5.1
2021-08-26T21:32:07.241Z 5.3
2021-08-26T21:34:47.235Z 5.6
2021-08-26T21:37:27.219Z 5.6
2021-08-26T21:40:07.197Z 5.8
2021-08-26T21:45:27.224Z 5.8
2021-08-26T21:48:07.208Z 6.1
2021-08-26T21:53:27.192Z 6.1
2021-08-26T21:56:07.183Z 6.3
2021-08-26T21:58:47.188Z 6.3
2021-08-26T22:01:27.182Z 0
2021-08-26T22:04:07.183Z 0.2
2021-08-26T22:06:47.178Z 0.2
2021-08-26T22:09:27.168Z 0.5
2021-08-26T22:12:07.184Z 0.7
2021-08-26T22:17:27.184Z 0.7
2021-08-26T22:20:07.942Z 1
2021-08-26T22:22:47.189Z 1
2021-08-26T22:25:27.176Z 1.3
2021-08-26T22:28:07.148Z 1.5
2021-08-26T22:30:47.143Z 1.8
2021-08-26T22:33:27.165Z 1.8
2021-08-26T22:36:07.18Z  2
2021-08-26T22:38:47.204Z 2
2021-08-26T22:41:27.176Z 2.3
2021-08-26T22:44:07.133Z 2.5
2021-08-26T22:46:47.156Z 2.8
2021-08-26T22:49:27.181Z 3
2021-08-26T22:52:07.161Z 3.3
2021-08-26T22:54:47.147Z 3.3
2021-08-26T22:57:27.141Z 3.5
2021-08-26T23:00:07.107Z 3.8
2021-08-26T23:02:47.132Z 4
2021-08-26T23:05:27.124Z 4.3
2021-08-26T23:08:07.154Z 4.3
2021-08-26T23:10:48.435Z 4.6
2021-08-26T23:13:27.132Z 4.6
2021-08-26T23:16:07.119Z 4.8
2021-08-26T23:18:47.099Z 4.8
2021-08-26T23:21:27.113Z 5.1
2021-08-26T23:24:07.109Z 5.1
2021-08-26T23:26:47.105Z 5.3
2021-08-26T23:29:27.131Z 5.3
2021-08-26T23:32:07.107Z 5.6
2021-08-27T10:04:06.34Z  5.6
2021-08-27T10:06:46.339Z 6.1
2021-08-27T12:52:06.102Z 6.1
2021-08-27T12:54:46.104Z 6.3
2021-08-27T18:54:45.662Z 6.3
2021-08-27T18:57:25.649Z 6.6
2021-08-27T19:02:46.263Z 6.6
2021-08-27T19:05:25.642Z 6.8
2021-08-27T19:08:05.647Z 6.8
2021-08-27T19:10:45.633Z 7.1
2021-08-27T20:25:25.56Z  7.1
2021-08-27T20:28:05.541Z 7.3
2021-08-27T21:13:25.47Z  7.3
2021-08-27T21:16:05.458Z 7.6
2021-08-27T21:18:45.457Z 7.6
2021-08-27T21:21:25.445Z 7.9
2021-08-27T21:26:45.444Z 7.9
2021-08-27T21:29:25.442Z 8.1
2021-08-27T21:32:05.461Z 8.1
2021-08-27T21:34:46.65Z  8.4
2021-08-27T21:37:25.434Z 8.4
2021-08-27T21:40:05.431Z 8.6
2021-08-27T21:42:45.441Z 8.6
2021-08-27T21:45:25.437Z 8.9
2021-08-27T21:50:45.428Z 8.9
2021-08-27T21:53:25.444Z 9.1
2021-08-27T21:56:05.407Z 9.4
2021-08-27T21:58:45.45Z  9.4
2021-08-27T22:01:25.429Z 0
2021-08-27T22:04:05.406Z 0.3
2021-08-27T22:06:45.405Z 0.5
2021-08-27T22:09:25.404Z 0.8
2021-08-27T22:14:45.401Z 0.8
2021-08-27T22:17:25.39Z  1
2021-08-27T22:49:25.35Z  1
2021-08-27T22:52:05.392Z 1.3
2021-08-27T23:08:05.337Z 1.3
2021-08-27T23:10:45.322Z 1.6
2021-08-27T23:16:05.953Z 1.6
2021-08-27T23:18:45.323Z 1.8
2021-08-27T23:21:25.322Z 1.8
2021-08-27T23:24:05.32Z  2.1
2021-08-27T23:26:45.315Z 2.1
2021-08-27T23:29:25.31Z  2.3
2021-08-27T23:34:45.305Z 2.3
2021-08-27T23:37:25.301Z 2.6
2021-08-27T23:56:05.289Z 2.6
2021-08-27T23:58:45.275Z 2.8
2021-08-28T00:06:46.006Z 2.8
2021-08-28T00:09:25.256Z 3.1
2021-08-28T00:12:05.259Z 3.3
2021-08-28T00:14:45.252Z 3.6
2021-08-28T00:20:05.269Z 3.6
2021-08-28T00:22:45.264Z 4.1
2021-08-28T00:25:25.258Z 4.6
2021-08-28T00:28:05.301Z 5.1
2021-08-28T00:30:45.251Z 5.6
2021-08-28T00:33:25.257Z 5.9
2021-08-28T00:36:05.238Z 5.9
2021-08-28T00:38:45.239Z 6.1
2021-08-28T00:41:25.251Z 6.1
2021-08-28T00:44:05.256Z 6.4
2021-08-28T00:46:45.283Z 6.6
2021-08-28T00:57:26.132Z 6.6
2021-08-28T01:00:05.232Z 6.9
2021-08-28T01:02:45.23Z  7.1
2021-08-28T01:05:25.235Z 7.7
2021-08-28T01:08:05.213Z 8.7
2021-08-28T01:10:45.218Z 8.9
2021-08-28T01:13:25.209Z 9.2
2021-08-28T01:16:05.22Z  9.7
2021-08-28T01:18:45.194Z 9.7
2021-08-28T01:21:25.199Z 9.9
2021-08-28T03:34:45.051Z 9.9
2021-08-28T03:37:25.04Z  10.2
2021-08-28T05:18:44.961Z 10.2
2021-08-28T05:21:24.955Z 10.4
2021-08-28T10:33:24.544Z 10.4
2021-08-28T10:36:04.537Z 10.7
2021-08-28T11:26:44.448Z 10.7
2021-08-28T11:29:24.446Z 11
2021-08-28T11:56:04.413Z 11
2021-08-28T11:58:44.407Z 11.2
2021-08-28T13:26:45.199Z 11.2
2021-08-28T13:29:24.295Z 11.5
2021-08-28T13:32:04.287Z 11.5
2021-08-28T13:34:44.281Z 11.7
2021-08-28T13:48:04.278Z 11.7
2021-08-28T13:50:44.267Z 12
2021-08-28T18:06:43.981Z 12
2021-08-28T18:09:23.981Z 12.2
2021-08-28T18:14:43.924Z 12.2
2021-08-28T18:17:23.957Z 12.5
2021-08-28T21:42:43.736Z 12.5
2021-08-28T21:45:23.745Z 12.7
2021-08-28T21:48:04.716Z 13.2
2021-08-28T21:50:43.689Z 13.5
2021-08-28T21:58:43.689Z 13.5
2021-08-28T22:01:23.71Z  0
2021-08-29T08:57:22.948Z 0
2021-08-29T08:59:56.037Z 0
2021-08-29T09:00:03.008Z 0
2021-08-29T13:26:42.559Z 0
2021-08-29T13:29:22.562Z 0.2
2021-08-29T13:40:02.5Z   0.2
2021-08-29T14:00:56.441Z 0.2
2021-08-29T14:01:07.196Z 0.2
2021-08-29T21:58:25.978Z 0.2
2021-08-29T22:01:03.447Z 0

Topic		Replies	Views
Query to count values per day Fluxlang influxdb , time , query , flux	2	3710	March 7, 2023
ERR: mixing aggregate and non-aggregate queries is not supported influxdb	5	11429	July 16, 2019
Zero Timestamp when selecting count of a subquery's results Store influxdb , time , influxql	0	990	December 4, 2017
Use number of days represented by query	1	1171	January 11, 2021
InfluxQL count with subquery in Flux InfluxDB 2 flux	3	1405	December 14, 2020

Count Number of Raindays in Month

Related topics