PREVIEW / stock_1hour / 2022-11-29

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-11-29.parquet
  size:    1.3 MB
  rows:    60,375
  symbols: 2,066

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-11-29 04:00:00	AAPL	Stock	145.04	145.68	144.7	144.92	49593.0
2022-11-29 05:00:00	AAPL	Stock	144.92	145.34	144.87	145.13	13333.0
2022-11-29 06:00:00	AAPL	Stock	145.12	145.29	144.9	145.24	15244.0
2022-11-29 07:00:00	AAPL	Stock	145.16	145.27	144.78	145.06	75504.0
2022-11-29 08:00:00	AAPL	Stock	145.2	145.47	143.86	144.58	261946.0
2022-11-29 09:00:00	AAPL	Stock	144.62	144.91	142.96	143.14	7773850.0
2022-11-29 10:00:00	AAPL	Stock	143.145	144.81	143.08	144.2779	11249615.0
2022-11-29 11:00:00	AAPL	Stock	144.275	144.34	141.2	142.1	15504288.0
2022-11-29 12:00:00	AAPL	Stock	142.11	142.11	141.29	141.5346	7071822.0
2022-11-29 13:00:00	AAPL	Stock	141.535	141.57	140.4958	141.145	6982564.0
2022-11-29 14:00:00	AAPL	Stock	141.15	141.61	140.39	140.5801	6358529.0
2022-11-29 15:00:00	AAPL	Stock	140.585	141.34	140.355	141.16	11515677.0
2022-11-29 16:00:00	AAPL	Stock	141.16	141.33	141.02	141.29	6673226.0
2022-11-29 17:00:00	AAPL	Stock	141.28	141.28	141.01	141.15	67746.0
2022-11-29 18:00:00	AAPL	Stock	141.15	141.19	140.99	140.99	35256.0
2022-11-29 19:00:00	AAPL	Stock	141.0	141.31	140.95	141.31	34596.0
2022-11-29 04:00:00	MSFT	Stock	243.0	243.0	242.16	242.16	2757.0
2022-11-29 05:00:00	MSFT	Stock	242.1	242.5	242.1	242.22	3447.0
2022-11-29 06:00:00	MSFT	Stock	242.44	242.44	242.0	242.33	7106.0
2022-11-29 07:00:00	MSFT	Stock	242.3	242.35	241.73	242.18	25524.0
2022-11-29 08:00:00	MSFT	Stock	242.09	242.6015	241.12	241.53	63856.0
2022-11-29 09:00:00	MSFT	Stock	241.6501	242.79	240.33	240.64	1799474.0
2022-11-29 10:00:00	MSFT	Stock	240.61	241.485	240.1075	240.65	1422236.0
2022-11-29 11:00:00	MSFT	Stock	240.63	240.74	238.21	239.67	1979155.0
2022-11-29 12:00:00	MSFT	Stock	239.67	240.39	239.42	240.1398	1096537.0
2022-11-29 13:00:00	MSFT	Stock	240.14	240.25	239.02	240.06	1010649.0
2022-11-29 14:00:00	MSFT	Stock	240.09	240.93	239.619	240.025	991190.0
2022-11-29 15:00:00	MSFT	Stock	240.04	240.65	239.45	240.29	2159251.0
2022-11-29 16:00:00	MSFT	Stock	240.28	240.55	240.1078	240.4	2386702.0
2022-11-29 17:00:00	MSFT	Stock	240.41	240.53	240.33	240.33	14696.0
2022-11-29 18:00:00	MSFT	Stock	240.4	240.4	240.06	240.1	1665.0
2022-11-29 19:00:00	MSFT	Stock	240.06	240.69	240.06	240.49	2628.0
2022-11-29 04:00:00	NVDA	Stock	15.98	16.004	15.95	15.95	89360.0
2022-11-29 05:00:00	NVDA	Stock	15.951	15.986	15.946	15.97	14640.0
2022-11-29 06:00:00	NVDA	Stock	15.959	16.01	15.952	15.981	77840.0
2022-11-29 07:00:00	NVDA	Stock	16.004	16.01	15.91	15.936	138100.0
2022-11-29 08:00:00	NVDA	Stock	15.98	16.02	15.84	15.959	1785180.0
2022-11-29 09:00:00	NVDA	Stock	15.95	16.0	15.683	15.7655	34784690.0
2022-11-29 10:00:00	NVDA	Stock	15.765	15.932	15.745	15.7769	54123970.0
2022-11-29 11:00:00	NVDA	Stock	15.777	15.787	15.52	15.701	43050130.0
2022-11-29 12:00:00	NVDA	Stock	15.702	15.73	15.635	15.6911	25359730.0
2022-11-29 13:00:00	NVDA	Stock	15.691	15.717	15.581	15.674	24576010.0
2022-11-29 14:00:00	NVDA	Stock	15.6745	15.747	15.613	15.6632	22250290.0
2022-11-29 15:00:00	NVDA	Stock	15.661	15.699	15.597	15.637	36067640.0
2022-11-29 16:00:00	NVDA	Stock	15.639	15.67	15.599	15.64	13364410.0
2022-11-29 17:00:00	NVDA	Stock	15.624	15.64	15.613	15.615	127000.0
2022-11-29 18:00:00	NVDA	Stock	15.622	15.63	15.57	15.57	62290.0
2022-11-29 19:00:00	NVDA	Stock	15.59	15.62	15.581	15.611	112460.0
2022-11-29 04:00:00	AMZN	Stock	94.58	95.15	94.37	94.5	19669.0
2022-11-29 05:00:00	AMZN	Stock	94.47	94.93	94.44	94.81	15488.0

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

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