PREVIEW / stock_1hour / 2016-03-02

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-03-02.parquet
  size:    1.0 MB
  rows:    48,183
  symbols: 3,349

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2016-03-02 04:00:00	AAPL	Stock	25.2125	25.2375	25.2025	25.215	16936.0
2016-03-02 05:00:00	AAPL	Stock	25.215	25.215	25.155	25.155	4360.0
2016-03-02 06:00:00	AAPL	Stock	25.16	25.175	25.1325	25.1625	15596.0
2016-03-02 07:00:00	AAPL	Stock	25.15	25.2125	25.125	25.2125	82004.0
2016-03-02 08:00:00	AAPL	Stock	25.2	25.2125	25.115	25.115	374360.0
2016-03-02 09:00:00	AAPL	Stock	25.115	25.2225	25.0165	25.045	18877648.0
2016-03-02 10:00:00	AAPL	Stock	25.045	25.09	24.92	25.0825	26323908.0
2016-03-02 11:00:00	AAPL	Stock	25.08	25.0925	24.9625	24.984	14937576.0
2016-03-02 12:00:00	AAPL	Stock	24.983	25.055	24.91	25.0225	12223012.0
2016-03-02 13:00:00	AAPL	Stock	25.025	25.1875	24.965	24.9825	7754792.0
2016-03-02 14:00:00	AAPL	Stock	24.9825	25.105	24.9125	25.09	14098104.0
2016-03-02 15:00:00	AAPL	Stock	25.09	25.2125	25.0175	25.1825	19696516.0
2016-03-02 16:00:00	AAPL	Stock	25.1875	25.215	24.9725	25.1725	7874816.0
2016-03-02 17:00:00	AAPL	Stock	25.1875	25.2125	25.175	25.21	67788.0
2016-03-02 18:00:00	AAPL	Stock	25.1875	25.195	25.1675	25.185	64352.0
2016-03-02 19:00:00	AAPL	Stock	25.17	25.1875	25.165	25.175	57660.0
2016-03-02 07:00:00	MSFT	Stock	52.59	52.59	52.59	52.59	100.0
2016-03-02 08:00:00	MSFT	Stock	52.6	52.83	52.42	52.42	8867.0
2016-03-02 09:00:00	MSFT	Stock	52.42	52.66	52.155	52.26	2521840.0
2016-03-02 10:00:00	MSFT	Stock	52.26	52.55	52.16	52.47	3807108.0
2016-03-02 11:00:00	MSFT	Stock	52.46	52.54	52.2	52.33	3205577.0
2016-03-02 12:00:00	MSFT	Stock	52.33	52.48	52.27	52.445	2415268.0
2016-03-02 13:00:00	MSFT	Stock	52.45	52.626	52.3	52.41	1902557.0
2016-03-02 14:00:00	MSFT	Stock	52.4	52.75	52.4	52.735	2326437.0
2016-03-02 15:00:00	MSFT	Stock	52.73	52.96	52.65	52.95	6253350.0
2016-03-02 16:00:00	MSFT	Stock	52.95	52.95	52.88	52.95	4568287.0
2016-03-02 17:00:00	MSFT	Stock	52.88	53.0	52.88	53.0	19601.0
2016-03-02 18:00:00	MSFT	Stock	52.93	52.93	52.93	52.93	200.0
2016-03-02 19:00:00	MSFT	Stock	52.92	52.93	52.92	52.93	3800.0
2016-03-02 08:00:00	NVDA	Stock	0.8225	0.8225	0.8188	0.8188	5420000.0
2016-03-02 09:00:00	NVDA	Stock	0.815	0.8265	0.8128	0.8212	33645840.0
2016-03-02 10:00:00	NVDA	Stock	0.8215	0.8222	0.816	0.8182	33865480.0
2016-03-02 11:00:00	NVDA	Stock	0.8182	0.8205	0.8165	0.8178	27407600.0
2016-03-02 12:00:00	NVDA	Stock	0.8178	0.8185	0.816	0.8181	18103680.0
2016-03-02 13:00:00	NVDA	Stock	0.8182	0.8212	0.8175	0.8185	21236640.0
2016-03-02 14:00:00	NVDA	Stock	0.8185	0.821	0.8175	0.8204	22773280.0
2016-03-02 15:00:00	NVDA	Stock	0.8205	0.8242	0.8203	0.8238	59691920.0
2016-03-02 16:00:00	NVDA	Stock	0.8235	0.8235	0.8208	0.8208	1215120.0
2016-03-02 17:00:00	NVDA	Stock	0.8238	0.8238	0.8238	0.8238	8000.0
2016-03-02 19:00:00	NVDA	Stock	0.8238	0.8238	0.8238	0.8238	4000.0
2016-03-02 04:00:00	AMZN	Stock	29.2	29.2	29.11	29.131	37360.0
2016-03-02 06:00:00	AMZN	Stock	29.05	29.0555	29.0095	29.0485	21000.0
2016-03-02 07:00:00	AMZN	Stock	29.0105	29.115	29.0	29.115	70920.0
2016-03-02 08:00:00	AMZN	Stock	29.0605	29.25	29.052	29.1245	430300.0
2016-03-02 09:00:00	AMZN	Stock	29.096	29.244	28.8843	29.0175	14533500.0
2016-03-02 10:00:00	AMZN	Stock	29.0175	29.25	28.906	29.11	15423000.0
2016-03-02 11:00:00	AMZN	Stock	29.0945	29.1575	28.6895	28.7015	13618660.0
2016-03-02 12:00:00	AMZN	Stock	28.7054	28.875	28.685	28.85	12118800.0
2016-03-02 13:00:00	AMZN	Stock	28.8471	28.873	28.7745	28.775	7817780.0
2016-03-02 14:00:00	AMZN	Stock	28.7705	29.033	28.7065	28.9725	7843820.0

> showing 50 of 48,183 rows — these rows as CSV

> unlock the full archive -- $79 one-time