PREVIEW / stock_1hour / 2021-10-18

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-10-18.parquet
  size:    1.4 MB
  rows:    64,644
  symbols: 2,660

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-18 04:00:00	AAPL	Stock	144.39	144.39	144.04	144.25	12161.0
2021-10-18 05:00:00	AAPL	Stock	144.21	144.4	144.16	144.32	10247.0
2021-10-18 06:00:00	AAPL	Stock	144.3	144.32	144.0	144.2	17719.0
2021-10-18 07:00:00	AAPL	Stock	144.27	144.87	144.25	144.64	76729.0
2021-10-18 08:00:00	AAPL	Stock	144.6	144.89	144.0	144.15	452316.0
2021-10-18 09:00:00	AAPL	Stock	144.11	144.46	143.16	144.315	11366461.0
2021-10-18 10:00:00	AAPL	Stock	144.32	144.88	144.17	144.83	9623143.0
2021-10-18 11:00:00	AAPL	Stock	144.83	145.52	144.8297	145.3901	8618281.0
2021-10-18 12:00:00	AAPL	Stock	145.4	145.48	145.07	145.2226	4551001.0
2021-10-18 13:00:00	AAPL	Stock	145.225	146.055	144.96	145.885	10026689.0
2021-10-18 14:00:00	AAPL	Stock	145.885	146.39	145.71	146.3221	5902493.0
2021-10-18 15:00:00	AAPL	Stock	146.32	146.84	146.24	146.54	11403147.0
2021-10-18 16:00:00	AAPL	Stock	146.55	146.79	146.55	146.65	10815220.0
2021-10-18 17:00:00	AAPL	Stock	146.62	146.84	146.59	146.84	111141.0
2021-10-18 18:00:00	AAPL	Stock	146.84	146.85	146.61	146.63	59411.0
2021-10-18 19:00:00	AAPL	Stock	146.63	146.8	146.63	146.79	50031.0
2021-10-18 04:00:00	MSFT	Stock	303.33	303.41	302.99	303.01	697.0
2021-10-18 05:00:00	MSFT	Stock	302.77	302.95	302.72	302.95	1326.0
2021-10-18 06:00:00	MSFT	Stock	302.71	302.71	302.01	302.47	1679.0
2021-10-18 07:00:00	MSFT	Stock	302.74	303.9	302.74	303.3	10713.0
2021-10-18 08:00:00	MSFT	Stock	303.25	304.18	302.5	302.9	76070.0
2021-10-18 09:00:00	MSFT	Stock	303.0	305.07	302.54	304.48	2116434.0
2021-10-18 10:00:00	MSFT	Stock	304.5	304.98	303.29	304.34	1875570.0
2021-10-18 11:00:00	MSFT	Stock	304.34	304.97	304.02	304.6602	1510833.0
2021-10-18 12:00:00	MSFT	Stock	304.6513	306.37	304.55	306.126	2368824.0
2021-10-18 13:00:00	MSFT	Stock	306.12	307.62	306.12	307.57	1775362.0
2021-10-18 14:00:00	MSFT	Stock	307.58	308.21	306.74	306.8863	1754746.0
2021-10-18 15:00:00	MSFT	Stock	306.88	307.4952	306.26	307.25	2624655.0
2021-10-18 16:00:00	MSFT	Stock	307.29	307.43	307.08	307.35	3141807.0
2021-10-18 17:00:00	MSFT	Stock	307.28	307.3	307.1501	307.3	2784.0
2021-10-18 18:00:00	MSFT	Stock	307.38	307.38	307.11	307.11	2272.0
2021-10-18 19:00:00	MSFT	Stock	307.28	307.4	307.1	307.36	2028.0
2021-10-18 04:00:00	NVDA	Stock	21.78	21.81	21.755	21.755	19270.0
2021-10-18 05:00:00	NVDA	Stock	21.755	21.755	21.712	21.728	10320.0
2021-10-18 06:00:00	NVDA	Stock	21.697	21.701	21.682	21.682	4000.0
2021-10-18 07:00:00	NVDA	Stock	21.72	21.803	21.705	21.786	124960.0
2021-10-18 08:00:00	NVDA	Stock	21.715	21.822	21.7	21.7375	396610.0
2021-10-18 09:00:00	NVDA	Stock	21.738	22.055	21.644	21.9969	24019690.0
2021-10-18 10:00:00	NVDA	Stock	21.997	22.118	21.965	22.0835	26169750.0
2021-10-18 11:00:00	NVDA	Stock	22.086	22.177	22.06	22.152	17607890.0
2021-10-18 12:00:00	NVDA	Stock	22.149	22.242	22.114	22.2365	13655620.0
2021-10-18 13:00:00	NVDA	Stock	22.238	22.249	22.16	22.195	9663870.0
2021-10-18 14:00:00	NVDA	Stock	22.194	22.274	22.1835	22.2653	11415460.0
2021-10-18 15:00:00	NVDA	Stock	22.266	22.291	22.169	22.222	21705470.0
2021-10-18 16:00:00	NVDA	Stock	22.222	22.265	22.205	22.225	19178830.0
2021-10-18 17:00:00	NVDA	Stock	22.245	22.245	22.225	22.24	43620.0
2021-10-18 18:00:00	NVDA	Stock	22.235	22.235	22.2	22.2	39770.0
2021-10-18 19:00:00	NVDA	Stock	22.202	22.24	22.187	22.239	151050.0
2021-10-18 05:00:00	AMZN	Stock	169.75	169.8	169.75	169.8	7480.0
2021-10-18 06:00:00	AMZN	Stock	169.75	169.75	169.45	169.6	11020.0

> showing 50 of 64,644 rows — these rows as CSV

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