PREVIEW / stock_1hour / 2020-05-28

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-05-28.parquet
  size:    1.2 MB
  rows:    55,898
  symbols: 2,387

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
2020-05-28 04:00:00	AAPL	Stock	79.375	79.3925	79.125	79.125	7532.0
2020-05-28 05:00:00	AAPL	Stock	79.25	79.275	79.01	79.0175	6508.0
2020-05-28 06:00:00	AAPL	Stock	79.095	79.45	79.095	79.405	12936.0
2020-05-28 07:00:00	AAPL	Stock	79.405	79.42	79.025	79.025	195100.0
2020-05-28 08:00:00	AAPL	Stock	79.05	79.435	78.625	78.815	557212.0
2020-05-28 09:00:00	AAPL	Stock	78.8575	80.11	78.8125	79.835	14373284.0
2020-05-28 10:00:00	AAPL	Stock	79.85	80.2	79.6125	80.1175	12400344.0
2020-05-28 11:00:00	AAPL	Stock	80.11	80.43	79.9125	80.4072	11617448.0
2020-05-28 12:00:00	AAPL	Stock	80.4025	80.75	80.3175	80.605	13324972.0
2020-05-28 13:00:00	AAPL	Stock	80.609	80.8375	80.5525	80.63	9916300.0
2020-05-28 14:00:00	AAPL	Stock	80.6262	80.7138	80.4375	80.5825	8959268.0
2020-05-28 15:00:00	AAPL	Stock	80.58	80.86	79.39	79.55	26181612.0
2020-05-28 16:00:00	AAPL	Stock	79.5575	79.875	79.5537	79.8475	13856336.0
2020-05-28 17:00:00	AAPL	Stock	79.8	79.85	79.75	79.85	79312.0
2020-05-28 18:00:00	AAPL	Stock	79.855	79.86	79.625	79.675	124664.0
2020-05-28 19:00:00	AAPL	Stock	79.73	79.7375	79.39	79.525	102432.0
2020-05-28 04:00:00	MSFT	Stock	181.59	181.59	181.5	181.55	400.0
2020-05-28 05:00:00	MSFT	Stock	181.25	181.6	180.72	180.72	2585.0
2020-05-28 06:00:00	MSFT	Stock	180.56	181.39	180.56	181.25	4511.0
2020-05-28 07:00:00	MSFT	Stock	181.44	181.6	180.2	180.2	23661.0
2020-05-28 08:00:00	MSFT	Stock	180.999	181.45	178.5	179.26	114901.0
2020-05-28 09:00:00	MSFT	Stock	179.5	182.38	179.2	181.03	3121460.0
2020-05-28 10:00:00	MSFT	Stock	181.04	182.37	180.38	182.24	3392233.0
2020-05-28 11:00:00	MSFT	Stock	182.24	182.47	181.41	182.445	2954646.0
2020-05-28 12:00:00	MSFT	Stock	182.43	183.83	182.3	183.325	2908701.0
2020-05-28 13:00:00	MSFT	Stock	183.32	184.147	183.32	183.749	2225428.0
2020-05-28 14:00:00	MSFT	Stock	183.74	183.87	183.2	183.52	2048917.0
2020-05-28 15:00:00	MSFT	Stock	183.525	184.1	180.62	181.32	6773537.0
2020-05-28 16:00:00	MSFT	Stock	181.31	182.7	181.3	182.29	4817873.0
2020-05-28 17:00:00	MSFT	Stock	182.21	182.34	182.0	182.0	10408.0
2020-05-28 18:00:00	MSFT	Stock	181.85	182.22	181.6	181.8	8901.0
2020-05-28 19:00:00	MSFT	Stock	181.82	181.85	181.01	181.2	12111.0
2020-05-28 04:00:00	NVDA	Stock	8.5	8.5	8.445	8.45	107520.0
2020-05-28 05:00:00	NVDA	Stock	8.465	8.475	8.4525	8.4525	117080.0
2020-05-28 06:00:00	NVDA	Stock	8.4538	8.4668	8.4323	8.4668	95400.0
2020-05-28 07:00:00	NVDA	Stock	8.4623	8.463	8.4212	8.4212	238520.0
2020-05-28 08:00:00	NVDA	Stock	8.4512	8.4748	8.325	8.338	3246680.0
2020-05-28 09:00:00	NVDA	Stock	8.3368	8.6735	8.3332	8.6382	103177600.0
2020-05-28 10:00:00	NVDA	Stock	8.6395	8.7605	8.581	8.7235	124259640.0
2020-05-28 11:00:00	NVDA	Stock	8.7202	8.737	8.589	8.6476	89126320.0
2020-05-28 12:00:00	NVDA	Stock	8.6475	8.7032	8.6378	8.6765	60147080.0
2020-05-28 13:00:00	NVDA	Stock	8.6775	8.726	8.657	8.6615	47901720.0
2020-05-28 14:00:00	NVDA	Stock	8.6628	8.673	8.5975	8.6258	57699400.0
2020-05-28 15:00:00	NVDA	Stock	8.6262	8.6915	8.4158	8.4828	116726360.0
2020-05-28 16:00:00	NVDA	Stock	8.487	8.6406	8.466	8.5162	15653520.0
2020-05-28 17:00:00	NVDA	Stock	8.5115	8.5122	8.5025	8.5108	304280.0
2020-05-28 18:00:00	NVDA	Stock	8.505	8.5162	8.487	8.5	799520.0
2020-05-28 19:00:00	NVDA	Stock	8.5	8.5	8.455	8.4593	539760.0
2020-05-28 07:00:00	AMZN	Stock	120.11	120.11	119.785	119.785	16000.0
2020-05-28 08:00:00	AMZN	Stock	119.9928	119.9928	118.95	119.068	121020.0

> showing 50 of 55,898 rows — these rows as CSV

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