PREVIEW / stock_1hour / 2016-05-18

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-05-18.parquet
  size:    1.0 MB
  rows:    47,968
  symbols: 3,302

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
2016-05-18 04:00:00	AAPL	Stock	23.4625	23.475	23.4225	23.45	14356.0
2016-05-18 05:00:00	AAPL	Stock	23.4375	23.505	23.4375	23.505	20056.0
2016-05-18 06:00:00	AAPL	Stock	23.505	23.52	23.475	23.475	7040.0
2016-05-18 07:00:00	AAPL	Stock	23.4575	23.4925	23.4375	23.4625	66408.0
2016-05-18 08:00:00	AAPL	Stock	23.4625	23.4875	23.395	23.43	277952.0
2016-05-18 09:00:00	AAPL	Stock	23.4275	23.67	23.375	23.5875	25604504.0
2016-05-18 10:00:00	AAPL	Stock	23.5875	23.755	23.5485	23.655	25035832.0
2016-05-18 11:00:00	AAPL	Stock	23.6575	23.7275	23.6275	23.685	16053796.0
2016-05-18 12:00:00	AAPL	Stock	23.6875	23.7225	23.615	23.7202	13617004.0
2016-05-18 13:00:00	AAPL	Stock	23.7225	23.8025	23.7175	23.7475	14847892.0
2016-05-18 14:00:00	AAPL	Stock	23.7475	23.75	23.5125	23.6175	27518836.0
2016-05-18 15:00:00	AAPL	Stock	23.6175	23.695	23.5475	23.6425	23677308.0
2016-05-18 16:00:00	AAPL	Stock	23.64	23.6875	23.6275	23.68	9582876.0
2016-05-18 17:00:00	AAPL	Stock	23.675	23.6825	23.65	23.675	43028.0
2016-05-18 18:00:00	AAPL	Stock	23.675	23.695	23.66	23.68	81880.0
2016-05-18 19:00:00	AAPL	Stock	23.68	23.7	23.68	23.6925	57188.0
2016-05-18 06:00:00	MSFT	Stock	50.48	50.48	50.48	50.48	2600.0
2016-05-18 07:00:00	MSFT	Stock	50.48	50.5	50.48	50.48	2100.0
2016-05-18 08:00:00	MSFT	Stock	50.48	50.48	50.3	50.3	6288.0
2016-05-18 09:00:00	MSFT	Stock	50.3	50.55	50.26	50.385	1893242.0
2016-05-18 10:00:00	MSFT	Stock	50.385	50.96	50.36	50.81	2850551.0
2016-05-18 11:00:00	MSFT	Stock	50.81	51.04	50.79	50.885	2263347.0
2016-05-18 12:00:00	MSFT	Stock	50.885	50.92	50.73	50.89	1184222.0
2016-05-18 13:00:00	MSFT	Stock	50.9	51.14	50.9	51.04	1467519.0
2016-05-18 14:00:00	MSFT	Stock	51.03	51.03	50.39	50.685	4030458.0
2016-05-18 15:00:00	MSFT	Stock	50.7	50.83	50.5	50.81	3448533.0
2016-05-18 16:00:00	MSFT	Stock	50.805	50.96	50.74	50.74	6326092.0
2016-05-18 17:00:00	MSFT	Stock	50.81	50.83	50.81	50.81	2301.0
2016-05-18 18:00:00	MSFT	Stock	50.81	50.81	50.81	50.81	1000.0
2016-05-18 19:00:00	MSFT	Stock	50.82	50.82	50.82	50.82	1000.0
2016-05-18 08:00:00	NVDA	Stock	1.0465	1.05	1.0465	1.05	107880.0
2016-05-18 09:00:00	NVDA	Stock	1.049	1.0803	1.0475	1.0795	66367320.0
2016-05-18 10:00:00	NVDA	Stock	1.0798	1.083	1.074	1.0752	69954440.0
2016-05-18 11:00:00	NVDA	Stock	1.0752	1.0885	1.0752	1.0838	56585120.0
2016-05-18 12:00:00	NVDA	Stock	1.0838	1.089	1.0818	1.0889	42592000.0
2016-05-18 13:00:00	NVDA	Stock	1.0889	1.0963	1.0865	1.0938	69159920.0
2016-05-18 14:00:00	NVDA	Stock	1.0935	1.0935	1.0778	1.0825	86491040.0
2016-05-18 15:00:00	NVDA	Stock	1.0825	1.0872	1.0788	1.084	108051840.0
2016-05-18 16:00:00	NVDA	Stock	1.084	1.0845	1.0822	1.084	1348280.0
2016-05-18 17:00:00	NVDA	Stock	1.0828	1.084	1.0828	1.084	28400.0
2016-05-18 18:00:00	NVDA	Stock	1.0832	1.0832	1.083	1.083	16000.0
2016-05-18 19:00:00	NVDA	Stock	1.0825	1.0832	1.0825	1.083	57480.0
2016-05-18 06:00:00	AMZN	Stock	34.725	34.725	34.725	34.725	2000.0
2016-05-18 07:00:00	AMZN	Stock	34.7575	34.76	34.72	34.72	20480.0
2016-05-18 08:00:00	AMZN	Stock	34.675	34.7395	34.625	34.7395	286900.0
2016-05-18 09:00:00	AMZN	Stock	34.7245	34.9859	34.438	34.833	14435120.0
2016-05-18 10:00:00	AMZN	Stock	34.8245	34.95	34.705	34.775	8959280.0
2016-05-18 11:00:00	AMZN	Stock	34.7805	35.127	34.7543	35.0	8346220.0
2016-05-18 12:00:00	AMZN	Stock	34.994	35.008	34.889	34.989	3550080.0
2016-05-18 13:00:00	AMZN	Stock	34.9744	35.0655	34.9075	34.9075	5509420.0

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

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