PREVIEW / stock_1hour / 2022-10-28

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-10-28.parquet
  size:    1.4 MB
  rows:    60,802
  symbols: 2,106

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-28 04:00:00	AAPL	Stock	143.69	146.37	143.69	146.34	89873.0
2022-10-28 05:00:00	AAPL	Stock	146.36	146.36	145.48	146.11	85743.0
2022-10-28 06:00:00	AAPL	Stock	146.11	146.65	145.65	145.9	75866.0
2022-10-28 07:00:00	AAPL	Stock	145.84	146.09	144.9	145.67	229533.0
2022-10-28 08:00:00	AAPL	Stock	145.68	146.24	144.31	145.0	825682.0
2022-10-28 09:00:00	AAPL	Stock	145.0	151.91	144.86	151.28	21807710.0
2022-10-28 10:00:00	AAPL	Stock	151.3	156.03	151.265	155.735	36147981.0
2022-10-28 11:00:00	AAPL	Stock	155.74	156.48	154.96	155.08	18578427.0
2022-10-28 12:00:00	AAPL	Stock	155.0718	156.99	154.75	156.7465	15208404.0
2022-10-28 13:00:00	AAPL	Stock	156.75	157.5	156.41	156.4499	12101674.0
2022-10-28 14:00:00	AAPL	Stock	156.45	156.59	155.6	156.125	11985412.0
2022-10-28 15:00:00	AAPL	Stock	156.13	156.25	155.36	155.71	17348918.0
2022-10-28 16:00:00	AAPL	Stock	155.71	156.4583	155.69	156.3	11127567.0
2022-10-28 17:00:00	AAPL	Stock	156.3	156.3	155.73	155.94	178767.0
2022-10-28 18:00:00	AAPL	Stock	155.94	155.94	155.76	155.8	33975.0
2022-10-28 19:00:00	AAPL	Stock	155.8	155.88	155.79	155.83	50369.0
2022-10-28 04:00:00	MSFT	Stock	224.01	224.4	223.5	224.21	22970.0
2022-10-28 05:00:00	MSFT	Stock	224.21	224.3	223.25	224.29	10990.0
2022-10-28 06:00:00	MSFT	Stock	224.3	224.49	223.91	224.37	6255.0
2022-10-28 07:00:00	MSFT	Stock	224.15	225.09	223.85	224.9	47446.0
2022-10-28 08:00:00	MSFT	Stock	224.39	227.0	223.85	225.69	145878.0
2022-10-28 09:00:00	MSFT	Stock	225.7	230.94	225.2425	229.235	4253756.0
2022-10-28 10:00:00	MSFT	Stock	229.28	235.19	228.39	233.67	6321160.0
2022-10-28 11:00:00	MSFT	Stock	233.68	234.58	232.11	232.5	3435638.0
2022-10-28 12:00:00	MSFT	Stock	232.5	233.81	231.72	232.995	2279555.0
2022-10-28 13:00:00	MSFT	Stock	233.02	234.05	232.94	233.84	1865339.0
2022-10-28 14:00:00	MSFT	Stock	233.84	236.24	233.83	235.7	3197059.0
2022-10-28 15:00:00	MSFT	Stock	235.72	236.6	234.57	235.78	5202349.0
2022-10-28 16:00:00	MSFT	Stock	235.87	236.25	235.39	236.0	5254564.0
2022-10-28 17:00:00	MSFT	Stock	236.0	236.03	235.82	235.85	12128.0
2022-10-28 18:00:00	MSFT	Stock	235.86	235.97	235.74	235.87	6449.0
2022-10-28 19:00:00	MSFT	Stock	235.89	235.89	235.0	235.65	16991.0
2022-10-28 04:00:00	NVDA	Stock	12.904	13.012	12.904	13.012	66230.0
2022-10-28 05:00:00	NVDA	Stock	13.001	13.001	12.953	12.967	66440.0
2022-10-28 06:00:00	NVDA	Stock	12.995	13.01	12.975	13.004	85880.0
2022-10-28 07:00:00	NVDA	Stock	12.986	13.069	12.967	13.03	242980.0
2022-10-28 08:00:00	NVDA	Stock	12.995	13.2	12.839	13.088	901130.0
2022-10-28 09:00:00	NVDA	Stock	13.088	13.541	13.037	13.4336	62032480.0
2022-10-28 10:00:00	NVDA	Stock	13.435	13.513	13.118	13.448	79206790.0
2022-10-28 11:00:00	NVDA	Stock	13.45	13.7	13.45	13.614	64544890.0
2022-10-28 12:00:00	NVDA	Stock	13.615	13.799	13.606	13.735	60218400.0
2022-10-28 13:00:00	NVDA	Stock	13.736	13.764	13.645	13.692	38471200.0
2022-10-28 14:00:00	NVDA	Stock	13.692	13.722	13.657	13.716	34096270.0
2022-10-28 15:00:00	NVDA	Stock	13.716	13.85	13.679	13.834	71413430.0
2022-10-28 16:00:00	NVDA	Stock	13.831	13.887	13.815	13.886	32832190.0
2022-10-28 17:00:00	NVDA	Stock	13.881	13.888	13.866	13.873	369850.0
2022-10-28 18:00:00	NVDA	Stock	13.87	13.889	13.867	13.888	125640.0
2022-10-28 19:00:00	NVDA	Stock	13.888	13.892	13.871	13.879	271750.0
2022-10-28 04:00:00	AMZN	Stock	96.55	98.84	94.81	95.67	300589.0
2022-10-28 05:00:00	AMZN	Stock	95.65	96.51	95.65	96.5	254397.0

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

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