PREVIEW / stock_1hour / 2022-09-26

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-09-26.parquet
  size:    1.4 MB
  rows:    62,661
  symbols: 2,281

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-09-26 04:00:00	AAPL	Stock	150.39	150.8	149.96	150.38	35428.0
2022-09-26 05:00:00	AAPL	Stock	150.45	150.45	149.17	149.4	20780.0
2022-09-26 06:00:00	AAPL	Stock	149.39	149.78	149.23	149.55	36285.0
2022-09-26 07:00:00	AAPL	Stock	149.52	149.82	149.27	149.8	83786.0
2022-09-26 08:00:00	AAPL	Stock	149.78	150.56	148.83	150.53	253482.0
2022-09-26 09:00:00	AAPL	Stock	150.5	152.75	149.42	152.6818	12684573.0
2022-09-26 10:00:00	AAPL	Stock	152.69	153.7701	152.3	152.52	12774867.0
2022-09-26 11:00:00	AAPL	Stock	152.53	152.84	150.9201	151.9	11062564.0
2022-09-26 12:00:00	AAPL	Stock	151.91	152.09	150.53	151.38	7650402.0
2022-09-26 13:00:00	AAPL	Stock	151.38	151.44	150.04	150.11	6865832.0
2022-09-26 14:00:00	AAPL	Stock	150.1	151.7	150.0407	151.53	7499606.0
2022-09-26 15:00:00	AAPL	Stock	151.53	152.0	150.56	150.75	13463331.0
2022-09-26 16:00:00	AAPL	Stock	150.75	151.1347	150.42	150.59	7902072.0
2022-09-26 17:00:00	AAPL	Stock	150.57	150.77	150.53	150.649	51952.0
2022-09-26 18:00:00	AAPL	Stock	150.65	150.98	150.5	150.78	50388.0
2022-09-26 19:00:00	AAPL	Stock	150.77	151.23	150.75	151.1	58003.0
2022-09-26 04:00:00	MSFT	Stock	237.8	238.55	237.3	238.47	4324.0
2022-09-26 05:00:00	MSFT	Stock	238.37	238.37	236.39	236.51	8971.0
2022-09-26 06:00:00	MSFT	Stock	236.52	237.2	236.37	236.9	2084.0
2022-09-26 07:00:00	MSFT	Stock	237.2	237.3	236.41	236.79	21642.0
2022-09-26 08:00:00	MSFT	Stock	236.9003	238.5666	236.4	238.5666	44131.0
2022-09-26 09:00:00	MSFT	Stock	238.35	240.71	235.66	240.54	3172711.0
2022-09-26 10:00:00	MSFT	Stock	240.565	241.45	239.78	240.57	2992205.0
2022-09-26 11:00:00	MSFT	Stock	240.57	240.84	238.375	239.67	1874656.0
2022-09-26 12:00:00	MSFT	Stock	239.69	239.7319	237.7918	239.0827	1509621.0
2022-09-26 13:00:00	MSFT	Stock	239.09	239.11	236.9272	236.99	1540527.0
2022-09-26 14:00:00	MSFT	Stock	236.97	238.95	236.9	238.5	1593473.0
2022-09-26 15:00:00	MSFT	Stock	238.57	239.59	237.16	237.46	3547146.0
2022-09-26 16:00:00	MSFT	Stock	237.5	237.52	236.86	237.27	4911073.0
2022-09-26 17:00:00	MSFT	Stock	237.3	237.45	237.1	237.1389	37290.0
2022-09-26 18:00:00	MSFT	Stock	237.18	237.31	236.9	237.31	20237.0
2022-09-26 19:00:00	MSFT	Stock	237.31	237.86	237.31	237.61	28545.0
2022-09-26 04:00:00	NVDA	Stock	12.486	12.62	12.482	12.557	225820.0
2022-09-26 05:00:00	NVDA	Stock	12.551	12.551	12.386	12.464	224350.0
2022-09-26 06:00:00	NVDA	Stock	12.442	12.489	12.339	12.45	134010.0
2022-09-26 07:00:00	NVDA	Stock	12.46	12.468	12.4	12.44	352840.0
2022-09-26 08:00:00	NVDA	Stock	12.433	12.545	12.309	12.54	1333480.0
2022-09-26 09:00:00	NVDA	Stock	12.53	12.61	12.4013	12.578	67849310.0
2022-09-26 10:00:00	NVDA	Stock	12.58	12.659	12.402	12.4381	69196480.0
2022-09-26 11:00:00	NVDA	Stock	12.439	12.447	12.304	12.4162	61968190.0
2022-09-26 12:00:00	NVDA	Stock	12.4185	12.4185	12.262	12.337	39162710.0
2022-09-26 13:00:00	NVDA	Stock	12.336	12.354	12.234	12.25	51620890.0
2022-09-26 14:00:00	NVDA	Stock	12.247	12.413	12.2448	12.395	50073140.0
2022-09-26 15:00:00	NVDA	Stock	12.3945	12.444	12.214	12.223	72683810.0
2022-09-26 16:00:00	NVDA	Stock	12.228	12.23	12.1825	12.212	25474350.0
2022-09-26 17:00:00	NVDA	Stock	12.21	12.2179	12.175	12.193	521630.0
2022-09-26 18:00:00	NVDA	Stock	12.19	12.21	12.171	12.183	440570.0
2022-09-26 19:00:00	NVDA	Stock	12.197	12.24	12.195	12.225	601280.0
2022-09-26 04:00:00	AMZN	Stock	113.7	113.92	113.02	113.78	32713.0
2022-09-26 05:00:00	AMZN	Stock	113.86	113.87	112.75	113.2	24481.0

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

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