PREVIEW / stock_1hour / 2015-02-05

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-02-05.parquet
  size:    1.1 MB
  rows:    50,428
  symbols: 3,518

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
2015-02-05 04:00:00	AAPL	Stock	29.84	29.9	29.81	29.8825	56720.0
2015-02-05 05:00:00	AAPL	Stock	29.8875	29.935	29.8825	29.935	42256.0
2015-02-05 06:00:00	AAPL	Stock	29.935	29.975	29.915	29.9375	87276.0
2015-02-05 07:00:00	AAPL	Stock	29.925	29.98	29.925	29.9375	308764.0
2015-02-05 08:00:00	AAPL	Stock	29.95	30.0375	29.9125	30.035	2677224.0
2015-02-05 09:00:00	AAPL	Stock	30.025	30.0512	29.88	29.9448	30094576.0
2015-02-05 10:00:00	AAPL	Stock	29.945	29.9975	29.8375	29.915	27312312.0
2015-02-05 11:00:00	AAPL	Stock	29.915	30.0575	29.8925	29.9625	22281908.0
2015-02-05 12:00:00	AAPL	Stock	29.9625	29.975	29.9112	29.9315	10855576.0
2015-02-05 13:00:00	AAPL	Stock	29.94	29.9825	29.9275	29.9342	9595392.0
2015-02-05 14:00:00	AAPL	Stock	29.9365	29.9725	29.875	29.8902	15335120.0
2015-02-05 15:00:00	AAPL	Stock	29.8925	30.0025	29.8125	29.985	29884640.0
2015-02-05 16:00:00	AAPL	Stock	29.985	30.0065	29.904	29.9375	4829124.0
2015-02-05 17:00:00	AAPL	Stock	29.95	29.985	29.95	29.9675	254308.0
2015-02-05 18:00:00	AAPL	Stock	29.9675	29.99	29.96	29.97	88248.0
2015-02-05 19:00:00	AAPL	Stock	29.9625	29.975	29.9625	29.9725	60964.0
2015-02-05 05:00:00	MSFT	Stock	41.94	42.01	41.94	42.01	3500.0
2015-02-05 06:00:00	MSFT	Stock	41.85	41.85	41.84	41.85	700.0
2015-02-05 07:00:00	MSFT	Stock	41.96	42.05	41.93	42.0	4027.0
2015-02-05 08:00:00	MSFT	Stock	42.01	42.19	42.01	42.02	17828.0
2015-02-05 09:00:00	MSFT	Stock	42.02	42.33	41.855	42.32	4743872.0
2015-02-05 10:00:00	MSFT	Stock	42.32	42.64	42.295	42.54	7038329.0
2015-02-05 11:00:00	MSFT	Stock	42.54	42.58	42.39	42.47	4078713.0
2015-02-05 12:00:00	MSFT	Stock	42.47	42.5	42.25	42.26	4395949.0
2015-02-05 13:00:00	MSFT	Stock	42.26	42.38	42.25	42.35	3097337.0
2015-02-05 14:00:00	MSFT	Stock	42.35	42.424	42.25	42.328	2997046.0
2015-02-05 15:00:00	MSFT	Stock	42.33	42.49	42.28	42.46	6050968.0
2015-02-05 16:00:00	MSFT	Stock	42.44	42.45	42.3	42.395	1747596.0
2015-02-05 17:00:00	MSFT	Stock	42.401	42.45	42.39	42.44	76788.0
2015-02-05 18:00:00	MSFT	Stock	42.351	42.44	42.351	42.4	1440.0
2015-02-05 19:00:00	MSFT	Stock	42.44	42.44	42.38	42.42	2122.0
2015-02-05 09:00:00	NVDA	Stock	0.5045	0.5088	0.504	0.5068	24793360.0
2015-02-05 10:00:00	NVDA	Stock	0.5068	0.5088	0.5048	0.508	25440920.0
2015-02-05 11:00:00	NVDA	Stock	0.5078	0.5093	0.5062	0.5088	15345240.0
2015-02-05 12:00:00	NVDA	Stock	0.5088	0.5094	0.5072	0.508	15084320.0
2015-02-05 13:00:00	NVDA	Stock	0.508	0.5105	0.5078	0.5093	6389440.0
2015-02-05 14:00:00	NVDA	Stock	0.5093	0.51	0.5085	0.5095	12270040.0
2015-02-05 15:00:00	NVDA	Stock	0.5093	0.5125	0.5088	0.5122	29656200.0
2015-02-05 16:00:00	NVDA	Stock	0.512	0.5122	0.5086	0.5121	1806920.0
2015-02-05 17:00:00	NVDA	Stock	0.513	0.513	0.5112	0.5112	88440.0
2015-02-05 04:00:00	AMZN	Stock	18.15	18.15	18.15	18.15	2700.0
2015-02-05 05:00:00	AMZN	Stock	18.2005	18.223	18.2	18.223	14000.0
2015-02-05 06:00:00	AMZN	Stock	18.225	18.225	18.225	18.225	10000.0
2015-02-05 07:00:00	AMZN	Stock	18.232	18.2775	18.232	18.274	97000.0
2015-02-05 08:00:00	AMZN	Stock	18.2575	18.4375	18.155	18.3555	304980.0
2015-02-05 09:00:00	AMZN	Stock	18.3695	18.643	18.295	18.6085	24756120.0
2015-02-05 10:00:00	AMZN	Stock	18.6175	18.85	18.591	18.8329	32828360.0
2015-02-05 11:00:00	AMZN	Stock	18.8352	18.8735	18.7575	18.836	18060220.0
2015-02-05 12:00:00	AMZN	Stock	18.8342	18.8855	18.775	18.8	11044860.0
2015-02-05 13:00:00	AMZN	Stock	18.8	18.94	18.756	18.8883	11398680.0

> showing 50 of 50,428 rows — these rows as CSV

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