PREVIEW / stock_1hour / 2023-12-11

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-12-11.parquet
  size:    1.3 MB
  rows:    59,849
  symbols: 1,295

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-12-11 04:00:00	AAPL	Stock	195.01	195.05	194.8	194.8	28690.0
2023-12-11 05:00:00	AAPL	Stock	194.83	194.85	194.61	194.64	24673.0
2023-12-11 06:00:00	AAPL	Stock	194.66	194.7	194.46	194.7	11720.0
2023-12-11 07:00:00	AAPL	Stock	194.75	195.5	194.74	194.95	73673.0
2023-12-11 08:00:00	AAPL	Stock	194.98	195.4763	194.48	194.91	191611.0
2023-12-11 09:00:00	AAPL	Stock	194.91	195.19	191.54	192.89	11196932.0
2023-12-11 10:00:00	AAPL	Stock	192.9	192.99	191.705	191.96	7380594.0
2023-12-11 11:00:00	AAPL	Stock	191.965	192.225	191.42	191.98	4798183.0
2023-12-11 12:00:00	AAPL	Stock	191.97	192.39	191.81	192.2142	2942576.0
2023-12-11 13:00:00	AAPL	Stock	192.22	192.81	192.15	192.785	3314705.0
2023-12-11 14:00:00	AAPL	Stock	192.788	193.005	192.68	192.895	3215078.0
2023-12-11 15:00:00	AAPL	Stock	192.9	193.31	192.75	193.19	6434987.0
2023-12-11 16:00:00	AAPL	Stock	193.2	193.26	193.18	193.2259	8558952.0
2023-12-11 17:00:00	AAPL	Stock	193.22	193.23	193.0997	193.1	27584.0
2023-12-11 18:00:00	AAPL	Stock	193.09	193.18	193.01	193.18	10145.0
2023-12-11 19:00:00	AAPL	Stock	193.18	193.52	193.18	193.42	25460.0
2023-12-11 04:00:00	MSFT	Stock	373.51	373.89	373.09	373.09	6228.0
2023-12-11 05:00:00	MSFT	Stock	373.2	373.2	372.6	372.71	7754.0
2023-12-11 06:00:00	MSFT	Stock	372.63	372.69	372.5	372.68	900.0
2023-12-11 07:00:00	MSFT	Stock	372.68	373.11	371.97	371.97	21846.0
2023-12-11 08:00:00	MSFT	Stock	372.99	373.22	370.61	370.7	84930.0
2023-12-11 09:00:00	MSFT	Stock	370.7	370.7	366.1	368.7138	5002808.0
2023-12-11 10:00:00	MSFT	Stock	368.72	370.56	368.06	369.8	2835795.0
2023-12-11 11:00:00	MSFT	Stock	369.8	370.28	367.82	368.54	1612880.0
2023-12-11 12:00:00	MSFT	Stock	368.52	369.08	368.03	369.05	1142808.0
2023-12-11 13:00:00	MSFT	Stock	369.02	370.15	368.92	369.44	1330901.0
2023-12-11 14:00:00	MSFT	Stock	369.44	370.4	369.32	369.77	1164433.0
2023-12-11 15:00:00	MSFT	Stock	369.765	371.6	369.7	371.3	2501195.0
2023-12-11 16:00:00	MSFT	Stock	371.3	371.73	370.31	371.3	4311225.0
2023-12-11 17:00:00	MSFT	Stock	370.77	370.85	370.5271	370.7411	10298.0
2023-12-11 18:00:00	MSFT	Stock	370.75	370.75	370.3	370.4	4339.0
2023-12-11 19:00:00	MSFT	Stock	370.8	371.88	370.8	371.65	10698.0
2023-12-11 04:00:00	NVDA	Stock	47.47	47.57	47.437	47.45	54060.0
2023-12-11 05:00:00	NVDA	Stock	47.455	47.461	47.313	47.317	95380.0
2023-12-11 06:00:00	NVDA	Stock	47.31	47.31	47.199	47.291	101770.0
2023-12-11 07:00:00	NVDA	Stock	47.32	47.615	47.32	47.531	439920.0
2023-12-11 08:00:00	NVDA	Stock	47.527	47.822	47.25	47.721	1324610.0
2023-12-11 09:00:00	NVDA	Stock	47.723	47.774	46.624	46.89	56491750.0
2023-12-11 10:00:00	NVDA	Stock	46.899	46.921	46.181	46.3045	77011210.0
2023-12-11 11:00:00	NVDA	Stock	46.3066	46.37	45.83	45.928	59035500.0
2023-12-11 12:00:00	NVDA	Stock	45.936	46.371	45.88	46.2236	35545670.0
2023-12-11 13:00:00	NVDA	Stock	46.22	46.898	46.195	46.75	45724140.0
2023-12-11 14:00:00	NVDA	Stock	46.75	46.959	46.571	46.7009	37527890.0
2023-12-11 15:00:00	NVDA	Stock	46.705	46.74	46.49	46.638	40944890.0
2023-12-11 16:00:00	NVDA	Stock	46.637	46.7107	46.546	46.595	26802640.0
2023-12-11 17:00:00	NVDA	Stock	46.582	46.598	46.44	46.539	391360.0
2023-12-11 18:00:00	NVDA	Stock	46.523	46.526	46.4	46.486	228040.0
2023-12-11 19:00:00	NVDA	Stock	46.4858	46.593	46.468	46.571	386390.0
2023-12-11 04:00:00	AMZN	Stock	146.56	146.77	146.5	146.5	9051.0
2023-12-11 05:00:00	AMZN	Stock	146.36	146.38	146.1	146.11	12372.0

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

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