PREVIEW / stock_1hour / 2022-02-03

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-02-03.parquet
  size:    1.4 MB
  rows:    63,506
  symbols: 2,520

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-02-03 04:00:00	AAPL	Stock	173.9	175.0	173.68	173.68	49387.0
2022-02-03 05:00:00	AAPL	Stock	173.8	173.95	173.64	173.66	10785.0
2022-02-03 06:00:00	AAPL	Stock	173.78	174.4	173.46	174.32	41840.0
2022-02-03 07:00:00	AAPL	Stock	174.23	174.58	173.56	174.21	242646.0
2022-02-03 08:00:00	AAPL	Stock	173.9789	174.5398	173.5	173.68	620224.0
2022-02-03 09:00:00	AAPL	Stock	173.67	175.29	173.23	174.7506	8014533.0
2022-02-03 10:00:00	AAPL	Stock	174.76	176.2399	174.39	175.26	11340635.0
2022-02-03 11:00:00	AAPL	Stock	175.265	176.03	174.55	174.58	7076642.0
2022-02-03 12:00:00	AAPL	Stock	174.57	175.465	174.28	175.29	6081263.0
2022-02-03 13:00:00	AAPL	Stock	175.29	176.03	174.88	175.515	5336363.0
2022-02-03 14:00:00	AAPL	Stock	175.51	175.81	174.31	174.47	6250282.0
2022-02-03 15:00:00	AAPL	Stock	174.4715	174.94	172.12	173.0	15332086.0
2022-02-03 16:00:00	AAPL	Stock	173.0	174.41	172.79	174.11	14481246.0
2022-02-03 17:00:00	AAPL	Stock	174.07	174.39	172.9	174.0	2083775.0
2022-02-03 18:00:00	AAPL	Stock	173.95	174.35	173.9	174.2	72014.0
2022-02-03 19:00:00	AAPL	Stock	174.25	174.3	173.9901	174.17	99544.0
2022-02-03 04:00:00	MSFT	Stock	311.58	311.98	309.37	309.37	8666.0
2022-02-03 05:00:00	MSFT	Stock	309.36	310.0	309.22	309.71	8250.0
2022-02-03 06:00:00	MSFT	Stock	309.71	310.45	309.03	310.45	12563.0
2022-02-03 07:00:00	MSFT	Stock	310.25	310.98	309.6	310.55	43495.0
2022-02-03 08:00:00	MSFT	Stock	310.206	310.98	309.01	309.0337	44809.0
2022-02-03 09:00:00	MSFT	Stock	309.15	310.74	307.55	308.905	4259293.0
2022-02-03 10:00:00	MSFT	Stock	308.89	311.23	308.43	309.26	3013009.0
2022-02-03 11:00:00	MSFT	Stock	309.24	309.52	307.51	307.71	2291985.0
2022-02-03 12:00:00	MSFT	Stock	307.73	307.98	305.92	306.51	2738312.0
2022-02-03 13:00:00	MSFT	Stock	306.54	306.74	305.2	305.4585	2110635.0
2022-02-03 14:00:00	MSFT	Stock	305.45	305.85	302.74	303.67	3658644.0
2022-02-03 15:00:00	MSFT	Stock	303.66	304.735	299.96	301.23	6601521.0
2022-02-03 16:00:00	MSFT	Stock	301.23	307.01	301.08	306.77	6263257.0
2022-02-03 17:00:00	MSFT	Stock	306.74	306.76	301.25	304.5	997164.0
2022-02-03 18:00:00	MSFT	Stock	304.47	305.55	304.07	305.1	25786.0
2022-02-03 19:00:00	MSFT	Stock	305.47	305.5	304.6	305.0	36453.0
2022-02-03 04:00:00	NVDA	Stock	24.387	24.478	24.251	24.341	250680.0
2022-02-03 05:00:00	NVDA	Stock	24.368	24.368	24.275	24.305	114450.0
2022-02-03 06:00:00	NVDA	Stock	24.33	24.33	24.21	24.328	49840.0
2022-02-03 07:00:00	NVDA	Stock	24.345	24.62	24.269	24.58	678050.0
2022-02-03 08:00:00	NVDA	Stock	24.3004	24.65	24.269	24.35	1259100.0
2022-02-03 09:00:00	NVDA	Stock	24.353	24.836	24.25	24.547	38252470.0
2022-02-03 10:00:00	NVDA	Stock	24.545	25.077	24.364	24.8265	52179820.0
2022-02-03 11:00:00	NVDA	Stock	24.834	24.981	24.414	24.415	26934630.0
2022-02-03 12:00:00	NVDA	Stock	24.417	24.498	24.141	24.362	36445860.0
2022-02-03 13:00:00	NVDA	Stock	24.3585	24.57	24.256	24.375	23171110.0
2022-02-03 14:00:00	NVDA	Stock	24.375	24.557	24.187	24.381	24256200.0
2022-02-03 15:00:00	NVDA	Stock	24.38	24.543	23.78	23.947	54766990.0
2022-02-03 16:00:00	NVDA	Stock	23.949	24.65	23.907	24.61	35042200.0
2022-02-03 17:00:00	NVDA	Stock	24.627	24.794	23.948	24.5	8601680.0
2022-02-03 18:00:00	NVDA	Stock	24.482	24.645	24.482	24.555	375800.0
2022-02-03 19:00:00	NVDA	Stock	24.57	24.679	24.57	24.65	286800.0
2022-02-03 04:00:00	AMZN	Stock	145.924	146.147	145.65	145.65	46760.0
2022-02-03 05:00:00	AMZN	Stock	145.75	145.9	145.487	145.487	23900.0

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

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