PREVIEW / stock_1hour / 2019-03-29

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-03-29.parquet
  size:    1.1 MB
  rows:    50,737
  symbols: 2,654

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-03-29 04:00:00	AAPL	Stock	47.47	47.5	47.36	47.36	19084.0
2019-03-29 05:00:00	AAPL	Stock	47.375	47.425	47.375	47.425	6000.0
2019-03-29 06:00:00	AAPL	Stock	47.3775	47.4225	47.3	47.4225	10464.0
2019-03-29 07:00:00	AAPL	Stock	47.3775	47.5	47.3775	47.4875	125208.0
2019-03-29 08:00:00	AAPL	Stock	47.4372	47.525	47.3	47.5	475924.0
2019-03-29 09:00:00	AAPL	Stock	47.5	47.585	47.195	47.305	10271000.0
2019-03-29 10:00:00	AAPL	Stock	47.305	47.43	47.135	47.1975	12558936.0
2019-03-29 11:00:00	AAPL	Stock	47.195	47.3998	47.1775	47.3425	8765896.0
2019-03-29 12:00:00	AAPL	Stock	47.3425	47.3575	47.2375	47.33	6127528.0
2019-03-29 13:00:00	AAPL	Stock	47.3325	47.3575	47.2725	47.3162	4501596.0
2019-03-29 14:00:00	AAPL	Stock	47.319	47.46	47.285	47.456	6537324.0
2019-03-29 15:00:00	AAPL	Stock	47.4575	47.5	47.3175	47.485	18181516.0
2019-03-29 16:00:00	AAPL	Stock	47.4875	47.52	47.3875	47.51	16266640.0
2019-03-29 17:00:00	AAPL	Stock	47.51	47.5175	47.4775	47.5	68172.0
2019-03-29 18:00:00	AAPL	Stock	47.49	47.49	47.4875	47.4875	3856.0
2019-03-29 19:00:00	AAPL	Stock	47.5	47.5375	47.4875	47.515	50144.0
2019-03-29 04:00:00	MSFT	Stock	117.5	117.5	117.01	117.01	3271.0
2019-03-29 05:00:00	MSFT	Stock	117.32	117.32	117.29	117.29	200.0
2019-03-29 06:00:00	MSFT	Stock	117.05	117.3	117.0	117.3	2798.0
2019-03-29 07:00:00	MSFT	Stock	117.22	117.6	117.2	117.53	12944.0
2019-03-29 08:00:00	MSFT	Stock	117.598	117.75	117.35	117.75	33695.0
2019-03-29 09:00:00	MSFT	Stock	117.65	118.32	117.22	117.41	1995464.0
2019-03-29 10:00:00	MSFT	Stock	117.42	117.849	116.96	117.15	2060920.0
2019-03-29 11:00:00	MSFT	Stock	117.15	117.72	117.13	117.48	1906544.0
2019-03-29 12:00:00	MSFT	Stock	117.47	117.65	117.185	117.48	1432595.0
2019-03-29 13:00:00	MSFT	Stock	117.48	117.51	117.23	117.45	1245283.0
2019-03-29 14:00:00	MSFT	Stock	117.45	117.71	117.42	117.68	1533353.0
2019-03-29 15:00:00	MSFT	Stock	117.68	117.97	117.46	117.95	4867253.0
2019-03-29 16:00:00	MSFT	Stock	117.94	118.05	117.69	118.0	7655826.0
2019-03-29 17:00:00	MSFT	Stock	118.0	118.0	117.9	117.91	6336.0
2019-03-29 18:00:00	MSFT	Stock	117.96	117.99	117.96	117.99	200.0
2019-03-29 19:00:00	MSFT	Stock	117.98	118.02	117.96	118.02	6730.0
2019-03-29 04:00:00	NVDA	Stock	4.4625	4.4725	4.4575	4.4725	29840.0
2019-03-29 05:00:00	NVDA	Stock	4.4575	4.4652	4.4572	4.46	51600.0
2019-03-29 06:00:00	NVDA	Stock	4.4602	4.4768	4.46	4.4768	86600.0
2019-03-29 07:00:00	NVDA	Stock	4.4658	4.4912	4.4625	4.4878	941880.0
2019-03-29 08:00:00	NVDA	Stock	4.4818	4.497	4.46	4.496	1582240.0
2019-03-29 09:00:00	NVDA	Stock	4.4975	4.5135	4.4478	4.468	83646240.0
2019-03-29 10:00:00	NVDA	Stock	4.4681	4.495	4.4502	4.4617	62279280.0
2019-03-29 11:00:00	NVDA	Stock	4.4628	4.4938	4.46	4.46	46112240.0
2019-03-29 12:00:00	NVDA	Stock	4.4608	4.47	4.4522	4.4633	48825760.0
2019-03-29 13:00:00	NVDA	Stock	4.464	4.4745	4.4566	4.4699	24285560.0
2019-03-29 14:00:00	NVDA	Stock	4.4698	4.495	4.4695	4.4908	41827960.0
2019-03-29 15:00:00	NVDA	Stock	4.4915	4.497	4.4798	4.4895	75678960.0
2019-03-29 16:00:00	NVDA	Stock	4.489	4.4912	4.4825	4.4875	21154040.0
2019-03-29 17:00:00	NVDA	Stock	4.4912	4.4912	4.4875	4.4875	154320.0
2019-03-29 18:00:00	NVDA	Stock	4.4875	4.4875	4.4862	4.4875	92000.0
2019-03-29 19:00:00	NVDA	Stock	4.49	4.4975	4.49	4.4975	250520.0
2019-03-29 04:00:00	AMZN	Stock	88.95	88.95	88.95	88.95	2080.0
2019-03-29 05:00:00	AMZN	Stock	88.95	89.0	88.9285	88.9285	17900.0

> showing 50 of 50,737 rows — these rows as CSV

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