PREVIEW / stock_1hour / 2022-10-12

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-10-12.parquet
  size:    1.3 MB
  rows:    59,734
  symbols: 2,155

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-12 04:00:00	AAPL	Stock	140.22	140.24	139.75	139.95	38593.0
2022-10-12 05:00:00	AAPL	Stock	139.83	140.59	139.81	140.23	22814.0
2022-10-12 06:00:00	AAPL	Stock	140.24	140.4	140.0	140.12	18960.0
2022-10-12 07:00:00	AAPL	Stock	140.09	140.44	139.95	140.32	65083.0
2022-10-12 08:00:00	AAPL	Stock	140.15	140.45	139.14	139.55	361316.0
2022-10-12 09:00:00	AAPL	Stock	139.5	140.36	138.6507	139.8937	8666684.0
2022-10-12 10:00:00	AAPL	Stock	139.9	140.2	138.831	139.43	9487745.0
2022-10-12 11:00:00	AAPL	Stock	139.44	140.14	139.05	139.99	7331404.0
2022-10-12 12:00:00	AAPL	Stock	140.0	140.09	138.94	139.4633	5232379.0
2022-10-12 13:00:00	AAPL	Stock	139.4699	139.6	138.37	138.5301	5288044.0
2022-10-12 14:00:00	AAPL	Stock	138.525	139.36	138.25	138.51	8677163.0
2022-10-12 15:00:00	AAPL	Stock	138.5	138.8	138.16	138.295	9685367.0
2022-10-12 16:00:00	AAPL	Stock	138.29	138.55	138.29	138.47	6163865.0
2022-10-12 17:00:00	AAPL	Stock	138.46	138.48	138.34	138.4504	26797.0
2022-10-12 18:00:00	AAPL	Stock	138.48	138.56	138.46	138.54	27962.0
2022-10-12 19:00:00	AAPL	Stock	138.52	138.77	138.48	138.61	34464.0
2022-10-12 04:00:00	MSFT	Stock	226.4	227.0	226.4	226.6	1941.0
2022-10-12 05:00:00	MSFT	Stock	226.6	227.77	226.6	227.36	5426.0
2022-10-12 06:00:00	MSFT	Stock	227.49	227.69	226.52	226.98	3072.0
2022-10-12 07:00:00	MSFT	Stock	226.72	227.35	226.71	227.01	17898.0
2022-10-12 08:00:00	MSFT	Stock	227.3	227.47	224.64	225.717	97436.0
2022-10-12 09:00:00	MSFT	Stock	225.6	226.87	224.25	226.35	1943611.0
2022-10-12 10:00:00	MSFT	Stock	226.43	226.6	223.96	224.35	2088763.0
2022-10-12 11:00:00	MSFT	Stock	224.34	226.18	224.3	225.85	1751973.0
2022-10-12 12:00:00	MSFT	Stock	225.87	226.41	224.56	225.5248	1396979.0
2022-10-12 13:00:00	MSFT	Stock	225.5268	226.98	225.5201	226.351	1953017.0
2022-10-12 14:00:00	MSFT	Stock	226.35	227.86	225.74	226.13	2561756.0
2022-10-12 15:00:00	MSFT	Stock	226.13	226.9	225.62	225.69	2309258.0
2022-10-12 16:00:00	MSFT	Stock	225.75	226.09	225.55	226.09	2522451.0
2022-10-12 17:00:00	MSFT	Stock	225.95	226.18	225.75	226.05	10278.0
2022-10-12 18:00:00	MSFT	Stock	226.07	226.22	226.02	226.07	1228.0
2022-10-12 19:00:00	MSFT	Stock	225.9	226.25	225.82	226.15	5623.0
2022-10-12 04:00:00	NVDA	Stock	11.7	11.712	11.67	11.701	96440.0
2022-10-12 05:00:00	NVDA	Stock	11.696	11.773	11.695	11.72	97130.0
2022-10-12 06:00:00	NVDA	Stock	11.744	11.744	11.7	11.715	73940.0
2022-10-12 07:00:00	NVDA	Stock	11.728	11.743	11.71	11.72	119780.0
2022-10-12 08:00:00	NVDA	Stock	11.72	11.745	11.541	11.655	1800920.0
2022-10-12 09:00:00	NVDA	Stock	11.66	11.735	11.472	11.554	64266400.0
2022-10-12 10:00:00	NVDA	Stock	11.556	11.5859	11.345	11.363	70953960.0
2022-10-12 11:00:00	NVDA	Stock	11.3645	11.617	11.352	11.59	59569730.0
2022-10-12 12:00:00	NVDA	Stock	11.591	11.601	11.454	11.5598	39636280.0
2022-10-12 13:00:00	NVDA	Stock	11.559	11.59	11.488	11.512	34575290.0
2022-10-12 14:00:00	NVDA	Stock	11.5146	11.639	11.482	11.5307	55660340.0
2022-10-12 15:00:00	NVDA	Stock	11.531	11.592	11.485	11.501	59433830.0
2022-10-12 16:00:00	NVDA	Stock	11.5	11.525	11.47	11.491	28959740.0
2022-10-12 17:00:00	NVDA	Stock	11.486	11.495	11.48	11.491	263300.0
2022-10-12 18:00:00	NVDA	Stock	11.5	11.507	11.49	11.5	114910.0
2022-10-12 19:00:00	NVDA	Stock	11.498	11.513	11.493	11.495	233180.0
2022-10-12 04:00:00	AMZN	Stock	112.95	113.25	112.93	113.17	8690.0
2022-10-12 05:00:00	AMZN	Stock	113.14	113.87	113.14	113.4	8459.0

> showing 50 of 59,734 rows — these rows as CSV

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