PREVIEW / stock_1hour / 2017-09-29

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-09-29.parquet
  size:    1.1 MB
  rows:    48,941
  symbols: 2,964

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-09-29 04:00:00	AAPL	Stock	38.3175	38.35	38.3	38.3025	13748.0
2017-09-29 05:00:00	AAPL	Stock	38.3025	38.3625	38.3025	38.3625	1200.0
2017-09-29 06:00:00	AAPL	Stock	38.3175	38.35	38.3	38.35	8276.0
2017-09-29 07:00:00	AAPL	Stock	38.35	38.4	38.2775	38.2875	122616.0
2017-09-29 08:00:00	AAPL	Stock	38.3475	38.375	38.225	38.27	235388.0
2017-09-29 09:00:00	AAPL	Stock	38.27	38.5	38.0025	38.045	14724396.0
2017-09-29 10:00:00	AAPL	Stock	38.0475	38.3325	38.0	38.3225	16904568.0
2017-09-29 11:00:00	AAPL	Stock	38.32	38.438	38.2675	38.4125	11837664.0
2017-09-29 12:00:00	AAPL	Stock	38.415	38.495	38.3775	38.456	8977400.0
2017-09-29 13:00:00	AAPL	Stock	38.457	38.4775	38.3975	38.444	5638396.0
2017-09-29 14:00:00	AAPL	Stock	38.4425	38.4825	38.405	38.44	6181248.0
2017-09-29 15:00:00	AAPL	Stock	38.4362	38.5325	38.37	38.5	18259984.0
2017-09-29 16:00:00	AAPL	Stock	38.53	38.55	38.372	38.52	12078212.0
2017-09-29 17:00:00	AAPL	Stock	38.52	38.535	38.5125	38.525	256652.0
2017-09-29 18:00:00	AAPL	Stock	38.505	38.5375	38.505	38.5375	22000.0
2017-09-29 19:00:00	AAPL	Stock	38.5375	38.5375	38.525	38.53	40128.0
2017-09-29 06:00:00	MSFT	Stock	73.96	73.96	73.96	73.96	229.0
2017-09-29 07:00:00	MSFT	Stock	73.96	73.96	73.96	73.96	300.0
2017-09-29 08:00:00	MSFT	Stock	73.94	73.95	73.94	73.95	5300.0
2017-09-29 09:00:00	MSFT	Stock	73.98	74.228	73.88	74.01	1320890.0
2017-09-29 10:00:00	MSFT	Stock	74.0	74.24	73.95	74.2	1436664.0
2017-09-29 11:00:00	MSFT	Stock	74.2	74.44	74.11	74.374	1385472.0
2017-09-29 12:00:00	MSFT	Stock	74.38	74.465	74.24	74.45	956236.0
2017-09-29 13:00:00	MSFT	Stock	74.45	74.48	74.29	74.35	998622.0
2017-09-29 14:00:00	MSFT	Stock	74.35	74.435	74.27	74.38	1176489.0
2017-09-29 15:00:00	MSFT	Stock	74.37	74.535	74.3	74.45	3937518.0
2017-09-29 16:00:00	MSFT	Stock	74.49	74.61	74.375	74.51	4335136.0
2017-09-29 17:00:00	MSFT	Stock	74.49	74.54	74.49	74.54	85891.0
2017-09-29 18:00:00	MSFT	Stock	74.49	74.53	74.49	74.53	2408.0
2017-09-29 19:00:00	MSFT	Stock	74.53	74.53	74.53	74.53	1083.0
2017-09-29 04:00:00	NVDA	Stock	4.3998	4.4025	4.3998	4.4025	48960.0
2017-09-29 05:00:00	NVDA	Stock	4.4125	4.4325	4.4125	4.4325	192000.0
2017-09-29 06:00:00	NVDA	Stock	4.4362	4.475	4.4338	4.475	518920.0
2017-09-29 07:00:00	NVDA	Stock	4.4713	4.4822	4.4553	4.465	798960.0
2017-09-29 08:00:00	NVDA	Stock	4.4675	4.475	4.4562	4.4715	3668760.0
2017-09-29 09:00:00	NVDA	Stock	4.4728	4.4958	4.4442	4.4592	135412080.0
2017-09-29 10:00:00	NVDA	Stock	4.4618	4.4748	4.4312	4.4394	99291920.0
2017-09-29 11:00:00	NVDA	Stock	4.4396	4.4768	4.434	4.4758	69023320.0
2017-09-29 12:00:00	NVDA	Stock	4.4762	4.4905	4.4728	4.4848	53767400.0
2017-09-29 13:00:00	NVDA	Stock	4.4848	4.4869	4.463	4.4695	43223480.0
2017-09-29 14:00:00	NVDA	Stock	4.47	4.4743	4.4578	4.4675	37136720.0
2017-09-29 15:00:00	NVDA	Stock	4.4672	4.475	4.4528	4.4668	70614800.0
2017-09-29 16:00:00	NVDA	Stock	4.4693	4.4715	4.4655	4.471	23106840.0
2017-09-29 17:00:00	NVDA	Stock	4.471	4.475	4.4693	4.4745	674280.0
2017-09-29 18:00:00	NVDA	Stock	4.475	4.475	4.47	4.4718	269040.0
2017-09-29 19:00:00	NVDA	Stock	4.4725	4.4822	4.4705	4.4822	373920.0
2017-09-29 05:00:00	AMZN	Stock	48.0375	48.0375	48.0375	48.0375	3260.0
2017-09-29 06:00:00	AMZN	Stock	48.021	48.021	47.9495	47.9495	16920.0
2017-09-29 07:00:00	AMZN	Stock	47.95	47.95	47.9	47.9	15060.0
2017-09-29 08:00:00	AMZN	Stock	47.95	47.95	47.935	47.9435	47000.0

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

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