PREVIEW / stock_1hour / 2022-07-29

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-07-29.parquet
  size:    1.4 MB
  rows:    62,751
  symbols: 2,305

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-07-29 04:00:00	AAPL	Stock	162.03	162.03	160.32	161.2	101422.0
2022-07-29 05:00:00	AAPL	Stock	161.21	161.64	161.04	161.46	24612.0
2022-07-29 06:00:00	AAPL	Stock	161.45	161.5	160.6	160.88	97466.0
2022-07-29 07:00:00	AAPL	Stock	160.95	161.84	160.95	161.8	291805.0
2022-07-29 08:00:00	AAPL	Stock	161.2387	162.0	160.27	161.49	1148126.0
2022-07-29 09:00:00	AAPL	Stock	161.49	163.0	159.5	161.9552	17515820.0
2022-07-29 10:00:00	AAPL	Stock	161.96	163.63	161.5	162.41	13885340.0
2022-07-29 11:00:00	AAPL	Stock	162.405	162.56	160.57	162.14	10432344.0
2022-07-29 12:00:00	AAPL	Stock	162.135	162.64	161.73	162.55	5956084.0
2022-07-29 13:00:00	AAPL	Stock	162.56	162.95	162.1	162.73	5225452.0
2022-07-29 14:00:00	AAPL	Stock	162.73	163.18	162.52	162.64	5395406.0
2022-07-29 15:00:00	AAPL	Stock	162.64	163.17	162.41	162.57	11147185.0
2022-07-29 16:00:00	AAPL	Stock	162.58	162.58	162.3	162.47	13917949.0
2022-07-29 17:00:00	AAPL	Stock	162.48	162.52	162.27	162.3	84038.0
2022-07-29 18:00:00	AAPL	Stock	162.3	162.33	162.1	162.2	32189.0
2022-07-29 19:00:00	AAPL	Stock	162.16	162.18	162.06	162.15	47048.0
2022-07-29 04:00:00	MSFT	Stock	277.95	278.88	277.17	277.4	9857.0
2022-07-29 05:00:00	MSFT	Stock	277.15	277.97	277.15	277.97	6631.0
2022-07-29 06:00:00	MSFT	Stock	277.93	278.15	277.65	277.85	5105.0
2022-07-29 07:00:00	MSFT	Stock	277.9	278.12	277.52	277.7	40566.0
2022-07-29 08:00:00	MSFT	Stock	277.8696	278.0972	275.719	277.1	69130.0
2022-07-29 09:00:00	MSFT	Stock	277.1284	279.35	276.16	279.295	3074769.0
2022-07-29 10:00:00	MSFT	Stock	279.295	281.12	278.86	279.6449	4012586.0
2022-07-29 11:00:00	MSFT	Stock	279.65	279.65	277.28	279.3204	2636028.0
2022-07-29 12:00:00	MSFT	Stock	279.33	279.99	278.18	279.741	1383348.0
2022-07-29 13:00:00	MSFT	Stock	279.75	280.07	279.02	279.8705	1228982.0
2022-07-29 14:00:00	MSFT	Stock	279.91	280.83	279.685	280.65	1334908.0
2022-07-29 15:00:00	MSFT	Stock	280.66	282.0	280.5	280.74	4451849.0
2022-07-29 16:00:00	MSFT	Stock	280.81	280.95	280.53	280.7298	6317352.0
2022-07-29 17:00:00	MSFT	Stock	280.67	280.73	280.55	280.55	5304.0
2022-07-29 18:00:00	MSFT	Stock	280.71	280.71	280.45	280.5	7278.0
2022-07-29 19:00:00	MSFT	Stock	280.45	280.63	280.41	280.42	8424.0
2022-07-29 04:00:00	NVDA	Stock	17.942	18.03	17.911	17.934	184960.0
2022-07-29 05:00:00	NVDA	Stock	17.912	17.934	17.89	17.927	27260.0
2022-07-29 06:00:00	NVDA	Stock	17.961	17.961	17.912	17.935	66470.0
2022-07-29 07:00:00	NVDA	Stock	17.95	17.96	17.9	17.915	173830.0
2022-07-29 08:00:00	NVDA	Stock	17.956	18.11	17.828	17.877	1111150.0
2022-07-29 09:00:00	NVDA	Stock	17.877	18.066	17.692	17.926	49037920.0
2022-07-29 10:00:00	NVDA	Stock	17.92	18.056	17.811	17.8709	59248580.0
2022-07-29 11:00:00	NVDA	Stock	17.8715	17.935	17.7338	17.865	41151560.0
2022-07-29 12:00:00	NVDA	Stock	17.868	18.019	17.817	18.005	27603750.0
2022-07-29 13:00:00	NVDA	Stock	18.006	18.244	17.989	18.131	50997590.0
2022-07-29 14:00:00	NVDA	Stock	18.134	18.209	18.1	18.1275	33787850.0
2022-07-29 15:00:00	NVDA	Stock	18.1275	18.24	18.089	18.1596	52923770.0
2022-07-29 16:00:00	NVDA	Stock	18.163	18.1897	18.133	18.1897	32589470.0
2022-07-29 17:00:00	NVDA	Stock	18.19	18.1968	18.168	18.178	162350.0
2022-07-29 18:00:00	NVDA	Stock	18.17	18.17	18.155	18.16	66700.0
2022-07-29 19:00:00	NVDA	Stock	18.161	18.19	18.15	18.165	124720.0
2022-07-29 04:00:00	AMZN	Stock	137.4	138.08	136.06	136.61	263646.0
2022-07-29 05:00:00	AMZN	Stock	136.63	137.55	136.35	136.52	136252.0

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

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