PREVIEW / stock_1hour / 2017-03-27

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-03-27.parquet
  size:    1.0 MB
  rows:    48,477
  symbols: 3,079

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-27 04:00:00	AAPL	Stock	34.9875	34.9875	34.9275	34.9325	4144.0
2017-03-27 05:00:00	AAPL	Stock	34.8925	34.9225	34.875	34.875	3296.0
2017-03-27 06:00:00	AAPL	Stock	34.91	34.96	34.87	34.9125	103100.0
2017-03-27 07:00:00	AAPL	Stock	34.9125	34.95	34.9	34.91	164792.0
2017-03-27 08:00:00	AAPL	Stock	34.91	34.9375	34.8525	34.8775	435652.0
2017-03-27 09:00:00	AAPL	Stock	34.8775	35.0	34.655	34.9725	18394404.0
2017-03-27 10:00:00	AAPL	Stock	34.9725	35.125	34.9275	35.0862	14607268.0
2017-03-27 11:00:00	AAPL	Stock	35.085	35.17	35.035	35.1425	8346800.0
2017-03-27 12:00:00	AAPL	Stock	35.145	35.2625	35.1213	35.245	8268088.0
2017-03-27 13:00:00	AAPL	Stock	35.2425	35.305	35.2212	35.245	6637620.0
2017-03-27 14:00:00	AAPL	Stock	35.245	35.265	35.175	35.2612	7080532.0
2017-03-27 15:00:00	AAPL	Stock	35.2622	35.2875	35.0	35.22	10376420.0
2017-03-27 16:00:00	AAPL	Stock	35.22	35.2375	35.215	35.22	11068068.0
2017-03-27 17:00:00	AAPL	Stock	35.245	35.2475	35.2325	35.2375	9004.0
2017-03-27 18:00:00	AAPL	Stock	35.255	35.2575	35.2375	35.24	6600.0
2017-03-27 19:00:00	AAPL	Stock	35.25	35.275	35.25	35.275	32896.0
2017-03-27 04:00:00	MSFT	Stock	64.79	64.79	64.47	64.47	700.0
2017-03-27 05:00:00	MSFT	Stock	64.48	64.48	64.48	64.48	152.0
2017-03-27 06:00:00	MSFT	Stock	64.57	64.58	64.51	64.51	452.0
2017-03-27 07:00:00	MSFT	Stock	64.54	64.54	64.54	64.54	525.0
2017-03-27 08:00:00	MSFT	Stock	64.64	64.69	64.5	64.69	17957.0
2017-03-27 09:00:00	MSFT	Stock	64.69	64.735	64.35	64.54	2477762.0
2017-03-27 10:00:00	MSFT	Stock	64.535	64.65	64.46	64.625	2185085.0
2017-03-27 11:00:00	MSFT	Stock	64.62	64.93	64.6	64.9	1655830.0
2017-03-27 12:00:00	MSFT	Stock	64.9	65.06	64.85	64.99	1083331.0
2017-03-27 13:00:00	MSFT	Stock	64.99	65.1	64.91	64.967	1290982.0
2017-03-27 14:00:00	MSFT	Stock	64.96	65.1	64.89	65.087	1634131.0
2017-03-27 15:00:00	MSFT	Stock	65.09	65.22	65.04	65.1	3099217.0
2017-03-27 16:00:00	MSFT	Stock	65.1	65.1	65.1	65.1	3176265.0
2017-03-27 17:00:00	MSFT	Stock	65.05	65.05	65.05	65.05	349.0
2017-03-27 18:00:00	MSFT	Stock	65.1	65.18	65.1	65.18	200.0
2017-03-27 04:00:00	NVDA	Stock	2.665	2.665	2.6615	2.665	63040.0
2017-03-27 06:00:00	NVDA	Stock	2.65	2.6625	2.65	2.65	109840.0
2017-03-27 07:00:00	NVDA	Stock	2.6552	2.6552	2.6463	2.6463	204120.0
2017-03-27 08:00:00	NVDA	Stock	2.6498	2.6868	2.6438	2.6468	1328040.0
2017-03-27 09:00:00	NVDA	Stock	2.645	2.657	2.5894	2.64	93916120.0
2017-03-27 10:00:00	NVDA	Stock	2.6418	2.6703	2.6278	2.6595	85345160.0
2017-03-27 11:00:00	NVDA	Stock	2.659	2.675	2.651	2.6722	45816560.0
2017-03-27 12:00:00	NVDA	Stock	2.6722	2.7015	2.6694	2.6998	60193040.0
2017-03-27 13:00:00	NVDA	Stock	2.6996	2.7101	2.6903	2.6935	52287520.0
2017-03-27 14:00:00	NVDA	Stock	2.6935	2.706	2.6918	2.7048	39657720.0
2017-03-27 15:00:00	NVDA	Stock	2.7048	2.71	2.6995	2.706	64815600.0
2017-03-27 16:00:00	NVDA	Stock	2.7063	2.7112	2.7023	2.7112	22478280.0
2017-03-27 17:00:00	NVDA	Stock	2.7095	2.711	2.7088	2.7088	56960.0
2017-03-27 18:00:00	NVDA	Stock	2.7075	2.7138	2.7075	2.7138	135160.0
2017-03-27 19:00:00	NVDA	Stock	2.7125	2.7138	2.7122	2.7138	282800.0
2017-03-27 06:00:00	AMZN	Stock	41.925	41.95	41.925	41.95	7960.0
2017-03-27 07:00:00	AMZN	Stock	41.992	42.0175	41.9555	41.9555	29460.0
2017-03-27 08:00:00	AMZN	Stock	42.2805	42.2805	41.92	41.95	202820.0
2017-03-27 09:00:00	AMZN	Stock	41.9385	41.984	41.675	41.941	11375480.0

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

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