PREVIEW / stock_1hour / 2022-12-07

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-12-07.parquet
  size:    1.3 MB
  rows:    60,508
  symbols: 2,027

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-07 04:00:00	AAPL	Stock	142.41	142.59	141.5	141.74	40941.0
2022-12-07 05:00:00	AAPL	Stock	141.74	142.0	141.61	141.95	22989.0
2022-12-07 06:00:00	AAPL	Stock	141.97	142.11	141.11	141.35	76460.0
2022-12-07 07:00:00	AAPL	Stock	141.45	141.5	140.5	140.58	159322.0
2022-12-07 08:00:00	AAPL	Stock	141.354	142.96	140.47	141.51	358126.0
2022-12-07 09:00:00	AAPL	Stock	141.6	143.37	140.64	140.8599	9111601.0
2022-12-07 10:00:00	AAPL	Stock	140.86	142.23	140.58	141.8801	10598559.0
2022-12-07 11:00:00	AAPL	Stock	141.88	142.16	140.6	141.08	6296048.0
2022-12-07 12:00:00	AAPL	Stock	141.08	141.3589	140.69	140.89	4887025.0
2022-12-07 13:00:00	AAPL	Stock	140.89	141.43	140.72	140.865	4319120.0
2022-12-07 14:00:00	AAPL	Stock	140.86	141.45	140.63	140.745	4874529.0
2022-12-07 15:00:00	AAPL	Stock	140.75	141.15	140.0	140.94	11225975.0
2022-12-07 16:00:00	AAPL	Stock	140.93	141.06	140.91	140.95	9410678.0
2022-12-07 17:00:00	AAPL	Stock	140.97	141.05	140.94	141.02	41688.0
2022-12-07 18:00:00	AAPL	Stock	141.02	141.03	140.95	140.99	11989.0
2022-12-07 19:00:00	AAPL	Stock	140.98	140.98	140.68	140.7	23071.0
2022-12-07 04:00:00	MSFT	Stock	245.44	245.44	243.9	243.9	1598.0
2022-12-07 05:00:00	MSFT	Stock	244.3	244.3	243.82	243.9	6485.0
2022-12-07 06:00:00	MSFT	Stock	244.2	244.2	243.21	243.27	8795.0
2022-12-07 07:00:00	MSFT	Stock	243.69	243.69	242.05	242.67	10391.0
2022-12-07 08:00:00	MSFT	Stock	243.51	244.508	242.0102	244.0	22474.0
2022-12-07 09:00:00	MSFT	Stock	243.76	245.64	242.69	242.94	1657084.0
2022-12-07 10:00:00	MSFT	Stock	242.93	245.89	242.205	245.64	2073168.0
2022-12-07 11:00:00	MSFT	Stock	245.65	246.16	243.29	244.11	1429606.0
2022-12-07 12:00:00	MSFT	Stock	244.13	245.12	243.56	245.02	1279839.0
2022-12-07 13:00:00	MSFT	Stock	245.02	245.95	244.62	244.72	1164476.0
2022-12-07 14:00:00	MSFT	Stock	244.71	245.19	244.08	244.26	1200936.0
2022-12-07 15:00:00	MSFT	Stock	244.25	244.88	243.79	244.3	2274716.0
2022-12-07 16:00:00	MSFT	Stock	244.3	244.37	244.11	244.34	4874171.0
2022-12-07 17:00:00	MSFT	Stock	244.34	244.72	244.25	244.4	13499.0
2022-12-07 18:00:00	MSFT	Stock	244.46	244.61	244.43	244.5	3056.0
2022-12-07 19:00:00	MSFT	Stock	244.43	244.43	243.65	243.99	3646.0
2022-12-07 04:00:00	NVDA	Stock	15.935	15.939	15.851	15.861	48300.0
2022-12-07 05:00:00	NVDA	Stock	15.864	15.87	15.842	15.843	46740.0
2022-12-07 06:00:00	NVDA	Stock	15.862	15.888	15.82	15.832	35610.0
2022-12-07 07:00:00	NVDA	Stock	15.84	15.851	15.615	15.68	543730.0
2022-12-07 08:00:00	NVDA	Stock	15.6746	15.918	15.615	15.87	1056780.0
2022-12-07 09:00:00	NVDA	Stock	15.864	16.156	15.667	15.87	41619800.0
2022-12-07 10:00:00	NVDA	Stock	15.871	16.0765	15.766	16.042	54259280.0
2022-12-07 11:00:00	NVDA	Stock	16.044	16.1679	15.8145	15.965	45239920.0
2022-12-07 12:00:00	NVDA	Stock	15.965	15.9983	15.865	15.997	27682300.0
2022-12-07 13:00:00	NVDA	Stock	15.996	16.133	15.97	16.036	36891270.0
2022-12-07 14:00:00	NVDA	Stock	16.035	16.148	15.9835	16.0723	38696400.0
2022-12-07 15:00:00	NVDA	Stock	16.071	16.186	16.0268	16.117	48296750.0
2022-12-07 16:00:00	NVDA	Stock	16.12	16.135	16.11	16.112	17227170.0
2022-12-07 17:00:00	NVDA	Stock	16.112	16.125	16.112	16.12	96230.0
2022-12-07 18:00:00	NVDA	Stock	16.12	16.12	16.112	16.113	65330.0
2022-12-07 19:00:00	NVDA	Stock	16.114	16.114	16.087	16.09	310770.0
2022-12-07 04:00:00	AMZN	Stock	88.88	88.88	88.13	88.29	27367.0
2022-12-07 05:00:00	AMZN	Stock	88.24	88.4	88.13	88.4	10348.0

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

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