PREVIEW / stock_1hour / 2017-01-26

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-01-26.parquet
  size:    1.0 MB
  rows:    48,293
  symbols: 3,124

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
2017-01-26 04:00:00	AAPL	Stock	30.5	30.515	30.5	30.515	1184.0
2017-01-26 05:00:00	AAPL	Stock	30.52	30.52	30.52	30.52	460.0
2017-01-26 06:00:00	AAPL	Stock	30.5025	30.5025	30.4825	30.4825	3864.0
2017-01-26 07:00:00	AAPL	Stock	30.4925	30.5	30.4575	30.4575	12292.0
2017-01-26 08:00:00	AAPL	Stock	30.495	30.51	30.4	30.45	100676.0
2017-01-26 09:00:00	AAPL	Stock	30.45	30.61	30.415	30.5062	14879136.0
2017-01-26 10:00:00	AAPL	Stock	30.5075	30.53	30.4125	30.455	12863908.0
2017-01-26 11:00:00	AAPL	Stock	30.4575	30.4825	30.4	30.455	9688972.0
2017-01-26 12:00:00	AAPL	Stock	30.455	30.5075	30.4125	30.4725	8235144.0
2017-01-26 13:00:00	AAPL	Stock	30.475	30.5	30.465	30.4975	6729804.0
2017-01-26 14:00:00	AAPL	Stock	30.4975	30.53	30.4725	30.4872	8901560.0
2017-01-26 15:00:00	AAPL	Stock	30.4862	30.515	30.4675	30.485	13148564.0
2017-01-26 16:00:00	AAPL	Stock	30.5	30.525	30.4675	30.49	13084456.0
2017-01-26 17:00:00	AAPL	Stock	30.49	30.5125	30.4775	30.49	55528.0
2017-01-26 18:00:00	AAPL	Stock	30.49	30.49	30.4575	30.4575	34268.0
2017-01-26 19:00:00	AAPL	Stock	30.495	30.495	30.4575	30.48	17160.0
2017-01-26 04:00:00	MSFT	Stock	64.01	64.09	64.01	64.09	1295.0
2017-01-26 05:00:00	MSFT	Stock	64.19	64.19	64.19	64.19	414.0
2017-01-26 06:00:00	MSFT	Stock	64.1	64.2	64.1	64.15	697.0
2017-01-26 07:00:00	MSFT	Stock	64.15	64.18	64.0	64.1	12571.0
2017-01-26 08:00:00	MSFT	Stock	64.07	64.19	63.94	64.05	61442.0
2017-01-26 09:00:00	MSFT	Stock	64.05	64.34	63.55	63.81	4960909.0
2017-01-26 10:00:00	MSFT	Stock	63.82	63.99	63.638	63.73	3808484.0
2017-01-26 11:00:00	MSFT	Stock	63.74	64.05	63.705	63.93	3141087.0
2017-01-26 12:00:00	MSFT	Stock	63.93	64.27	63.86	64.225	4715128.0
2017-01-26 13:00:00	MSFT	Stock	64.227	64.24	63.97	64.11	2894553.0
2017-01-26 14:00:00	MSFT	Stock	64.11	64.535	64.1	64.295	4818994.0
2017-01-26 15:00:00	MSFT	Stock	64.295	64.48	64.21	64.28	7808639.0
2017-01-26 16:00:00	MSFT	Stock	64.27	65.2	62.43	64.56	6950837.0
2017-01-26 17:00:00	MSFT	Stock	64.58	65.0	64.18	64.39	625977.0
2017-01-26 18:00:00	MSFT	Stock	64.39	65.12	64.06	65.0	527639.0
2017-01-26 19:00:00	MSFT	Stock	65.0	65.19	64.93	65.19	111751.0
2017-01-26 08:00:00	NVDA	Stock	2.692	2.6925	2.684	2.6858	499400.0
2017-01-26 09:00:00	NVDA	Stock	2.684	2.71	2.6675	2.6808	68858880.0
2017-01-26 10:00:00	NVDA	Stock	2.682	2.693	2.6758	2.691	51510840.0
2017-01-26 11:00:00	NVDA	Stock	2.6907	2.729	2.6907	2.7163	89888560.0
2017-01-26 12:00:00	NVDA	Stock	2.716	2.7195	2.7075	2.715	32300040.0
2017-01-26 13:00:00	NVDA	Stock	2.715	2.72	2.7098	2.719	27438280.0
2017-01-26 14:00:00	NVDA	Stock	2.7189	2.7488	2.7185	2.7476	75684240.0
2017-01-26 15:00:00	NVDA	Stock	2.7478	2.7478	2.7343	2.7413	79052720.0
2017-01-26 16:00:00	NVDA	Stock	2.7413	2.7462	2.7145	2.7312	2714640.0
2017-01-26 17:00:00	NVDA	Stock	2.7312	2.7362	2.7302	2.7362	202680.0
2017-01-26 18:00:00	NVDA	Stock	2.736	2.736	2.7325	2.735	143000.0
2017-01-26 19:00:00	NVDA	Stock	2.73	2.735	2.73	2.7312	112080.0
2017-01-26 05:00:00	AMZN	Stock	41.945	41.945	41.945	41.945	2000.0
2017-01-26 07:00:00	AMZN	Stock	41.8945	41.8975	41.8945	41.8975	9000.0
2017-01-26 08:00:00	AMZN	Stock	41.83	41.895	41.775	41.8	142120.0
2017-01-26 09:00:00	AMZN	Stock	41.775	41.82	41.65	41.7594	10229200.0
2017-01-26 10:00:00	AMZN	Stock	41.74	41.987	41.7045	41.9115	12822480.0
2017-01-26 11:00:00	AMZN	Stock	41.9245	42.033	41.8595	42.0137	9214180.0

> showing 50 of 48,293 rows — these rows as CSV

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