github.com/diadata-org/diadata@v1.4.593/scripts/influxdb.sh (about)

     1  
     2  DB="dia"
     3  
     4  #CREATE RETENTION POLICY "30d" ON "$DB" DURATION 30d REPLICATION 1
     5  
     6  
     7  for fnc in mean sum
     8  	do
     9  	for a in 5m 30m 1h 4h 1d 1w
    10  		do
    11  		QUERY="SELECT $fnc(\"value\") AS value INTO \"a_year\".\"filters_${fnc}_$a\" FROM \"filters\" GROUP BY time($a), symbol, filter, exchange"
    12  		echo $QUERY
    13  		#echo  "CREATE CONTINUOUS QUERY \"cq_filters_${fnc}_$a\" ON \"$DB\" BEGIN  $QUERY END"
    14  	done
    15  done
    16  
    17  exit
    18  
    19  for fnc in mean sum
    20  	do
    21  	for a in 5m 30m 1h 4h 1d 1w
    22  		do
    23  		SELECT * from "a_year"."filters_mean_5m" orderby asc
    24  		echo  "select count(value) from \"a_year\".\"filters_${fnc}_$a\""
    25  		echo  "SELECT * from \"a_year\".\"filters_${fnc}_$a\""
    26  		echo  "SELECT * INTO  \"a_year\".\"filters_${fnc}_$a\" FROM filters WHERE time > now() - 100w and time < now() - 90w GROUP BY *"
    27  	done
    28  done