PREVIEW / stock_1hour / 2022-10-06

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-10-06.parquet
  size:    1.3 MB
  rows:    60,381
  symbols: 2,164

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-06 04:00:00	AAPL	Stock	147.31	147.31	145.62	145.88	29681.0
2022-10-06 05:00:00	AAPL	Stock	145.72	145.88	145.11	145.15	15395.0
2022-10-06 06:00:00	AAPL	Stock	145.24	145.4	145.11	145.3	20806.0
2022-10-06 07:00:00	AAPL	Stock	145.49	145.98	145.44	145.9	56014.0
2022-10-06 08:00:00	AAPL	Stock	145.5995	147.0	145.43	146.36	240443.0
2022-10-06 09:00:00	AAPL	Stock	146.34	147.54	145.45	146.73	8293227.0
2022-10-06 10:00:00	AAPL	Stock	146.74	146.75	145.6	146.6299	10303141.0
2022-10-06 11:00:00	AAPL	Stock	146.62	146.94	145.72	145.89	7935372.0
2022-10-06 12:00:00	AAPL	Stock	145.88	146.475	145.565	146.26	5468615.0
2022-10-06 13:00:00	AAPL	Stock	146.265	146.54	145.94	146.425	4752568.0
2022-10-06 14:00:00	AAPL	Stock	146.4393	146.4393	145.27	145.69	5289080.0
2022-10-06 15:00:00	AAPL	Stock	145.68	146.045	145.22	145.49	9936172.0
2022-10-06 16:00:00	AAPL	Stock	145.495	145.495	144.67	144.79	4605981.0
2022-10-06 17:00:00	AAPL	Stock	144.77	144.9	144.4	144.67	86490.0
2022-10-06 18:00:00	AAPL	Stock	144.65	144.95	144.32	144.69	40193.0
2022-10-06 19:00:00	AAPL	Stock	144.68	145.19	144.61	144.78	66851.0
2022-10-06 04:00:00	MSFT	Stock	248.9	249.22	247.15	247.33	7649.0
2022-10-06 05:00:00	MSFT	Stock	247.63	247.63	246.82	246.82	2862.0
2022-10-06 06:00:00	MSFT	Stock	246.85	247.0	246.64	247.0	12566.0
2022-10-06 07:00:00	MSFT	Stock	247.2	247.96	247.19	247.96	7396.0
2022-10-06 08:00:00	MSFT	Stock	247.3898	249.67	247.3	249.2	52006.0
2022-10-06 09:00:00	MSFT	Stock	248.76	250.34	247.44	248.4	1967890.0
2022-10-06 10:00:00	MSFT	Stock	248.39	249.34	246.08	249.26	2701166.0
2022-10-06 11:00:00	MSFT	Stock	249.28	250.0	248.0	248.44	1899465.0
2022-10-06 12:00:00	MSFT	Stock	248.44	248.94	247.83	248.34	1210387.0
2022-10-06 13:00:00	MSFT	Stock	248.35	248.5753	247.55	248.245	886685.0
2022-10-06 14:00:00	MSFT	Stock	248.25	248.27	246.45	247.32	1136384.0
2022-10-06 15:00:00	MSFT	Stock	247.33	247.91	246.46	246.85	2438423.0
2022-10-06 16:00:00	MSFT	Stock	246.86	247.2268	245.42	245.42	2870144.0
2022-10-06 17:00:00	MSFT	Stock	245.5095	245.79	245.2	245.79	18544.0
2022-10-06 18:00:00	MSFT	Stock	245.7	245.9	245.23	245.5	11371.0
2022-10-06 19:00:00	MSFT	Stock	245.66	246.29	245.33	245.85	13576.0
2022-10-06 04:00:00	NVDA	Stock	13.215	13.234	13.024	13.06	460690.0
2022-10-06 05:00:00	NVDA	Stock	13.06	13.077	13.04	13.04	30380.0
2022-10-06 06:00:00	NVDA	Stock	13.029	13.05	13.0	13.012	331730.0
2022-10-06 07:00:00	NVDA	Stock	13.02	13.127	13.02	13.1	597800.0
2022-10-06 08:00:00	NVDA	Stock	13.057	13.25	13.0219	13.2	3122090.0
2022-10-06 09:00:00	NVDA	Stock	13.2	13.656	13.157	13.486	90946450.0
2022-10-06 10:00:00	NVDA	Stock	13.488	13.497	13.145	13.446	137278850.0
2022-10-06 11:00:00	NVDA	Stock	13.445	13.462	13.239	13.254	90825210.0
2022-10-06 12:00:00	NVDA	Stock	13.251	13.328	13.1779	13.279	54336150.0
2022-10-06 13:00:00	NVDA	Stock	13.28	13.357	13.241	13.3226	41103330.0
2022-10-06 14:00:00	NVDA	Stock	13.323	13.326	13.109	13.1662	46916200.0
2022-10-06 15:00:00	NVDA	Stock	13.164	13.206	13.103	13.13	59293200.0
2022-10-06 16:00:00	NVDA	Stock	13.13	13.141	12.65	12.843	19481880.0
2022-10-06 17:00:00	NVDA	Stock	12.8352	12.84	12.725	12.764	2322350.0
2022-10-06 18:00:00	NVDA	Stock	12.758	12.816	12.74	12.751	1159440.0
2022-10-06 19:00:00	NVDA	Stock	12.762	12.786	12.715	12.718	825270.0
2022-10-06 04:00:00	AMZN	Stock	121.67	121.67	120.01	120.17	14774.0
2022-10-06 05:00:00	AMZN	Stock	120.21	120.38	119.62	119.62	7743.0

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

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