PREVIEW / stock_1hour / 2023-09-18

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-09-18.parquet
  size:    1.3 MB
  rows:    58,981
  symbols: 1,438

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-09-18 04:00:00	AAPL	Stock	175.9	175.9	175.55	175.75	56904.0
2023-09-18 05:00:00	AAPL	Stock	175.73	175.9	175.67	175.84	22084.0
2023-09-18 06:00:00	AAPL	Stock	175.82	175.96	175.63	175.77	97038.0
2023-09-18 07:00:00	AAPL	Stock	175.84	175.84	174.6	174.72	161821.0
2023-09-18 08:00:00	AAPL	Stock	175.65	176.07	174.6	175.8394	478094.0
2023-09-18 09:00:00	AAPL	Stock	175.82	178.98	175.7465	177.05	13661635.0
2023-09-18 10:00:00	AAPL	Stock	177.025	177.62	176.44	177.135	8561793.0
2023-09-18 11:00:00	AAPL	Stock	177.135	178.31	177.0899	178.265	5834855.0
2023-09-18 12:00:00	AAPL	Stock	178.265	179.18	178.11	178.8601	5412836.0
2023-09-18 13:00:00	AAPL	Stock	178.88	179.38	178.7301	179.005	4724474.0
2023-09-18 14:00:00	AAPL	Stock	179.01	179.22	178.4246	178.61	3603120.0
2023-09-18 15:00:00	AAPL	Stock	178.6	178.76	177.775	177.98	7557131.0
2023-09-18 16:00:00	AAPL	Stock	177.97	178.02	177.82	177.9	5537925.0
2023-09-18 17:00:00	AAPL	Stock	177.9	177.98	177.85	177.95	84190.0
2023-09-18 18:00:00	AAPL	Stock	177.98	178.6	177.95	178.4	74031.0
2023-09-18 19:00:00	AAPL	Stock	178.36	178.5	178.21	178.5	53111.0
2023-09-18 04:00:00	MSFT	Stock	330.5	331.29	330.5	330.8	3572.0
2023-09-18 05:00:00	MSFT	Stock	330.95	330.95	330.5	330.5	657.0
2023-09-18 06:00:00	MSFT	Stock	330.22	330.56	330.22	330.56	2902.0
2023-09-18 07:00:00	MSFT	Stock	330.64	330.67	328.71	328.71	12035.0
2023-09-18 08:00:00	MSFT	Stock	330.49	331.0	328.6	329.0	44621.0
2023-09-18 09:00:00	MSFT	Stock	329.0	330.315	326.85	329.19	2084105.0
2023-09-18 10:00:00	MSFT	Stock	329.14	329.8	328.06	328.78	1408139.0
2023-09-18 11:00:00	MSFT	Stock	328.77	330.4	328.372	329.925	1087008.0
2023-09-18 12:00:00	MSFT	Stock	329.98	330.08	328.65	328.67	771116.0
2023-09-18 13:00:00	MSFT	Stock	328.7	329.05	327.34	328.0903	881112.0
2023-09-18 14:00:00	MSFT	Stock	328.15	328.64	326.36	326.82	866693.0
2023-09-18 15:00:00	MSFT	Stock	326.81	329.32	326.5799	329.1	1849131.0
2023-09-18 16:00:00	MSFT	Stock	329.06	329.79	328.4	329.05	2857675.0
2023-09-18 17:00:00	MSFT	Stock	329.04	329.06	328.13	328.85	15030.0
2023-09-18 18:00:00	MSFT	Stock	329.37	329.4	329.2	329.3999	2273.0
2023-09-18 19:00:00	MSFT	Stock	329.25	329.29	329.07	329.29	2364.0
2023-09-18 04:00:00	NVDA	Stock	43.862	43.96	43.751	43.82	127330.0
2023-09-18 05:00:00	NVDA	Stock	43.843	43.843	43.79	43.819	33130.0
2023-09-18 06:00:00	NVDA	Stock	43.81	43.812	43.388	43.485	261630.0
2023-09-18 07:00:00	NVDA	Stock	43.486	43.6	42.985	43.0	1758070.0
2023-09-18 08:00:00	NVDA	Stock	43.5	43.978	42.897	42.93	3791920.0
2023-09-18 09:00:00	NVDA	Stock	42.92	43.56	42.0	43.319	98117310.0
2023-09-18 10:00:00	NVDA	Stock	43.317	43.865	43.182	43.8365	75435380.0
2023-09-18 11:00:00	NVDA	Stock	43.836	43.952	43.508	43.856	49629200.0
2023-09-18 12:00:00	NVDA	Stock	43.85	44.242	43.752	43.9259	39561060.0
2023-09-18 13:00:00	NVDA	Stock	43.926	44.155	43.781	44.0495	34403740.0
2023-09-18 14:00:00	NVDA	Stock	44.0475	44.2	43.732	43.791	31000940.0
2023-09-18 15:00:00	NVDA	Stock	43.785	43.975	43.688	43.965	45754500.0
2023-09-18 16:00:00	NVDA	Stock	43.957	43.999	43.922	43.925	8783740.0
2023-09-18 17:00:00	NVDA	Stock	43.926	43.95	43.9005	43.949	243010.0
2023-09-18 18:00:00	NVDA	Stock	43.941	43.995	43.935	43.993	165730.0
2023-09-18 19:00:00	NVDA	Stock	43.994	44.008	43.98	44.0	431030.0
2023-09-18 04:00:00	AMZN	Stock	140.68	141.01	140.68	140.8	8713.0
2023-09-18 05:00:00	AMZN	Stock	140.82	140.86	140.77	140.77	6658.0

> showing 50 of 58,981 rows — these rows as CSV

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