PREVIEW / stock_1hour / 2013-06-05

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-06-05.parquet
  size:    987 KB
  rows:    45,926
  symbols: 3,515

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
2013-06-05 04:00:00	AAPL	Stock	15.9471	15.9686	15.9471	15.9686	9240.0
2013-06-05 05:00:00	AAPL	Stock	15.9664	15.9664	15.9575	15.9575	58576.0
2013-06-05 06:00:00	AAPL	Stock	15.9511	15.9511	15.8946	15.9286	86800.0
2013-06-05 07:00:00	AAPL	Stock	15.9136	15.9443	15.8768	15.9196	423696.0
2013-06-05 08:00:00	AAPL	Stock	15.9143	16.0357	15.8768	15.95	1757700.0
2013-06-05 09:00:00	AAPL	Stock	15.9539	16.0971	15.8957	16.0209	56712348.0
2013-06-05 10:00:00	AAPL	Stock	16.0214	16.0525	15.8929	15.9239	61273156.0
2013-06-05 11:00:00	AAPL	Stock	15.9209	15.9536	15.8468	15.898	40500432.0
2013-06-05 12:00:00	AAPL	Stock	15.9011	15.925	15.8596	15.8771	20990424.0
2013-06-05 13:00:00	AAPL	Stock	15.8707	15.9682	15.8679	15.9141	30818928.0
2013-06-05 14:00:00	AAPL	Stock	15.9089	15.9382	15.8893	15.9225	24261832.0
2013-06-05 15:00:00	AAPL	Stock	15.9179	15.9379	15.8764	15.8982	39739504.0
2013-06-05 16:00:00	AAPL	Stock	15.8968	16.0257	15.8875	15.9	5600756.0
2013-06-05 17:00:00	AAPL	Stock	15.9089	15.9164	15.9036	15.9043	146440.0
2013-06-05 18:00:00	AAPL	Stock	15.9089	15.9107	15.9071	15.9107	103628.0
2013-06-05 19:00:00	AAPL	Stock	15.9139	15.9143	15.9071	15.9143	302680.0
2013-06-05 07:00:00	MSFT	Stock	34.98	34.99	34.65	34.71	111576.0
2013-06-05 08:00:00	MSFT	Stock	34.73	34.8	34.7	34.8	27139.0
2013-06-05 09:00:00	MSFT	Stock	34.81	34.83	34.43	34.8	5968982.0
2013-06-05 10:00:00	MSFT	Stock	34.805	34.89	34.66	34.77	10181977.0
2013-06-05 11:00:00	MSFT	Stock	34.765	34.79	34.58	34.71	5970730.0
2013-06-05 12:00:00	MSFT	Stock	34.715	34.755	34.59	34.64	4608383.0
2013-06-05 13:00:00	MSFT	Stock	34.645	34.81	34.62	34.685	4151664.0
2013-06-05 14:00:00	MSFT	Stock	34.685	34.75	34.64	34.68	3896844.0
2013-06-05 15:00:00	MSFT	Stock	34.675	34.85	34.64	34.78	7988645.0
2013-06-05 16:00:00	MSFT	Stock	34.78	34.82	34.69	34.69	1699071.0
2013-06-05 17:00:00	MSFT	Stock	34.78	34.78	34.78	34.78	105.0
2013-06-05 18:00:00	MSFT	Stock	34.78	34.78	34.75	34.75	2200.0
2013-06-05 19:00:00	MSFT	Stock	34.74	34.78	34.72	34.78	6600.0
2013-06-05 09:00:00	NVDA	Stock	0.3612	0.3639	0.3595	0.3626	25513640.0
2013-06-05 10:00:00	NVDA	Stock	0.3626	0.364	0.3591	0.3598	55480760.0
2013-06-05 11:00:00	NVDA	Stock	0.3598	0.3608	0.3558	0.3572	50720640.0
2013-06-05 12:00:00	NVDA	Stock	0.3572	0.3582	0.3564	0.358	29032480.0
2013-06-05 13:00:00	NVDA	Stock	0.3578	0.3605	0.3575	0.3579	26184040.0
2013-06-05 14:00:00	NVDA	Stock	0.3578	0.358	0.353	0.355	97980320.0
2013-06-05 15:00:00	NVDA	Stock	0.355	0.3578	0.353	0.3535	155832080.0
2013-06-05 16:00:00	NVDA	Stock	0.354	0.3562	0.3538	0.3562	7866560.0
2013-06-05 19:00:00	NVDA	Stock	0.3542	0.3542	0.3542	0.3542	20000.0
2013-06-05 08:00:00	AMZN	Stock	13.3	13.3	13.22	13.2575	66040.0
2013-06-05 09:00:00	AMZN	Stock	13.2625	13.524	13.251	13.515	12370160.0
2013-06-05 10:00:00	AMZN	Stock	13.5155	13.583	13.4425	13.497	15771160.0
2013-06-05 11:00:00	AMZN	Stock	13.491	13.5195	13.35	13.363	9772560.0
2013-06-05 12:00:00	AMZN	Stock	13.3655	13.383	13.287	13.3235	6160640.0
2013-06-05 13:00:00	AMZN	Stock	13.3225	13.4385	13.303	13.4	5894580.0
2013-06-05 14:00:00	AMZN	Stock	13.3978	13.4045	13.318	13.3785	6147620.0
2013-06-05 15:00:00	AMZN	Stock	13.374	13.432	13.339	13.3585	12010580.0
2013-06-05 16:00:00	AMZN	Stock	13.3585	13.5135	13.348	13.35	1983960.0
2013-06-05 17:00:00	AMZN	Stock	13.3585	13.3585	13.3585	13.3585	2000.0
2013-06-05 18:00:00	AMZN	Stock	13.3725	13.387	13.3725	13.3865	8000.0
2013-06-05 19:00:00	AMZN	Stock	13.364	13.37	13.3605	13.37	10240.0

> showing 50 of 45,926 rows — these rows as CSV

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