PREVIEW / stock_1hour / 2023-10-16

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-10-16.parquet
  size:    1.3 MB
  rows:    59,182
  symbols: 1,341

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-10-16 04:00:00	AAPL	Stock	178.54	178.84	178.2	178.78	19662.0
2023-10-16 05:00:00	AAPL	Stock	178.65	178.67	178.44	178.46	10541.0
2023-10-16 06:00:00	AAPL	Stock	178.43	178.43	175.84	177.1	106154.0
2023-10-16 07:00:00	AAPL	Stock	177.14	177.85	176.85	177.45	98859.0
2023-10-16 08:00:00	AAPL	Stock	177.29	179.02	176.8504	178.15	171383.0
2023-10-16 09:00:00	AAPL	Stock	178.14	178.36	176.33	177.8	7655272.0
2023-10-16 10:00:00	AAPL	Stock	177.81	178.85	177.34	178.82	6216229.0
2023-10-16 11:00:00	AAPL	Stock	178.82	179.075	178.03	178.0301	4277244.0
2023-10-16 12:00:00	AAPL	Stock	178.035	178.06	177.28	177.55	4374257.0
2023-10-16 13:00:00	AAPL	Stock	177.5494	178.22	176.85	178.15	4739186.0
2023-10-16 14:00:00	AAPL	Stock	178.15	178.55	177.82	178.5273	3705334.0
2023-10-16 15:00:00	AAPL	Stock	178.53	179.0	178.24	178.675	7998704.0
2023-10-16 16:00:00	AAPL	Stock	178.67	178.82	178.51	178.73	4950857.0
2023-10-16 17:00:00	AAPL	Stock	178.7	178.79	178.66	178.6756	14131.0
2023-10-16 18:00:00	AAPL	Stock	178.72	178.72	178.6	178.6	9073.0
2023-10-16 19:00:00	AAPL	Stock	178.6	178.7	178.51	178.7	27426.0
2023-10-16 04:00:00	MSFT	Stock	327.0	329.25	326.97	328.98	13242.0
2023-10-16 05:00:00	MSFT	Stock	328.89	328.89	328.24	328.24	2845.0
2023-10-16 06:00:00	MSFT	Stock	328.02	329.98	327.56	329.84	8697.0
2023-10-16 07:00:00	MSFT	Stock	329.85	330.49	329.5	330.22	21226.0
2023-10-16 08:00:00	MSFT	Stock	329.75	330.5	327.71	330.32	26527.0
2023-10-16 09:00:00	MSFT	Stock	330.45	333.39	330.12	332.5	2673750.0
2023-10-16 10:00:00	MSFT	Stock	332.48	336.14	331.96	334.82	3101644.0
2023-10-16 11:00:00	MSFT	Stock	334.86	335.35	333.61	333.6467	1447271.0
2023-10-16 12:00:00	MSFT	Stock	333.67	334.1	333.15	333.76	840985.0
2023-10-16 13:00:00	MSFT	Stock	333.77	334.701	332.27	333.921	1218380.0
2023-10-16 14:00:00	MSFT	Stock	333.95	334.23	333.35	334.07	818315.0
2023-10-16 15:00:00	MSFT	Stock	334.08	334.505	332.22	332.62	2942049.0
2023-10-16 16:00:00	MSFT	Stock	332.62	333.31	332.1	333.15	3658898.0
2023-10-16 17:00:00	MSFT	Stock	332.96	333.05	332.76	333.0	3721.0
2023-10-16 18:00:00	MSFT	Stock	333.0048	333.15	332.79	332.79	6870.0
2023-10-16 19:00:00	MSFT	Stock	332.9	332.9	332.42	332.77	10428.0
2023-10-16 04:00:00	NVDA	Stock	45.216	45.279	44.784	44.92	281370.0
2023-10-16 05:00:00	NVDA	Stock	44.935	44.98	44.877	44.98	83800.0
2023-10-16 06:00:00	NVDA	Stock	44.921	45.01	44.888	45.0	140390.0
2023-10-16 07:00:00	NVDA	Stock	45.0	45.08	44.723	45.08	956480.0
2023-10-16 08:00:00	NVDA	Stock	44.923	45.4	44.7103	45.12	2056580.0
2023-10-16 09:00:00	NVDA	Stock	45.145	45.86	44.912	45.55	53423400.0
2023-10-16 10:00:00	NVDA	Stock	45.5565	46.1251	45.495	45.9632	63865340.0
2023-10-16 11:00:00	NVDA	Stock	45.966	46.225	45.8209	45.823	38581830.0
2023-10-16 12:00:00	NVDA	Stock	45.832	45.957	45.7311	45.889	25519850.0
2023-10-16 13:00:00	NVDA	Stock	45.891	46.059	45.508	45.848	32228480.0
2023-10-16 14:00:00	NVDA	Stock	45.852	46.0089	45.74	46.005	22155130.0
2023-10-16 15:00:00	NVDA	Stock	46.0055	46.208	45.933	46.088	36196450.0
2023-10-16 16:00:00	NVDA	Stock	46.079	46.12	46.05	46.105	18306050.0
2023-10-16 17:00:00	NVDA	Stock	46.104	46.15	46.095	46.106	169430.0
2023-10-16 18:00:00	NVDA	Stock	46.106	46.106	46.04	46.04	126010.0
2023-10-16 19:00:00	NVDA	Stock	46.055	46.15	46.045	46.15	257350.0
2023-10-16 04:00:00	AMZN	Stock	129.6	130.0	129.32	130.0	9305.0
2023-10-16 05:00:00	AMZN	Stock	129.89	130.0	129.85	129.96	6450.0

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

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