PREVIEW / stock_1hour / 2019-12-12

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-12-12.parquet
  size:    1.2 MB
  rows:    51,244
  symbols: 2,506

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
2019-12-12 04:00:00	AAPL	Stock	67.8525	67.8725	67.6725	67.725	47768.0
2019-12-12 05:00:00	AAPL	Stock	67.6625	67.72	67.4375	67.4375	64516.0
2019-12-12 06:00:00	AAPL	Stock	67.4375	67.6	67.4375	67.535	76992.0
2019-12-12 07:00:00	AAPL	Stock	67.545	67.5675	67.0625	67.105	455608.0
2019-12-12 08:00:00	AAPL	Stock	67.1625	67.55	66.9175	66.9525	1233492.0
2019-12-12 09:00:00	AAPL	Stock	66.9625	67.7825	66.75	67.675	23102520.0
2019-12-12 10:00:00	AAPL	Stock	67.685	68.14	67.525	67.76	21844392.0
2019-12-12 11:00:00	AAPL	Stock	67.75	67.78	67.0025	67.0875	15764900.0
2019-12-12 12:00:00	AAPL	Stock	67.075	67.41	66.855	67.335	12854056.0
2019-12-12 13:00:00	AAPL	Stock	67.33	67.5902	67.32	67.5325	7572960.0
2019-12-12 14:00:00	AAPL	Stock	67.5335	67.7812	67.31	67.5492	10544328.0
2019-12-12 15:00:00	AAPL	Stock	67.555	67.925	67.4975	67.865	16908244.0
2019-12-12 16:00:00	AAPL	Stock	67.865	67.9875	67.7875	67.9225	10092996.0
2019-12-12 17:00:00	AAPL	Stock	67.9175	68.0625	67.9175	68.0125	139744.0
2019-12-12 18:00:00	AAPL	Stock	68.01	68.235	68.01	68.235	215412.0
2019-12-12 19:00:00	AAPL	Stock	68.215	68.25	68.125	68.24	206852.0
2019-12-12 04:00:00	MSFT	Stock	151.9	152.14	151.9	152.07	500.0
2019-12-12 05:00:00	MSFT	Stock	152.21	152.21	151.92	151.92	1496.0
2019-12-12 06:00:00	MSFT	Stock	151.99	152.0	151.99	152.0	1075.0
2019-12-12 07:00:00	MSFT	Stock	152.0	152.13	151.85	151.95	21984.0
2019-12-12 08:00:00	MSFT	Stock	151.86	152.1	151.39	151.88	48549.0
2019-12-12 09:00:00	MSFT	Stock	151.88	152.94	151.02	152.87	2990629.0
2019-12-12 10:00:00	MSFT	Stock	152.87	153.42	152.67	153.095	3400243.0
2019-12-12 11:00:00	MSFT	Stock	153.1	153.14	151.88	152.17	1964723.0
2019-12-12 12:00:00	MSFT	Stock	152.14	152.185	151.47	151.74	1745348.0
2019-12-12 13:00:00	MSFT	Stock	151.74	152.21	151.71	152.075	1180429.0
2019-12-12 14:00:00	MSFT	Stock	152.08	152.87	151.81	152.64	2390393.0
2019-12-12 15:00:00	MSFT	Stock	152.64	153.44	152.49	153.23	3888124.0
2019-12-12 16:00:00	MSFT	Stock	153.24	153.55	151.52	153.35	3903503.0
2019-12-12 17:00:00	MSFT	Stock	153.39	153.45	153.35	153.35	14536.0
2019-12-12 18:00:00	MSFT	Stock	153.41	153.58	153.33	153.58	74705.0
2019-12-12 19:00:00	MSFT	Stock	153.55	153.73	153.31	153.73	14128.0
2019-12-12 04:00:00	NVDA	Stock	5.4585	5.4625	5.4585	5.4625	20560.0
2019-12-12 05:00:00	NVDA	Stock	5.4722	5.4722	5.4352	5.4362	65880.0
2019-12-12 06:00:00	NVDA	Stock	5.4423	5.4423	5.437	5.4398	63080.0
2019-12-12 07:00:00	NVDA	Stock	5.4373	5.4473	5.4252	5.4278	198520.0
2019-12-12 08:00:00	NVDA	Stock	5.4438	5.445	5.402	5.4128	719640.0
2019-12-12 09:00:00	NVDA	Stock	5.41	5.5248	5.3955	5.5193	46507040.0
2019-12-12 10:00:00	NVDA	Stock	5.522	5.5635	5.5188	5.549	71420480.0
2019-12-12 11:00:00	NVDA	Stock	5.5493	5.55	5.4842	5.5118	42513800.0
2019-12-12 12:00:00	NVDA	Stock	5.5115	5.5231	5.4773	5.517	29173240.0
2019-12-12 13:00:00	NVDA	Stock	5.5183	5.5425	5.5145	5.5358	22253600.0
2019-12-12 14:00:00	NVDA	Stock	5.5354	5.5715	5.5222	5.5642	35527280.0
2019-12-12 15:00:00	NVDA	Stock	5.5665	5.62	5.5642	5.6028	90736720.0
2019-12-12 16:00:00	NVDA	Stock	5.6018	5.6163	5.5828	5.6062	25153200.0
2019-12-12 17:00:00	NVDA	Stock	5.61	5.6212	5.6073	5.6165	1234160.0
2019-12-12 18:00:00	NVDA	Stock	5.6195	5.6625	5.6188	5.661	1297000.0
2019-12-12 19:00:00	NVDA	Stock	5.6588	5.67	5.6428	5.6675	697080.0
2019-12-12 07:00:00	AMZN	Stock	87.5875	87.5875	87.452	87.475	10200.0
2019-12-12 08:00:00	AMZN	Stock	87.5	87.6545	87.305	87.4065	85520.0

> showing 50 of 51,244 rows — these rows as CSV

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