PREVIEW / stock_1hour / 2013-06-28

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-06-28.parquet
  size:    1.0 MB
  rows:    47,267
  symbols: 3,505

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-28 04:00:00	AAPL	Stock	14.0696	14.0696	14.0646	14.0646	5600.0
2013-06-28 05:00:00	AAPL	Stock	14.0646	14.0696	14.0646	14.0696	25200.0
2013-06-28 06:00:00	AAPL	Stock	14.0486	14.0486	14.0486	14.0486	12320.0
2013-06-28 07:00:00	AAPL	Stock	14.0357	14.1071	14.0325	14.1036	189840.0
2013-06-28 08:00:00	AAPL	Stock	14.0964	14.0982	14.0179	14.0379	1178268.0
2013-06-28 09:00:00	AAPL	Stock	14.0375	14.0393	13.8882	13.9568	81980864.0
2013-06-28 10:00:00	AAPL	Stock	13.9643	14.0321	13.9189	14.0232	66457888.0
2013-06-28 11:00:00	AAPL	Stock	14.0289	14.13	14.0136	14.0693	61700800.0
2013-06-28 12:00:00	AAPL	Stock	14.0689	14.1771	14.0118	14.15	46061064.0
2013-06-28 13:00:00	AAPL	Stock	14.1521	14.2586	14.1429	14.2421	41697012.0
2013-06-28 14:00:00	AAPL	Stock	14.2421	14.2954	14.2036	14.2329	47375328.0
2013-06-28 15:00:00	AAPL	Stock	14.2321	14.2939	14.1332	14.1486	76010956.0
2013-06-28 16:00:00	AAPL	Stock	14.1457	14.2854	14.0539	14.1768	110871012.0
2013-06-28 17:00:00	AAPL	Stock	14.1754	14.1843	14.1431	14.1821	20836088.0
2013-06-28 18:00:00	AAPL	Stock	14.1804	14.1821	14.1786	14.1821	63700.0
2013-06-28 19:00:00	AAPL	Stock	14.1804	14.1857	14.1804	14.1821	95032.0
2013-06-28 08:00:00	MSFT	Stock	34.61	34.63	34.6	34.6	130300.0
2013-06-28 09:00:00	MSFT	Stock	34.6	34.7	34.34	34.59	3585780.0
2013-06-28 10:00:00	MSFT	Stock	34.6	34.62	34.37	34.57	5685319.0
2013-06-28 11:00:00	MSFT	Stock	34.57	34.73	34.535	34.645	2581427.0
2013-06-28 12:00:00	MSFT	Stock	34.65	34.66	34.48	34.48	2207611.0
2013-06-28 13:00:00	MSFT	Stock	34.485	34.715	34.47	34.68	2812093.0
2013-06-28 14:00:00	MSFT	Stock	34.689	34.77	34.63	34.655	2952541.0
2013-06-28 15:00:00	MSFT	Stock	34.657	34.79	34.5	34.55	9188507.0
2013-06-28 16:00:00	MSFT	Stock	34.53	34.75	34.479	34.51	33252813.0
2013-06-28 17:00:00	MSFT	Stock	34.51	34.524	34.49	34.5	2218532.0
2013-06-28 19:00:00	MSFT	Stock	34.67	34.67	34.52	34.52	2751.0
2013-06-28 08:00:00	NVDA	Stock	0.3502	0.3502	0.3502	0.3502	28000.0
2013-06-28 09:00:00	NVDA	Stock	0.3478	0.3522	0.3458	0.3473	70799760.0
2013-06-28 10:00:00	NVDA	Stock	0.3473	0.3518	0.3466	0.351	101712920.0
2013-06-28 11:00:00	NVDA	Stock	0.351	0.3528	0.3505	0.3518	30972480.0
2013-06-28 12:00:00	NVDA	Stock	0.3515	0.3528	0.3502	0.3518	23136560.0
2013-06-28 13:00:00	NVDA	Stock	0.3518	0.353	0.3513	0.3525	24712360.0
2013-06-28 14:00:00	NVDA	Stock	0.3526	0.3541	0.352	0.3521	34513240.0
2013-06-28 15:00:00	NVDA	Stock	0.3521	0.3545	0.3508	0.3508	88991960.0
2013-06-28 16:00:00	NVDA	Stock	0.3508	0.353	0.3502	0.3507	10085480.0
2013-06-28 17:00:00	NVDA	Stock	0.3508	0.351	0.3507	0.351	630040.0
2013-06-28 04:00:00	AMZN	Stock	13.8775	13.8775	13.8775	13.8775	2000.0
2013-06-28 07:00:00	AMZN	Stock	13.8995	13.925	13.8995	13.925	10000.0
2013-06-28 08:00:00	AMZN	Stock	13.91	13.91	13.853	13.853	59860.0
2013-06-28 09:00:00	AMZN	Stock	13.855	13.9655	13.806	13.915	8659460.0
2013-06-28 10:00:00	AMZN	Stock	13.922	13.9835	13.879	13.934	8197540.0
2013-06-28 11:00:00	AMZN	Stock	13.937	13.9787	13.8975	13.908	4400520.0
2013-06-28 12:00:00	AMZN	Stock	13.9069	13.9145	13.8656	13.8905	3258760.0
2013-06-28 13:00:00	AMZN	Stock	13.8995	13.9775	13.88	13.9645	3489160.0
2013-06-28 14:00:00	AMZN	Stock	13.9545	13.975	13.915	13.9375	17650060.0
2013-06-28 15:00:00	AMZN	Stock	13.9345	13.9915	13.877	13.885	8817160.0
2013-06-28 16:00:00	AMZN	Stock	13.879	13.9533	13.8773	13.8925	3107180.0
2013-06-28 17:00:00	AMZN	Stock	13.887	13.8925	13.882	13.882	213720.0
2013-06-28 19:00:00	AMZN	Stock	13.895	13.8965	13.895	13.8965	5060.0

> showing 50 of 47,267 rows — these rows as CSV

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