PREVIEW / stock_1hour / 2018-01-10

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-01-10.parquet
  size:    1.1 MB
  rows:    49,758
  symbols: 2,903

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-10 04:00:00	AAPL	Stock	43.475	43.475	43.3575	43.3625	16148.0
2018-01-10 05:00:00	AAPL	Stock	43.3325	43.3325	43.27	43.2875	19632.0
2018-01-10 06:00:00	AAPL	Stock	43.245	43.245	43.15	43.175	60880.0
2018-01-10 07:00:00	AAPL	Stock	43.1825	43.27	43.125	43.2025	267892.0
2018-01-10 08:00:00	AAPL	Stock	43.205	43.45	43.1425	43.31	402088.0
2018-01-10 09:00:00	AAPL	Stock	43.3	43.4775	43.25	43.33	13172796.0
2018-01-10 10:00:00	AAPL	Stock	43.34	43.5525	43.2578	43.395	14038556.0
2018-01-10 11:00:00	AAPL	Stock	43.394	43.4775	43.295	43.3025	8638444.0
2018-01-10 12:00:00	AAPL	Stock	43.3	43.3625	43.25	43.3438	6420256.0
2018-01-10 13:00:00	AAPL	Stock	43.3438	43.4325	43.26	43.4238	6263376.0
2018-01-10 14:00:00	AAPL	Stock	43.425	43.4775	43.3575	43.4308	15765384.0
2018-01-10 15:00:00	AAPL	Stock	43.43	43.575	43.3825	43.5612	11911240.0
2018-01-10 16:00:00	AAPL	Stock	43.5725	43.5725	43.3755	43.56	6665232.0
2018-01-10 17:00:00	AAPL	Stock	43.56	43.575	43.55	43.575	823484.0
2018-01-10 18:00:00	AAPL	Stock	43.5825	43.5825	43.55	43.5725	4060.0
2018-01-10 19:00:00	AAPL	Stock	43.5725	43.6125	43.5675	43.6125	21536.0
2018-01-10 05:00:00	MSFT	Stock	88.0	88.0	88.0	88.0	801.0
2018-01-10 06:00:00	MSFT	Stock	87.89	87.89	87.11	87.15	700.0
2018-01-10 07:00:00	MSFT	Stock	87.82	87.84	87.45	87.55	5443.0
2018-01-10 08:00:00	MSFT	Stock	87.75	87.99	87.45	87.77	9926.0
2018-01-10 09:00:00	MSFT	Stock	87.79	88.19	87.58	87.86	2327651.0
2018-01-10 10:00:00	MSFT	Stock	87.855	87.94	87.56	87.69	2663958.0
2018-01-10 11:00:00	MSFT	Stock	87.69	87.88	87.52	87.56	1539024.0
2018-01-10 12:00:00	MSFT	Stock	87.55	87.78	87.455	87.74	1503338.0
2018-01-10 13:00:00	MSFT	Stock	87.732	87.87	87.52	87.8	1538920.0
2018-01-10 14:00:00	MSFT	Stock	87.8	87.809	87.41	87.715	1569650.0
2018-01-10 15:00:00	MSFT	Stock	87.71	87.92	87.69	87.81	2641760.0
2018-01-10 16:00:00	MSFT	Stock	87.82	87.85	87.71	87.75	2927265.0
2018-01-10 17:00:00	MSFT	Stock	87.82	87.88	87.82	87.88	922.0
2018-01-10 19:00:00	MSFT	Stock	87.81	87.88	87.81	87.88	11752.0
2018-01-10 04:00:00	NVDA	Stock	5.525	5.525	5.4788	5.5	150680.0
2018-01-10 05:00:00	NVDA	Stock	5.5075	5.51	5.45	5.45	286640.0
2018-01-10 06:00:00	NVDA	Stock	5.4488	5.46	5.447	5.45	385560.0
2018-01-10 07:00:00	NVDA	Stock	5.4528	5.47	5.4403	5.455	1776160.0
2018-01-10 08:00:00	NVDA	Stock	5.455	5.4965	5.44	5.4825	4442080.0
2018-01-10 09:00:00	NVDA	Stock	5.4842	5.5225	5.4	5.4488	114763200.0
2018-01-10 10:00:00	NVDA	Stock	5.4494	5.4948	5.426	5.4918	99600480.0
2018-01-10 11:00:00	NVDA	Stock	5.4934	5.575	5.4934	5.575	89381440.0
2018-01-10 12:00:00	NVDA	Stock	5.575	5.5932	5.5618	5.5658	62987840.0
2018-01-10 13:00:00	NVDA	Stock	5.5658	5.59	5.545	5.585	42591240.0
2018-01-10 14:00:00	NVDA	Stock	5.586	5.5943	5.55	5.5655	38624160.0
2018-01-10 15:00:00	NVDA	Stock	5.567	5.5955	5.557	5.5915	63070520.0
2018-01-10 16:00:00	NVDA	Stock	5.592	5.6175	5.5485	5.605	20916560.0
2018-01-10 17:00:00	NVDA	Stock	5.6073	5.617	5.592	5.608	2313480.0
2018-01-10 18:00:00	NVDA	Stock	5.6075	5.6138	5.6075	5.611	184400.0
2018-01-10 19:00:00	NVDA	Stock	5.6112	5.6138	5.6062	5.6138	503560.0
2018-01-10 04:00:00	AMZN	Stock	62.5	62.5	62.5	62.5	4700.0
2018-01-10 05:00:00	AMZN	Stock	62.4	62.4	62.0505	62.0505	20580.0
2018-01-10 06:00:00	AMZN	Stock	62.0	62.0	61.9	62.0	28680.0
2018-01-10 07:00:00	AMZN	Stock	62.0065	62.15	61.95	62.15	67320.0

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

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