PREVIEW / stock_1hour / 2024-02-01

all stock 1-hour files

  file:    by_date/stock_1hour/2024/2024-02-01.parquet
  size:    1.3 MB
  rows:    58,886
  symbols: 1,156

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
2024-02-01 04:00:00	AAPL	Stock	185.49	185.9	185.45	185.51	9950.0
2024-02-01 05:00:00	AAPL	Stock	185.4	185.69	185.36	185.69	21523.0
2024-02-01 06:00:00	AAPL	Stock	185.65	185.88	185.06	185.6	24379.0
2024-02-01 07:00:00	AAPL	Stock	185.64	185.82	185.44	185.7	31699.0
2024-02-01 08:00:00	AAPL	Stock	185.7	186.0786	185.24	185.3096	185883.0
2024-02-01 09:00:00	AAPL	Stock	185.25	185.64	183.81	185.5	5624546.0
2024-02-01 10:00:00	AAPL	Stock	185.46	186.31	184.9	185.3706	5616762.0
2024-02-01 11:00:00	AAPL	Stock	185.37	186.07	185.29	185.682	3847848.0
2024-02-01 12:00:00	AAPL	Stock	185.68	186.44	185.64	186.12	4076951.0
2024-02-01 13:00:00	AAPL	Stock	186.13	186.19	185.26	185.795	3281344.0
2024-02-01 14:00:00	AAPL	Stock	185.8	186.62	185.55	186.475	4024839.0
2024-02-01 15:00:00	AAPL	Stock	186.47	186.95	186.28	186.89	8470679.0
2024-02-01 16:00:00	AAPL	Stock	186.89	191.81	181.5	184.66	10183025.0
2024-02-01 17:00:00	AAPL	Stock	184.71	185.75	179.1	180.61	3608726.0
2024-02-01 18:00:00	AAPL	Stock	180.61	181.37	180.28	180.95	577640.0
2024-02-01 19:00:00	AAPL	Stock	180.86	181.58	180.79	181.4	312880.0
2024-02-01 04:00:00	MSFT	Stock	400.15	400.95	399.45	400.47	12903.0
2024-02-01 05:00:00	MSFT	Stock	400.56	401.85	400.56	401.28	15548.0
2024-02-01 06:00:00	MSFT	Stock	401.28	402.59	401.2	401.4	36821.0
2024-02-01 07:00:00	MSFT	Stock	401.54	402.0	400.5	401.25	35158.0
2024-02-01 08:00:00	MSFT	Stock	400.9	402.0	398.81	401.59	160748.0
2024-02-01 09:00:00	MSFT	Stock	401.71	406.2899	400.85	406.0	4826083.0
2024-02-01 10:00:00	MSFT	Stock	405.96	408.0	403.36	403.6801	4296026.0
2024-02-01 11:00:00	MSFT	Stock	403.7	404.42	402.55	403.76	2048185.0
2024-02-01 12:00:00	MSFT	Stock	403.83	405.11	402.68	404.0	1910947.0
2024-02-01 13:00:00	MSFT	Stock	404.0	404.67	402.98	403.67	1158366.0
2024-02-01 14:00:00	MSFT	Stock	403.7	405.11	403.68	404.602	1295763.0
2024-02-01 15:00:00	MSFT	Stock	404.61	404.8	402.94	403.8	2608849.0
2024-02-01 16:00:00	MSFT	Stock	403.78	406.85	402.66	406.5	3288543.0
2024-02-01 17:00:00	MSFT	Stock	406.462	407.8	406.45	406.75	85451.0
2024-02-01 18:00:00	MSFT	Stock	406.75	407.2	406.5	407.05	40339.0
2024-02-01 19:00:00	MSFT	Stock	407.1499	407.1499	406.5	406.9	30049.0
2024-02-01 04:00:00	NVDA	Stock	62.2	62.2	61.939	62.041	96290.0
2024-02-01 05:00:00	NVDA	Stock	62.04	62.299	62.04	62.299	65310.0
2024-02-01 06:00:00	NVDA	Stock	62.3	62.349	62.155	62.166	77070.0
2024-02-01 07:00:00	NVDA	Stock	62.2	62.3	62.11	62.24	620030.0
2024-02-01 08:00:00	NVDA	Stock	62.2	62.3	61.824	62.1968	2008340.0
2024-02-01 09:00:00	NVDA	Stock	62.181	62.239	61.7387	61.8688	42631100.0
2024-02-01 10:00:00	NVDA	Stock	61.883	62.482	61.65	61.9785	57935000.0
2024-02-01 11:00:00	NVDA	Stock	61.9788	62.229	61.757	62.151	32701010.0
2024-02-01 12:00:00	NVDA	Stock	62.1512	62.68	62.135	62.5458	34217270.0
2024-02-01 13:00:00	NVDA	Stock	62.541	62.84	62.361	62.7605	26466000.0
2024-02-01 14:00:00	NVDA	Stock	62.768	62.997	62.715	62.947	26706140.0
2024-02-01 15:00:00	NVDA	Stock	62.949	63.191	62.868	63.035	39909460.0
2024-02-01 16:00:00	NVDA	Stock	63.027	64.035	62.95	63.856	17998080.0
2024-02-01 17:00:00	NVDA	Stock	63.84	64.112	63.675	63.9068	1759440.0
2024-02-01 18:00:00	NVDA	Stock	63.926	64.045	63.825	64.029	692260.0
2024-02-01 19:00:00	NVDA	Stock	64.029	64.135	64.014	64.09	836150.0
2024-02-01 04:00:00	AMZN	Stock	156.99	157.02	156.28	156.6	11831.0
2024-02-01 05:00:00	AMZN	Stock	156.67	156.96	156.54	156.8	6455.0

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

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