PREVIEW / stock_1hour / 2023-09-11

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-09-11.parquet
  size:    1.3 MB
  rows:    59,002
  symbols: 1,419

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-09-11 04:00:00	AAPL	Stock	179.35	179.95	179.35	179.43	29270.0
2023-09-11 05:00:00	AAPL	Stock	179.48	179.7	179.48	179.56	20625.0
2023-09-11 06:00:00	AAPL	Stock	179.57	179.74	179.45	179.65	25680.0
2023-09-11 07:00:00	AAPL	Stock	179.58	180.11	179.25	180.04	181989.0
2023-09-11 08:00:00	AAPL	Stock	179.66	180.8	179.2	180.68	413448.0
2023-09-11 09:00:00	AAPL	Stock	180.66	180.8	177.48	178.01	8928435.0
2023-09-11 10:00:00	AAPL	Stock	178.01	178.33	177.34	177.8	8322712.0
2023-09-11 11:00:00	AAPL	Stock	177.79	178.95	177.755	178.4201	5629610.0
2023-09-11 12:00:00	AAPL	Stock	178.42	178.86	178.25	178.6646	4173158.0
2023-09-11 13:00:00	AAPL	Stock	178.67	179.4274	178.56	179.245	3807117.0
2023-09-11 14:00:00	AAPL	Stock	179.25	179.675	179.04	179.6623	3764508.0
2023-09-11 15:00:00	AAPL	Stock	179.67	179.95	179.16	179.38	7930986.0
2023-09-11 16:00:00	AAPL	Stock	179.43	179.43	179.06	179.1	5538537.0
2023-09-11 17:00:00	AAPL	Stock	179.1	179.22	179.0	179.1	44703.0
2023-09-11 18:00:00	AAPL	Stock	179.1	179.34	179.0754	179.25	23856.0
2023-09-11 19:00:00	AAPL	Stock	179.29	179.55	179.29	179.55	50402.0
2023-09-11 04:00:00	MSFT	Stock	335.53	335.65	334.79	334.79	3606.0
2023-09-11 05:00:00	MSFT	Stock	335.42	335.42	335.42	335.42	313.0
2023-09-11 06:00:00	MSFT	Stock	335.16	337.48	334.47	337.15	19320.0
2023-09-11 07:00:00	MSFT	Stock	337.0	337.43	336.69	336.78	21921.0
2023-09-11 08:00:00	MSFT	Stock	337.0	337.32	333.435	336.8301	35032.0
2023-09-11 09:00:00	MSFT	Stock	336.9	338.07	335.89	336.59	1825270.0
2023-09-11 10:00:00	MSFT	Stock	336.62	337.23	335.43	336.14	1513961.0
2023-09-11 11:00:00	MSFT	Stock	336.14	337.5	335.9	336.49	819327.0
2023-09-11 12:00:00	MSFT	Stock	336.48	337.12	335.91	336.465	777622.0
2023-09-11 13:00:00	MSFT	Stock	336.47	337.9	336.3	337.8724	731747.0
2023-09-11 14:00:00	MSFT	Stock	337.88	338.42	337.44	337.77	877761.0
2023-09-11 15:00:00	MSFT	Stock	337.78	338.18	337.13	337.95	1894000.0
2023-09-11 16:00:00	MSFT	Stock	337.95	338.25	336.3	336.7238	2945374.0
2023-09-11 17:00:00	MSFT	Stock	336.79	336.85	336.0054	336.14	16662.0
2023-09-11 18:00:00	MSFT	Stock	336.2	336.6	336.08	336.4993	11440.0
2023-09-11 19:00:00	MSFT	Stock	336.3	336.6	336.3	336.6	4206.0
2023-09-11 04:00:00	NVDA	Stock	45.952	46.0	45.712	45.76	377030.0
2023-09-11 05:00:00	NVDA	Stock	45.784	45.865	45.784	45.865	47660.0
2023-09-11 06:00:00	NVDA	Stock	45.851	45.882	45.752	45.867	123450.0
2023-09-11 07:00:00	NVDA	Stock	45.867	46.141	45.82	46.075	777540.0
2023-09-11 08:00:00	NVDA	Stock	45.85	46.3148	45.62	46.299	2783560.0
2023-09-11 09:00:00	NVDA	Stock	46.299	46.3	44.505	44.59	79865600.0
2023-09-11 10:00:00	NVDA	Stock	44.595	44.976	44.312	44.623	75749140.0
2023-09-11 11:00:00	NVDA	Stock	44.622	44.834	44.511	44.5859	39489800.0
2023-09-11 12:00:00	NVDA	Stock	44.595	44.777	44.46	44.7435	29520960.0
2023-09-11 13:00:00	NVDA	Stock	44.7435	45.1529	44.73	45.135	39110930.0
2023-09-11 14:00:00	NVDA	Stock	45.1371	45.146	44.905	45.029	27389060.0
2023-09-11 15:00:00	NVDA	Stock	45.0385	45.3329	44.976	45.1775	42893310.0
2023-09-11 16:00:00	NVDA	Stock	45.178	45.18	45.055	45.148	12565120.0
2023-09-11 17:00:00	NVDA	Stock	45.131	45.148	44.99	45.019	455670.0
2023-09-11 18:00:00	NVDA	Stock	45.05	45.089	45.025	45.06	265780.0
2023-09-11 19:00:00	NVDA	Stock	45.055	45.065	45.025	45.05	250040.0
2023-09-11 04:00:00	AMZN	Stock	138.51	138.84	138.33	138.5	6493.0
2023-09-11 05:00:00	AMZN	Stock	138.59	138.76	138.54	138.7	7690.0

> showing 50 of 59,002 rows — these rows as CSV

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