PREVIEW / stock_1hour / 2016-12-23

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-12-23.parquet
  size:    1.0 MB
  rows:    47,497
  symbols: 3,149

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
2016-12-23 05:00:00	AAPL	Stock	28.9775	28.9775	28.9775	28.9775	400.0
2016-12-23 06:00:00	AAPL	Stock	28.97	28.97	28.97	28.97	2000.0
2016-12-23 07:00:00	AAPL	Stock	28.99	29.0175	28.9575	28.9575	24632.0
2016-12-23 08:00:00	AAPL	Stock	29.0	29.0025	28.9375	28.9475	91856.0
2016-12-23 09:00:00	AAPL	Stock	28.94	29.125	28.8975	29.1	10945944.0
2016-12-23 10:00:00	AAPL	Stock	29.1	29.115	29.0175	29.025	8428772.0
2016-12-23 11:00:00	AAPL	Stock	29.025	29.0675	28.9925	29.0525	6142352.0
2016-12-23 12:00:00	AAPL	Stock	29.0525	29.0988	29.0475	29.095	4726308.0
2016-12-23 13:00:00	AAPL	Stock	29.0928	29.12	29.0775	29.0862	4512328.0
2016-12-23 14:00:00	AAPL	Stock	29.086	29.1012	29.07	29.1	3835356.0
2016-12-23 15:00:00	AAPL	Stock	29.0988	29.13	29.08	29.1275	9049368.0
2016-12-23 16:00:00	AAPL	Stock	29.13	29.14	29.0875	29.125	4308332.0
2016-12-23 17:00:00	AAPL	Stock	29.13	29.13	29.1225	29.13	9604.0
2016-12-23 18:00:00	AAPL	Stock	29.1275	29.1275	29.1275	29.1275	400.0
2016-12-23 19:00:00	AAPL	Stock	29.13	29.1375	29.125	29.1375	15816.0
2016-12-23 07:00:00	MSFT	Stock	63.55	63.55	63.55	63.55	799.0
2016-12-23 08:00:00	MSFT	Stock	63.6	63.63	63.5	63.63	5970.0
2016-12-23 09:00:00	MSFT	Stock	63.55	63.55	63.1	63.27	1807945.0
2016-12-23 10:00:00	MSFT	Stock	63.27	63.295	62.93	62.96	1641773.0
2016-12-23 11:00:00	MSFT	Stock	62.967	63.02	62.8	62.87	1558888.0
2016-12-23 12:00:00	MSFT	Stock	62.865	63.01	62.865	62.93	978312.0
2016-12-23 13:00:00	MSFT	Stock	62.925	63.03	62.92	62.941	956721.0
2016-12-23 14:00:00	MSFT	Stock	62.94	63.04	62.92	63.035	874866.0
2016-12-23 15:00:00	MSFT	Stock	63.036	63.25	63.034	63.24	2368233.0
2016-12-23 16:00:00	MSFT	Stock	63.23	63.24	63.14	63.22	1393610.0
2016-12-23 17:00:00	MSFT	Stock	63.24	63.24	63.22	63.22	2900.0
2016-12-23 18:00:00	MSFT	Stock	63.24	63.24	63.24	63.24	400.0
2016-12-23 19:00:00	MSFT	Stock	63.27	63.27	63.18	63.18	1751.0
2016-12-23 07:00:00	NVDA	Stock	2.6788	2.6795	2.675	2.675	264400.0
2016-12-23 08:00:00	NVDA	Stock	2.6762	2.6762	2.6552	2.6588	1291680.0
2016-12-23 09:00:00	NVDA	Stock	2.6588	2.6792	2.6475	2.6678	66070960.0
2016-12-23 10:00:00	NVDA	Stock	2.6675	2.687	2.6672	2.6832	68393640.0
2016-12-23 11:00:00	NVDA	Stock	2.683	2.7018	2.6813	2.701	62028120.0
2016-12-23 12:00:00	NVDA	Stock	2.701	2.7208	2.7005	2.7078	94504280.0
2016-12-23 13:00:00	NVDA	Stock	2.7078	2.709	2.6915	2.694	84002360.0
2016-12-23 14:00:00	NVDA	Stock	2.694	2.7253	2.6933	2.725	68641280.0
2016-12-23 15:00:00	NVDA	Stock	2.725	2.7459	2.714	2.7445	135154160.0
2016-12-23 16:00:00	NVDA	Stock	2.7435	2.7475	2.7023	2.7475	29112120.0
2016-12-23 17:00:00	NVDA	Stock	2.7473	2.7475	2.745	2.7465	412920.0
2016-12-23 18:00:00	NVDA	Stock	2.7475	2.7483	2.7448	2.7448	98760.0
2016-12-23 19:00:00	NVDA	Stock	2.7448	2.748	2.743	2.748	152200.0
2016-12-23 07:00:00	AMZN	Stock	38.233	38.233	38.233	38.233	2060.0
2016-12-23 08:00:00	AMZN	Stock	38.255	38.2625	38.255	38.2625	10380.0
2016-12-23 09:00:00	AMZN	Stock	38.24	38.325	38.108	38.1735	5809860.0
2016-12-23 10:00:00	AMZN	Stock	38.1834	38.213	37.962	37.975	6998620.0
2016-12-23 11:00:00	AMZN	Stock	37.968	38.0099	37.8995	37.981	6453440.0
2016-12-23 12:00:00	AMZN	Stock	37.984	38.063	37.9756	38.007	3963540.0
2016-12-23 13:00:00	AMZN	Stock	38.0094	38.087	38.0094	38.0335	2701120.0
2016-12-23 14:00:00	AMZN	Stock	38.0305	38.0945	37.983	37.996	3816060.0
2016-12-23 15:00:00	AMZN	Stock	37.9965	38.0465	37.9815	38.029	7911840.0

> showing 50 of 47,497 rows — these rows as CSV

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