PREVIEW / stock_1hour / 2023-03-07

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-03-07.parquet
  size:    1.3 MB
  rows:    59,583
  symbols: 1,803

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
2023-03-07 04:00:00	AAPL	Stock	154.0	154.72	153.98	154.15	17927.0
2023-03-07 05:00:00	AAPL	Stock	154.16	154.33	154.16	154.2	3670.0
2023-03-07 06:00:00	AAPL	Stock	154.26	154.33	154.15	154.18	12517.0
2023-03-07 07:00:00	AAPL	Stock	154.3	154.38	154.06	154.13	36594.0
2023-03-07 08:00:00	AAPL	Stock	154.19	154.7	153.446	153.95	167205.0
2023-03-07 09:00:00	AAPL	Stock	153.97	154.0299	153.15	153.855	5349259.0
2023-03-07 10:00:00	AAPL	Stock	153.86	153.86	151.78	152.1914	10568027.0
2023-03-07 11:00:00	AAPL	Stock	152.21	152.77	151.97	152.0656	5448993.0
2023-03-07 12:00:00	AAPL	Stock	152.06	153.0899	151.8	152.4288	4668717.0
2023-03-07 13:00:00	AAPL	Stock	152.42	152.69	151.74	151.83	4352118.0
2023-03-07 14:00:00	AAPL	Stock	151.82	152.04	151.14	151.1795	4442052.0
2023-03-07 15:00:00	AAPL	Stock	151.18	151.77	151.13	151.58	6941155.0
2023-03-07 16:00:00	AAPL	Stock	151.57	151.72	151.45	151.5966	5306368.0
2023-03-07 17:00:00	AAPL	Stock	151.57	151.64	151.53	151.53	12912.0
2023-03-07 18:00:00	AAPL	Stock	151.57	151.75	151.57	151.64	22614.0
2023-03-07 19:00:00	AAPL	Stock	151.69	151.75	151.37	151.43	25968.0
2023-03-07 04:00:00	MSFT	Stock	257.64	257.64	257.14	257.14	1579.0
2023-03-07 05:00:00	MSFT	Stock	257.25	257.43	257.25	257.43	1297.0
2023-03-07 06:00:00	MSFT	Stock	257.45	257.45	256.99	256.99	2773.0
2023-03-07 07:00:00	MSFT	Stock	257.08	257.25	256.85	257.15	5836.0
2023-03-07 08:00:00	MSFT	Stock	257.2481	258.4	257.0	257.68	20228.0
2023-03-07 09:00:00	MSFT	Stock	257.61	257.69	256.0	256.92	1507803.0
2023-03-07 10:00:00	MSFT	Stock	256.87	256.87	254.04	254.705	2811339.0
2023-03-07 11:00:00	MSFT	Stock	254.74	255.72	254.51	254.72	1506336.0
2023-03-07 12:00:00	MSFT	Stock	254.69	256.34	254.61	255.47	1334926.0
2023-03-07 13:00:00	MSFT	Stock	255.45	255.55	254.07	254.37	1506977.0
2023-03-07 14:00:00	MSFT	Stock	254.36	254.722	253.43	253.485	1004105.0
2023-03-07 15:00:00	MSFT	Stock	253.49	254.38	253.39	254.16	2535639.0
2023-03-07 16:00:00	MSFT	Stock	254.15	254.78	254.15	254.46	2729969.0
2023-03-07 17:00:00	MSFT	Stock	254.51	254.51	254.39	254.39	5498.0
2023-03-07 18:00:00	MSFT	Stock	254.44	254.7	254.44	254.57	6311.0
2023-03-07 19:00:00	MSFT	Stock	254.58	254.58	254.15	254.25	8460.0
2023-03-07 04:00:00	NVDA	Stock	23.64	23.67	23.58	23.59	77110.0
2023-03-07 05:00:00	NVDA	Stock	23.6	23.615	23.6	23.606	42430.0
2023-03-07 06:00:00	NVDA	Stock	23.621	23.632	23.587	23.597	72480.0
2023-03-07 07:00:00	NVDA	Stock	23.617	23.654	23.602	23.615	218610.0
2023-03-07 08:00:00	NVDA	Stock	23.642	23.686	23.547	23.659	457640.0
2023-03-07 09:00:00	NVDA	Stock	23.65	23.854	23.5251	23.742	38093310.0
2023-03-07 10:00:00	NVDA	Stock	23.737	23.948	23.3294	23.6375	92586720.0
2023-03-07 11:00:00	NVDA	Stock	23.635	24.099	23.612	23.9578	67800680.0
2023-03-07 12:00:00	NVDA	Stock	23.9568	24.125	23.858	24.02	56035670.0
2023-03-07 13:00:00	NVDA	Stock	24.016	24.0259	23.505	23.5394	47609500.0
2023-03-07 14:00:00	NVDA	Stock	23.54	23.577	23.321	23.354	44869200.0
2023-03-07 15:00:00	NVDA	Stock	23.354	23.4719	23.241	23.285	52123050.0
2023-03-07 16:00:00	NVDA	Stock	23.288	23.292	23.259	23.26	17022480.0
2023-03-07 17:00:00	NVDA	Stock	23.26	23.272	23.251	23.265	224420.0
2023-03-07 18:00:00	NVDA	Stock	23.268	23.282	23.25	23.263	221090.0
2023-03-07 19:00:00	NVDA	Stock	23.255	23.259	23.23	23.24	283360.0
2023-03-07 04:00:00	AMZN	Stock	94.2	94.34	94.06	94.12	15320.0
2023-03-07 05:00:00	AMZN	Stock	94.15	94.2	94.14	94.2	6097.0

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

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