PREVIEW / stock_1hour / 2017-01-17

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-01-17.parquet
  size:    1.1 MB
  rows:    48,965
  symbols: 3,127

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-17 04:00:00	AAPL	Stock	29.685	29.685	29.6725	29.6725	880.0
2017-01-17 05:00:00	AAPL	Stock	29.625	29.625	29.6	29.6	5200.0
2017-01-17 06:00:00	AAPL	Stock	29.625	29.6425	29.5675	29.6425	21956.0
2017-01-17 07:00:00	AAPL	Stock	29.6625	29.685	29.635	29.6825	65176.0
2017-01-17 08:00:00	AAPL	Stock	29.665	29.6875	29.6275	29.6675	204280.0
2017-01-17 09:00:00	AAPL	Stock	29.6725	29.945	29.555	29.8945	24823844.0
2017-01-17 10:00:00	AAPL	Stock	29.895	29.99	29.8875	29.99	18486052.0
2017-01-17 11:00:00	AAPL	Stock	29.9888	30.06	29.91	30.0138	23969640.0
2017-01-17 12:00:00	AAPL	Stock	30.0125	30.0175	29.9425	29.9538	9109620.0
2017-01-17 13:00:00	AAPL	Stock	29.9525	30.0125	29.95	29.992	8281300.0
2017-01-17 14:00:00	AAPL	Stock	29.9908	30.005	29.895	29.9612	12916680.0
2017-01-17 15:00:00	AAPL	Stock	29.9625	30.0	29.9275	29.9975	15165576.0
2017-01-17 16:00:00	AAPL	Stock	29.985	30.0	29.7875	29.9925	13972184.0
2017-01-17 17:00:00	AAPL	Stock	29.9925	30.0	29.9725	29.9775	32764.0
2017-01-17 18:00:00	AAPL	Stock	29.98	29.995	29.98	29.99	3608.0
2017-01-17 19:00:00	AAPL	Stock	29.975	29.99	29.975	29.99	15600.0
2017-01-17 04:00:00	MSFT	Stock	62.7	62.7	62.65	62.65	520.0
2017-01-17 08:00:00	MSFT	Stock	62.69	62.69	62.58	62.58	2482.0
2017-01-17 09:00:00	MSFT	Stock	62.6	62.7	62.03	62.18	2870750.0
2017-01-17 10:00:00	MSFT	Stock	62.18	62.47	62.18	62.355	2604476.0
2017-01-17 11:00:00	MSFT	Stock	62.36	62.36	62.2	62.326	1874115.0
2017-01-17 12:00:00	MSFT	Stock	62.325	62.38	62.215	62.27	946217.0
2017-01-17 13:00:00	MSFT	Stock	62.27	62.485	62.27	62.45	1627995.0
2017-01-17 14:00:00	MSFT	Stock	62.46	62.52	62.3	62.37	1571356.0
2017-01-17 15:00:00	MSFT	Stock	62.37	62.54	62.31	62.52	3254886.0
2017-01-17 16:00:00	MSFT	Stock	62.53	62.53	62.44	62.5	4308351.0
2017-01-17 17:00:00	MSFT	Stock	62.53	62.75	62.45	62.6	10095.0
2017-01-17 18:00:00	MSFT	Stock	62.69	62.69	62.54	62.6	750.0
2017-01-17 04:00:00	NVDA	Stock	2.5825	2.5825	2.5725	2.575	141400.0
2017-01-17 05:00:00	NVDA	Stock	2.57	2.57	2.5588	2.5588	29920.0
2017-01-17 06:00:00	NVDA	Stock	2.5625	2.5625	2.56	2.56	95560.0
2017-01-17 07:00:00	NVDA	Stock	2.567	2.5745	2.5528	2.5712	1117480.0
2017-01-17 08:00:00	NVDA	Stock	2.5668	2.572	2.5555	2.563	721560.0
2017-01-17 09:00:00	NVDA	Stock	2.5632	2.5815	2.533	2.5595	97556640.0
2017-01-17 10:00:00	NVDA	Stock	2.5602	2.567	2.538	2.5505	100500520.0
2017-01-17 11:00:00	NVDA	Stock	2.5511	2.5533	2.5375	2.5428	52428240.0
2017-01-17 12:00:00	NVDA	Stock	2.5436	2.5481	2.5288	2.5312	58494360.0
2017-01-17 13:00:00	NVDA	Stock	2.5312	2.5367	2.5142	2.5254	71187480.0
2017-01-17 14:00:00	NVDA	Stock	2.525	2.53	2.517	2.5255	65011360.0
2017-01-17 15:00:00	NVDA	Stock	2.5258	2.5285	2.5188	2.5273	69751560.0
2017-01-17 16:00:00	NVDA	Stock	2.5278	2.5388	2.5228	2.5268	46125800.0
2017-01-17 17:00:00	NVDA	Stock	2.5258	2.5278	2.525	2.525	247920.0
2017-01-17 18:00:00	NVDA	Stock	2.5273	2.5273	2.5245	2.5273	40800.0
2017-01-17 19:00:00	NVDA	Stock	2.5273	2.5273	2.523	2.525	130240.0
2017-01-17 05:00:00	AMZN	Stock	40.75	40.75	40.75	40.75	2000.0
2017-01-17 07:00:00	AMZN	Stock	40.713	40.75	40.705	40.75	52460.0
2017-01-17 08:00:00	AMZN	Stock	40.848	40.848	40.738	40.785	160440.0
2017-01-17 09:00:00	AMZN	Stock	40.785	40.8	40.172	40.387	18364060.0
2017-01-17 10:00:00	AMZN	Stock	40.4265	40.63	40.3712	40.5255	8897580.0
2017-01-17 11:00:00	AMZN	Stock	40.52	40.54	40.3665	40.4762	6128540.0

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

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