PREVIEW / stock_1hour / 2022-10-26

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-10-26.parquet
  size:    1.4 MB
  rows:    62,024
  symbols: 2,178

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-26 04:00:00	AAPL	Stock	151.06	151.78	151.06	151.47	62511.0
2022-10-26 05:00:00	AAPL	Stock	151.31	151.41	150.81	150.86	27717.0
2022-10-26 06:00:00	AAPL	Stock	150.85	151.3	150.66	151.27	44276.0
2022-10-26 07:00:00	AAPL	Stock	151.1	151.71	150.78	151.1	191958.0
2022-10-26 08:00:00	AAPL	Stock	151.09	151.96	150.42	150.71	290418.0
2022-10-26 09:00:00	AAPL	Stock	150.71	151.32	149.53	149.62	10452112.0
2022-10-26 10:00:00	AAPL	Stock	149.63	150.9699	149.625	150.4837	11379552.0
2022-10-26 11:00:00	AAPL	Stock	150.49	151.89	150.49	151.5568	7807785.0
2022-10-26 12:00:00	AAPL	Stock	151.5599	151.99	150.5	150.58	6613748.0
2022-10-26 13:00:00	AAPL	Stock	150.5598	150.56	148.8784	149.4591	9384529.0
2022-10-26 14:00:00	AAPL	Stock	149.455	149.52	148.04	148.81	7864653.0
2022-10-26 15:00:00	AAPL	Stock	148.8	149.53	148.49	149.51	12158582.0
2022-10-26 16:00:00	AAPL	Stock	149.35	150.7	148.49	149.88	9034947.0
2022-10-26 17:00:00	AAPL	Stock	149.8	149.8	149.2	149.2	141317.0
2022-10-26 18:00:00	AAPL	Stock	149.11	149.6	148.99	149.2	165528.0
2022-10-26 19:00:00	AAPL	Stock	149.16	149.99	149.16	149.8	74456.0
2022-10-26 04:00:00	MSFT	Stock	235.26	237.34	235.2	236.8	75254.0
2022-10-26 05:00:00	MSFT	Stock	236.62	236.86	235.5	235.52	60104.0
2022-10-26 06:00:00	MSFT	Stock	235.54	235.9	234.66	234.7	117840.0
2022-10-26 07:00:00	MSFT	Stock	234.96	235.89	233.27	234.75	385669.0
2022-10-26 08:00:00	MSFT	Stock	234.9	235.8	233.35	233.96	568065.0
2022-10-26 09:00:00	MSFT	Stock	233.9	234.63	230.17	231.12	15150391.0
2022-10-26 10:00:00	MSFT	Stock	231.13	237.23	230.81	235.22	14473312.0
2022-10-26 11:00:00	MSFT	Stock	235.25	238.3	235.25	236.525	7201239.0
2022-10-26 12:00:00	MSFT	Stock	236.52	237.17	234.82	234.93	5328074.0
2022-10-26 13:00:00	MSFT	Stock	234.925	235.189	233.2729	235.086	4565927.0
2022-10-26 14:00:00	MSFT	Stock	235.08	235.78	232.96	233.425	4288911.0
2022-10-26 15:00:00	MSFT	Stock	233.41	233.415	230.06	231.2027	9020042.0
2022-10-26 16:00:00	MSFT	Stock	231.2	231.67	230.23	231.5	5033152.0
2022-10-26 17:00:00	MSFT	Stock	231.44	231.63	230.61	230.74	57620.0
2022-10-26 18:00:00	MSFT	Stock	230.65	231.71	230.38	231.71	53955.0
2022-10-26 19:00:00	MSFT	Stock	231.7	232.75	231.7	232.55	59587.0
2022-10-26 04:00:00	NVDA	Stock	12.902	13.0	12.902	12.986	465210.0
2022-10-26 05:00:00	NVDA	Stock	12.984	12.984	12.905	12.963	26270.0
2022-10-26 06:00:00	NVDA	Stock	12.923	12.976	12.921	12.937	53110.0
2022-10-26 07:00:00	NVDA	Stock	12.95	12.99	12.875	12.928	389430.0
2022-10-26 08:00:00	NVDA	Stock	12.918	12.983	12.861	12.901	975090.0
2022-10-26 09:00:00	NVDA	Stock	12.9	13.124	12.708	13.069	71595960.0
2022-10-26 10:00:00	NVDA	Stock	13.069	13.302	12.96	13.19	88508900.0
2022-10-26 11:00:00	NVDA	Stock	13.191	13.388	13.19	13.298	60418720.0
2022-10-26 12:00:00	NVDA	Stock	13.3	13.333	13.08	13.093	44388170.0
2022-10-26 13:00:00	NVDA	Stock	13.092	13.094	12.866	13.011	57534300.0
2022-10-26 14:00:00	NVDA	Stock	13.01	13.058	12.926	13.002	37566530.0
2022-10-26 15:00:00	NVDA	Stock	13.005	13.005	12.877	12.895	54022450.0
2022-10-26 16:00:00	NVDA	Stock	12.896	13.493	12.851	13.4	28429010.0
2022-10-26 17:00:00	NVDA	Stock	13.4	13.547	13.391	13.391	3825940.0
2022-10-26 18:00:00	NVDA	Stock	13.39	13.512	13.356	13.478	1973760.0
2022-10-26 19:00:00	NVDA	Stock	13.48	13.495	13.425	13.448	806160.0
2022-10-26 04:00:00	AMZN	Stock	116.4	116.8	115.0	116.52	92024.0
2022-10-26 05:00:00	AMZN	Stock	116.52	116.59	115.81	116.1	22954.0

> showing 50 of 62,024 rows — these rows as CSV

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