PREVIEW / stock_1hour / 2022-09-15

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-09-15.parquet
  size:    1.4 MB
  rows:    63,607
  symbols: 2,215

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-09-15 04:00:00	AAPL	Stock	156.0	156.15	155.3	155.32	26578.0
2022-09-15 05:00:00	AAPL	Stock	155.43	155.63	155.34	155.59	14253.0
2022-09-15 06:00:00	AAPL	Stock	155.55	155.59	154.65	154.92	28607.0
2022-09-15 07:00:00	AAPL	Stock	154.98	155.42	154.85	154.96	81035.0
2022-09-15 08:00:00	AAPL	Stock	155.05	155.78	154.5325	155.03	351320.0
2022-09-15 09:00:00	AAPL	Stock	155.0	155.24	154.09	154.8681	7904747.0
2022-09-15 10:00:00	AAPL	Stock	154.87	155.21	151.78	152.0699	14092392.0
2022-09-15 11:00:00	AAPL	Stock	152.05	153.0879	151.92	152.645	9788877.0
2022-09-15 12:00:00	AAPL	Stock	152.64	153.245	152.26	153.23	6354800.0
2022-09-15 13:00:00	AAPL	Stock	153.24	154.3	153.2	153.42	6547022.0
2022-09-15 14:00:00	AAPL	Stock	153.43	153.455	152.31	152.39	6280420.0
2022-09-15 15:00:00	AAPL	Stock	152.4	152.69	151.38	152.35	15832214.0
2022-09-15 16:00:00	AAPL	Stock	152.35	152.68	151.73	152.05	9159520.0
2022-09-15 17:00:00	AAPL	Stock	152.05	152.37	151.523	151.69	105534.0
2022-09-15 18:00:00	AAPL	Stock	151.69	151.69	151.11	151.35	114700.0
2022-09-15 19:00:00	AAPL	Stock	151.35	151.4	151.1	151.35	97388.0
2022-09-15 04:00:00	MSFT	Stock	252.88	252.88	252.0	252.36	5288.0
2022-09-15 05:00:00	MSFT	Stock	252.36	252.53	252.05	252.5	3826.0
2022-09-15 06:00:00	MSFT	Stock	252.5	252.55	251.21	251.38	3245.0
2022-09-15 07:00:00	MSFT	Stock	251.85	251.86	251.4	251.4	2674.0
2022-09-15 08:00:00	MSFT	Stock	251.6011	252.1887	250.8817	251.72	43678.0
2022-09-15 09:00:00	MSFT	Stock	251.73	251.99	248.3256	250.42	2695667.0
2022-09-15 10:00:00	MSFT	Stock	250.42	251.4	245.59	245.64	4066180.0
2022-09-15 11:00:00	MSFT	Stock	245.63	247.38	245.2	245.8129	2325383.0
2022-09-15 12:00:00	MSFT	Stock	245.8	246.64	245.27	246.56	1552079.0
2022-09-15 13:00:00	MSFT	Stock	246.57	248.45	246.57	247.023	1627806.0
2022-09-15 14:00:00	MSFT	Stock	247.04	247.06	245.49	245.6	1630783.0
2022-09-15 15:00:00	MSFT	Stock	245.62	246.4	244.02	245.33	5099576.0
2022-09-15 16:00:00	MSFT	Stock	245.38	246.09	244.64	245.23	5208363.0
2022-09-15 17:00:00	MSFT	Stock	245.2225	245.38	244.5	244.55	24551.0
2022-09-15 18:00:00	MSFT	Stock	244.55	244.72	243.56	243.75	34086.0
2022-09-15 19:00:00	MSFT	Stock	243.8	243.8	243.38	243.55	17479.0
2022-09-15 04:00:00	NVDA	Stock	13.245	13.245	13.155	13.193	110640.0
2022-09-15 05:00:00	NVDA	Stock	13.19	13.212	13.166	13.199	44010.0
2022-09-15 06:00:00	NVDA	Stock	13.204	13.204	13.07	13.089	120290.0
2022-09-15 07:00:00	NVDA	Stock	13.084	13.13	13.058	13.085	268360.0
2022-09-15 08:00:00	NVDA	Stock	13.089	13.2369	13.037	13.091	1048420.0
2022-09-15 09:00:00	NVDA	Stock	13.091	13.223	12.9622	13.18	57110270.0
2022-09-15 10:00:00	NVDA	Stock	13.182	13.232	12.811	12.813	79404020.0
2022-09-15 11:00:00	NVDA	Stock	12.813	13.016	12.79	12.957	63550610.0
2022-09-15 12:00:00	NVDA	Stock	12.955	13.041	12.927	13.0405	40555800.0
2022-09-15 13:00:00	NVDA	Stock	13.041	13.19	13.0245	13.063	48989540.0
2022-09-15 14:00:00	NVDA	Stock	13.0635	13.068	12.951	12.965	41944670.0
2022-09-15 15:00:00	NVDA	Stock	12.966	12.983	12.828	12.93	65474570.0
2022-09-15 16:00:00	NVDA	Stock	12.929	12.9592	12.84	12.867	28321480.0
2022-09-15 17:00:00	NVDA	Stock	12.89	12.929	12.829	12.879	684110.0
2022-09-15 18:00:00	NVDA	Stock	12.851	12.863	12.78	12.82	735860.0
2022-09-15 19:00:00	NVDA	Stock	12.825	12.825	12.77	12.774	756200.0
2022-09-15 04:00:00	AMZN	Stock	128.95	128.95	128.05	128.08	7846.0
2022-09-15 05:00:00	AMZN	Stock	128.14	128.56	128.11	128.45	2748.0

> showing 50 of 63,607 rows — these rows as CSV

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