PREVIEW / stock_1hour / 2022-12-09

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-12-09.parquet
  size:    1.3 MB
  rows:    60,309
  symbols: 2,028

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-09 04:00:00	AAPL	Stock	143.69	143.69	143.0	143.2	11879.0
2022-12-09 05:00:00	AAPL	Stock	143.13	143.38	142.97	143.35	13137.0
2022-12-09 06:00:00	AAPL	Stock	143.35	143.72	143.34	143.61	31133.0
2022-12-09 07:00:00	AAPL	Stock	143.64	144.12	143.55	144.03	71863.0
2022-12-09 08:00:00	AAPL	Stock	143.6492	144.1	141.49	142.75	473535.0
2022-12-09 09:00:00	AAPL	Stock	142.86	142.89	140.9	141.765	6539449.0
2022-12-09 10:00:00	AAPL	Stock	141.81	144.31	141.2	144.295	9746887.0
2022-12-09 11:00:00	AAPL	Stock	144.29	145.12	143.83	145.009	10010287.0
2022-12-09 12:00:00	AAPL	Stock	145.01	145.57	144.38	144.4347	6057770.0
2022-12-09 13:00:00	AAPL	Stock	144.43	144.47	143.84	144.2	5370958.0
2022-12-09 14:00:00	AAPL	Stock	144.195	144.32	143.75	143.85	4763043.0
2022-12-09 15:00:00	AAPL	Stock	143.84	144.15	142.07	142.19	9923534.0
2022-12-09 16:00:00	AAPL	Stock	142.2	142.3	141.95	141.96	13819305.0
2022-12-09 17:00:00	AAPL	Stock	142.0	142.07	141.94	141.98	20444.0
2022-12-09 18:00:00	AAPL	Stock	141.98	142.06	141.95	141.99	11031.0
2022-12-09 19:00:00	AAPL	Stock	141.99	142.0499	141.9	141.95	9573.0
2022-12-09 04:00:00	MSFT	Stock	247.7	248.31	247.4	247.4	1923.0
2022-12-09 05:00:00	MSFT	Stock	247.49	247.99	247.3	247.99	1719.0
2022-12-09 06:00:00	MSFT	Stock	247.86	247.98	247.8	247.98	606.0
2022-12-09 07:00:00	MSFT	Stock	248.08	248.75	247.93	248.75	14327.0
2022-12-09 08:00:00	MSFT	Stock	248.0	248.9789	243.51	246.5	73157.0
2022-12-09 09:00:00	MSFT	Stock	246.47	246.62	244.56	245.48	1277739.0
2022-12-09 10:00:00	MSFT	Stock	245.51	247.7699	244.16	247.75	2561069.0
2022-12-09 11:00:00	MSFT	Stock	247.79	248.31	246.43	247.41	2168306.0
2022-12-09 12:00:00	MSFT	Stock	247.42	247.91	246.86	247.3801	1084856.0
2022-12-09 13:00:00	MSFT	Stock	247.38	247.38	246.31	246.98	952864.0
2022-12-09 14:00:00	MSFT	Stock	246.95	247.18	246.19	246.91	857997.0
2022-12-09 15:00:00	MSFT	Stock	246.87	247.5075	245.2	245.42	2316369.0
2022-12-09 16:00:00	MSFT	Stock	245.42	245.49	245.01	245.01	4491144.0
2022-12-09 17:00:00	MSFT	Stock	245.0	245.25	244.98	244.98	2749.0
2022-12-09 18:00:00	MSFT	Stock	245.09	245.24	245.09	245.24	480.0
2022-12-09 19:00:00	MSFT	Stock	245.0	245.0	245.0	245.0	250.0
2022-12-09 04:00:00	NVDA	Stock	17.187	17.269	17.15	17.182	246160.0
2022-12-09 05:00:00	NVDA	Stock	17.188	17.253	17.188	17.253	19140.0
2022-12-09 06:00:00	NVDA	Stock	17.253	17.253	17.22	17.24	32160.0
2022-12-09 07:00:00	NVDA	Stock	17.23	17.313	17.23	17.286	256180.0
2022-12-09 08:00:00	NVDA	Stock	17.235	17.313	16.912	17.085	3447390.0
2022-12-09 09:00:00	NVDA	Stock	17.086	17.449	17.0011	17.2	69081840.0
2022-12-09 10:00:00	NVDA	Stock	17.208	17.5	17.1074	17.494	71548990.0
2022-12-09 11:00:00	NVDA	Stock	17.4957	17.583	17.382	17.506	54318510.0
2022-12-09 12:00:00	NVDA	Stock	17.507	17.535	17.3855	17.3942	35070360.0
2022-12-09 13:00:00	NVDA	Stock	17.39	17.39	17.217	17.304	38044410.0
2022-12-09 14:00:00	NVDA	Stock	17.303	17.351	17.224	17.3339	28533960.0
2022-12-09 15:00:00	NVDA	Stock	17.328	17.341	16.975	16.998	54509280.0
2022-12-09 16:00:00	NVDA	Stock	16.998	17.014	16.985	16.996	22093900.0
2022-12-09 17:00:00	NVDA	Stock	17.01	17.011	16.98	16.9969	158280.0
2022-12-09 18:00:00	NVDA	Stock	16.987	16.997	16.962	16.98	88940.0
2022-12-09 19:00:00	NVDA	Stock	16.98	16.985	16.97	16.971	102310.0
2022-12-09 04:00:00	AMZN	Stock	90.97	91.0	90.7	90.93	19618.0
2022-12-09 05:00:00	AMZN	Stock	90.95	91.34	90.93	91.25	18394.0

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

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