PREVIEW / stock_1hour / 2015-10-07

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-10-07.parquet
  size:    1.0 MB
  rows:    49,149
  symbols: 3,438

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
2015-10-07 04:00:00	AAPL	Stock	27.8325	27.965	27.825	27.945	51216.0
2015-10-07 05:00:00	AAPL	Stock	27.9425	27.975	27.9075	27.95	32972.0
2015-10-07 06:00:00	AAPL	Stock	27.9275	27.9375	27.765	27.765	61676.0
2015-10-07 07:00:00	AAPL	Stock	27.7575	27.9375	27.7575	27.935	306748.0
2015-10-07 08:00:00	AAPL	Stock	27.9325	28.0375	27.8	27.9775	964308.0
2015-10-07 09:00:00	AAPL	Stock	27.985	28.0	27.7075	27.8412	26494780.0
2015-10-07 10:00:00	AAPL	Stock	27.8412	27.8575	27.59	27.685	29246652.0
2015-10-07 11:00:00	AAPL	Stock	27.685	27.685	27.3525	27.52	33404260.0
2015-10-07 12:00:00	AAPL	Stock	27.52	27.53	27.3525	27.39	17496372.0
2015-10-07 13:00:00	AAPL	Stock	27.39	27.6225	27.385	27.6125	18402516.0
2015-10-07 14:00:00	AAPL	Stock	27.615	27.665	27.5275	27.6025	18443752.0
2015-10-07 15:00:00	AAPL	Stock	27.6075	27.7025	27.595	27.6925	25945104.0
2015-10-07 16:00:00	AAPL	Stock	27.6925	27.695	27.66	27.6825	3852236.0
2015-10-07 17:00:00	AAPL	Stock	27.68	27.6875	27.68	27.6875	126576.0
2015-10-07 18:00:00	AAPL	Stock	27.6775	27.6975	27.6775	27.69	39520.0
2015-10-07 19:00:00	AAPL	Stock	27.69	27.7025	27.69	27.7025	50600.0
2015-10-07 04:00:00	MSFT	Stock	47.0	47.2	47.0	47.14	1660.0
2015-10-07 05:00:00	MSFT	Stock	47.14	47.14	47.14	47.14	100.0
2015-10-07 06:00:00	MSFT	Stock	47.1	47.12	47.0	47.07	1771.0
2015-10-07 07:00:00	MSFT	Stock	47.08	47.15	47.07	47.07	6409.0
2015-10-07 08:00:00	MSFT	Stock	47.1	47.14	47.03	47.09	53484.0
2015-10-07 09:00:00	MSFT	Stock	47.12	47.35	46.905	46.995	3340267.0
2015-10-07 10:00:00	MSFT	Stock	46.99	47.06	46.26	46.29	4840643.0
2015-10-07 11:00:00	MSFT	Stock	46.29	46.41	45.95	46.39	3967675.0
2015-10-07 12:00:00	MSFT	Stock	46.385	46.45	46.21	46.33	1762806.0
2015-10-07 13:00:00	MSFT	Stock	46.328	46.47	46.26	46.43	1955536.0
2015-10-07 14:00:00	MSFT	Stock	46.43	46.72	46.38	46.64	3820027.0
2015-10-07 15:00:00	MSFT	Stock	46.64	46.79	46.59	46.79	4978877.0
2015-10-07 16:00:00	MSFT	Stock	46.8	46.8	46.592	46.79	1242941.0
2015-10-07 17:00:00	MSFT	Stock	46.79	46.79	46.61	46.61	420.0
2015-10-07 19:00:00	MSFT	Stock	46.7	46.7	46.7	46.7	200.0
2015-10-07 08:00:00	NVDA	Stock	0.6445	0.6498	0.6445	0.6498	20120.0
2015-10-07 09:00:00	NVDA	Stock	0.6452	0.657	0.6452	0.6515	43419240.0
2015-10-07 10:00:00	NVDA	Stock	0.6515	0.6525	0.6408	0.6411	55077320.0
2015-10-07 11:00:00	NVDA	Stock	0.641	0.6452	0.6348	0.6438	48776000.0
2015-10-07 12:00:00	NVDA	Stock	0.6436	0.6442	0.6393	0.6419	26381360.0
2015-10-07 13:00:00	NVDA	Stock	0.6418	0.6485	0.6418	0.6478	26114200.0
2015-10-07 14:00:00	NVDA	Stock	0.6478	0.6495	0.6463	0.6482	18880080.0
2015-10-07 15:00:00	NVDA	Stock	0.6481	0.6505	0.6478	0.6505	42062720.0
2015-10-07 16:00:00	NVDA	Stock	0.6505	0.6505	0.6505	0.6505	32971360.0
2015-10-07 05:00:00	AMZN	Stock	27.1	27.114	27.0275	27.0275	18000.0
2015-10-07 06:00:00	AMZN	Stock	27.0165	27.0165	26.9885	26.9885	19760.0
2015-10-07 07:00:00	AMZN	Stock	27.04	27.1	27.04	27.081	40700.0
2015-10-07 08:00:00	AMZN	Stock	27.1	27.1	27.024	27.082	230600.0
2015-10-07 09:00:00	AMZN	Stock	27.0975	27.0975	26.722	26.9065	10788820.0
2015-10-07 10:00:00	AMZN	Stock	26.9075	27.062	26.4685	26.6355	15240720.0
2015-10-07 11:00:00	AMZN	Stock	26.6225	27.0005	26.45	26.7068	11461040.0
2015-10-07 12:00:00	AMZN	Stock	26.7087	27.06	26.545	26.6445	4786300.0
2015-10-07 13:00:00	AMZN	Stock	26.6525	26.9395	26.581	26.8255	5270920.0
2015-10-07 14:00:00	AMZN	Stock	26.843	26.9435	26.7788	26.8316	7310400.0

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

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