PREVIEW / stock_1hour / 2018-01-05

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-01-05.parquet
  size:    1.1 MB
  rows:    49,854
  symbols: 2,925

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
2018-01-05 04:00:00	AAPL	Stock	43.175	43.25	43.175	43.25	16276.0
2018-01-05 05:00:00	AAPL	Stock	43.25	43.36	43.25	43.36	24420.0
2018-01-05 06:00:00	AAPL	Stock	43.375	43.4	43.315	43.325	30772.0
2018-01-05 07:00:00	AAPL	Stock	43.33	43.3875	43.2875	43.3525	105936.0
2018-01-05 08:00:00	AAPL	Stock	43.375	43.455	43.325	43.44	329676.0
2018-01-05 09:00:00	AAPL	Stock	43.41	43.5475	43.2625	43.52	13091564.0
2018-01-05 10:00:00	AAPL	Stock	43.525	43.7975	43.445	43.7838	16710312.0
2018-01-05 11:00:00	AAPL	Stock	43.7838	43.7938	43.6825	43.735	8301388.0
2018-01-05 12:00:00	AAPL	Stock	43.735	43.735	43.64	43.715	7375492.0
2018-01-05 13:00:00	AAPL	Stock	43.7158	43.7575	43.6885	43.7525	5334256.0
2018-01-05 14:00:00	AAPL	Stock	43.7585	43.77	43.6625	43.7125	6358600.0
2018-01-05 15:00:00	AAPL	Stock	43.71	43.8425	43.6875	43.74	16757936.0
2018-01-05 16:00:00	AAPL	Stock	43.75	43.7575	43.7425	43.7475	9977576.0
2018-01-05 17:00:00	AAPL	Stock	43.7475	43.775	43.7475	43.75	247052.0
2018-01-05 18:00:00	AAPL	Stock	43.745	43.7675	43.7425	43.745	23948.0
2018-01-05 19:00:00	AAPL	Stock	43.745	43.7675	43.745	43.7675	25032.0
2018-01-05 04:00:00	MSFT	Stock	87.35	87.35	87.35	87.35	100.0
2018-01-05 05:00:00	MSFT	Stock	87.45	87.65	87.45	87.65	550.0
2018-01-05 06:00:00	MSFT	Stock	87.65	87.65	87.6	87.6	844.0
2018-01-05 07:00:00	MSFT	Stock	87.59	87.59	87.54	87.55	1020.0
2018-01-05 08:00:00	MSFT	Stock	87.45	87.65	87.37	87.5	13379.0
2018-01-05 09:00:00	MSFT	Stock	87.55	88.035	87.41	88.03	2651553.0
2018-01-05 10:00:00	MSFT	Stock	88.035	88.21	87.915	88.12	2762549.0
2018-01-05 11:00:00	MSFT	Stock	88.13	88.41	88.1	88.155	1959987.0
2018-01-05 12:00:00	MSFT	Stock	88.16	88.23	88.055	88.11	1634954.0
2018-01-05 13:00:00	MSFT	Stock	88.105	88.161	88.05	88.126	1137667.0
2018-01-05 14:00:00	MSFT	Stock	88.124	88.15	88.02	88.08	1406707.0
2018-01-05 15:00:00	MSFT	Stock	88.08	88.38	87.95	88.11	4655670.0
2018-01-05 16:00:00	MSFT	Stock	88.19	88.21	88.08	88.2	5054194.0
2018-01-05 17:00:00	MSFT	Stock	88.2	88.2	88.12	88.12	360.0
2018-01-05 18:00:00	MSFT	Stock	88.14	88.16	88.14	88.15	1191.0
2018-01-05 19:00:00	MSFT	Stock	88.19	88.23	88.14	88.23	2372.0
2018-01-05 04:00:00	NVDA	Stock	5.35	5.3573	5.3375	5.35	152000.0
2018-01-05 05:00:00	NVDA	Stock	5.35	5.3573	5.3475	5.3573	119720.0
2018-01-05 06:00:00	NVDA	Stock	5.3573	5.3635	5.3573	5.3592	29760.0
2018-01-05 07:00:00	NVDA	Stock	5.36	5.3623	5.3452	5.35	967560.0
2018-01-05 08:00:00	NVDA	Stock	5.35	5.3688	5.3458	5.3555	1669560.0
2018-01-05 09:00:00	NVDA	Stock	5.3545	5.3588	5.277	5.3298	87646960.0
2018-01-05 10:00:00	NVDA	Stock	5.3291	5.3348	5.2808	5.3052	75013400.0
2018-01-05 11:00:00	NVDA	Stock	5.306	5.3472	5.2952	5.347	47054840.0
2018-01-05 12:00:00	NVDA	Stock	5.3475	5.4	5.3452	5.3968	89078480.0
2018-01-05 13:00:00	NVDA	Stock	5.3983	5.4135	5.3932	5.4098	63351600.0
2018-01-05 14:00:00	NVDA	Stock	5.4103	5.4228	5.4	5.4038	50252760.0
2018-01-05 15:00:00	NVDA	Stock	5.4045	5.4053	5.3675	5.382	83594760.0
2018-01-05 16:00:00	NVDA	Stock	5.3808	5.385	5.3625	5.3832	8810040.0
2018-01-05 17:00:00	NVDA	Stock	5.3813	5.3848	5.375	5.3838	578800.0
2018-01-05 18:00:00	NVDA	Stock	5.3848	5.405	5.3848	5.4038	1457400.0
2018-01-05 19:00:00	NVDA	Stock	5.4038	5.4038	5.3962	5.3962	945360.0
2018-01-05 07:00:00	AMZN	Stock	60.546	60.7	60.546	60.7	68980.0
2018-01-05 08:00:00	AMZN	Stock	60.665	60.8	60.66	60.75	436280.0

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

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