PREVIEW / stock_1hour / 2019-05-22

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-05-22.parquet
  size:    1.1 MB
  rows:    49,152
  symbols: 2,601

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-05-22 04:00:00	AAPL	Stock	46.445	46.445	46.375	46.375	9772.0
2019-05-22 05:00:00	AAPL	Stock	46.34	46.375	46.155	46.225	33196.0
2019-05-22 06:00:00	AAPL	Stock	46.225	46.3925	46.225	46.25	37760.0
2019-05-22 07:00:00	AAPL	Stock	46.275	46.315	46.0725	46.1	283372.0
2019-05-22 08:00:00	AAPL	Stock	46.1225	46.325	45.8125	46.065	665940.0
2019-05-22 09:00:00	AAPL	Stock	46.075	46.4275	46.0375	46.2638	13960324.0
2019-05-22 10:00:00	AAPL	Stock	46.2638	46.315	45.7625	45.8098	19965152.0
2019-05-22 11:00:00	AAPL	Stock	45.8088	46.1025	45.6375	45.9735	14237812.0
2019-05-22 12:00:00	AAPL	Stock	45.9738	46.0078	45.75	45.8375	8906436.0
2019-05-22 13:00:00	AAPL	Stock	45.835	45.8575	45.685	45.8325	8944384.0
2019-05-22 14:00:00	AAPL	Stock	45.8375	45.9625	45.735	45.903	9943448.0
2019-05-22 15:00:00	AAPL	Stock	45.9075	45.9272	45.6625	45.6975	15370488.0
2019-05-22 16:00:00	AAPL	Stock	45.695	45.695	45.6	45.615	9498244.0
2019-05-22 17:00:00	AAPL	Stock	45.6325	45.675	45.625	45.6525	59384.0
2019-05-22 18:00:00	AAPL	Stock	45.6525	45.6525	45.6	45.62	39664.0
2019-05-22 19:00:00	AAPL	Stock	45.61	45.6125	45.545	45.6125	87536.0
2019-05-22 04:00:00	MSFT	Stock	126.58	126.72	126.57	126.7	1216.0
2019-05-22 05:00:00	MSFT	Stock	126.75	127.0	126.75	126.9	1071.0
2019-05-22 06:00:00	MSFT	Stock	126.9	127.14	126.89	126.92	2019.0
2019-05-22 07:00:00	MSFT	Stock	126.77	126.8	126.35	126.35	3003.0
2019-05-22 08:00:00	MSFT	Stock	126.65	126.768	126.01	126.45	20394.0
2019-05-22 09:00:00	MSFT	Stock	126.45	127.34	126.32	127.31	1421910.0
2019-05-22 10:00:00	MSFT	Stock	127.32	127.89	127.1	127.405	2283121.0
2019-05-22 11:00:00	MSFT	Stock	127.4	127.715	127.19	127.42	1296665.0
2019-05-22 12:00:00	MSFT	Stock	127.42	127.69	127.34	127.58	1075258.0
2019-05-22 13:00:00	MSFT	Stock	127.57	127.85	127.33	127.8	1309682.0
2019-05-22 14:00:00	MSFT	Stock	127.78	128.24	127.68	128.03	1543090.0
2019-05-22 15:00:00	MSFT	Stock	128.03	128.15	127.66	127.66	2339916.0
2019-05-22 16:00:00	MSFT	Stock	127.67	127.86	127.6	127.61	2280483.0
2019-05-22 17:00:00	MSFT	Stock	127.65	127.67	127.62	127.67	2095.0
2019-05-22 18:00:00	MSFT	Stock	127.67	127.7	127.67	127.7	908.0
2019-05-22 19:00:00	MSFT	Stock	127.62	127.62	127.45	127.5	3704.0
2019-05-22 05:00:00	NVDA	Stock	3.8765	3.8775	3.8628	3.8628	13240.0
2019-05-22 06:00:00	NVDA	Stock	3.8625	3.8625	3.8588	3.8588	20000.0
2019-05-22 07:00:00	NVDA	Stock	3.8628	3.874	3.842	3.842	468600.0
2019-05-22 08:00:00	NVDA	Stock	3.85	3.8698	3.8325	3.8352	1540680.0
2019-05-22 09:00:00	NVDA	Stock	3.84	3.8638	3.8153	3.851	53010640.0
2019-05-22 10:00:00	NVDA	Stock	3.8519	3.858	3.794	3.8028	55116800.0
2019-05-22 11:00:00	NVDA	Stock	3.8028	3.8308	3.7978	3.8285	32632960.0
2019-05-22 12:00:00	NVDA	Stock	3.8281	3.8281	3.7988	3.8048	23193400.0
2019-05-22 13:00:00	NVDA	Stock	3.8042	3.8155	3.7948	3.81	16370680.0
2019-05-22 14:00:00	NVDA	Stock	3.81	3.825	3.797	3.8205	25394360.0
2019-05-22 15:00:00	NVDA	Stock	3.8206	3.828	3.804	3.805	38073120.0
2019-05-22 16:00:00	NVDA	Stock	3.805	3.8095	3.798	3.8018	23092760.0
2019-05-22 17:00:00	NVDA	Stock	3.8028	3.8088	3.8018	3.8075	137920.0
2019-05-22 18:00:00	NVDA	Stock	3.8062	3.8062	3.803	3.805	88720.0
2019-05-22 19:00:00	NVDA	Stock	3.805	3.8062	3.7902	3.7975	224520.0
2019-05-22 04:00:00	AMZN	Stock	92.6975	92.6975	92.6975	92.6975	2000.0
2019-05-22 05:00:00	AMZN	Stock	92.75	92.75	92.725	92.725	41500.0
2019-05-22 06:00:00	AMZN	Stock	92.756	92.756	92.71	92.71	10180.0

> showing 50 of 49,152 rows — these rows as CSV

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