PREVIEW / stock_1hour / 2022-10-03

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-10-03.parquet
  size:    1.4 MB
  rows:    62,055
  symbols: 2,264

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-03 04:00:00	AAPL	Stock	137.21	137.21	136.4	136.97	75109.0
2022-10-03 05:00:00	AAPL	Stock	136.9	137.45	136.57	137.27	55553.0
2022-10-03 06:00:00	AAPL	Stock	137.34	137.84	137.21	137.73	44310.0
2022-10-03 07:00:00	AAPL	Stock	137.65	138.11	137.49	138.11	157979.0
2022-10-03 08:00:00	AAPL	Stock	137.58	138.95	136.7015	138.6	683280.0
2022-10-03 09:00:00	AAPL	Stock	138.59	139.45	137.685	139.41	14321138.0
2022-10-03 10:00:00	AAPL	Stock	139.41	141.585	139.375	141.22	16207221.0
2022-10-03 11:00:00	AAPL	Stock	141.23	141.57	140.08	140.83	10838716.0
2022-10-03 12:00:00	AAPL	Stock	140.83	141.43	140.8	141.41	7686437.0
2022-10-03 13:00:00	AAPL	Stock	141.415	142.24	141.38	142.0989	9342178.0
2022-10-03 14:00:00	AAPL	Stock	142.095	143.07	142.065	142.8913	9732689.0
2022-10-03 15:00:00	AAPL	Stock	142.9	143.07	142.22	142.44	14982323.0
2022-10-03 16:00:00	AAPL	Stock	142.44	142.92	142.43	142.68	10966417.0
2022-10-03 17:00:00	AAPL	Stock	142.67	142.75	142.45	142.75	52759.0
2022-10-03 18:00:00	AAPL	Stock	142.83	142.85	142.42	142.56	57311.0
2022-10-03 19:00:00	AAPL	Stock	142.53	143.0	142.52	142.97	48559.0
2022-10-03 04:00:00	MSFT	Stock	232.26	233.22	232.21	233.2	14613.0
2022-10-03 05:00:00	MSFT	Stock	232.67	233.04	232.02	233.04	7984.0
2022-10-03 06:00:00	MSFT	Stock	233.27	234.71	233.27	234.71	2301.0
2022-10-03 07:00:00	MSFT	Stock	233.83	234.99	233.8	234.99	16987.0
2022-10-03 08:00:00	MSFT	Stock	234.1358	235.8	232.318	235.35	75581.0
2022-10-03 09:00:00	MSFT	Stock	235.29	237.15	234.66	235.04	2700020.0
2022-10-03 10:00:00	MSFT	Stock	235.04	238.16	234.98	237.44	2803701.0
2022-10-03 11:00:00	MSFT	Stock	237.43	238.15	236.75	237.25	1712622.0
2022-10-03 12:00:00	MSFT	Stock	237.25	238.02	236.9	237.8	1174902.0
2022-10-03 13:00:00	MSFT	Stock	237.8199	239.66	237.77	239.475	1718464.0
2022-10-03 14:00:00	MSFT	Stock	239.49	241.61	239.46	241.3646	2429947.0
2022-10-03 15:00:00	MSFT	Stock	241.35	241.49	240.35	240.66	4117033.0
2022-10-03 16:00:00	MSFT	Stock	240.74	241.5	240.74	241.26	5249162.0
2022-10-03 17:00:00	MSFT	Stock	241.45	241.45	240.75	241.0187	4199.0
2022-10-03 18:00:00	MSFT	Stock	241.29	241.4	240.35	240.68	19791.0
2022-10-03 19:00:00	MSFT	Stock	240.6	241.85	240.6	241.7	8506.0
2022-10-03 04:00:00	NVDA	Stock	12.047	12.058	12.009	12.04	152570.0
2022-10-03 05:00:00	NVDA	Stock	12.036	12.087	12.019	12.08	747770.0
2022-10-03 06:00:00	NVDA	Stock	12.091	12.119	12.07	12.119	21900.0
2022-10-03 07:00:00	NVDA	Stock	12.101	12.2	12.101	12.2	292470.0
2022-10-03 08:00:00	NVDA	Stock	12.1004	12.29	12.06	12.273	1671380.0
2022-10-03 09:00:00	NVDA	Stock	12.26	12.38	12.105	12.269	56908840.0
2022-10-03 10:00:00	NVDA	Stock	12.272	12.518	12.263	12.463	79446890.0
2022-10-03 11:00:00	NVDA	Stock	12.467	12.5897	12.4057	12.4349	68163630.0
2022-10-03 12:00:00	NVDA	Stock	12.435	12.539	12.402	12.448	49380310.0
2022-10-03 13:00:00	NVDA	Stock	12.448	12.574	12.43	12.542	40686400.0
2022-10-03 14:00:00	NVDA	Stock	12.542	12.6523	12.52	12.6285	60117080.0
2022-10-03 15:00:00	NVDA	Stock	12.629	12.678	12.4861	12.513	71257830.0
2022-10-03 16:00:00	NVDA	Stock	12.512	12.56	12.4529	12.5461	32429060.0
2022-10-03 17:00:00	NVDA	Stock	12.549	12.549	12.5434	12.545	331270.0
2022-10-03 18:00:00	NVDA	Stock	12.547	12.565	12.52	12.523	442920.0
2022-10-03 19:00:00	NVDA	Stock	12.53	12.62	12.53	12.62	338890.0
2022-10-03 04:00:00	AMZN	Stock	112.3	112.33	112.0	112.12	16875.0
2022-10-03 05:00:00	AMZN	Stock	112.11	112.5	111.78	112.26	15989.0

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

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