PREVIEW / stock_1hour / 2013-11-20

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-11-20.parquet
  size:    1.0 MB
  rows:    47,137
  symbols: 3,547

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-11-20 05:00:00	AAPL	Stock	18.5579	18.5579	18.5579	18.5579	2800.0
2013-11-20 06:00:00	AAPL	Stock	18.525	18.5321	18.525	18.5321	5600.0
2013-11-20 07:00:00	AAPL	Stock	18.5321	18.5375	18.505	18.5182	103292.0
2013-11-20 08:00:00	AAPL	Stock	18.5336	18.5821	18.5189	18.5625	357588.0
2013-11-20 09:00:00	AAPL	Stock	18.5625	18.5864	18.4839	18.5	33993568.0
2013-11-20 10:00:00	AAPL	Stock	18.5014	18.56	18.4739	18.525	36100624.0
2013-11-20 11:00:00	AAPL	Stock	18.5243	18.5296	18.4896	18.5032	27554492.0
2013-11-20 12:00:00	AAPL	Stock	18.5032	18.5268	18.4761	18.4911	13201776.0
2013-11-20 13:00:00	AAPL	Stock	18.4907	18.5107	18.4693	18.5032	9021684.0
2013-11-20 14:00:00	AAPL	Stock	18.5032	18.5121	18.4114	18.4411	27483176.0
2013-11-20 15:00:00	AAPL	Stock	18.4354	18.4564	18.3689	18.3932	36416408.0
2013-11-20 16:00:00	AAPL	Stock	18.3929	18.4834	18.3929	18.4071	5967948.0
2013-11-20 17:00:00	AAPL	Stock	18.4061	18.41	18.4046	18.4064	151844.0
2013-11-20 18:00:00	AAPL	Stock	18.41	18.41	18.3929	18.4018	97832.0
2013-11-20 19:00:00	AAPL	Stock	18.4096	18.4096	18.3961	18.4089	164416.0
2013-11-20 08:00:00	MSFT	Stock	36.8	36.83	36.75	36.83	13108.0
2013-11-20 09:00:00	MSFT	Stock	36.83	37.18	36.8	37.1	4563986.0
2013-11-20 10:00:00	MSFT	Stock	37.1	37.41	37.067	37.32	6556346.0
2013-11-20 11:00:00	MSFT	Stock	37.325	37.37	37.203	37.316	3346927.0
2013-11-20 12:00:00	MSFT	Stock	37.31	37.38	37.16	37.17	2191234.0
2013-11-20 13:00:00	MSFT	Stock	37.174	37.21	37.12	37.15	1757936.0
2013-11-20 14:00:00	MSFT	Stock	37.15	37.2	37.0	37.07	4463665.0
2013-11-20 15:00:00	MSFT	Stock	37.08	37.185	36.95	37.08	6078337.0
2013-11-20 16:00:00	MSFT	Stock	37.08	37.267	36.789	37.15	2902562.0
2013-11-20 17:00:00	MSFT	Stock	37.2	37.2	37.02	37.09	2944.0
2013-11-20 18:00:00	MSFT	Stock	37.08	37.08	37.02	37.04	1150.0
2013-11-20 19:00:00	MSFT	Stock	37.08	37.1	37.08	37.1	528.0
2013-11-20 09:00:00	NVDA	Stock	0.3875	0.3875	0.382	0.3848	36751280.0
2013-11-20 10:00:00	NVDA	Stock	0.3846	0.387	0.3838	0.3846	33160600.0
2013-11-20 11:00:00	NVDA	Stock	0.3846	0.3848	0.3834	0.3838	17817280.0
2013-11-20 12:00:00	NVDA	Stock	0.3835	0.3845	0.383	0.384	16851080.0
2013-11-20 13:00:00	NVDA	Stock	0.3838	0.3845	0.3833	0.3835	10801360.0
2013-11-20 14:00:00	NVDA	Stock	0.3833	0.3838	0.381	0.3819	35426200.0
2013-11-20 15:00:00	NVDA	Stock	0.382	0.382	0.3795	0.3803	45458120.0
2013-11-20 16:00:00	NVDA	Stock	0.3805	0.3865	0.3803	0.3805	7449800.0
2013-11-20 08:00:00	AMZN	Stock	18.3175	18.3975	18.264	18.3925	191460.0
2013-11-20 09:00:00	AMZN	Stock	18.38	18.38	18.2125	18.2505	4173740.0
2013-11-20 10:00:00	AMZN	Stock	18.2382	18.375	18.193	18.3432	5834300.0
2013-11-20 11:00:00	AMZN	Stock	18.344	18.3585	18.2875	18.309	3576220.0
2013-11-20 12:00:00	AMZN	Stock	18.309	18.3525	18.2601	18.269	1681680.0
2013-11-20 13:00:00	AMZN	Stock	18.263	18.286	18.2075	18.2625	2241460.0
2013-11-20 14:00:00	AMZN	Stock	18.259	18.2685	18.0696	18.133	5992900.0
2013-11-20 15:00:00	AMZN	Stock	18.1305	18.223	18.0225	18.1195	9660580.0
2013-11-20 16:00:00	AMZN	Stock	18.1285	18.3277	18.05	18.1285	611660.0
2013-11-20 17:00:00	AMZN	Stock	18.15	18.16	18.15	18.16	6000.0
2013-11-20 18:00:00	AMZN	Stock	18.1175	18.125	18.1175	18.125	16500.0
2013-11-20 19:00:00	AMZN	Stock	18.125	18.1675	18.125	18.1675	14000.0
2013-11-20 05:00:00	META	Stock	46.52	46.52	46.52	46.52	100.0
2013-11-20 06:00:00	META	Stock	46.54	46.55	46.2	46.31	5982.0
2013-11-20 07:00:00	META	Stock	46.35	46.45	46.26	46.29	21650.0

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

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