PREVIEW / stock_1hour / 2022-09-30

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-09-30.parquet
  size:    1.4 MB
  rows:    62,030
  symbols: 2,223

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-09-30 04:00:00	AAPL	Stock	143.59	143.59	143.0	143.54	70317.0
2022-09-30 05:00:00	AAPL	Stock	143.41	143.41	142.89	142.89	60230.0
2022-09-30 06:00:00	AAPL	Stock	143.03	143.51	142.76	142.79	64885.0
2022-09-30 07:00:00	AAPL	Stock	142.85	142.94	141.79	141.96	178576.0
2022-09-30 08:00:00	AAPL	Stock	142.9238	143.3988	140.96	141.83	561873.0
2022-09-30 09:00:00	AAPL	Stock	141.77	142.63	140.61	142.12	13171744.0
2022-09-30 10:00:00	AAPL	Stock	142.12	142.89	141.37	142.2701	12606994.0
2022-09-30 11:00:00	AAPL	Stock	142.29	143.1	141.025	141.32	11211000.0
2022-09-30 12:00:00	AAPL	Stock	141.33	141.76	140.85	141.19	7133581.0
2022-09-30 13:00:00	AAPL	Stock	141.18	141.2993	140.1769	140.3641	7716022.0
2022-09-30 14:00:00	AAPL	Stock	140.36	140.85	139.61	139.71	10762671.0
2022-09-30 15:00:00	AAPL	Stock	139.71	140.35	138.0	138.08	25727176.0
2022-09-30 16:00:00	AAPL	Stock	138.0	138.5	137.85	138.04	19197930.0
2022-09-30 17:00:00	AAPL	Stock	138.03	138.24	137.21	137.51	329909.0
2022-09-30 18:00:00	AAPL	Stock	137.53	137.77	137.52	137.59	76206.0
2022-09-30 19:00:00	AAPL	Stock	137.6	137.69	137.5	137.52	93375.0
2022-09-30 04:00:00	MSFT	Stock	240.93	241.0	239.55	240.35	6635.0
2022-09-30 05:00:00	MSFT	Stock	240.05	240.05	239.0	239.13	3132.0
2022-09-30 06:00:00	MSFT	Stock	239.5	240.3	239.0	239.0	3530.0
2022-09-30 07:00:00	MSFT	Stock	239.08	239.26	238.0	239.0	26542.0
2022-09-30 08:00:00	MSFT	Stock	239.0	240.6	236.4	238.99	81562.0
2022-09-30 09:00:00	MSFT	Stock	239.28	240.52	237.35	238.8	2799565.0
2022-09-30 10:00:00	MSFT	Stock	238.77	239.47	237.3	238.99	2736966.0
2022-09-30 11:00:00	MSFT	Stock	238.99	240.54	237.61	237.6132	2086628.0
2022-09-30 12:00:00	MSFT	Stock	237.63	237.65	236.44	236.96	1637513.0
2022-09-30 13:00:00	MSFT	Stock	236.95	237.01	235.0426	235.65	1636946.0
2022-09-30 14:00:00	MSFT	Stock	235.635	236.27	234.73	234.89	2112510.0
2022-09-30 15:00:00	MSFT	Stock	234.86	236.17	232.73	232.81	6986415.0
2022-09-30 16:00:00	MSFT	Stock	232.83	234.24	232.82	233.77	7796197.0
2022-09-30 17:00:00	MSFT	Stock	233.7956	233.85	233.5	233.6132	12696.0
2022-09-30 18:00:00	MSFT	Stock	233.7	233.75	233.5	233.75	7427.0
2022-09-30 19:00:00	MSFT	Stock	233.59	233.79	233.4	233.79	6903.0
2022-09-30 04:00:00	NVDA	Stock	12.3	12.335	12.262	12.33	111320.0
2022-09-30 05:00:00	NVDA	Stock	12.332	12.335	12.25	12.257	107320.0
2022-09-30 06:00:00	NVDA	Stock	12.282	12.29	12.24	12.24	51510.0
2022-09-30 07:00:00	NVDA	Stock	12.245	12.245	12.16	12.195	359740.0
2022-09-30 08:00:00	NVDA	Stock	12.246	12.2889	12.018	12.11	2953130.0
2022-09-30 09:00:00	NVDA	Stock	12.132	12.438	12.005	12.3575	65377400.0
2022-09-30 10:00:00	NVDA	Stock	12.359	12.583	12.31	12.5779	83484920.0
2022-09-30 11:00:00	NVDA	Stock	12.5785	12.633	12.4659	12.483	65908180.0
2022-09-30 12:00:00	NVDA	Stock	12.485	12.489	12.382	12.412	42109850.0
2022-09-30 13:00:00	NVDA	Stock	12.4125	12.4385	12.2729	12.285	44504250.0
2022-09-30 14:00:00	NVDA	Stock	12.2844	12.347	12.213	12.236	48429930.0
2022-09-30 15:00:00	NVDA	Stock	12.234	12.315	12.132	12.137	83243290.0
2022-09-30 16:00:00	NVDA	Stock	12.139	12.204	12.115	12.141	38371640.0
2022-09-30 17:00:00	NVDA	Stock	12.143	12.17	12.14	12.16	226020.0
2022-09-30 18:00:00	NVDA	Stock	12.166	12.17	12.15	12.159	137010.0
2022-09-30 19:00:00	NVDA	Stock	12.155	12.159	12.113	12.113	465710.0
2022-09-30 04:00:00	AMZN	Stock	115.88	116.09	115.52	116.08	7271.0
2022-09-30 05:00:00	AMZN	Stock	115.9	115.93	115.13	115.42	8557.0

> showing 50 of 62,030 rows — these rows as CSV

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