PREVIEW / stock_1hour / 2022-10-07

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-10-07.parquet
  size:    1.3 MB
  rows:    60,447
  symbols: 2,100

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-07 04:00:00	AAPL	Stock	144.83	144.83	144.15	144.82	14395.0
2022-10-07 05:00:00	AAPL	Stock	144.9	145.13	144.88	145.0	9247.0
2022-10-07 06:00:00	AAPL	Stock	144.96	144.96	144.52	144.66	17685.0
2022-10-07 07:00:00	AAPL	Stock	144.71	144.91	144.41	144.65	62682.0
2022-10-07 08:00:00	AAPL	Stock	144.8892	145.25	141.64	142.6	935809.0
2022-10-07 09:00:00	AAPL	Stock	142.58	143.1	141.39	141.54	9589467.0
2022-10-07 10:00:00	AAPL	Stock	141.54	141.86	140.88	141.334	10514567.0
2022-10-07 11:00:00	AAPL	Stock	141.33	141.645	140.79	141.1206	7261428.0
2022-10-07 12:00:00	AAPL	Stock	141.12	141.37	140.1825	140.3	6170536.0
2022-10-07 13:00:00	AAPL	Stock	140.3	140.6	139.94	140.15	5844520.0
2022-10-07 14:00:00	AAPL	Stock	140.1335	140.56	139.92	140.18	5789025.0
2022-10-07 15:00:00	AAPL	Stock	140.1704	140.535	139.445	140.1	16134035.0
2022-10-07 16:00:00	AAPL	Stock	140.14	140.35	139.93	140.01	12926019.0
2022-10-07 17:00:00	AAPL	Stock	140.01	140.06	139.95	140.0	61078.0
2022-10-07 18:00:00	AAPL	Stock	140.0	140.02	139.91	139.92	26446.0
2022-10-07 19:00:00	AAPL	Stock	139.95	140.02	139.9	140.02	29476.0
2022-10-07 04:00:00	MSFT	Stock	245.23	245.7	244.56	245.7	3204.0
2022-10-07 05:00:00	MSFT	Stock	246.01	246.01	246.01	246.01	491.0
2022-10-07 06:00:00	MSFT	Stock	245.8	245.98	245.37	245.37	2057.0
2022-10-07 07:00:00	MSFT	Stock	245.85	246.0	245.52	245.55	4918.0
2022-10-07 08:00:00	MSFT	Stock	245.4008	246.3	241.4	242.62	184284.0
2022-10-07 09:00:00	MSFT	Stock	242.61	242.76	236.82	237.25	4510375.0
2022-10-07 10:00:00	MSFT	Stock	237.27	237.33	235.16	235.97	4240549.0
2022-10-07 11:00:00	MSFT	Stock	235.97	236.72	235.4601	236.01	2130494.0
2022-10-07 12:00:00	MSFT	Stock	236.0	236.28	234.56	234.81	2227757.0
2022-10-07 13:00:00	MSFT	Stock	234.81	235.19	234.34	234.39	1628335.0
2022-10-07 14:00:00	MSFT	Stock	234.385	234.82	233.91	234.81	1971713.0
2022-10-07 15:00:00	MSFT	Stock	234.81	235.12	233.17	234.25	6281346.0
2022-10-07 16:00:00	MSFT	Stock	234.29	234.63	234.11	234.21	6219207.0
2022-10-07 17:00:00	MSFT	Stock	234.23	234.25	234.11	234.15	13158.0
2022-10-07 18:00:00	MSFT	Stock	234.11	234.11	233.85	233.9	8851.0
2022-10-07 19:00:00	MSFT	Stock	233.9	234.0	233.83	233.89	18883.0
2022-10-07 04:00:00	NVDA	Stock	12.792	12.795	12.664	12.752	361370.0
2022-10-07 05:00:00	NVDA	Stock	12.752	12.763	12.732	12.732	54060.0
2022-10-07 06:00:00	NVDA	Stock	12.72	12.743	12.702	12.728	73960.0
2022-10-07 07:00:00	NVDA	Stock	12.735	12.767	12.724	12.744	409170.0
2022-10-07 08:00:00	NVDA	Stock	12.73	12.767	12.381	12.551	7008800.0
2022-10-07 09:00:00	NVDA	Stock	12.555	12.67	12.452	12.484	81497010.0
2022-10-07 10:00:00	NVDA	Stock	12.4845	12.608	12.417	12.4241	91167890.0
2022-10-07 11:00:00	NVDA	Stock	12.425	12.475	12.2349	12.298	73525550.0
2022-10-07 12:00:00	NVDA	Stock	12.298	12.331	12.174	12.2565	53519860.0
2022-10-07 13:00:00	NVDA	Stock	12.256	12.281	12.1841	12.1929	50498650.0
2022-10-07 14:00:00	NVDA	Stock	12.191	12.2	12.096	12.127	56409240.0
2022-10-07 15:00:00	NVDA	Stock	12.127	12.194	12.022	12.078	107646230.0
2022-10-07 16:00:00	NVDA	Stock	12.082	12.082	12.0256	12.048	40907450.0
2022-10-07 17:00:00	NVDA	Stock	12.048	12.05	12.025	12.025	327320.0
2022-10-07 18:00:00	NVDA	Stock	12.025	12.035	12.0	12.0	225380.0
2022-10-07 19:00:00	NVDA	Stock	12.008	12.034	12.0	12.024	336200.0
2022-10-07 04:00:00	AMZN	Stock	119.42	119.8	119.31	119.73	3134.0
2022-10-07 05:00:00	AMZN	Stock	119.7	120.17	119.7	120.15	7900.0

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

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