PREVIEW / stock_1hour / 2022-10-05

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-10-05.parquet
  size:    1.3 MB
  rows:    61,141
  symbols: 2,159

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-05 04:00:00	AAPL	Stock	145.44	145.44	144.37	144.92	23515.0
2022-10-05 05:00:00	AAPL	Stock	144.8	144.9	144.4	144.57	11604.0
2022-10-05 06:00:00	AAPL	Stock	144.62	144.94	144.57	144.93	13511.0
2022-10-05 07:00:00	AAPL	Stock	144.94	145.0	144.7	144.8	75818.0
2022-10-05 08:00:00	AAPL	Stock	144.96	145.8	144.3115	144.35	236815.0
2022-10-05 09:00:00	AAPL	Stock	144.33	145.33	143.67	145.195	8868510.0
2022-10-05 10:00:00	AAPL	Stock	145.19	145.3	143.01	143.61	11603321.0
2022-10-05 11:00:00	AAPL	Stock	143.59	144.48	143.54	144.38	7803131.0
2022-10-05 12:00:00	AAPL	Stock	144.4	145.905	144.01	145.445	7685820.0
2022-10-05 13:00:00	AAPL	Stock	145.45	146.26	145.32	145.3471	6024459.0
2022-10-05 14:00:00	AAPL	Stock	145.345	146.46	145.2795	146.4155	6621682.0
2022-10-05 15:00:00	AAPL	Stock	146.415	147.38	145.87	146.42	14562783.0
2022-10-05 16:00:00	AAPL	Stock	146.42	146.8	146.0	146.28	5530742.0
2022-10-05 17:00:00	AAPL	Stock	146.28	146.33	146.08	146.15	36847.0
2022-10-05 18:00:00	AAPL	Stock	146.15	146.55	146.02	146.4	64216.0
2022-10-05 19:00:00	AAPL	Stock	146.5	147.4	146.25	147.31	47744.0
2022-10-05 04:00:00	MSFT	Stock	247.35	247.5	245.74	246.63	1793.0
2022-10-05 05:00:00	MSFT	Stock	246.8	246.8	246.0	246.34	2080.0
2022-10-05 06:00:00	MSFT	Stock	246.5	247.15	246.5	247.15	1954.0
2022-10-05 07:00:00	MSFT	Stock	247.35	247.35	246.75	246.8	13409.0
2022-10-05 08:00:00	MSFT	Stock	246.7501	248.258	245.91	246.0	39896.0
2022-10-05 09:00:00	MSFT	Stock	246.01	247.55	245.26	246.14	1815195.0
2022-10-05 10:00:00	MSFT	Stock	246.06	246.14	244.11	244.345	2203008.0
2022-10-05 11:00:00	MSFT	Stock	244.365	245.9381	244.28	245.64	1495979.0
2022-10-05 12:00:00	MSFT	Stock	245.64	248.26	244.99	247.65	1561530.0
2022-10-05 13:00:00	MSFT	Stock	247.635	248.94	247.55	247.61	1255351.0
2022-10-05 14:00:00	MSFT	Stock	247.58	249.61	247.42	249.55	1796736.0
2022-10-05 15:00:00	MSFT	Stock	249.56	250.58	248.67	249.33	3227881.0
2022-10-05 16:00:00	MSFT	Stock	249.2	249.61	248.66	248.81	2529670.0
2022-10-05 17:00:00	MSFT	Stock	248.8	248.92	248.56	248.83	5112.0
2022-10-05 18:00:00	MSFT	Stock	248.65	249.24	248.56	249.24	10567.0
2022-10-05 19:00:00	MSFT	Stock	249.19	250.2	249.19	250.1	20274.0
2022-10-05 04:00:00	NVDA	Stock	13.146	13.146	12.99	13.065	295120.0
2022-10-05 05:00:00	NVDA	Stock	13.05	13.071	13.006	13.006	85040.0
2022-10-05 06:00:00	NVDA	Stock	13.02	13.084	13.015	13.065	58050.0
2022-10-05 07:00:00	NVDA	Stock	13.055	13.069	13.018	13.044	173330.0
2022-10-05 08:00:00	NVDA	Stock	13.06	13.1341	12.949	12.96	1468800.0
2022-10-05 09:00:00	NVDA	Stock	12.952	12.983	12.7146	12.8021	64848180.0
2022-10-05 10:00:00	NVDA	Stock	12.798	12.809	12.621	12.67	68615760.0
2022-10-05 11:00:00	NVDA	Stock	12.668	12.889	12.666	12.8826	51560810.0
2022-10-05 12:00:00	NVDA	Stock	12.8835	13.054	12.8255	13.0175	49243840.0
2022-10-05 13:00:00	NVDA	Stock	13.017	13.168	13.006	13.054	50353450.0
2022-10-05 14:00:00	NVDA	Stock	13.054	13.204	13.04	13.2	47723590.0
2022-10-05 15:00:00	NVDA	Stock	13.201	13.321	13.172	13.208	80914190.0
2022-10-05 16:00:00	NVDA	Stock	13.205	13.228	13.1716	13.197	16374120.0
2022-10-05 17:00:00	NVDA	Stock	13.19	13.1967	13.145	13.163	362740.0
2022-10-05 18:00:00	NVDA	Stock	13.173	13.214	13.127	13.214	278790.0
2022-10-05 19:00:00	NVDA	Stock	13.214	13.3	13.205	13.3	433980.0
2022-10-05 04:00:00	AMZN	Stock	120.25	120.7	119.87	120.27	46826.0
2022-10-05 05:00:00	AMZN	Stock	120.14	120.42	119.53	119.57	26760.0

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

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