PREVIEW / stock_1hour / 2017-03-21

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-03-21.parquet
  size:    1.1 MB
  rows:    48,290
  symbols: 3,073

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-03-21 04:00:00	AAPL	Stock	35.3975	35.4575	35.3975	35.455	9396.0
2017-03-21 05:00:00	AAPL	Stock	35.465	35.4675	35.46	35.4675	4868.0
2017-03-21 06:00:00	AAPL	Stock	35.465	35.4675	35.45	35.46	16720.0
2017-03-21 07:00:00	AAPL	Stock	35.46	35.4625	35.4325	35.4625	90428.0
2017-03-21 08:00:00	AAPL	Stock	35.4525	35.55	35.4275	35.53	733244.0
2017-03-21 09:00:00	AAPL	Stock	35.5225	35.7	35.4775	35.6775	21805164.0
2017-03-21 10:00:00	AAPL	Stock	35.6785	35.6785	35.435	35.4978	20851976.0
2017-03-21 11:00:00	AAPL	Stock	35.5	35.5025	35.2375	35.3662	20990668.0
2017-03-21 12:00:00	AAPL	Stock	35.3675	35.37	35.08	35.1425	16401080.0
2017-03-21 13:00:00	AAPL	Stock	35.1425	35.1812	34.9728	34.985	13032460.0
2017-03-21 14:00:00	AAPL	Stock	34.985	35.12	34.9325	35.1175	13735396.0
2017-03-21 15:00:00	AAPL	Stock	35.115	35.15	34.9575	34.9625	26282412.0
2017-03-21 16:00:00	AAPL	Stock	34.9625	35.4	34.9275	34.9275	6952896.0
2017-03-21 17:00:00	AAPL	Stock	34.9275	34.95	34.925	34.925	81488.0
2017-03-21 18:00:00	AAPL	Stock	34.925	34.9675	34.8875	34.91	43960.0
2017-03-21 19:00:00	AAPL	Stock	34.9	34.9125	34.8375	34.8375	105800.0
2017-03-21 05:00:00	MSFT	Stock	65.17	65.2	65.17	65.2	1311.0
2017-03-21 07:00:00	MSFT	Stock	65.17	65.17	65.17	65.17	889.0
2017-03-21 08:00:00	MSFT	Stock	65.0	65.15	65.0	65.02	4621.0
2017-03-21 09:00:00	MSFT	Stock	65.01	65.5	65.01	65.475	2262603.0
2017-03-21 10:00:00	MSFT	Stock	65.475	65.48	64.845	64.93	3633767.0
2017-03-21 11:00:00	MSFT	Stock	64.92	64.97	64.625	64.82	3634520.0
2017-03-21 12:00:00	MSFT	Stock	64.815	64.82	64.48	64.59	2369773.0
2017-03-21 13:00:00	MSFT	Stock	64.59	64.67	64.4	64.405	1805029.0
2017-03-21 14:00:00	MSFT	Stock	64.405	64.62	64.39	64.52	2501766.0
2017-03-21 15:00:00	MSFT	Stock	64.51	64.55	64.13	64.21	5378032.0
2017-03-21 16:00:00	MSFT	Stock	64.21	64.25	64.07	64.15	2622003.0
2017-03-21 17:00:00	MSFT	Stock	64.15	64.21	64.15	64.21	2477.0
2017-03-21 18:00:00	MSFT	Stock	64.15	64.21	64.07	64.07	2248.0
2017-03-21 04:00:00	NVDA	Stock	2.75	2.75	2.74	2.74	92960.0
2017-03-21 05:00:00	NVDA	Stock	2.7375	2.7375	2.7375	2.7375	4000.0
2017-03-21 06:00:00	NVDA	Stock	2.7423	2.7423	2.7413	2.7413	27640.0
2017-03-21 07:00:00	NVDA	Stock	2.7413	2.7445	2.7362	2.739	393480.0
2017-03-21 08:00:00	NVDA	Stock	2.74	2.7475	2.7362	2.7405	2128440.0
2017-03-21 09:00:00	NVDA	Stock	2.7405	2.749	2.7175	2.7285	125054120.0
2017-03-21 10:00:00	NVDA	Stock	2.7282	2.7448	2.716	2.7235	147157040.0
2017-03-21 11:00:00	NVDA	Stock	2.7238	2.7245	2.6525	2.689	218586920.0
2017-03-21 12:00:00	NVDA	Stock	2.6891	2.6892	2.6615	2.6655	84806720.0
2017-03-21 13:00:00	NVDA	Stock	2.6655	2.677	2.6548	2.6602	63044840.0
2017-03-21 14:00:00	NVDA	Stock	2.6601	2.669	2.6538	2.663	68539040.0
2017-03-21 15:00:00	NVDA	Stock	2.6628	2.6777	2.6396	2.6478	124336040.0
2017-03-21 16:00:00	NVDA	Stock	2.6478	2.65	2.6438	2.6438	7934800.0
2017-03-21 17:00:00	NVDA	Stock	2.645	2.6475	2.64	2.64	245800.0
2017-03-21 18:00:00	NVDA	Stock	2.64	2.6405	2.63	2.6375	410360.0
2017-03-21 19:00:00	NVDA	Stock	2.6375	2.6375	2.6328	2.6363	260480.0
2017-03-21 06:00:00	AMZN	Stock	42.95	42.975	42.95	42.975	4200.0
2017-03-21 07:00:00	AMZN	Stock	42.9795	42.982	42.9525	42.9525	14120.0
2017-03-21 08:00:00	AMZN	Stock	42.95	42.9745	42.935	42.9555	161100.0
2017-03-21 09:00:00	AMZN	Stock	42.969	43.1398	42.9405	43.087	11422200.0
2017-03-21 10:00:00	AMZN	Stock	43.0895	43.092	42.7095	42.755	11645260.0

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

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