PREVIEW / stock_1hour / 2017-12-07

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-12-07.parquet
  size:    1.1 MB
  rows:    48,982
  symbols: 2,935

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-12-07 04:00:00	AAPL	Stock	42.4125	42.4125	42.4125	42.4125	1000.0
2017-12-07 05:00:00	AAPL	Stock	42.4125	42.4175	42.4125	42.4175	11596.0
2017-12-07 06:00:00	AAPL	Stock	42.4175	42.4175	42.325	42.325	42368.0
2017-12-07 07:00:00	AAPL	Stock	42.3725	42.4225	42.3375	42.35	86812.0
2017-12-07 08:00:00	AAPL	Stock	42.395	42.44	42.34	42.3725	228864.0
2017-12-07 09:00:00	AAPL	Stock	42.355	42.595	42.2275	42.4975	13837716.0
2017-12-07 10:00:00	AAPL	Stock	42.4925	42.5275	42.2425	42.4325	13978728.0
2017-12-07 11:00:00	AAPL	Stock	42.435	42.465	42.285	42.44	10096976.0
2017-12-07 12:00:00	AAPL	Stock	42.4375	42.495	42.385	42.485	6255752.0
2017-12-07 13:00:00	AAPL	Stock	42.485	42.61	42.325	42.4425	10520456.0
2017-12-07 14:00:00	AAPL	Stock	42.4475	42.5012	42.24	42.3675	9569644.0
2017-12-07 15:00:00	AAPL	Stock	42.37	42.4475	42.33	42.3325	13700876.0
2017-12-07 16:00:00	AAPL	Stock	42.33	42.39	42.3125	42.3525	11598116.0
2017-12-07 17:00:00	AAPL	Stock	42.3525	42.3675	42.3375	42.3475	36888.0
2017-12-07 18:00:00	AAPL	Stock	42.3625	42.405	42.3625	42.3925	19312.0
2017-12-07 19:00:00	AAPL	Stock	42.3925	42.4125	42.375	42.375	36228.0
2017-12-07 05:00:00	MSFT	Stock	83.26	83.26	83.26	83.26	332.0
2017-12-07 06:00:00	MSFT	Stock	83.0	83.0	83.0	83.0	120.0
2017-12-07 07:00:00	MSFT	Stock	83.0	83.0	82.8	83.0	1602.0
2017-12-07 08:00:00	MSFT	Stock	82.8	83.05	82.8	82.95	11769.0
2017-12-07 09:00:00	MSFT	Stock	82.98	83.0	82.1	82.2	2739171.0
2017-12-07 10:00:00	MSFT	Stock	82.2	82.555	82.0	82.325	3561173.0
2017-12-07 11:00:00	MSFT	Stock	82.325	82.77	82.16	82.77	2230268.0
2017-12-07 12:00:00	MSFT	Stock	82.78	82.78	82.48	82.63	1277278.0
2017-12-07 13:00:00	MSFT	Stock	82.64	82.72	82.31	82.47	1878681.0
2017-12-07 14:00:00	MSFT	Stock	82.475	82.52	82.17	82.47	1485278.0
2017-12-07 15:00:00	MSFT	Stock	82.475	82.53	82.33	82.49	2811833.0
2017-12-07 16:00:00	MSFT	Stock	82.48	82.53	82.48	82.49	4504428.0
2017-12-07 17:00:00	MSFT	Stock	82.49	82.52	82.4	82.52	1257.0
2017-12-07 18:00:00	MSFT	Stock	82.53	82.55	82.5	82.55	6305.0
2017-12-07 19:00:00	MSFT	Stock	82.53	82.55	82.5	82.5	1800.0
2017-12-07 04:00:00	NVDA	Stock	4.8018	4.825	4.8018	4.825	78160.0
2017-12-07 05:00:00	NVDA	Stock	4.835	4.835	4.82	4.82	107480.0
2017-12-07 06:00:00	NVDA	Stock	4.8138	4.8138	4.7805	4.795	229520.0
2017-12-07 07:00:00	NVDA	Stock	4.7988	4.7988	4.7805	4.7943	559440.0
2017-12-07 08:00:00	NVDA	Stock	4.7975	4.8098	4.7825	4.7995	2163160.0
2017-12-07 09:00:00	NVDA	Stock	4.7928	4.8175	4.7625	4.7805	95123920.0
2017-12-07 10:00:00	NVDA	Stock	4.7798	4.816	4.753	4.8141	89610400.0
2017-12-07 11:00:00	NVDA	Stock	4.815	4.84	4.8083	4.827	79031960.0
2017-12-07 12:00:00	NVDA	Stock	4.8272	4.8272	4.7988	4.805	40094760.0
2017-12-07 13:00:00	NVDA	Stock	4.8052	4.8088	4.78	4.7888	36448600.0
2017-12-07 14:00:00	NVDA	Stock	4.7885	4.8008	4.7602	4.7798	39368760.0
2017-12-07 15:00:00	NVDA	Stock	4.7799	4.8065	4.7728	4.7995	111206400.0
2017-12-07 16:00:00	NVDA	Stock	4.7998	4.8123	4.799	4.8072	7192000.0
2017-12-07 17:00:00	NVDA	Stock	4.8075	4.8198	4.8032	4.8198	384520.0
2017-12-07 18:00:00	NVDA	Stock	4.8198	4.8225	4.815	4.8175	794160.0
2017-12-07 19:00:00	NVDA	Stock	4.82	4.8228	4.7998	4.815	5746280.0
2017-12-07 06:00:00	AMZN	Stock	57.8615	57.8615	57.8	57.8	8820.0
2017-12-07 07:00:00	AMZN	Stock	57.775	57.85	57.775	57.85	82060.0
2017-12-07 08:00:00	AMZN	Stock	57.795	58.1	57.775	57.9265	372900.0

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

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