PREVIEW / stock_1hour / 2015-11-27

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-11-27.parquet
  size:    706 KB
  rows:    30,552
  symbols: 3,334

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-11-27 04:00:00	AAPL	Stock	29.5075	29.535	29.5	29.5	29760.0
2015-11-27 05:00:00	AAPL	Stock	29.5125	29.5675	29.495	29.5675	27492.0
2015-11-27 06:00:00	AAPL	Stock	29.575	29.6	29.57	29.575	19844.0
2015-11-27 07:00:00	AAPL	Stock	29.5725	29.65	29.565	29.65	121800.0
2015-11-27 08:00:00	AAPL	Stock	29.65	29.66	29.565	29.5875	255580.0
2015-11-27 09:00:00	AAPL	Stock	29.59	29.625	29.4	29.47	12266800.0
2015-11-27 10:00:00	AAPL	Stock	29.47	29.5075	29.415	29.43	10056496.0
2015-11-27 11:00:00	AAPL	Stock	29.43	29.55	29.43	29.4812	9769156.0
2015-11-27 12:00:00	AAPL	Stock	29.4818	29.5375	29.455	29.455	10774428.0
2015-11-27 13:00:00	AAPL	Stock	29.455	29.48	29.4	29.435	5401948.0
2015-11-27 14:00:00	AAPL	Stock	29.4375	29.4375	29.4125	29.4375	27700.0
2015-11-27 15:00:00	AAPL	Stock	29.4375	29.45	29.425	29.4375	30040.0
2015-11-27 16:00:00	AAPL	Stock	29.425	29.45	29.4125	29.4475	30788.0
2015-11-27 18:00:00	AAPL	Stock	29.478	29.478	29.478	29.478	6800.0
2015-11-27 05:00:00	MSFT	Stock	53.77	53.77	53.77	53.77	600.0
2015-11-27 07:00:00	MSFT	Stock	53.79	53.91	53.76	53.91	6900.0
2015-11-27 08:00:00	MSFT	Stock	53.88	53.89	53.78	53.79	13498.0
2015-11-27 09:00:00	MSFT	Stock	53.79	54.07	53.79	53.92	2245702.0
2015-11-27 10:00:00	MSFT	Stock	53.93	53.96	53.84	53.91	1761865.0
2015-11-27 11:00:00	MSFT	Stock	53.91	54.08	53.89	53.915	1395599.0
2015-11-27 12:00:00	MSFT	Stock	53.92	54.03	53.875	53.94	2231804.0
2015-11-27 13:00:00	MSFT	Stock	53.95	54.02	53.71	53.92	786742.0
2015-11-27 15:00:00	MSFT	Stock	53.95	54.0	53.95	54.0	1900.0
2015-11-27 07:00:00	NVDA	Stock	0.7818	0.7818	0.7818	0.7818	4000.0
2015-11-27 08:00:00	NVDA	Stock	0.7818	0.7818	0.7818	0.7818	12000.0
2015-11-27 09:00:00	NVDA	Stock	0.7805	0.7825	0.7758	0.7818	17164640.0
2015-11-27 10:00:00	NVDA	Stock	0.7818	0.785	0.7798	0.784	24623120.0
2015-11-27 11:00:00	NVDA	Stock	0.7843	0.7872	0.7825	0.7828	14318160.0
2015-11-27 12:00:00	NVDA	Stock	0.783	0.7855	0.782	0.7848	20155320.0
2015-11-27 13:00:00	NVDA	Stock	0.7845	0.7848	0.7845	0.7848	6915480.0
2015-11-27 17:00:00	NVDA	Stock	0.7849	0.7849	0.7849	0.7849	178200.0
2015-11-27 06:00:00	AMZN	Stock	33.95	33.95	33.95	33.95	7420.0
2015-11-27 07:00:00	AMZN	Stock	33.9	34.05	33.9	33.975	125700.0
2015-11-27 08:00:00	AMZN	Stock	33.957	34.0555	33.953	34.0075	551200.0
2015-11-27 09:00:00	AMZN	Stock	34.011	34.0495	33.77	33.7757	11915820.0
2015-11-27 10:00:00	AMZN	Stock	33.7834	33.825	33.605	33.662	10322500.0
2015-11-27 11:00:00	AMZN	Stock	33.6602	33.8425	33.6602	33.7186	6108580.0
2015-11-27 12:00:00	AMZN	Stock	33.727	33.7705	33.6505	33.652	6498660.0
2015-11-27 13:00:00	AMZN	Stock	33.663	33.663	33.51	33.6	1021780.0
2015-11-27 14:00:00	AMZN	Stock	33.625	33.645	33.6005	33.6375	41540.0
2015-11-27 15:00:00	AMZN	Stock	33.6361	33.65	33.6	33.625	40740.0
2015-11-27 16:00:00	AMZN	Stock	33.605	33.605	33.605	33.605	3000.0
2015-11-27 05:00:00	GOOGL	Stock	38.6	38.6	38.6	38.6	2000.0
2015-11-27 06:00:00	GOOGL	Stock	38.6	38.6	38.6	38.6	4000.0
2015-11-27 07:00:00	GOOGL	Stock	38.6	38.6	38.6	38.6	2000.0
2015-11-27 08:00:00	GOOGL	Stock	38.625	38.625	38.625	38.625	10000.0
2015-11-27 09:00:00	GOOGL	Stock	38.6	38.6	38.35	38.383	2383720.0
2015-11-27 10:00:00	GOOGL	Stock	38.3715	38.517	38.3505	38.4954	2385940.0
2015-11-27 11:00:00	GOOGL	Stock	38.4975	38.7	38.4895	38.619	2506460.0
2015-11-27 12:00:00	GOOGL	Stock	38.619	38.6675	38.581	38.6025	2193880.0

> showing 50 of 30,552 rows — these rows as CSV

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