PREVIEW / stock_1hour / 2017-11-29

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-11-29.parquet
  size:    1.1 MB
  rows:    49,192
  symbols: 2,936

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-11-29 05:00:00	AAPL	Stock	43.185	43.185	43.125	43.125	2372.0
2017-11-29 06:00:00	AAPL	Stock	43.1875	43.2075	43.1875	43.2025	2848.0
2017-11-29 07:00:00	AAPL	Stock	43.27	43.3375	43.27	43.275	49228.0
2017-11-29 08:00:00	AAPL	Stock	43.335	43.335	43.1775	43.2225	161968.0
2017-11-29 09:00:00	AAPL	Stock	43.2325	43.2375	42.92	42.9505	14579724.0
2017-11-29 10:00:00	AAPL	Stock	42.95	42.9575	42.1825	42.2	35907544.0
2017-11-29 11:00:00	AAPL	Stock	42.2012	42.4068	41.815	41.8475	26401932.0
2017-11-29 12:00:00	AAPL	Stock	41.845	42.3375	41.79	42.1575	21949808.0
2017-11-29 13:00:00	AAPL	Stock	42.1545	42.365	42.0625	42.1175	12493852.0
2017-11-29 14:00:00	AAPL	Stock	42.115	42.355	42.1	42.2375	9961112.0
2017-11-29 15:00:00	AAPL	Stock	42.24	42.41	42.1225	42.3725	16364240.0
2017-11-29 16:00:00	AAPL	Stock	42.3475	42.37	42.275	42.3	8558156.0
2017-11-29 17:00:00	AAPL	Stock	42.3	42.37	42.275	42.3075	99324.0
2017-11-29 18:00:00	AAPL	Stock	42.3	42.3125	42.2775	42.31	48756.0
2017-11-29 19:00:00	AAPL	Stock	42.295	42.3125	42.2575	42.275	27708.0
2017-11-29 07:00:00	MSFT	Stock	85.0	85.0	84.78	84.99	2268.0
2017-11-29 08:00:00	MSFT	Stock	84.997	84.997	84.66	84.78	9738.0
2017-11-29 09:00:00	MSFT	Stock	84.71	84.917	84.42	84.82	3004533.0
2017-11-29 10:00:00	MSFT	Stock	84.83	84.84	83.67	83.805	4991178.0
2017-11-29 11:00:00	MSFT	Stock	83.81	84.07	83.38	83.52	3412570.0
2017-11-29 12:00:00	MSFT	Stock	83.51	83.82	83.36	83.44	2696742.0
2017-11-29 13:00:00	MSFT	Stock	83.44	83.899	83.43	83.52	1663343.0
2017-11-29 14:00:00	MSFT	Stock	83.515	83.67	83.42	83.54	2204640.0
2017-11-29 15:00:00	MSFT	Stock	83.54	83.54	83.175	83.335	3841321.0
2017-11-29 16:00:00	MSFT	Stock	83.34	83.34	83.3	83.32	2411220.0
2017-11-29 17:00:00	MSFT	Stock	83.4	83.43	83.35	83.43	4485.0
2017-11-29 18:00:00	MSFT	Stock	83.35	83.44	83.35	83.35	1999.0
2017-11-29 19:00:00	MSFT	Stock	83.4	83.4	83.34	83.34	1100.0
2017-11-29 04:00:00	NVDA	Stock	5.2588	5.2588	5.2588	5.2588	15960.0
2017-11-29 05:00:00	NVDA	Stock	5.2725	5.2725	5.2712	5.2712	50000.0
2017-11-29 06:00:00	NVDA	Stock	5.2712	5.2788	5.2712	5.2788	16000.0
2017-11-29 07:00:00	NVDA	Stock	5.2815	5.2922	5.27	5.27	301280.0
2017-11-29 08:00:00	NVDA	Stock	5.2846	5.2938	5.242	5.2515	1507080.0
2017-11-29 09:00:00	NVDA	Stock	5.25	5.2668	5.0375	5.0664	156847960.0
2017-11-29 10:00:00	NVDA	Stock	5.0695	5.0975	4.9008	4.906	277924920.0
2017-11-29 11:00:00	NVDA	Stock	4.9064	4.9495	4.835	4.84	210823080.0
2017-11-29 12:00:00	NVDA	Stock	4.8422	4.9798	4.7808	4.9425	252521320.0
2017-11-29 13:00:00	NVDA	Stock	4.943	4.997	4.932	4.9462	98512640.0
2017-11-29 14:00:00	NVDA	Stock	4.9459	4.9568	4.8712	4.8944	106938280.0
2017-11-29 15:00:00	NVDA	Stock	4.8958	4.9185	4.847	4.9092	138765800.0
2017-11-29 16:00:00	NVDA	Stock	4.9105	4.918	4.903	4.9083	6648160.0
2017-11-29 17:00:00	NVDA	Stock	4.9083	4.9248	4.9083	4.9213	1009000.0
2017-11-29 18:00:00	NVDA	Stock	4.9213	4.9248	4.9105	4.9208	754880.0
2017-11-29 19:00:00	NVDA	Stock	4.921	4.9248	4.918	4.9248	404760.0
2017-11-29 04:00:00	AMZN	Stock	59.65	59.65	59.65	59.65	5100.0
2017-11-29 06:00:00	AMZN	Stock	59.7	59.7	59.7	59.7	18000.0
2017-11-29 07:00:00	AMZN	Stock	59.7915	59.7915	59.6055	59.6055	75360.0
2017-11-29 08:00:00	AMZN	Stock	59.7275	59.7625	59.6	59.6295	30400.0
2017-11-29 09:00:00	AMZN	Stock	59.55	59.951	58.45	58.666	22302520.0
2017-11-29 10:00:00	AMZN	Stock	58.6715	58.8915	57.55	57.8665	51569920.0

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

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