PREVIEW / stock_1hour / 2021-10-22

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-10-22.parquet
  size:    1.4 MB
  rows:    65,077
  symbols: 2,647

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
2021-10-22 04:00:00	AAPL	Stock	149.23	149.93	149.13	149.59	16481.0
2021-10-22 05:00:00	AAPL	Stock	149.54	149.75	149.46	149.69	12688.0
2021-10-22 06:00:00	AAPL	Stock	149.66	149.75	149.6	149.75	10615.0
2021-10-22 07:00:00	AAPL	Stock	149.71	150.1	149.6	149.72	156774.0
2021-10-22 08:00:00	AAPL	Stock	149.9799	150.1129	149.107	149.6999	349824.0
2021-10-22 09:00:00	AAPL	Stock	149.71	150.18	148.845	149.865	9207616.0
2021-10-22 10:00:00	AAPL	Stock	149.87	150.17	149.32	149.54	7864058.0
2021-10-22 11:00:00	AAPL	Stock	149.5403	149.65	148.64	148.95	7213919.0
2021-10-22 12:00:00	AAPL	Stock	148.945	149.48	148.78	149.11	4926550.0
2021-10-22 13:00:00	AAPL	Stock	149.11	149.3	148.9	148.93	3995104.0
2021-10-22 14:00:00	AAPL	Stock	148.94	149.6716	148.8923	149.105	4607314.0
2021-10-22 15:00:00	AAPL	Stock	149.11	149.18	148.64	148.69	7911614.0
2021-10-22 16:00:00	AAPL	Stock	148.69	148.7	148.55	148.55	4645507.0
2021-10-22 17:00:00	AAPL	Stock	148.55	148.57	148.41	148.48	70165.0
2021-10-22 18:00:00	AAPL	Stock	148.47	148.61	148.43	148.57	28149.0
2021-10-22 19:00:00	AAPL	Stock	148.59	148.62	148.43	148.46	20873.0
2021-10-22 04:00:00	MSFT	Stock	310.27	311.15	310.27	310.8	4302.0
2021-10-22 05:00:00	MSFT	Stock	310.85	310.85	310.8	310.8	3576.0
2021-10-22 06:00:00	MSFT	Stock	310.99	311.02	310.9	311.0	11041.0
2021-10-22 07:00:00	MSFT	Stock	311.03	311.3	310.55	310.56	27338.0
2021-10-22 08:00:00	MSFT	Stock	311.03	311.3396	309.984	310.9399	27682.0
2021-10-22 09:00:00	MSFT	Stock	310.76	311.09	308.5	309.59	1947488.0
2021-10-22 10:00:00	MSFT	Stock	309.595	310.26	309.12	309.919	1505484.0
2021-10-22 11:00:00	MSFT	Stock	309.92	310.1454	307.8	308.31	1840089.0
2021-10-22 12:00:00	MSFT	Stock	308.28	310.01	307.99	309.1992	1230297.0
2021-10-22 13:00:00	MSFT	Stock	309.21	309.6787	308.57	308.67	784577.0
2021-10-22 14:00:00	MSFT	Stock	308.7	310.26	308.665	309.54	841584.0
2021-10-22 15:00:00	MSFT	Stock	309.54	309.72	308.9	309.14	1754112.0
2021-10-22 16:00:00	MSFT	Stock	309.16	309.4	308.8	308.8	2383639.0
2021-10-22 17:00:00	MSFT	Stock	308.96	309.0	308.7	308.91	3954.0
2021-10-22 18:00:00	MSFT	Stock	309.14	309.35	309.09	309.16	5826.0
2021-10-22 19:00:00	MSFT	Stock	309.13	309.13	308.96	309.0	2170.0
2021-10-22 04:00:00	NVDA	Stock	22.724	22.82	22.662	22.763	45070.0
2021-10-22 05:00:00	NVDA	Stock	22.779	22.827	22.779	22.827	18520.0
2021-10-22 06:00:00	NVDA	Stock	22.812	22.94	22.812	22.93	76690.0
2021-10-22 07:00:00	NVDA	Stock	22.927	22.93	22.83	22.893	264110.0
2021-10-22 08:00:00	NVDA	Stock	22.898	22.93	22.6353	22.887	803370.0
2021-10-22 09:00:00	NVDA	Stock	22.885	23.13	22.591	22.998	44466200.0
2021-10-22 10:00:00	NVDA	Stock	22.998	23.121	22.901	22.9415	29456260.0
2021-10-22 11:00:00	NVDA	Stock	22.946	22.982	22.561	22.665	25641680.0
2021-10-22 12:00:00	NVDA	Stock	22.663	22.846	22.5721	22.808	18796770.0
2021-10-22 13:00:00	NVDA	Stock	22.809	22.871	22.685	22.69	12990980.0
2021-10-22 14:00:00	NVDA	Stock	22.691	22.914	22.689	22.834	13766180.0
2021-10-22 15:00:00	NVDA	Stock	22.836	22.845	22.698	22.723	21666390.0
2021-10-22 16:00:00	NVDA	Stock	22.726	22.747	22.7	22.729	24890690.0
2021-10-22 17:00:00	NVDA	Stock	22.7	22.72	22.7	22.72	56790.0
2021-10-22 18:00:00	NVDA	Stock	22.72	22.73	22.69	22.7	51290.0
2021-10-22 19:00:00	NVDA	Stock	22.7	22.72	22.697	22.72	75410.0
2021-10-22 06:00:00	AMZN	Stock	171.7505	171.7505	171.6	171.6	4460.0
2021-10-22 07:00:00	AMZN	Stock	171.45	171.6	171.45	171.5	32620.0

> showing 50 of 65,077 rows — these rows as CSV

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