2019年1月3日 星期四

InfluxDB InfluxQL Examples

SELECT "bid" FROM "quotes"."autogen"."quotes" WHERE time > '2019-01-03 00:00:00' and time > '2019-01-03 00:00:01' AND "symbol" =~/AUDUSD*/ GROUP BY "symbol"

SELECT symbol, "bid" FROM "quotes" WHERE symbol =~ /AUDUSD*/ and time > now()-1s

SELECT symbol, "bid" FROM "quotes" WHERE symbol =~ /AUDUSD*/ and time > '2019-01-02 23:00:00' and time < '2019-01-02 23:01:00'

沒有留言:

張貼留言

2025 My Hardware Personal Computer Used

 2025 My Hardware Personal Computer Used Check Ubunut sudo dmidecode -t 2 sudo lsblk -o NAME,FSTYPE,LABEL,MOUNTPOINT,SIZE,MODEL 2025 Intel(R...