PREVIEW / stock_1hour / 2016-10-03

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-10-03.parquet
  size:    1.0 MB
  rows:    47,726
  symbols: 3,218

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-10-03 05:00:00	AAPL	Stock	28.2425	28.2425	28.2425	28.2425	1996.0
2016-10-03 06:00:00	AAPL	Stock	28.2425	28.2425	28.24	28.24	4400.0
2016-10-03 07:00:00	AAPL	Stock	28.245	28.325	28.2375	28.3175	32944.0
2016-10-03 08:00:00	AAPL	Stock	28.3	28.3	28.2	28.2025	206432.0
2016-10-03 09:00:00	AAPL	Stock	28.2025	28.2548	28.0825	28.1225	12839476.0
2016-10-03 10:00:00	AAPL	Stock	28.1225	28.2625	28.105	28.2375	12431112.0
2016-10-03 11:00:00	AAPL	Stock	28.2375	28.25	28.115	28.1385	7170120.0
2016-10-03 12:00:00	AAPL	Stock	28.1375	28.1975	28.13	28.155	7374316.0
2016-10-03 13:00:00	AAPL	Stock	28.1525	28.16	28.09	28.0925	7619224.0
2016-10-03 14:00:00	AAPL	Stock	28.0912	28.1512	28.07	28.1022	9505248.0
2016-10-03 15:00:00	AAPL	Stock	28.1022	28.175	28.0988	28.1275	14850684.0
2016-10-03 16:00:00	AAPL	Stock	28.13	28.175	28.12	28.15	7806468.0
2016-10-03 17:00:00	AAPL	Stock	28.15	28.1525	28.13	28.15	230064.0
2016-10-03 18:00:00	AAPL	Stock	28.1475	28.1525	28.1375	28.1375	15692.0
2016-10-03 19:00:00	AAPL	Stock	28.1375	28.17	28.1375	28.1575	26680.0
2016-10-03 07:00:00	MSFT	Stock	57.86	57.86	57.68	57.78	3600.0
2016-10-03 08:00:00	MSFT	Stock	57.6	57.63	57.5	57.5	11556.0
2016-10-03 09:00:00	MSFT	Stock	57.45	57.55	57.06	57.17	2634205.0
2016-10-03 10:00:00	MSFT	Stock	57.17	57.435	57.15	57.38	3078336.0
2016-10-03 11:00:00	MSFT	Stock	57.38	57.405	57.18	57.306	2080422.0
2016-10-03 12:00:00	MSFT	Stock	57.3	57.33	57.17	57.31	1763986.0
2016-10-03 13:00:00	MSFT	Stock	57.31	57.395	57.27	57.38	1412922.0
2016-10-03 14:00:00	MSFT	Stock	57.383	57.485	57.29	57.365	1625319.0
2016-10-03 15:00:00	MSFT	Stock	57.36	57.48	57.34	57.41	3754483.0
2016-10-03 16:00:00	MSFT	Stock	57.42	57.49	57.3	57.49	1735663.0
2016-10-03 17:00:00	MSFT	Stock	57.42	57.42	57.37	57.4	829.0
2016-10-03 18:00:00	MSFT	Stock	57.41	57.46	57.41	57.46	1079.0
2016-10-03 19:00:00	MSFT	Stock	57.43	57.46	57.43	57.46	803.0
2016-10-03 05:00:00	NVDA	Stock	1.722	1.722	1.722	1.722	19680.0
2016-10-03 06:00:00	NVDA	Stock	1.725	1.725	1.725	1.725	8000.0
2016-10-03 07:00:00	NVDA	Stock	1.73	1.73	1.675	1.7005	439800.0
2016-10-03 08:00:00	NVDA	Stock	1.7225	1.7225	1.713	1.713	937600.0
2016-10-03 09:00:00	NVDA	Stock	1.7148	1.7378	1.7102	1.7275	38334600.0
2016-10-03 10:00:00	NVDA	Stock	1.7268	1.728	1.7125	1.7235	39169800.0
2016-10-03 11:00:00	NVDA	Stock	1.7238	1.726	1.7142	1.716	25353320.0
2016-10-03 12:00:00	NVDA	Stock	1.716	1.7212	1.7132	1.7175	16068200.0
2016-10-03 13:00:00	NVDA	Stock	1.7175	1.72	1.7132	1.7175	15715560.0
2016-10-03 14:00:00	NVDA	Stock	1.7178	1.7212	1.71	1.711	25561400.0
2016-10-03 15:00:00	NVDA	Stock	1.7112	1.7152	1.7083	1.7115	46732240.0
2016-10-03 16:00:00	NVDA	Stock	1.7112	1.7174	1.7112	1.7145	16156520.0
2016-10-03 17:00:00	NVDA	Stock	1.7125	1.7148	1.7125	1.7148	40000.0
2016-10-03 18:00:00	NVDA	Stock	1.7138	1.7155	1.7138	1.715	51000.0
2016-10-03 19:00:00	NVDA	Stock	1.715	1.715	1.7148	1.7148	14000.0
2016-10-03 04:00:00	AMZN	Stock	41.885	41.885	41.885	41.885	9800.0
2016-10-03 07:00:00	AMZN	Stock	41.872	41.89	41.8665	41.8665	42040.0
2016-10-03 08:00:00	AMZN	Stock	41.8655	41.8655	41.7985	41.8	176420.0
2016-10-03 09:00:00	AMZN	Stock	41.787	41.8	41.5625	41.5905	11072200.0
2016-10-03 10:00:00	AMZN	Stock	41.5975	41.993	41.59	41.914	10615240.0
2016-10-03 11:00:00	AMZN	Stock	41.9175	41.9245	41.6305	41.7383	5773780.0
2016-10-03 12:00:00	AMZN	Stock	41.7325	41.787	41.6605	41.692	3954480.0

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

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