PREVIEW / stock_1hour / 2023-11-14

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-11-14.parquet
  size:    1.4 MB
  rows:    60,466
  symbols: 1,311

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-11-14 04:00:00	AAPL	Stock	184.99	185.47	184.99	185.15	5379.0
2023-11-14 05:00:00	AAPL	Stock	185.12	185.28	185.0	185.0	11766.0
2023-11-14 06:00:00	AAPL	Stock	185.05	185.07	185.0	185.05	1711.0
2023-11-14 07:00:00	AAPL	Stock	185.15	185.2	185.0	185.05	15675.0
2023-11-14 08:00:00	AAPL	Stock	185.06	188.1	184.97	187.8	437300.0
2023-11-14 09:00:00	AAPL	Stock	187.75	187.96	186.3	187.26	7962827.0
2023-11-14 10:00:00	AAPL	Stock	187.265	187.52	186.85	187.025	6013375.0
2023-11-14 11:00:00	AAPL	Stock	187.03	187.16	186.41	186.66	4036278.0
2023-11-14 12:00:00	AAPL	Stock	186.66	187.46	186.61	187.4301	3490983.0
2023-11-14 13:00:00	AAPL	Stock	187.44	187.5	187.11	187.1901	3394567.0
2023-11-14 14:00:00	AAPL	Stock	187.2	187.99	186.82	187.905	4747742.0
2023-11-14 15:00:00	AAPL	Stock	187.9	188.11	187.21	187.44	9126381.0
2023-11-14 16:00:00	AAPL	Stock	187.44	187.57	187.13	187.2	8287433.0
2023-11-14 17:00:00	AAPL	Stock	187.2	187.32	187.13	187.25	29765.0
2023-11-14 18:00:00	AAPL	Stock	187.24	187.4309	187.21	187.33	25596.0
2023-11-14 19:00:00	AAPL	Stock	187.31	187.4	187.18	187.3301	18485.0
2023-11-14 04:00:00	MSFT	Stock	368.24	368.3	367.82	367.82	6525.0
2023-11-14 05:00:00	MSFT	Stock	367.79	368.15	367.79	367.91	3597.0
2023-11-14 06:00:00	MSFT	Stock	367.68	367.72	367.3	367.3	7439.0
2023-11-14 07:00:00	MSFT	Stock	367.4	367.51	366.7	367.03	11298.0
2023-11-14 08:00:00	MSFT	Stock	367.45	373.0499	366.7	372.0	187004.0
2023-11-14 09:00:00	MSFT	Stock	371.88	372.6	369.32	370.9	2860002.0
2023-11-14 10:00:00	MSFT	Stock	370.92	371.95	370.31	370.75	2275253.0
2023-11-14 11:00:00	MSFT	Stock	370.74	371.6399	368.61	368.69	1624438.0
2023-11-14 12:00:00	MSFT	Stock	368.69	370.04	368.46	369.9	1638721.0
2023-11-14 13:00:00	MSFT	Stock	369.91	370.47	368.38	368.39	1515981.0
2023-11-14 14:00:00	MSFT	Stock	368.3999	370.36	367.3454	370.275	2043462.0
2023-11-14 15:00:00	MSFT	Stock	370.26	371.33	369.7	370.26	3698369.0
2023-11-14 16:00:00	MSFT	Stock	370.27	371.19	369.955	370.8	4014262.0
2023-11-14 17:00:00	MSFT	Stock	370.71	371.44	370.27	371.24	813291.0
2023-11-14 18:00:00	MSFT	Stock	371.24	371.2957	370.5	371.05	19360.0
2023-11-14 19:00:00	MSFT	Stock	371.05	371.14	370.55	371.12	6117.0
2023-11-14 04:00:00	NVDA	Stock	48.93	49.088	48.9	49.06	176460.0
2023-11-14 05:00:00	NVDA	Stock	49.042	49.042	48.865	48.96	96250.0
2023-11-14 06:00:00	NVDA	Stock	48.96	49.006	48.944	49.006	45340.0
2023-11-14 07:00:00	NVDA	Stock	49.0	49.004	48.87	48.99	504790.0
2023-11-14 08:00:00	NVDA	Stock	48.98	49.884	48.767	49.77	7992950.0
2023-11-14 09:00:00	NVDA	Stock	49.775	49.835	49.271	49.399	63293580.0
2023-11-14 10:00:00	NVDA	Stock	49.408	49.667	49.04	49.495	64588290.0
2023-11-14 11:00:00	NVDA	Stock	49.495	49.719	49.302	49.333	35211920.0
2023-11-14 12:00:00	NVDA	Stock	49.331	49.6741	49.288	49.645	30278090.0
2023-11-14 13:00:00	NVDA	Stock	49.643	49.695	49.426	49.4995	22899560.0
2023-11-14 14:00:00	NVDA	Stock	49.4995	49.7109	49.336	49.6646	28184550.0
2023-11-14 15:00:00	NVDA	Stock	49.661	49.834	49.593	49.654	45922090.0
2023-11-14 16:00:00	NVDA	Stock	49.657	49.82	49.65	49.7	18477410.0
2023-11-14 17:00:00	NVDA	Stock	49.695	49.8	49.695	49.79	357580.0
2023-11-14 18:00:00	NVDA	Stock	49.804	49.872	49.79	49.867	531830.0
2023-11-14 19:00:00	NVDA	Stock	49.864	49.865	49.802	49.84	374570.0
2023-11-14 04:00:00	AMZN	Stock	142.75	143.19	142.75	143.18	2741.0
2023-11-14 05:00:00	AMZN	Stock	143.22	143.36	143.15	143.3	9851.0

> showing 50 of 60,466 rows — these rows as CSV

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