PREVIEW / stock_1hour / 2023-01-25

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-01-25.parquet
  size:    1.4 MB
  rows:    61,356
  symbols: 1,912

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-01-25 04:00:00	AAPL	Stock	141.93	141.93	141.55	141.55	21137.0
2023-01-25 05:00:00	AAPL	Stock	141.42	141.5	140.94	141.3	30427.0
2023-01-25 06:00:00	AAPL	Stock	141.16	141.45	140.93	141.04	19089.0
2023-01-25 07:00:00	AAPL	Stock	141.05	141.49	140.91	141.33	41504.0
2023-01-25 08:00:00	AAPL	Stock	141.29	142.89	140.75	140.85	389168.0
2023-01-25 09:00:00	AAPL	Stock	140.92	141.2	139.48	139.7145	8384541.0
2023-01-25 10:00:00	AAPL	Stock	139.72	140.46	138.81	139.315	9146684.0
2023-01-25 11:00:00	AAPL	Stock	139.315	140.84	139.15	140.4807	8256582.0
2023-01-25 12:00:00	AAPL	Stock	140.4811	140.7099	140.12	140.44	3944560.0
2023-01-25 13:00:00	AAPL	Stock	140.44	141.328	140.4088	141.08	5160906.0
2023-01-25 14:00:00	AAPL	Stock	141.08	141.97	140.9609	141.79	5438535.0
2023-01-25 15:00:00	AAPL	Stock	141.8	142.43	141.275	141.8501	9367426.0
2023-01-25 16:00:00	AAPL	Stock	141.85	141.98	141.16	141.61	5491767.0
2023-01-25 17:00:00	AAPL	Stock	141.57	141.68	141.36	141.47	26840.0
2023-01-25 18:00:00	AAPL	Stock	141.5	142.08	141.5	142.0	58925.0
2023-01-25 19:00:00	AAPL	Stock	142.04	142.15	142.0	142.06	62729.0
2023-01-25 04:00:00	MSFT	Stock	238.9	241.5	237.2	237.37	61773.0
2023-01-25 05:00:00	MSFT	Stock	237.32	237.48	235.51	235.94	30367.0
2023-01-25 06:00:00	MSFT	Stock	235.91	237.0	235.34	235.93	67685.0
2023-01-25 07:00:00	MSFT	Stock	235.93	236.5	235.03	235.8	232490.0
2023-01-25 08:00:00	MSFT	Stock	235.8	240.09	234.3	234.4	505180.0
2023-01-25 09:00:00	MSFT	Stock	234.4586	235.0	230.9	231.495	9802849.0
2023-01-25 10:00:00	MSFT	Stock	231.41	235.37	231.15	234.59	8492496.0
2023-01-25 11:00:00	MSFT	Stock	234.59	240.95	234.27	240.48	9716154.0
2023-01-25 12:00:00	MSFT	Stock	240.49	240.67	237.91	239.21	5903709.0
2023-01-25 13:00:00	MSFT	Stock	239.23	241.5	238.95	240.33	4863741.0
2023-01-25 14:00:00	MSFT	Stock	240.34	243.3	239.8804	241.3603	5709540.0
2023-01-25 15:00:00	MSFT	Stock	241.36	242.11	239.57	240.55	6011739.0
2023-01-25 16:00:00	MSFT	Stock	240.55	240.67	238.0	240.22	2786062.0
2023-01-25 17:00:00	MSFT	Stock	240.19	240.61	239.75	240.61	42979.0
2023-01-25 18:00:00	MSFT	Stock	240.47	241.33	240.31	240.91	27719.0
2023-01-25 19:00:00	MSFT	Stock	241.0	241.2	240.74	241.2	18769.0
2023-01-25 04:00:00	NVDA	Stock	19.211	19.211	18.975	18.975	375980.0
2023-01-25 05:00:00	NVDA	Stock	18.976	19.001	18.921	18.96	153580.0
2023-01-25 06:00:00	NVDA	Stock	18.948	18.981	18.928	18.933	186710.0
2023-01-25 07:00:00	NVDA	Stock	18.933	19.007	18.933	18.987	365630.0
2023-01-25 08:00:00	NVDA	Stock	19.145	19.145	18.8611	18.89	1457390.0
2023-01-25 09:00:00	NVDA	Stock	18.898	19.171	18.811	18.864	61469490.0
2023-01-25 10:00:00	NVDA	Stock	18.867	18.9413	18.58	18.802	94699550.0
2023-01-25 11:00:00	NVDA	Stock	18.802	18.989	18.75	18.901	49301870.0
2023-01-25 12:00:00	NVDA	Stock	18.904	18.967	18.83	18.8933	28401710.0
2023-01-25 13:00:00	NVDA	Stock	18.894	19.142	18.893	19.1125	39978620.0
2023-01-25 14:00:00	NVDA	Stock	19.116	19.315	19.079	19.2688	46165330.0
2023-01-25 15:00:00	NVDA	Stock	19.27	19.37	19.23	19.323	49240560.0
2023-01-25 16:00:00	NVDA	Stock	19.323	19.427	19.272	19.315	14235880.0
2023-01-25 17:00:00	NVDA	Stock	19.319	19.319	19.2601	19.29	263960.0
2023-01-25 18:00:00	NVDA	Stock	19.287	19.48	19.271	19.46	549090.0
2023-01-25 19:00:00	NVDA	Stock	19.462	19.5	19.445	19.47	399870.0
2023-01-25 04:00:00	AMZN	Stock	95.13	95.13	94.65	94.7	47785.0
2023-01-25 05:00:00	AMZN	Stock	94.71	94.8	94.45	94.47	34826.0

> showing 50 of 61,356 rows — these rows as CSV

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