PREVIEW / stock_1hour / 2014-03-10

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-03-10.parquet
  size:    1.0 MB
  rows:    48,391
  symbols: 3,527

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
2014-03-10 04:00:00	AAPL	Stock	18.9089	18.9107	18.9089	18.9107	5600.0
2014-03-10 05:00:00	AAPL	Stock	18.9421	18.9421	18.9421	18.9421	2800.0
2014-03-10 06:00:00	AAPL	Stock	18.9304	18.9304	18.9304	18.9304	2800.0
2014-03-10 07:00:00	AAPL	Stock	18.9286	18.9429	18.9286	18.9321	17780.0
2014-03-10 08:00:00	AAPL	Stock	18.9196	18.9425	18.8707	18.8732	592144.0
2014-03-10 09:00:00	AAPL	Stock	18.8764	19.0325	18.86	19.0095	30675988.0
2014-03-10 10:00:00	AAPL	Stock	19.0129	19.0132	18.9257	18.9351	25508616.0
2014-03-10 11:00:00	AAPL	Stock	18.9379	19.0475	18.9071	19.0136	24043796.0
2014-03-10 12:00:00	AAPL	Stock	19.0136	19.0354	18.9739	19.0246	13092156.0
2014-03-10 13:00:00	AAPL	Stock	19.0232	19.0321	18.9493	18.9704	13126988.0
2014-03-10 14:00:00	AAPL	Stock	18.9671	18.9996	18.94	18.9811	11727716.0
2014-03-10 15:00:00	AAPL	Stock	18.9821	18.9957	18.9486	18.9614	21494536.0
2014-03-10 16:00:00	AAPL	Stock	18.9614	19.0082	18.9336	18.955	6166216.0
2014-03-10 17:00:00	AAPL	Stock	18.9532	18.9614	18.9379	18.9571	126280.0
2014-03-10 18:00:00	AAPL	Stock	18.9429	18.9614	18.9429	18.9614	105868.0
2014-03-10 19:00:00	AAPL	Stock	18.9518	18.9518	18.9375	18.9375	43484.0
2014-03-10 06:00:00	MSFT	Stock	37.84	37.84	37.78	37.78	487.0
2014-03-10 07:00:00	MSFT	Stock	37.75	37.75	37.75	37.75	2700.0
2014-03-10 08:00:00	MSFT	Stock	37.82	37.88	37.76	37.8	4195.0
2014-03-10 09:00:00	MSFT	Stock	37.82	38.01	37.79	37.898	1592966.0
2014-03-10 10:00:00	MSFT	Stock	37.89	37.9	37.72	37.83	3405784.0
2014-03-10 11:00:00	MSFT	Stock	37.82	37.88	37.78	37.819	1871194.0
2014-03-10 12:00:00	MSFT	Stock	37.81	37.89	37.78	37.87	1909706.0
2014-03-10 13:00:00	MSFT	Stock	37.87	37.9	37.77	37.81	1676695.0
2014-03-10 14:00:00	MSFT	Stock	37.81	37.85	37.8	37.83	1149251.0
2014-03-10 15:00:00	MSFT	Stock	37.83	37.895	37.79	37.82	3742086.0
2014-03-10 16:00:00	MSFT	Stock	37.81	37.94	37.81	37.94	2948945.0
2014-03-10 17:00:00	MSFT	Stock	37.81	37.83	37.81	37.83	47687.0
2014-03-10 19:00:00	MSFT	Stock	37.82	37.82	37.81	37.81	1070.0
2014-03-10 09:00:00	NVDA	Stock	0.455	0.4595	0.455	0.4585	17519920.0
2014-03-10 10:00:00	NVDA	Stock	0.4582	0.4588	0.452	0.4525	31661160.0
2014-03-10 11:00:00	NVDA	Stock	0.4523	0.4545	0.4515	0.4538	22499960.0
2014-03-10 12:00:00	NVDA	Stock	0.4538	0.4548	0.4528	0.4535	18282840.0
2014-03-10 13:00:00	NVDA	Stock	0.4534	0.4542	0.4523	0.4525	15859600.0
2014-03-10 14:00:00	NVDA	Stock	0.4525	0.4528	0.4502	0.4524	25398240.0
2014-03-10 15:00:00	NVDA	Stock	0.4522	0.4524	0.4508	0.4521	83011560.0
2014-03-10 16:00:00	NVDA	Stock	0.4522	0.4525	0.4522	0.4522	13970080.0
2014-03-10 17:00:00	NVDA	Stock	0.4545	0.4545	0.4545	0.4545	16000.0
2014-03-10 19:00:00	NVDA	Stock	0.4528	0.4528	0.4528	0.4528	4000.0
2014-03-10 05:00:00	AMZN	Stock	18.6495	18.7125	18.6495	18.712	22000.0
2014-03-10 06:00:00	AMZN	Stock	18.6125	18.62	18.6	18.6175	10000.0
2014-03-10 07:00:00	AMZN	Stock	18.6225	18.6455	18.6225	18.6455	4000.0
2014-03-10 08:00:00	AMZN	Stock	18.575	18.628	18.575	18.5855	93900.0
2014-03-10 09:00:00	AMZN	Stock	18.6015	18.6365	18.505	18.5125	3905540.0
2014-03-10 10:00:00	AMZN	Stock	18.5148	18.5195	18.35	18.408	8665340.0
2014-03-10 11:00:00	AMZN	Stock	18.416	18.475	18.3925	18.456	5170320.0
2014-03-10 12:00:00	AMZN	Stock	18.4618	18.5265	18.431	18.5205	4540760.0
2014-03-10 13:00:00	AMZN	Stock	18.525	18.5485	18.4395	18.4673	4779260.0
2014-03-10 14:00:00	AMZN	Stock	18.4665	18.51	18.4535	18.4925	2555100.0
2014-03-10 15:00:00	AMZN	Stock	18.4925	18.5525	18.4445	18.5255	5736760.0

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

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