PREVIEW / stock_1hour / 2022-09-21

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-09-21.parquet
  size:    1.4 MB
  rows:    61,868
  symbols: 2,234

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-21 04:00:00	AAPL	Stock	157.39	157.39	156.32	156.68	21412.0
2022-09-21 05:00:00	AAPL	Stock	156.62	156.97	156.38	156.75	21469.0
2022-09-21 06:00:00	AAPL	Stock	156.8	156.8	156.41	156.71	12350.0
2022-09-21 07:00:00	AAPL	Stock	156.64	156.86	156.36	156.82	89893.0
2022-09-21 08:00:00	AAPL	Stock	156.5732	157.47	156.35	157.3	278633.0
2022-09-21 09:00:00	AAPL	Stock	157.34	158.4	156.521	157.0301	10192866.0
2022-09-21 10:00:00	AAPL	Stock	157.02	157.425	156.31	156.465	8916332.0
2022-09-21 11:00:00	AAPL	Stock	156.46	156.53	155.92	156.3086	5684303.0
2022-09-21 12:00:00	AAPL	Stock	156.29	157.3712	156.16	157.091	6086923.0
2022-09-21 13:00:00	AAPL	Stock	157.1	158.05	156.962	157.89	6084559.0
2022-09-21 14:00:00	AAPL	Stock	157.89	158.74	154.44	158.34	23257040.0
2022-09-21 15:00:00	AAPL	Stock	158.33	158.61	153.6	153.71	19099153.0
2022-09-21 16:00:00	AAPL	Stock	153.71	153.818	153.0	153.45	7024712.0
2022-09-21 17:00:00	AAPL	Stock	153.45	153.72	153.17	153.2565	204800.0
2022-09-21 18:00:00	AAPL	Stock	153.27	153.39	152.41	152.53	176802.0
2022-09-21 19:00:00	AAPL	Stock	152.55	152.55	152.22	152.45	86777.0
2022-09-21 04:00:00	MSFT	Stock	242.41	242.97	242.28	242.97	1772.0
2022-09-21 05:00:00	MSFT	Stock	242.6	243.1	242.45	243.1	745.0
2022-09-21 06:00:00	MSFT	Stock	242.97	242.97	242.31	242.78	2494.0
2022-09-21 07:00:00	MSFT	Stock	242.6	243.35	242.47	243.1	8329.0
2022-09-21 08:00:00	MSFT	Stock	242.5149	244.38	242.4	244.38	49439.0
2022-09-21 09:00:00	MSFT	Stock	244.49	245.49	243.63	244.82	1943314.0
2022-09-21 10:00:00	MSFT	Stock	244.81	245.16	243.66	243.95	1627824.0
2022-09-21 11:00:00	MSFT	Stock	243.9329	244.609	243.44	244.5	1125245.0
2022-09-21 12:00:00	MSFT	Stock	244.465	245.69	244.27	245.029	1274659.0
2022-09-21 13:00:00	MSFT	Stock	245.0	246.37	244.67	246.08	1043123.0
2022-09-21 14:00:00	MSFT	Stock	246.13	247.66	240.29	246.3	5645879.0
2022-09-21 15:00:00	MSFT	Stock	246.35	246.75	238.9	238.96	5746940.0
2022-09-21 16:00:00	MSFT	Stock	239.13	239.13	238.0	238.58	3121896.0
2022-09-21 17:00:00	MSFT	Stock	238.5	238.6	238.25	238.2732	26501.0
2022-09-21 18:00:00	MSFT	Stock	238.5	238.5	237.78	237.8	64110.0
2022-09-21 19:00:00	MSFT	Stock	237.8	237.95	237.15	237.26	19289.0
2022-09-21 04:00:00	NVDA	Stock	13.15	13.185	13.08	13.166	148690.0
2022-09-21 05:00:00	NVDA	Stock	13.155	13.19	13.137	13.19	68240.0
2022-09-21 06:00:00	NVDA	Stock	13.185	13.186	13.15	13.175	67390.0
2022-09-21 07:00:00	NVDA	Stock	13.175	13.209	13.16	13.207	142790.0
2022-09-21 08:00:00	NVDA	Stock	13.1838	13.311	13.16	13.275	1122220.0
2022-09-21 09:00:00	NVDA	Stock	13.276	13.347	13.11	13.3355	59636700.0
2022-09-21 10:00:00	NVDA	Stock	13.333	13.448	13.3211	13.3912	85268190.0
2022-09-21 11:00:00	NVDA	Stock	13.3895	13.537	13.378	13.506	66996480.0
2022-09-21 12:00:00	NVDA	Stock	13.5065	13.6077	13.491	13.5325	60507530.0
2022-09-21 13:00:00	NVDA	Stock	13.531	13.685	13.486	13.6686	45321360.0
2022-09-21 14:00:00	NVDA	Stock	13.6686	14.031	13.176	13.9175	193665830.0
2022-09-21 15:00:00	NVDA	Stock	13.9185	13.97	13.254	13.255	138719860.0
2022-09-21 16:00:00	NVDA	Stock	13.261	13.2771	13.16	13.194	28773040.0
2022-09-21 17:00:00	NVDA	Stock	13.261	13.261	13.174	13.19	461640.0
2022-09-21 18:00:00	NVDA	Stock	13.18	13.189	13.092	13.115	502730.0
2022-09-21 19:00:00	NVDA	Stock	13.102	13.12	13.0	13.05	1245100.0
2022-09-21 04:00:00	AMZN	Stock	122.0	122.37	121.71	122.15	4756.0
2022-09-21 05:00:00	AMZN	Stock	122.08	122.31	121.99	122.31	3281.0

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

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