PREVIEW / stock_1hour / 2019-01-10

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-01-10.parquet
  size:    1.1 MB
  rows:    49,904
  symbols: 2,691

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-01-10 04:00:00	AAPL	Stock	37.95	38.025	37.9	38.005	23496.0
2019-01-10 05:00:00	AAPL	Stock	37.975	38.0675	37.975	38.03	10008.0
2019-01-10 06:00:00	AAPL	Stock	38.0375	38.0375	38.0	38.0	13756.0
2019-01-10 07:00:00	AAPL	Stock	38.0125	38.08	37.965	38.075	122952.0
2019-01-10 08:00:00	AAPL	Stock	38.05	38.1225	37.9575	38.0675	217468.0
2019-01-10 09:00:00	AAPL	Stock	38.05	38.1975	37.715	37.83	18507016.0
2019-01-10 10:00:00	AAPL	Stock	37.8325	38.175	37.775	38.13	18735524.0
2019-01-10 11:00:00	AAPL	Stock	38.1342	38.265	37.995	38.25	13217024.0
2019-01-10 12:00:00	AAPL	Stock	38.2472	38.4125	38.1675	38.36	10977684.0
2019-01-10 13:00:00	AAPL	Stock	38.36	38.3625	38.0775	38.1875	11317024.0
2019-01-10 14:00:00	AAPL	Stock	38.1875	38.3865	38.184	38.2975	10998876.0
2019-01-10 15:00:00	AAPL	Stock	38.295	38.4925	38.25	38.45	18865336.0
2019-01-10 16:00:00	AAPL	Stock	38.45	38.475	38.4275	38.45	11177368.0
2019-01-10 17:00:00	AAPL	Stock	38.45	38.4625	38.45	38.4625	22084.0
2019-01-10 18:00:00	AAPL	Stock	38.44	38.525	38.4025	38.5	252244.0
2019-01-10 19:00:00	AAPL	Stock	38.4875	38.5625	38.4875	38.5625	190976.0
2019-01-10 04:00:00	MSFT	Stock	103.5	103.5	103.48	103.48	600.0
2019-01-10 05:00:00	MSFT	Stock	103.48	103.7	103.48	103.56	1000.0
2019-01-10 06:00:00	MSFT	Stock	103.43	103.6	103.43	103.6	250.0
2019-01-10 07:00:00	MSFT	Stock	103.56	103.65	103.42	103.53	12870.0
2019-01-10 08:00:00	MSFT	Stock	103.501	103.7	103.45	103.55	23114.0
2019-01-10 09:00:00	MSFT	Stock	103.506	103.6	102.594	102.9	2950333.0
2019-01-10 10:00:00	MSFT	Stock	102.905	103.66	102.62	103.545	3411048.0
2019-01-10 11:00:00	MSFT	Stock	103.55	103.61	103.21	103.45	2183075.0
2019-01-10 12:00:00	MSFT	Stock	103.44	103.58	102.9	103.25	3172001.0
2019-01-10 13:00:00	MSFT	Stock	103.255	103.26	102.38	102.86	2716705.0
2019-01-10 14:00:00	MSFT	Stock	102.85	103.37	102.85	103.17	2893362.0
2019-01-10 15:00:00	MSFT	Stock	103.17	103.75	103.14	103.58	4640001.0
2019-01-10 16:00:00	MSFT	Stock	103.6	103.71	103.48	103.57	5196487.0
2019-01-10 17:00:00	MSFT	Stock	103.57	103.6	103.55	103.6	13890.0
2019-01-10 18:00:00	MSFT	Stock	103.5	103.6	103.5	103.55	2728.0
2019-01-10 19:00:00	MSFT	Stock	103.53	103.6	103.42	103.59	5031.0
2019-01-10 04:00:00	NVDA	Stock	3.525	3.535	3.525	3.535	63600.0
2019-01-10 05:00:00	NVDA	Stock	3.535	3.5488	3.535	3.5488	49040.0
2019-01-10 06:00:00	NVDA	Stock	3.5412	3.5468	3.5412	3.5468	72400.0
2019-01-10 07:00:00	NVDA	Stock	3.5498	3.5625	3.5412	3.5562	438600.0
2019-01-10 08:00:00	NVDA	Stock	3.5508	3.5645	3.538	3.5488	1498480.0
2019-01-10 09:00:00	NVDA	Stock	3.544	3.552	3.484	3.5484	73662600.0
2019-01-10 10:00:00	NVDA	Stock	3.5489	3.602	3.5458	3.5976	100714560.0
2019-01-10 11:00:00	NVDA	Stock	3.5975	3.6245	3.5843	3.6062	73551760.0
2019-01-10 12:00:00	NVDA	Stock	3.6059	3.6362	3.6028	3.6272	44406800.0
2019-01-10 13:00:00	NVDA	Stock	3.6272	3.6312	3.5702	3.579	54783080.0
2019-01-10 14:00:00	NVDA	Stock	3.5808	3.6205	3.5808	3.6068	41136640.0
2019-01-10 15:00:00	NVDA	Stock	3.6062	3.6395	3.6053	3.6292	81910640.0
2019-01-10 16:00:00	NVDA	Stock	3.6308	3.6308	3.62	3.625	3282720.0
2019-01-10 17:00:00	NVDA	Stock	3.6275	3.63	3.625	3.6265	256680.0
2019-01-10 18:00:00	NVDA	Stock	3.6263	3.6308	3.6163	3.6163	392920.0
2019-01-10 19:00:00	NVDA	Stock	3.6175	3.625	3.6175	3.625	276800.0
2019-01-10 04:00:00	AMZN	Stock	81.795	82.125	81.795	82.125	27320.0
2019-01-10 05:00:00	AMZN	Stock	82.001	82.072	82.001	82.072	7420.0

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

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