PREVIEW / stock_1hour / 2022-12-14

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-12-14.parquet
  size:    1.4 MB
  rows:    60,944
  symbols: 2,004

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-12-14 04:00:00	AAPL	Stock	145.6	145.62	144.91	145.14	10782.0
2022-12-14 05:00:00	AAPL	Stock	145.08	145.25	145.0	145.05	13464.0
2022-12-14 06:00:00	AAPL	Stock	145.03	145.07	144.71	145.0	19837.0
2022-12-14 07:00:00	AAPL	Stock	145.05	145.37	144.92	145.08	50528.0
2022-12-14 08:00:00	AAPL	Stock	144.95	145.37	144.9009	145.25	109915.0
2022-12-14 09:00:00	AAPL	Stock	145.25	146.42	145.04	146.305	4767169.0
2022-12-14 10:00:00	AAPL	Stock	146.3	146.655	145.64	145.99	6788618.0
2022-12-14 11:00:00	AAPL	Stock	146.0	146.36	145.58	145.93	5207483.0
2022-12-14 12:00:00	AAPL	Stock	145.93	145.94	145.2595	145.3	3596621.0
2022-12-14 13:00:00	AAPL	Stock	145.31	146.63	145.2747	146.3162	5825249.0
2022-12-14 14:00:00	AAPL	Stock	146.35	146.37	141.16	142.695	18412859.0
2022-12-14 15:00:00	AAPL	Stock	142.71	145.08	142.19	143.22	15203264.0
2022-12-14 16:00:00	AAPL	Stock	143.23	143.58	143.13	143.42	9717118.0
2022-12-14 17:00:00	AAPL	Stock	143.41	143.43	143.21	143.34	39616.0
2022-12-14 18:00:00	AAPL	Stock	143.34	143.55	143.28	143.42	21928.0
2022-12-14 19:00:00	AAPL	Stock	143.44	143.44	143.25	143.4	24557.0
2022-12-14 04:00:00	MSFT	Stock	257.14	257.14	256.75	257.01	1089.0
2022-12-14 05:00:00	MSFT	Stock	257.07	257.07	256.93	256.93	571.0
2022-12-14 06:00:00	MSFT	Stock	256.5	256.65	256.35	256.6	2073.0
2022-12-14 07:00:00	MSFT	Stock	257.0	257.38	256.92	257.01	7255.0
2022-12-14 08:00:00	MSFT	Stock	257.0202	257.88	256.278	257.74	37706.0
2022-12-14 09:00:00	MSFT	Stock	257.6	260.83	256.29	260.61	2510814.0
2022-12-14 10:00:00	MSFT	Stock	260.57	261.1299	259.8251	260.65	2390765.0
2022-12-14 11:00:00	MSFT	Stock	260.68	262.588	260.4701	261.825	2380551.0
2022-12-14 12:00:00	MSFT	Stock	261.805	261.82	260.3986	260.86	1988724.0
2022-12-14 13:00:00	MSFT	Stock	260.87	262.0617	260.4583	261.51	1899910.0
2022-12-14 14:00:00	MSFT	Stock	261.51	261.51	254.31	256.6494	5622070.0
2022-12-14 15:00:00	MSFT	Stock	256.7	260.54	255.75	257.23	5181160.0
2022-12-14 16:00:00	MSFT	Stock	257.22	258.28	257.22	258.17	4038531.0
2022-12-14 17:00:00	MSFT	Stock	258.15	258.1675	257.8	257.8	6681.0
2022-12-14 18:00:00	MSFT	Stock	257.8	258.29	257.73	258.09	7384.0
2022-12-14 19:00:00	MSFT	Stock	257.85	258.45	257.73	258.27	12898.0
2022-12-14 04:00:00	NVDA	Stock	18.1	18.18	18.055	18.099	161850.0
2022-12-14 05:00:00	NVDA	Stock	18.099	18.127	18.075	18.09	24650.0
2022-12-14 06:00:00	NVDA	Stock	18.06	18.06	18.01	18.05	22180.0
2022-12-14 07:00:00	NVDA	Stock	18.067	18.115	18.044	18.053	107310.0
2022-12-14 08:00:00	NVDA	Stock	18.0896	18.1334	17.95	18.0	475740.0
2022-12-14 09:00:00	NVDA	Stock	17.998	18.179	17.851	18.0941	55764040.0
2022-12-14 10:00:00	NVDA	Stock	18.096	18.252	18.011	18.0519	64093530.0
2022-12-14 11:00:00	NVDA	Stock	18.052	18.079	17.96	18.031	36550480.0
2022-12-14 12:00:00	NVDA	Stock	18.03	18.0338	17.892	17.9008	25223380.0
2022-12-14 13:00:00	NVDA	Stock	17.91	18.145	17.9	18.116	29940880.0
2022-12-14 14:00:00	NVDA	Stock	18.112	18.125	17.42	17.566	88716040.0
2022-12-14 15:00:00	NVDA	Stock	17.57	18.006	17.512	17.671	77913660.0
2022-12-14 16:00:00	NVDA	Stock	17.674	17.7	17.578	17.626	31568450.0
2022-12-14 17:00:00	NVDA	Stock	17.625	17.631	17.601	17.615	166930.0
2022-12-14 18:00:00	NVDA	Stock	17.607	17.615	17.592	17.604	187910.0
2022-12-14 19:00:00	NVDA	Stock	17.6	17.665	17.594	17.665	248680.0
2022-12-14 04:00:00	AMZN	Stock	92.66	92.76	92.38	92.54	8262.0
2022-12-14 05:00:00	AMZN	Stock	92.61	92.61	92.17	92.4	7283.0

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

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