PREVIEW / stock_1hour / 2022-10-20

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-10-20.parquet
  size:    1.3 MB
  rows:    60,506
  symbols: 2,133

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
2022-10-20 04:00:00	AAPL	Stock	142.49	142.9	142.2	142.82	13953.0
2022-10-20 05:00:00	AAPL	Stock	142.85	143.15	142.83	143.0	10658.0
2022-10-20 06:00:00	AAPL	Stock	143.0	144.11	142.8	143.83	25499.0
2022-10-20 07:00:00	AAPL	Stock	143.74	144.2	143.41	143.71	69159.0
2022-10-20 08:00:00	AAPL	Stock	143.8501	144.48	142.51	142.51	329133.0
2022-10-20 09:00:00	AAPL	Stock	142.5	145.3	142.47	144.63	8413680.0
2022-10-20 10:00:00	AAPL	Stock	144.63	145.89	144.57	145.69	8496830.0
2022-10-20 11:00:00	AAPL	Stock	145.7	145.83	144.83	145.38	5869947.0
2022-10-20 12:00:00	AAPL	Stock	145.37	145.41	144.24	144.63	5938312.0
2022-10-20 13:00:00	AAPL	Stock	144.6299	144.69	143.33	143.5699	6047675.0
2022-10-20 14:00:00	AAPL	Stock	143.56	143.64	142.65	143.305	5750697.0
2022-10-20 15:00:00	AAPL	Stock	143.3	143.78	143.0	143.33	8536887.0
2022-10-20 16:00:00	AAPL	Stock	143.33	143.67	143.0	143.35	6803549.0
2022-10-20 17:00:00	AAPL	Stock	143.4	143.49	142.83	142.9777	44906.0
2022-10-20 18:00:00	AAPL	Stock	142.85	142.87	142.11	142.32	47667.0
2022-10-20 19:00:00	AAPL	Stock	142.43	142.72	142.05	142.72	53624.0
2022-10-20 04:00:00	MSFT	Stock	234.02	235.05	234.01	234.8	5665.0
2022-10-20 05:00:00	MSFT	Stock	234.99	235.58	234.99	235.3	4172.0
2022-10-20 06:00:00	MSFT	Stock	235.24	237.65	235.24	236.8	9370.0
2022-10-20 07:00:00	MSFT	Stock	237.12	237.98	236.33	236.33	11090.0
2022-10-20 08:00:00	MSFT	Stock	237.65	239.0	235.53	235.53	38389.0
2022-10-20 09:00:00	MSFT	Stock	235.72	239.36	235.71	238.89	1947704.0
2022-10-20 10:00:00	MSFT	Stock	238.91	241.31	238.54	240.4	1862548.0
2022-10-20 11:00:00	MSFT	Stock	240.4	240.6	238.87	239.65	1213491.0
2022-10-20 12:00:00	MSFT	Stock	239.635	239.65	236.89	237.94	1648925.0
2022-10-20 13:00:00	MSFT	Stock	237.9166	238.5	235.35	235.9836	1468862.0
2022-10-20 14:00:00	MSFT	Stock	235.96	236.21	234.87	235.82	1612237.0
2022-10-20 15:00:00	MSFT	Stock	235.8	236.96	235.38	236.12	2519993.0
2022-10-20 16:00:00	MSFT	Stock	236.11	237.1	235.29	235.81	3966124.0
2022-10-20 17:00:00	MSFT	Stock	236.0	236.09	235.67	235.8	5207.0
2022-10-20 18:00:00	MSFT	Stock	235.82	235.82	234.02	234.6	17398.0
2022-10-20 19:00:00	MSFT	Stock	234.1	235.4	233.25	234.75	21306.0
2022-10-20 04:00:00	NVDA	Stock	11.85	11.937	11.85	11.901	91040.0
2022-10-20 05:00:00	NVDA	Stock	11.911	11.98	11.911	11.969	31330.0
2022-10-20 06:00:00	NVDA	Stock	11.94	12.079	11.94	12.077	64160.0
2022-10-20 07:00:00	NVDA	Stock	12.06	12.087	12.03	12.078	182500.0
2022-10-20 08:00:00	NVDA	Stock	12.0799	12.205	12.013	12.053	1382410.0
2022-10-20 09:00:00	NVDA	Stock	12.043	12.573	12.031	12.561	81492850.0
2022-10-20 10:00:00	NVDA	Stock	12.567	12.769	12.538	12.7421	107698290.0
2022-10-20 11:00:00	NVDA	Stock	12.744	12.759	12.522	12.6112	70864470.0
2022-10-20 12:00:00	NVDA	Stock	12.613	12.621	12.332	12.385	73184720.0
2022-10-20 13:00:00	NVDA	Stock	12.385	12.433	12.236	12.2608	58930570.0
2022-10-20 14:00:00	NVDA	Stock	12.258	12.273	12.1362	12.1999	67455030.0
2022-10-20 15:00:00	NVDA	Stock	12.2	12.277	12.127	12.183	77189270.0
2022-10-20 16:00:00	NVDA	Stock	12.194	12.197	12.082	12.115	21691170.0
2022-10-20 17:00:00	NVDA	Stock	12.119	12.14	12.075	12.11	449230.0
2022-10-20 18:00:00	NVDA	Stock	12.095	12.11	12.04	12.05	775070.0
2022-10-20 19:00:00	NVDA	Stock	12.067	12.067	11.981	12.0	801040.0
2022-10-20 04:00:00	AMZN	Stock	113.59	114.15	113.59	113.72	5490.0
2022-10-20 05:00:00	AMZN	Stock	113.84	114.39	113.84	114.19	3885.0

> showing 50 of 60,506 rows — these rows as CSV

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