PREVIEW / stock_1hour / 2023-03-29

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-03-29.parquet
  size:    1.3 MB
  rows:    60,061
  symbols: 1,755

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
2023-03-29 04:00:00	AAPL	Stock	158.66	158.7	158.33	158.54	34348.0
2023-03-29 05:00:00	AAPL	Stock	158.56	158.8	158.56	158.73	8216.0
2023-03-29 06:00:00	AAPL	Stock	158.75	158.75	158.54	158.54	11593.0
2023-03-29 07:00:00	AAPL	Stock	158.52	158.8	158.5	158.74	28946.0
2023-03-29 08:00:00	AAPL	Stock	158.6001	159.2	157.256	158.95	133704.0
2023-03-29 09:00:00	AAPL	Stock	158.9996	160.08	158.9109	159.848	6782176.0
2023-03-29 10:00:00	AAPL	Stock	159.86	160.3	159.35	159.5106	6372945.0
2023-03-29 11:00:00	AAPL	Stock	159.51	160.06	159.5	159.87	3998686.0
2023-03-29 12:00:00	AAPL	Stock	159.88	160.04	159.51	159.955	3466441.0
2023-03-29 13:00:00	AAPL	Stock	159.955	160.46	159.84	160.02	4329203.0
2023-03-29 14:00:00	AAPL	Stock	160.025	160.51	159.9	160.445	4010325.0
2023-03-29 15:00:00	AAPL	Stock	160.45	161.05	160.295	160.78	8446640.0
2023-03-29 16:00:00	AAPL	Stock	160.78	160.94	160.62	160.63	7081551.0
2023-03-29 17:00:00	AAPL	Stock	160.64	160.77	160.6	160.6102	209840.0
2023-03-29 18:00:00	AAPL	Stock	160.61	160.65	160.51	160.59	16265.0
2023-03-29 19:00:00	AAPL	Stock	160.5999	160.6	160.21	160.35	20149.0
2023-03-29 04:00:00	MSFT	Stock	276.88	277.79	276.8	277.06	9958.0
2023-03-29 05:00:00	MSFT	Stock	277.32	277.8	277.32	277.6	8002.0
2023-03-29 06:00:00	MSFT	Stock	277.67	277.67	277.3	277.51	2617.0
2023-03-29 07:00:00	MSFT	Stock	277.42	277.85	277.38	277.6	20904.0
2023-03-29 08:00:00	MSFT	Stock	277.6397	277.88	276.1	277.59	45637.0
2023-03-29 09:00:00	MSFT	Stock	277.48	279.97	277.4	279.905	2299026.0
2023-03-29 10:00:00	MSFT	Stock	279.93	280.66	278.7	278.86	2958723.0
2023-03-29 11:00:00	MSFT	Stock	278.87	279.95	278.41	279.69	1739068.0
2023-03-29 12:00:00	MSFT	Stock	279.7	280.01	279.16	279.35	1370331.0
2023-03-29 13:00:00	MSFT	Stock	279.3613	280.14	278.96	279.17	1281612.0
2023-03-29 14:00:00	MSFT	Stock	279.17	279.81	278.96	279.73	1348945.0
2023-03-29 15:00:00	MSFT	Stock	279.73	281.1398	279.37	280.52	3679211.0
2023-03-29 16:00:00	MSFT	Stock	280.73	280.8	280.21	280.68	5126691.0
2023-03-29 17:00:00	MSFT	Stock	280.7	281.49	280.51	281.2134	48615.0
2023-03-29 18:00:00	MSFT	Stock	281.22	281.28	281.0	281.0	5675.0
2023-03-29 19:00:00	MSFT	Stock	280.95	281.13	280.68	281.0	10716.0
2023-03-29 04:00:00	NVDA	Stock	26.702	26.786	26.552	26.75	226440.0
2023-03-29 05:00:00	NVDA	Stock	26.75	26.815	26.75	26.809	126330.0
2023-03-29 06:00:00	NVDA	Stock	26.819	26.896	26.756	26.756	171590.0
2023-03-29 07:00:00	NVDA	Stock	26.756	26.797	26.718	26.77	565150.0
2023-03-29 08:00:00	NVDA	Stock	26.705	26.798	26.466	26.73	1688020.0
2023-03-29 09:00:00	NVDA	Stock	26.72	27.067	26.72	27.028	53993940.0
2023-03-29 10:00:00	NVDA	Stock	27.03	27.042	26.597	26.706	59753420.0
2023-03-29 11:00:00	NVDA	Stock	26.7027	26.95	26.701	26.923	36689890.0
2023-03-29 12:00:00	NVDA	Stock	26.923	26.95	26.756	26.778	24675830.0
2023-03-29 13:00:00	NVDA	Stock	26.774	26.945	26.767	26.8366	22652850.0
2023-03-29 14:00:00	NVDA	Stock	26.8395	26.948	26.753	26.938	24863720.0
2023-03-29 15:00:00	NVDA	Stock	26.94	27.078	26.9081	26.984	55455960.0
2023-03-29 16:00:00	NVDA	Stock	26.984	27.046	26.971	27.01	26977230.0
2023-03-29 17:00:00	NVDA	Stock	27.014	27.021	27.0008	27.017	177140.0
2023-03-29 18:00:00	NVDA	Stock	27.004	27.029	26.945	26.945	458480.0
2023-03-29 19:00:00	NVDA	Stock	26.955	26.96	26.9	26.928	287340.0
2023-03-29 04:00:00	AMZN	Stock	97.5	98.25	97.5	98.08	28552.0
2023-03-29 05:00:00	AMZN	Stock	98.08	98.2	98.05	98.12	7445.0

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

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