PREVIEW / stock_1hour / 2022-11-14

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-11-14.parquet
  size:    1.4 MB
  rows:    62,405
  symbols: 2,144

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-11-14 04:00:00	AAPL	Stock	149.24	149.24	148.26	148.4	39340.0
2022-11-14 05:00:00	AAPL	Stock	148.45	148.49	148.12	148.36	34278.0
2022-11-14 06:00:00	AAPL	Stock	148.36	148.36	148.23	148.3	5479.0
2022-11-14 07:00:00	AAPL	Stock	148.32	148.87	148.25	148.82	76875.0
2022-11-14 08:00:00	AAPL	Stock	148.44	148.88	147.96	148.55	218584.0
2022-11-14 09:00:00	AAPL	Stock	148.55	149.7	147.43	147.9	9133807.0
2022-11-14 10:00:00	AAPL	Stock	147.91	148.6651	147.71	148.25	8164059.0
2022-11-14 11:00:00	AAPL	Stock	148.23	148.55	147.5399	148.4212	7578275.0
2022-11-14 12:00:00	AAPL	Stock	148.4299	149.28	148.26	148.84	5615770.0
2022-11-14 13:00:00	AAPL	Stock	148.84	150.2	148.701	150.18	5809373.0
2022-11-14 14:00:00	AAPL	Stock	150.18	150.28	149.5	149.55	5938431.0
2022-11-14 15:00:00	AAPL	Stock	149.56	150.1599	148.07	148.37	10544750.0
2022-11-14 16:00:00	AAPL	Stock	148.37	148.75	148.21	148.54	10518620.0
2022-11-14 17:00:00	AAPL	Stock	148.52	148.59	148.41	148.5	45900.0
2022-11-14 18:00:00	AAPL	Stock	148.68	148.95	148.55	148.83	33449.0
2022-11-14 19:00:00	AAPL	Stock	148.84	148.94	148.71	148.76	21350.0
2022-11-14 04:00:00	MSFT	Stock	246.48	246.48	245.2	245.2	5828.0
2022-11-14 05:00:00	MSFT	Stock	245.15	245.76	245.0	245.76	13641.0
2022-11-14 06:00:00	MSFT	Stock	245.62	245.87	245.42	245.45	5991.0
2022-11-14 07:00:00	MSFT	Stock	245.55	245.55	244.16	244.37	38817.0
2022-11-14 08:00:00	MSFT	Stock	245.55	245.55	243.55	243.92	53325.0
2022-11-14 09:00:00	MSFT	Stock	243.88	247.11	239.21	241.54	4190055.0
2022-11-14 10:00:00	MSFT	Stock	241.55	243.22	241.15	241.6889	3301027.0
2022-11-14 11:00:00	MSFT	Stock	241.68	243.15	240.8267	242.35	2232499.0
2022-11-14 12:00:00	MSFT	Stock	242.36	243.19	241.73	242.5765	1641118.0
2022-11-14 13:00:00	MSFT	Stock	242.58	243.635	242.53	243.55	1563532.0
2022-11-14 14:00:00	MSFT	Stock	243.54	243.91	242.6483	243.25	2134007.0
2022-11-14 15:00:00	MSFT	Stock	243.265	243.8	241.37	241.6	4338063.0
2022-11-14 16:00:00	MSFT	Stock	241.57	242.47	241.35	242.05	5546195.0
2022-11-14 17:00:00	MSFT	Stock	242.01	242.28	241.9	242.15	4690.0
2022-11-14 18:00:00	MSFT	Stock	242.25	242.35	242.05	242.27	7012.0
2022-11-14 19:00:00	MSFT	Stock	242.07	242.27	242.01	242.01	6081.0
2022-11-14 04:00:00	NVDA	Stock	16.224	16.235	16.137	16.145	187900.0
2022-11-14 05:00:00	NVDA	Stock	16.146	16.176	16.121	16.174	127780.0
2022-11-14 06:00:00	NVDA	Stock	16.16	16.209	16.131	16.208	142160.0
2022-11-14 07:00:00	NVDA	Stock	16.194	16.312	16.183	16.29	639860.0
2022-11-14 08:00:00	NVDA	Stock	16.18	16.318	16.18	16.232	1032690.0
2022-11-14 09:00:00	NVDA	Stock	16.233	16.439	15.922	16.0795	71116010.0
2022-11-14 10:00:00	NVDA	Stock	16.082	16.3925	16.081	16.304	87151060.0
2022-11-14 11:00:00	NVDA	Stock	16.304	16.489	16.164	16.3775	63831550.0
2022-11-14 12:00:00	NVDA	Stock	16.38	16.459	16.2839	16.364	40411750.0
2022-11-14 13:00:00	NVDA	Stock	16.3655	16.486	16.333	16.459	34492750.0
2022-11-14 14:00:00	NVDA	Stock	16.46	16.53	16.432	16.495	44626410.0
2022-11-14 15:00:00	NVDA	Stock	16.498	16.54	16.285	16.322	70441030.0
2022-11-14 16:00:00	NVDA	Stock	16.324	16.364	16.295	16.329	31124230.0
2022-11-14 17:00:00	NVDA	Stock	16.325	16.355	16.295	16.341	398480.0
2022-11-14 18:00:00	NVDA	Stock	16.349	16.352	16.307	16.319	222950.0
2022-11-14 19:00:00	NVDA	Stock	16.31	16.339	16.308	16.33	240530.0
2022-11-14 04:00:00	AMZN	Stock	100.79	100.79	99.51	99.72	30093.0
2022-11-14 05:00:00	AMZN	Stock	99.71	99.83	99.5	99.67	18841.0

> showing 50 of 62,405 rows — these rows as CSV

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