PREVIEW / stock_1hour / 2023-10-26

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-10-26.parquet
  size:    1.3 MB
  rows:    57,868
  symbols: 1,340

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-26 04:00:00	AAPL	Stock	169.2	169.51	168.7	169.0	35578.0
2023-10-26 05:00:00	AAPL	Stock	168.99	169.5	168.95	169.24	12801.0
2023-10-26 06:00:00	AAPL	Stock	169.33	169.8	169.25	169.51	35151.0
2023-10-26 07:00:00	AAPL	Stock	169.38	169.61	169.1	169.6	43200.0
2023-10-26 08:00:00	AAPL	Stock	169.5387	171.1	168.16	170.6	382831.0
2023-10-26 09:00:00	AAPL	Stock	170.66	171.3775	169.375	169.81	6172164.0
2023-10-26 10:00:00	AAPL	Stock	169.78	170.03	167.89	168.315	9370787.0
2023-10-26 11:00:00	AAPL	Stock	168.31	168.415	166.52	167.2682	7883704.0
2023-10-26 12:00:00	AAPL	Stock	167.26	167.32	165.95	166.075	6075091.0
2023-10-26 13:00:00	AAPL	Stock	166.075	166.885	165.67	166.77	5245029.0
2023-10-26 14:00:00	AAPL	Stock	166.77	167.71	166.68	167.685	5621430.0
2023-10-26 15:00:00	AAPL	Stock	167.68	167.94	166.375	166.76	9631782.0
2023-10-26 16:00:00	AAPL	Stock	166.89	167.07	166.52	166.69	8198100.0
2023-10-26 17:00:00	AAPL	Stock	166.68	166.69	165.3	166.24	355781.0
2023-10-26 18:00:00	AAPL	Stock	166.32	166.89	166.3	166.46	167872.0
2023-10-26 19:00:00	AAPL	Stock	166.41	167.25	166.4	167.25	93218.0
2023-10-26 04:00:00	MSFT	Stock	336.47	337.64	336.47	337.1	16679.0
2023-10-26 05:00:00	MSFT	Stock	337.5	337.83	337.0	337.5	2943.0
2023-10-26 06:00:00	MSFT	Stock	337.69	338.4	337.69	338.01	4998.0
2023-10-26 07:00:00	MSFT	Stock	337.87	338.0	337.0	338.0	14690.0
2023-10-26 08:00:00	MSFT	Stock	340.67	340.8	334.73	340.54	235543.0
2023-10-26 09:00:00	MSFT	Stock	340.48	342.0	334.68	335.38	3994948.0
2023-10-26 10:00:00	MSFT	Stock	335.27	335.88	332.13	334.08	4573378.0
2023-10-26 11:00:00	MSFT	Stock	334.0417	334.096	329.6	330.71	3246899.0
2023-10-26 12:00:00	MSFT	Stock	330.72	330.78	326.94	327.95	3421133.0
2023-10-26 13:00:00	MSFT	Stock	327.98	329.51	327.33	328.9299	2086001.0
2023-10-26 14:00:00	MSFT	Stock	328.89	331.48	328.37	331.46	2447861.0
2023-10-26 15:00:00	MSFT	Stock	331.46	331.5	327.3256	327.84	3889835.0
2023-10-26 16:00:00	MSFT	Stock	327.89	329.48	327.1201	328.19	4780983.0
2023-10-26 17:00:00	MSFT	Stock	328.3	329.8	326.84	329.04	93147.0
2023-10-26 18:00:00	MSFT	Stock	329.63	331.94	328.99	331.17	100562.0
2023-10-26 19:00:00	MSFT	Stock	331.04	331.89	331.01	331.7087	35222.0
2023-10-26 04:00:00	NVDA	Stock	40.793	41.14	40.793	41.022	203410.0
2023-10-26 05:00:00	NVDA	Stock	41.06	41.199	40.936	41.1	146400.0
2023-10-26 06:00:00	NVDA	Stock	41.085	41.161	41.069	41.112	107970.0
2023-10-26 07:00:00	NVDA	Stock	41.111	41.145	40.751	40.922	1131450.0
2023-10-26 08:00:00	NVDA	Stock	41.045	41.779	40.618	41.444	4059730.0
2023-10-26 09:00:00	NVDA	Stock	41.449	42.2556	41.0128	41.189	56598800.0
2023-10-26 10:00:00	NVDA	Stock	41.19	41.3286	40.675	41.1334	72891140.0
2023-10-26 11:00:00	NVDA	Stock	41.1415	41.153	40.25	40.612	60664910.0
2023-10-26 12:00:00	NVDA	Stock	40.62	40.668	40.002	40.057	45471690.0
2023-10-26 13:00:00	NVDA	Stock	40.065	40.44	39.8802	40.429	55508650.0
2023-10-26 14:00:00	NVDA	Stock	40.436	40.918	40.281	40.915	43559250.0
2023-10-26 15:00:00	NVDA	Stock	40.9125	40.985	40.242	40.2745	51500210.0
2023-10-26 16:00:00	NVDA	Stock	40.265	40.601	40.15	40.15	18427560.0
2023-10-26 17:00:00	NVDA	Stock	40.15	40.42	39.951	40.412	1515600.0
2023-10-26 18:00:00	NVDA	Stock	40.418	40.78	40.4	40.711	1513350.0
2023-10-26 19:00:00	NVDA	Stock	40.702	41.0	40.7	40.91	1130640.0
2023-10-26 04:00:00	AMZN	Stock	118.8	119.96	118.5	119.6	47660.0
2023-10-26 05:00:00	AMZN	Stock	119.6	120.0	119.55	119.63	18188.0

> showing 50 of 57,868 rows — these rows as CSV

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