PREVIEW / stock_1hour / 2017-03-17

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-03-17.parquet
  size:    1.1 MB
  rows:    49,469
  symbols: 3,084

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-17 04:00:00	AAPL	Stock	35.1375	35.1725	35.1375	35.1725	5800.0
2017-03-17 05:00:00	AAPL	Stock	35.1725	35.1725	35.1725	35.1725	2660.0
2017-03-17 06:00:00	AAPL	Stock	35.15	35.15	35.15	35.15	656.0
2017-03-17 07:00:00	AAPL	Stock	35.1525	35.2025	35.1525	35.165	14252.0
2017-03-17 08:00:00	AAPL	Stock	35.1875	35.225	35.1425	35.225	179172.0
2017-03-17 09:00:00	AAPL	Stock	35.2075	35.275	35.145	35.147	46878868.0
2017-03-17 10:00:00	AAPL	Stock	35.1475	35.1725	35.1045	35.16	8195516.0
2017-03-17 11:00:00	AAPL	Stock	35.1612	35.17	35.115	35.15	5408304.0
2017-03-17 12:00:00	AAPL	Stock	35.1502	35.21	35.1425	35.1875	6063704.0
2017-03-17 13:00:00	AAPL	Stock	35.1865	35.2225	35.1775	35.18	4185240.0
2017-03-17 14:00:00	AAPL	Stock	35.18	35.2375	35.18	35.1925	5984488.0
2017-03-17 15:00:00	AAPL	Stock	35.1925	35.21	34.9725	34.9775	22982168.0
2017-03-17 16:00:00	AAPL	Stock	34.98	35.03	34.9775	35.005	62155132.0
2017-03-17 17:00:00	AAPL	Stock	35.005	35.025	34.9975	35.0125	236348.0
2017-03-17 18:00:00	AAPL	Stock	35.0075	35.0125	35.0025	35.0075	11772.0
2017-03-17 19:00:00	AAPL	Stock	35.005	35.005	34.99	35.0	47416.0
2017-03-17 08:00:00	MSFT	Stock	64.67	64.67	64.67	64.67	477.0
2017-03-17 09:00:00	MSFT	Stock	64.67	65.05	64.67	64.99	17062374.0
2017-03-17 10:00:00	MSFT	Stock	64.98	65.08	64.86	65.025	3905278.0
2017-03-17 11:00:00	MSFT	Stock	65.03	65.04	64.885	65.03	2321865.0
2017-03-17 12:00:00	MSFT	Stock	65.032	65.07	65.0	65.039	1580816.0
2017-03-17 13:00:00	MSFT	Stock	65.035	65.1	65.01	65.08	1352496.0
2017-03-17 14:00:00	MSFT	Stock	65.08	65.24	65.075	65.105	2375067.0
2017-03-17 15:00:00	MSFT	Stock	65.11	65.125	64.85	64.85	6342138.0
2017-03-17 16:00:00	MSFT	Stock	64.87	65.043	64.82	64.85	10526870.0
2017-03-17 17:00:00	MSFT	Stock	64.95	64.95	64.83	64.94	75798.0
2017-03-17 19:00:00	MSFT	Stock	64.91	64.91	64.91	64.91	300.0
2017-03-17 04:00:00	NVDA	Stock	2.6133	2.6165	2.6133	2.6165	19360.0
2017-03-17 06:00:00	NVDA	Stock	2.6248	2.6248	2.6248	2.6248	55360.0
2017-03-17 07:00:00	NVDA	Stock	2.6248	2.6312	2.6075	2.6138	539160.0
2017-03-17 08:00:00	NVDA	Stock	2.6192	2.6312	2.6013	2.63	2289880.0
2017-03-17 09:00:00	NVDA	Stock	2.63	2.6303	2.59	2.6145	162959160.0
2017-03-17 10:00:00	NVDA	Stock	2.6145	2.6208	2.5982	2.6145	112618600.0
2017-03-17 11:00:00	NVDA	Stock	2.6143	2.636	2.6065	2.6295	111005400.0
2017-03-17 12:00:00	NVDA	Stock	2.6298	2.6485	2.6278	2.6377	94646240.0
2017-03-17 13:00:00	NVDA	Stock	2.6375	2.6423	2.6328	2.6412	56619320.0
2017-03-17 14:00:00	NVDA	Stock	2.6411	2.6468	2.6355	2.6383	59768640.0
2017-03-17 15:00:00	NVDA	Stock	2.6385	2.653	2.6383	2.6525	157128600.0
2017-03-17 16:00:00	NVDA	Stock	2.6515	2.654	2.6503	2.6505	125173120.0
2017-03-17 17:00:00	NVDA	Stock	2.6512	2.655	2.651	2.655	809720.0
2017-03-17 18:00:00	NVDA	Stock	2.655	2.6613	2.655	2.6588	871360.0
2017-03-17 19:00:00	NVDA	Stock	2.6562	2.6625	2.6562	2.6605	433600.0
2017-03-17 04:00:00	AMZN	Stock	42.626	42.626	42.626	42.626	10000.0
2017-03-17 07:00:00	AMZN	Stock	42.643	42.643	42.6355	42.6355	4000.0
2017-03-17 08:00:00	AMZN	Stock	42.5515	42.6	42.45	42.525	216560.0
2017-03-17 09:00:00	AMZN	Stock	42.525	42.675	42.515	42.5832	19981080.0
2017-03-17 10:00:00	AMZN	Stock	42.5875	42.6065	42.5525	42.5645	4551800.0
2017-03-17 11:00:00	AMZN	Stock	42.568	42.599	42.532	42.5915	3100340.0
2017-03-17 12:00:00	AMZN	Stock	42.5905	42.6465	42.59	42.637	3243140.0
2017-03-17 13:00:00	AMZN	Stock	42.634	42.6915	42.629	42.6415	3150380.0

> showing 50 of 49,469 rows — these rows as CSV

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