Faceted Time Series (Returns)

Time series (stock returns), faceted and colored based on positive or negative returns

SELECT ts::TIME AS t, ts::DATE AS d, LN(close/TICKER[-1].close) AS return
 FROM (EXTERNAL CSV("http://scleraviz.herokuapp.com/assets/data/bhel5d.csv") TYPEINFER(LIMIT 1)) AS TICKER
PLOT(
  GEOM=POINT(x=t, y=return),
  FILL=(return > 0) SCALE=COLOR(true AS "green", false AS "red")
)
FACET(ROWS=d)

Description

Plots stock returns as a time series, faceted on the date. The returns are computed in real-time using the SclerSQL indexed history access feature, even when the input is a continuous time series.

Data Preparation

The data is read from a URL and the column types are inferred using the `TYPEINFER` operator. Next the time `t` and date `d` are extracted from the timestamp. The return to be plotted is computed on the fly using the ScleraSQL indexed history access feature.

bhel5d.csv

SYMBOL,TS,CLOSE,HIGH,LOW,OPEN,VOLUME
BHEL.NS,2016-01-04 09:19:00.0,169.85,170.5,169.6,170.5,58200
BHEL.NS,2016-01-04 09:24:00.0,169.9,169.9,169.55,169.85,31700
BHEL.NS,2016-01-04 09:29:04.0,169.85,170.0,169.65,169.7,14500
BHEL.NS,2016-01-04 09:34:59.0,169.8,170.0,169.4,169.9,49900
BHEL.NS,2016-01-04 09:39:58.0,170.55,170.7,169.7,169.75,64200
BHEL.NS,2016-01-04 09:44:03.0,170.85,170.95,170.2,170.55,29400
BHEL.NS,2016-01-04 09:49:04.0,170.45,170.85,170.4,170.75,23600
BHEL.NS,2016-01-04 09:54:00.0,170.35,170.7,170.35,170.5,16300
BHEL.NS,2016-01-04 09:59:00.0,170.2,170.5,170.1,170.4,12800
BHEL.NS,2016-01-04 10:04:12.0,169.85,170.1,169.6,170.1,28000
BHEL.NS,2016-01-04 10:09:00.0,169.95,170.65,169.75,169.9,33700
BHEL.NS,2016-01-04 10:14:04.0,169.8,170.0,169.65,169.85,14000
BHEL.NS,2016-01-04 10:19:02.0,170.2,170.25,169.6,169.7,29900
BHEL.NS,2016-01-04 10:24:00.0,170.4,170.55,170.1,170.2,13500
BHEL.NS,2016-01-04 10:29:03.0,170.35,170.4,170.25,170.3,7900
BHEL.NS,2016-01-04 10:34:03.0,170.1,170.4,169.85,170.4,13500
BHEL.NS,2016-01-04 10:39:13.0,169.75,170.1,169.7,170.1,11200
BHEL.NS,2016-01-04 10:44:00.0,170.2,170.2,169.65,169.7,21000
BHEL.NS,2016-01-04 10:49:03.0,170.25,170.4,170.05,170.05,11900
BHEL.NS,2016-01-04 10:54:06.0,170.3,170.5,170.2,170.25,17200
BHEL.NS,2016-01-04 10:59:59.0,169.95,170.4,169.85,170.25,13100
BHEL.NS,2016-01-04 11:04:01.0,170.0,170.2,169.75,169.95,20000
BHEL.NS,2016-01-04 11:09:00.0,169.15,170.1,169.1,169.95,45800
BHEL.NS,2016-01-04 11:14:02.0,168.85,169.25,168.8,169.05,44700
BHEL.NS,2016-01-04 11:19:07.0,168.65,169.0,168.3,168.9,51200
BHEL.NS,2016-01-04 11:24:01.0,168.25,168.9,168.0,168.65,61200
BHEL.NS,2016-01-04 11:29:59.0,169.0,169.0,168.1,168.1,29700
BHEL.NS,2016-01-04 11:34:01.0,168.5,169.1,168.45,168.8,32800
BHEL.NS,2016-01-04 11:39:01.0,168.75,168.8,168.5,168.55,6400
BHEL.NS,2016-01-04 11:44:00.0,168.5,168.65,168.35,168.6,17000
BHEL.NS,2016-01-04 11:49:01.0,167.35,168.55,167.1,168.55,99000
BHEL.NS,2016-01-04 11:54:00.0,167.2,167.5,167.2,167.35,32400
BHEL.NS,2016-01-04 11:59:00.0,166.9,167.6,166.5,167.15,76600
BHEL.NS,2016-01-04 12:04:58.0,166.65,167.0,165.9,166.9,75200
BHEL.NS,2016-01-04 12:09:03.0,167.15,167.2,166.6,166.65,29900
BHEL.NS,2016-01-04 12:14:59.0,167.2,167.2,166.85,167.2,24100
BHEL.NS,2016-01-04 12:19:02.0,166.9,167.2,166.85,167.1,23100
BHEL.NS,2016-01-04 12:24:01.0,167.0,167.2,166.85,166.85,15600
BHEL.NS,2016-01-04 12:29:12.0,167.2,167.35,167.0,167.0,9700
BHEL.NS,2016-01-04 12:34:01.0,167.0,167.3,166.9,167.15,12000
BHEL.NS,2016-01-04 12:39:15.0,166.7,167.05,166.7,167.0,9700
BHEL.NS,2016-01-04 12:44:00.0,166.7,166.75,166.5,166.7,26000
BHEL.NS,2016-01-04 12:49:02.0,166.65,166.75,166.4,166.7,12100
BHEL.NS,2016-01-04 12:54:00.0,166.3,166.7,166.3,166.55,13600
BHEL.NS,2016-01-04 12:59:21.0,166.65,166.7,166.3,166.45,16100
BHEL.NS,2016-01-04 13:04:00.0,166.6,166.85,166.55,166.7,20600
BHEL.NS,2016-01-04 13:09:02.0,166.0,166.6,165.9,166.6,40200
BHEL.NS,2016-01-04 13:14:01.0,166.1,166.35,165.95,166.0,15500
BHEL.NS,2016-01-04 13:19:59.0,166.25,166.35,166.05,166.1,23100
BHEL.NS,2016-01-04 13:24:01.0,166.4,166.6,166.1,166.25,14100
BHEL.NS,2016-01-04 13:29:58.0,166.5,166.6,166.25,166.4,20900
BHEL.NS,2016-01-04 13:34:59.0,166.35,166.65,166.05,166.6,32400
BHEL.NS,2016-01-04 13:39:00.0,165.9,166.4,165.8,166.25,36000
BHEL.NS,2016-01-04 13:44:59.0,165.9,166.15,165.85,165.9,15500
BHEL.NS,2016-01-04 13:49:02.0,165.55,166.2,165.5,166.0,30400
BHEL.NS,2016-01-04 13:54:59.0,165.65,165.9,165.5,165.55,32700
BHEL.NS,2016-01-04 13:59:04.0,165.55,165.8,165.5,165.55,27100
BHEL.NS,2016-01-04 14:04:00.0,165.5,165.7,165.45,165.55,38500
BHEL.NS,2016-01-04 14:09:02.0,165.85,166.15,165.45,165.45,16900
BHEL.NS,2016-01-04 14:14:01.0,166.0,166.25,165.8,166.0,20900
BHEL.NS,2016-01-04 14:19:59.0,166.05,166.25,165.9,166.0,10900
BHEL.NS,2016-01-04 14:24:01.0,166.0,166.2,166.0,166.2,13100
BHEL.NS,2016-01-04 14:29:01.0,166.15,166.35,165.95,166.05,27200
BHEL.NS,2016-01-04 14:34:01.0,166.15,166.3,166.05,166.3,14500
BHEL.NS,2016-01-04 14:39:59.0,165.45,166.2,165.25,166.15,51000
BHEL.NS,2016-01-04 14:44:59.0,165.55,165.75,165.3,165.3,26700
BHEL.NS,2016-01-04 14:49:59.0,165.45,165.7,165.45,165.7,28500
BHEL.NS,2016-01-04 14:54:01.0,165.5,165.75,165.25,165.65,20100
BHEL.NS,2016-01-04 14:59:59.0,165.8,165.85,165.5,165.6,15300
BHEL.NS,2016-01-04 15:04:00.0,165.55,165.95,165.5,165.85,26800
BHEL.NS,2016-01-04 15:09:01.0,165.45,165.7,165.3,165.65,35700
BHEL.NS,2016-01-04 15:14:59.0,165.3,165.4,165.0,165.35,105300
BHEL.NS,2016-01-04 15:19:59.0,165.05,165.4,165.0,165.3,91100
BHEL.NS,2016-01-04 15:24:59.0,165.2,165.35,165.0,165.1,78000
BHEL.NS,2016-01-04 15:29:59.0,164.5,165.3,164.5,165.2,84600
BHEL.NS,2016-01-04 15:30:00.0,164.65,164.65,164.65,164.65,200
BHEL.NS,2016-01-05 09:19:00.0,166.7,166.9,165.85,165.95,0
BHEL.NS,2016-01-05 09:24:00.0,166.2,166.85,166.0,166.6,97400
BHEL.NS,2016-01-05 09:29:59.0,166.1,166.35,165.8,166.2,66300
BHEL.NS,2016-01-05 09:34:00.0,166.65,166.9,166.05,166.1,51800
BHEL.NS,2016-01-05 09:39:59.0,166.3,166.65,166.1,166.65,29200
BHEL.NS,2016-01-05 09:44:59.0,166.3,166.4,166.05,166.3,19700
BHEL.NS,2016-01-05 09:49:00.0,166.3,166.45,166.1,166.3,33300
BHEL.NS,2016-01-05 09:54:00.0,165.6,166.2,165.5,166.15,47000
BHEL.NS,2016-01-05 09:59:00.0,165.75,165.8,165.25,165.5,53800
BHEL.NS,2016-01-05 10:04:00.0,165.6,165.9,165.4,165.75,17600
BHEL.NS,2016-01-05 10:09:59.0,165.9,165.9,165.6,165.7,17200
BHEL.NS,2016-01-05 10:14:59.0,165.7,166.15,165.6,165.9,34100
BHEL.NS,2016-01-05 10:19:59.0,165.75,166.15,165.65,165.7,37800
BHEL.NS,2016-01-05 10:24:59.0,166.1,166.15,165.6,165.7,34700
BHEL.NS,2016-01-05 10:29:00.0,166.05,166.25,165.9,165.9,16300
BHEL.NS,2016-01-05 10:34:58.0,166.0,166.15,165.8,166.05,7200
BHEL.NS,2016-01-05 10:39:59.0,165.8,166.05,165.65,165.95,13600
BHEL.NS,2016-01-05 10:44:59.0,165.65,165.85,165.6,165.7,11700
BHEL.NS,2016-01-05 10:49:59.0,165.5,165.8,165.4,165.65,47900
BHEL.NS,2016-01-05 10:54:59.0,165.1,165.5,165.0,165.4,41200
BHEL.NS,2016-01-05 10:59:59.0,165.1,165.25,165.0,165.15,25100
BHEL.NS,2016-01-05 11:04:00.0,164.35,165.15,164.2,165.15,75500
BHEL.NS,2016-01-05 11:09:03.0,164.7,164.9,164.35,164.5,25300
BHEL.NS,2016-01-05 11:14:00.0,164.65,164.85,164.55,164.8,12600
BHEL.NS,2016-01-05 11:19:59.0,164.7,164.7,164.35,164.55,26100
BHEL.NS,2016-01-05 11:24:59.0,164.95,165.25,164.55,164.55,21400
BHEL.NS,2016-01-05 11:29:01.0,165.3,165.4,164.9,164.95,14200
BHEL.NS,2016-01-05 11:34:59.0,165.3,165.45,165.1,165.35,14500
BHEL.NS,2016-01-05 11:39:05.0,165.2,165.5,165.15,165.3,11600
BHEL.NS,2016-01-05 11:44:05.0,165.0,165.3,165.0,165.2,9900
BHEL.NS,2016-01-05 11:49:18.0,165.1,165.1,164.9,165.05,14500
BHEL.NS,2016-01-05 11:54:04.0,165.15,165.15,164.9,165.1,9900
BHEL.NS,2016-01-05 11:59:17.0,165.4,165.45,165.1,165.15,10700
BHEL.NS,2016-01-05 12:04:01.0,165.4,165.55,165.3,165.45,11900
BHEL.NS,2016-01-05 12:09:02.0,165.75,165.8,165.4,165.4,16800
BHEL.NS,2016-01-05 12:14:03.0,165.8,165.8,165.5,165.5,31800
BHEL.NS,2016-01-05 12:19:12.0,165.55,165.8,165.45,165.8,9400
BHEL.NS,2016-01-05 12:24:00.0,165.5,165.6,165.4,165.55,6600
BHEL.NS,2016-01-05 12:29:00.0,165.7,165.7,165.25,165.5,10400
BHEL.NS,2016-01-05 12:34:01.0,166.05,166.4,165.6,165.7,75000
BHEL.NS,2016-01-05 12:39:59.0,166.5,166.5,166.0,166.15,46300
BHEL.NS,2016-01-05 12:44:01.0,166.5,166.75,166.4,166.5,57800
BHEL.NS,2016-01-05 12:49:10.0,166.6,166.75,166.45,166.6,24100
BHEL.NS,2016-01-05 12:54:03.0,166.65,166.65,166.45,166.55,10800
BHEL.NS,2016-01-05 12:59:59.0,167.6,168.05,166.45,166.65,167500
BHEL.NS,2016-01-05 13:04:59.0,167.4,167.9,167.3,167.65,58300
BHEL.NS,2016-01-05 13:09:00.0,167.4,167.6,167.2,167.55,17800
BHEL.NS,2016-01-05 13:14:00.0,167.05,167.4,166.8,167.4,25500
BHEL.NS,2016-01-05 13:19:17.0,167.0,167.15,166.8,167.1,12000
BHEL.NS,2016-01-05 13:24:04.0,167.0,167.1,166.85,166.95,13200
BHEL.NS,2016-01-05 13:29:11.0,166.85,167.0,166.45,167.0,28500
BHEL.NS,2016-01-05 13:34:01.0,166.9,166.95,166.6,166.75,12600
BHEL.NS,2016-01-05 13:39:00.0,166.85,167.1,166.8,166.9,10400
BHEL.NS,2016-01-05 13:44:59.0,166.6,167.0,166.3,166.85,25000
BHEL.NS,2016-01-05 13:49:04.0,166.55,166.65,166.4,166.5,8200
BHEL.NS,2016-01-05 13:54:03.0,166.5,166.75,166.35,166.65,7300
BHEL.NS,2016-01-05 13:59:59.0,166.45,166.65,166.4,166.55,9600
BHEL.NS,2016-01-05 14:04:59.0,166.55,166.7,166.45,166.45,9200
BHEL.NS,2016-01-05 14:09:00.0,167.15,167.25,166.5,166.65,34200
BHEL.NS,2016-01-05 14:14:04.0,167.45,167.45,167.0,167.15,25400
BHEL.NS,2016-01-05 14:19:07.0,167.25,167.5,167.15,167.4,21400
BHEL.NS,2016-01-05 14:24:08.0,167.15,167.25,167.05,167.25,9100
BHEL.NS,2016-01-05 14:29:00.0,166.9,167.15,166.85,167.05,14900
BHEL.NS,2016-01-05 14:34:01.0,166.95,167.2,166.8,166.9,20000
BHEL.NS,2016-01-05 14:39:00.0,166.5,166.9,166.4,166.8,17500
BHEL.NS,2016-01-05 14:44:59.0,166.0,166.45,166.0,166.45,32300
BHEL.NS,2016-01-05 14:49:59.0,166.25,166.3,165.95,166.1,26800
BHEL.NS,2016-01-05 14:54:59.0,166.4,166.4,166.0,166.25,18900
BHEL.NS,2016-01-05 14:59:01.0,166.6,166.8,166.2,166.4,31000
BHEL.NS,2016-01-05 15:04:02.0,166.5,166.6,166.35,166.6,19100
BHEL.NS,2016-01-05 15:09:00.0,166.5,166.6,166.2,166.4,34900
BHEL.NS,2016-01-05 15:14:03.0,166.5,166.5,166.1,166.45,43500
BHEL.NS,2016-01-05 15:19:00.0,166.2,166.55,166.15,166.5,69800
BHEL.NS,2016-01-05 15:24:00.0,166.3,166.45,166.2,166.25,38300
BHEL.NS,2016-01-05 15:29:00.0,166.05,166.35,166.0,166.3,45600
BHEL.NS,2016-01-06 09:19:59.0,167.9,168.05,166.4,167.1,0
BHEL.NS,2016-01-06 09:24:05.0,167.65,168.0,167.5,167.85,57200
BHEL.NS,2016-01-06 09:29:59.0,167.45,167.8,167.3,167.7,30900
BHEL.NS,2016-01-06 09:34:01.0,167.5,167.65,167.3,167.5,17300
BHEL.NS,2016-01-06 09:39:03.0,167.2,167.5,167.05,167.5,36200
BHEL.NS,2016-01-06 09:44:01.0,166.8,167.3,166.6,167.1,38400
BHEL.NS,2016-01-06 09:49:59.0,166.8,167.05,166.7,166.7,30500
BHEL.NS,2016-01-06 09:54:59.0,167.05,167.2,166.75,166.75,37700
BHEL.NS,2016-01-06 09:59:03.0,166.8,167.1,166.5,167.05,77300
BHEL.NS,2016-01-06 10:04:59.0,166.8,166.85,166.5,166.8,30500
BHEL.NS,2016-01-06 10:09:02.0,166.7,166.85,166.6,166.8,17900
BHEL.NS,2016-01-06 10:14:01.0,166.3,166.8,166.15,166.7,39100
BHEL.NS,2016-01-06 10:19:01.0,166.65,166.65,166.3,166.35,18400
BHEL.NS,2016-01-06 10:24:02.0,166.65,166.75,166.45,166.55,23400
BHEL.NS,2016-01-06 10:29:02.0,166.6,166.9,166.55,166.65,25800
BHEL.NS,2016-01-06 10:34:00.0,166.65,166.8,166.55,166.6,15100
BHEL.NS,2016-01-06 10:39:00.0,166.6,166.8,166.6,166.6,17400
BHEL.NS,2016-01-06 10:44:02.0,166.65,166.85,166.5,166.6,13700
BHEL.NS,2016-01-06 10:49:01.0,166.95,166.95,166.6,166.65,11600
BHEL.NS,2016-01-06 10:54:01.0,167.0,167.1,166.75,166.8,18100
BHEL.NS,2016-01-06 10:59:02.0,166.9,167.1,166.85,166.95,13500
BHEL.NS,2016-01-06 11:04:01.0,166.95,167.05,166.9,166.9,10100
BHEL.NS,2016-01-06 11:09:00.0,166.7,167.1,166.7,166.95,20500
BHEL.NS,2016-01-06 11:14:03.0,166.45,166.75,166.45,166.75,38900
BHEL.NS,2016-01-06 11:19:58.0,166.45,166.55,166.45,166.5,69800
BHEL.NS,2016-01-06 11:24:00.0,166.5,166.65,166.45,166.45,14500
BHEL.NS,2016-01-06 11:29:04.0,166.7,166.8,166.55,166.65,13000
BHEL.NS,2016-01-06 11:34:01.0,166.7,166.75,166.45,166.55,16000
BHEL.NS,2016-01-06 11:39:01.0,166.65,166.75,166.5,166.7,10000
BHEL.NS,2016-01-06 11:44:03.0,167.25,167.5,166.55,166.55,79000
BHEL.NS,2016-01-06 11:49:00.0,167.45,167.5,167.1,167.25,27100
BHEL.NS,2016-01-06 11:54:00.0,167.6,167.8,167.25,167.4,44600
BHEL.NS,2016-01-06 11:59:01.0,167.65,167.9,167.3,167.6,37200
BHEL.NS,2016-01-06 12:04:01.0,167.5,167.8,167.5,167.55,29100
BHEL.NS,2016-01-06 12:09:01.0,167.65,167.65,167.5,167.5,15500
BHEL.NS,2016-01-06 12:14:02.0,167.65,167.75,167.5,167.6,14100
BHEL.NS,2016-01-06 12:19:00.0,167.6,167.7,167.5,167.65,10100
BHEL.NS,2016-01-06 12:24:12.0,167.5,167.7,167.5,167.6,11100
BHEL.NS,2016-01-06 12:29:00.0,167.6,167.7,167.5,167.55,9000
BHEL.NS,2016-01-06 12:34:59.0,167.65,167.65,167.5,167.5,10100
BHEL.NS,2016-01-06 12:39:00.0,167.6,167.7,167.35,167.65,13900
BHEL.NS,2016-01-06 12:44:59.0,167.5,167.6,167.3,167.6,20300
BHEL.NS,2016-01-06 12:49:59.0,167.5,167.55,167.15,167.5,30800
BHEL.NS,2016-01-06 12:54:59.0,167.35,167.6,167.35,167.5,52700
BHEL.NS,2016-01-06 12:59:59.0,167.5,167.65,167.25,167.4,44800
BHEL.NS,2016-01-06 13:04:00.0,167.7,167.8,167.3,167.45,20300
BHEL.NS,2016-01-06 13:09:01.0,167.6,167.7,167.45,167.7,7500
BHEL.NS,2016-01-06 13:14:01.0,168.0,168.0,167.5,167.6,58400
BHEL.NS,2016-01-06 13:19:59.0,168.3,168.6,167.75,168.0,90700
BHEL.NS,2016-01-06 13:24:01.0,168.3,168.45,168.2,168.3,40200
BHEL.NS,2016-01-06 13:29:01.0,168.15,168.8,168.15,168.25,60500
BHEL.NS,2016-01-06 13:34:02.0,168.3,168.45,168.05,168.25,27300
BHEL.NS,2016-01-06 13:39:01.0,167.8,168.3,167.8,168.2,17700
BHEL.NS,2016-01-06 13:44:00.0,167.65,167.85,167.5,167.8,27300
BHEL.NS,2016-01-06 13:49:01.0,167.65,167.75,167.55,167.7,14300
BHEL.NS,2016-01-06 13:54:02.0,167.4,167.65,167.25,167.65,32000
BHEL.NS,2016-01-06 13:59:02.0,166.35,167.4,166.35,167.4,91200
BHEL.NS,2016-01-06 14:04:59.0,165.85,166.5,165.25,166.35,113100
BHEL.NS,2016-01-06 14:09:00.0,165.75,166.0,165.6,165.85,48000
BHEL.NS,2016-01-06 14:14:00.0,165.9,166.0,165.6,165.75,51100
BHEL.NS,2016-01-06 14:19:01.0,166.0,166.15,165.6,165.8,55700
BHEL.NS,2016-01-06 14:24:04.0,166.25,166.3,166.0,166.15,30700
BHEL.NS,2016-01-06 14:29:00.0,166.1,166.3,166.1,166.25,15900
BHEL.NS,2016-01-06 14:34:00.0,166.05,166.3,166.05,166.1,14000
BHEL.NS,2016-01-06 14:39:01.0,166.05,166.2,166.0,166.05,22600
BHEL.NS,2016-01-06 14:44:59.0,166.1,166.25,166.1,166.1,9900
BHEL.NS,2016-01-06 14:49:00.0,166.2,166.25,166.1,166.1,12900
BHEL.NS,2016-01-06 14:54:03.0,166.25,166.25,166.1,166.2,21000
BHEL.NS,2016-01-06 14:59:01.0,166.3,166.35,166.2,166.2,12400
BHEL.NS,2016-01-06 15:04:58.0,166.0,166.3,166.0,166.3,21200
BHEL.NS,2016-01-06 15:09:02.0,165.6,166.1,165.5,166.1,44800
BHEL.NS,2016-01-06 15:14:00.0,165.2,165.7,165.2,165.6,50600
BHEL.NS,2016-01-06 15:19:59.0,165.8,165.8,165.25,165.3,67900
BHEL.NS,2016-01-06 15:24:59.0,165.75,166.0,165.6,165.8,49100
BHEL.NS,2016-01-06 15:29:59.0,165.2,165.85,165.2,165.85,35900
BHEL.NS,2016-01-06 15:30:00.0,165.25,165.25,165.25,165.25,0
BHEL.NS,2016-01-07 09:19:59.0,162.15,164.05,161.1,164.05,0
BHEL.NS,2016-01-07 09:24:59.0,162.1,162.25,162.0,162.2,60700
BHEL.NS,2016-01-07 09:29:00.0,161.25,162.15,160.2,162.15,146000
BHEL.NS,2016-01-07 09:34:59.0,161.4,161.6,161.05,161.25,52700
BHEL.NS,2016-01-07 09:39:00.0,161.4,161.6,161.05,161.25,53400
BHEL.NS,2016-01-07 09:44:01.0,161.25,161.5,161.1,161.3,20900
BHEL.NS,2016-01-07 09:49:01.0,160.95,161.25,160.7,161.25,62700
BHEL.NS,2016-01-07 09:54:00.0,161.2,161.25,160.9,160.95,27100
BHEL.NS,2016-01-07 09:59:02.0,161.05,161.2,160.9,161.1,23700
BHEL.NS,2016-01-07 10:04:58.0,161.15,161.3,160.95,161.1,18100
BHEL.NS,2016-01-07 10:09:59.0,161.3,161.35,161.0,161.1,24700
BHEL.NS,2016-01-07 10:14:01.0,161.25,161.4,160.95,161.3,23600
BHEL.NS,2016-01-07 10:19:01.0,161.05,161.25,160.85,161.15,24900
BHEL.NS,2016-01-07 10:24:01.0,161.0,161.15,161.0,161.0,31700
BHEL.NS,2016-01-07 10:29:59.0,160.35,161.0,160.0,161.0,119300
BHEL.NS,2016-01-07 10:34:59.0,159.7,160.4,159.35,160.35,126400
BHEL.NS,2016-01-07 10:39:00.0,159.8,159.9,159.35,159.65,46600
BHEL.NS,2016-01-07 10:44:04.0,159.9,160.0,159.55,159.8,24700
BHEL.NS,2016-01-07 10:49:01.0,159.95,160.0,159.7,159.9,32300
BHEL.NS,2016-01-07 10:54:59.0,160.1,160.1,159.7,159.85,24800
BHEL.NS,2016-01-07 10:59:00.0,160.15,160.15,159.8,160.0,23800
BHEL.NS,2016-01-07 11:04:58.0,159.7,160.2,159.5,160.15,32600
BHEL.NS,2016-01-07 11:09:59.0,159.55,159.9,159.5,159.7,33300
BHEL.NS,2016-01-07 11:14:00.0,158.85,159.7,158.55,159.6,100800
BHEL.NS,2016-01-07 11:19:00.0,158.7,158.9,158.5,158.8,50900
BHEL.NS,2016-01-07 11:24:00.0,158.1,158.9,158.05,158.7,61900
BHEL.NS,2016-01-07 11:29:00.0,157.35,158.15,156.55,158.05,196100
BHEL.NS,2016-01-07 11:34:01.0,157.05,157.5,156.9,157.4,62600
BHEL.NS,2016-01-07 11:39:00.0,156.25,157.05,156.1,157.0,84000
BHEL.NS,2016-01-07 11:44:59.0,156.4,156.75,156.2,156.5,72200
BHEL.NS,2016-01-07 11:49:59.0,156.5,156.55,156.0,156.2,76900
BHEL.NS,2016-01-07 11:54:01.0,156.25,156.75,156.2,156.5,63600
BHEL.NS,2016-01-07 11:59:00.0,156.1,156.25,155.6,156.25,75200
BHEL.NS,2016-01-07 12:04:59.0,155.95,156.4,155.85,156.1,66000
BHEL.NS,2016-01-07 12:09:00.0,155.7,156.15,155.65,155.9,51400
BHEL.NS,2016-01-07 12:14:00.0,155.3,155.7,155.0,155.7,123500
BHEL.NS,2016-01-07 12:19:59.0,155.85,155.9,155.2,155.25,44700
BHEL.NS,2016-01-07 12:24:59.0,156.1,156.2,155.7,155.85,45200
BHEL.NS,2016-01-07 12:29:01.0,155.8,156.2,155.8,156.15,41400
BHEL.NS,2016-01-07 12:34:00.0,155.85,156.1,155.8,155.9,26100
BHEL.NS,2016-01-07 12:39:02.0,155.95,156.15,155.8,155.8,16900
BHEL.NS,2016-01-07 12:44:59.0,155.8,156.0,155.6,155.95,23800
BHEL.NS,2016-01-07 12:49:00.0,155.9,156.0,155.8,155.9,22100
BHEL.NS,2016-01-07 12:54:09.0,156.1,156.15,155.85,155.85,29500
BHEL.NS,2016-01-07 12:59:01.0,156.2,156.3,156.0,156.1,29900
BHEL.NS,2016-01-07 13:04:00.0,156.2,156.4,156.0,156.2,34900
BHEL.NS,2016-01-07 13:09:01.0,156.0,156.3,156.0,156.1,27200
BHEL.NS,2016-01-07 13:14:59.0,155.95,156.15,155.75,156.05,31000
BHEL.NS,2016-01-07 13:19:58.0,155.5,155.85,155.5,155.85,42500
BHEL.NS,2016-01-07 13:24:00.0,155.7,155.8,155.5,155.5,21200
BHEL.NS,2016-01-07 13:29:01.0,155.6,155.7,155.5,155.65,25100
BHEL.NS,2016-01-07 13:34:02.0,155.75,155.8,155.5,155.6,34800
BHEL.NS,2016-01-07 13:39:02.0,155.75,156.0,155.5,155.85,38200
BHEL.NS,2016-01-07 13:44:00.0,156.6,156.95,155.7,155.75,99400
BHEL.NS,2016-01-07 13:49:01.0,156.6,156.9,156.5,156.5,45100
BHEL.NS,2016-01-07 13:54:59.0,156.7,156.75,156.4,156.6,36000
BHEL.NS,2016-01-07 13:59:00.0,156.55,156.85,156.45,156.6,27100
BHEL.NS,2016-01-07 14:04:00.0,156.2,156.65,156.2,156.55,24700
BHEL.NS,2016-01-07 14:09:01.0,155.8,156.25,155.1,156.15,115500
BHEL.NS,2016-01-07 14:14:59.0,155.9,155.9,155.65,155.8,29200
BHEL.NS,2016-01-07 14:19:00.0,156.25,156.45,155.8,155.9,56500
BHEL.NS,2016-01-07 14:24:01.0,155.7,156.3,155.6,156.15,27500
BHEL.NS,2016-01-07 14:29:01.0,155.55,155.9,155.4,155.75,47400
BHEL.NS,2016-01-07 14:34:59.0,155.35,155.65,155.35,155.55,39200
BHEL.NS,2016-01-07 14:39:59.0,155.1,155.5,155.05,155.4,58100
BHEL.NS,2016-01-07 14:44:00.0,154.9,155.15,154.25,155.1,195200
BHEL.NS,2016-01-07 14:49:02.0,154.65,154.95,154.55,154.95,38400
BHEL.NS,2016-01-07 14:54:00.0,154.1,154.65,154.0,154.65,119300
BHEL.NS,2016-01-07 14:59:00.0,153.85,154.15,153.1,154.15,134700
BHEL.NS,2016-01-07 15:04:59.0,153.75,154.0,153.65,153.85,150500
BHEL.NS,2016-01-07 15:09:59.0,153.9,154.0,153.7,153.75,130700
BHEL.NS,2016-01-07 15:14:59.0,153.6,154.1,153.35,153.9,200300
BHEL.NS,2016-01-07 15:19:59.0,153.6,153.8,153.1,153.55,221200
BHEL.NS,2016-01-07 15:24:59.0,154.35,154.35,153.5,153.6,190000
BHEL.NS,2016-01-07 15:29:59.0,153.9,154.55,153.5,154.35,155500
BHEL.NS,2016-01-07 15:30:00.0,153.95,153.95,153.95,153.95,0
BHEL.NS,2016-01-08 09:19:00.0,155.5,156.35,154.7,156.2,0
BHEL.NS,2016-01-08 09:24:59.0,155.6,156.0,155.1,155.55,113400
BHEL.NS,2016-01-08 09:29:59.0,155.4,155.65,155.1,155.65,72400
BHEL.NS,2016-01-08 09:34:59.0,155.6,155.7,155.2,155.4,41500
BHEL.NS,2016-01-08 09:39:59.0,154.7,155.7,154.7,155.6,55200
BHEL.NS,2016-01-08 09:44:00.0,154.6,154.85,154.3,154.85,70900
BHEL.NS,2016-01-08 09:49:01.0,155.15,155.35,154.55,154.6,57200
BHEL.NS,2016-01-08 09:54:59.0,154.65,155.25,154.65,155.1,40900
BHEL.NS,2016-01-08 09:59:00.0,154.6,154.85,154.55,154.7,52800
BHEL.NS,2016-01-08 10:04:59.0,153.0,154.7,152.7,154.6,172600
BHEL.NS,2016-01-08 10:09:02.0,153.3,153.5,152.85,153.0,76400
BHEL.NS,2016-01-08 10:14:02.0,152.9,153.3,152.4,153.3,107600
BHEL.NS,2016-01-08 10:19:02.0,153.4,153.4,152.75,152.9,61700
BHEL.NS,2016-01-08 10:24:59.0,153.15,153.35,152.8,153.25,33300
BHEL.NS,2016-01-08 10:29:00.0,153.2,153.3,153.0,153.1,40100
BHEL.NS,2016-01-08 10:34:00.0,153.45,153.45,153.1,153.15,34200
BHEL.NS,2016-01-08 10:39:02.0,153.55,153.95,153.3,153.4,34400
BHEL.NS,2016-01-08 10:44:00.0,153.35,153.55,153.1,153.55,29200
BHEL.NS,2016-01-08 10:49:04.0,153.35,153.5,153.2,153.35,18200
BHEL.NS,2016-01-08 10:54:04.0,153.45,153.5,153.25,153.35,20000
BHEL.NS,2016-01-08 10:59:02.0,153.5,153.7,153.3,153.5,22200
BHEL.NS,2016-01-08 11:04:59.0,153.3,153.5,153.1,153.45,22200
BHEL.NS,2016-01-08 11:09:00.0,153.15,153.4,153.1,153.4,17700
BHEL.NS,2016-01-08 11:14:06.0,153.35,153.45,153.0,153.15,37300
BHEL.NS,2016-01-08 11:19:00.0,154.35,154.35,153.3,153.35,54600
BHEL.NS,2016-01-08 11:24:01.0,154.1,154.5,154.0,154.2,29900
BHEL.NS,2016-01-08 11:29:02.0,153.75,154.15,153.45,154.1,32200
BHEL.NS,2016-01-08 11:34:00.0,154.05,154.2,153.75,153.75,22600
BHEL.NS,2016-01-08 11:39:59.0,154.25,154.5,154.05,154.05,33300
BHEL.NS,2016-01-08 11:44:06.0,154.4,154.85,154.25,154.3,37600
BHEL.NS,2016-01-08 11:49:03.0,154.3,154.55,154.2,154.3,42800
BHEL.NS,2016-01-08 11:54:59.0,154.0,154.45,154.0,154.3,18500
BHEL.NS,2016-01-08 11:59:04.0,154.15,154.25,154.0,154.1,11500
BHEL.NS,2016-01-08 12:04:03.0,154.25,154.4,154.05,154.1,18400
BHEL.NS,2016-01-08 12:09:03.0,154.35,154.4,154.1,154.2,10100
BHEL.NS,2016-01-08 12:14:04.0,154.15,154.35,154.05,154.2,13900
BHEL.NS,2016-01-08 12:19:02.0,154.0,154.25,153.8,154.1,14500
BHEL.NS,2016-01-08 12:24:18.0,153.7,154.0,153.6,153.9,16900
BHEL.NS,2016-01-08 12:29:04.0,153.4,153.8,153.2,153.65,19700
BHEL.NS,2016-01-08 12:34:58.0,153.85,153.9,153.25,153.35,23100
BHEL.NS,2016-01-08 12:39:00.0,154.4,154.4,153.75,153.85,34000
BHEL.NS,2016-01-08 12:44:00.0,154.3,154.45,154.15,154.45,22200
BHEL.NS,2016-01-08 12:49:00.0,154.45,154.6,154.2,154.25,25100
BHEL.NS,2016-01-08 12:54:06.0,154.6,154.6,154.25,154.5,16600
BHEL.NS,2016-01-08 12:59:00.0,154.6,154.75,154.5,154.6,14700
BHEL.NS,2016-01-08 13:04:01.0,154.5,154.6,154.35,154.6,23400
BHEL.NS,2016-01-08 13:09:01.0,154.85,154.9,154.5,154.5,23400
BHEL.NS,2016-01-08 13:14:00.0,154.85,155.05,154.65,154.8,21600
BHEL.NS,2016-01-08 13:19:00.0,154.9,155.05,154.85,154.85,20100
BHEL.NS,2016-01-08 13:24:59.0,154.8,155.0,154.75,155.0,15900
BHEL.NS,2016-01-08 13:29:01.0,154.6,154.8,154.5,154.8,20200
BHEL.NS,2016-01-08 13:34:04.0,154.45,154.85,154.3,154.75,14800
BHEL.NS,2016-01-08 13:39:57.0,154.3,154.6,154.1,154.5,18400
BHEL.NS,2016-01-08 13:44:06.0,154.1,154.35,153.8,154.3,18400
BHEL.NS,2016-01-08 13:49:05.0,154.2,154.3,153.9,153.9,18400
BHEL.NS,2016-01-08 13:54:59.0,154.65,154.65,154.2,154.35,16200
BHEL.NS,2016-01-08 13:59:01.0,154.75,154.9,154.6,154.65,19900
BHEL.NS,2016-01-08 14:04:01.0,154.65,154.95,154.6,154.8,29200
BHEL.NS,2016-01-08 14:09:01.0,154.7,155.0,154.65,154.75,29200
BHEL.NS,2016-01-08 14:14:08.0,154.95,154.95,154.65,154.65,16700
BHEL.NS,2016-01-08 14:19:05.0,154.85,155.0,154.75,155.0,13300
BHEL.NS,2016-01-08 14:24:00.0,154.95,155.4,154.75,154.8,38100
BHEL.NS,2016-01-08 14:29:02.0,154.85,155.1,154.75,154.95,18300
BHEL.NS,2016-01-08 14:34:59.0,154.4,154.9,154.1,154.75,37800
BHEL.NS,2016-01-08 14:39:13.0,154.4,154.5,154.2,154.4,27400
BHEL.NS,2016-01-08 14:44:01.0,154.25,154.4,154.1,154.35,13100
BHEL.NS,2016-01-08 14:49:00.0,154.45,154.5,154.2,154.25,16200
BHEL.NS,2016-01-08 14:54:00.0,154.7,154.7,154.45,154.5,16200
BHEL.NS,2016-01-08 14:59:59.0,154.15,154.7,154.1,154.7,31000
BHEL.NS,2016-01-08 15:04:04.0,153.95,154.3,153.8,154.1,73000
BHEL.NS,2016-01-08 15:09:03.0,153.8,154.2,153.8,154.0,57200
BHEL.NS,2016-01-08 15:14:03.0,153.4,153.95,153.0,153.75,142300
BHEL.NS,2016-01-08 15:19:01.0,153.65,153.75,153.1,153.5,88700
BHEL.NS,2016-01-08 15:24:00.0,153.5,153.7,153.35,153.6,69200
BHEL.NS,2016-01-08 15:29:59.0,153.55,153.9,153.2,153.5,90500
BHEL.NS,2016-01-08 15:30:00.0,153.7,153.7,153.7,153.7,0

Built with D3 and D3-Legend

Powered by Sclera