PREVIEW / stock_1hour / 2024-05-09

all stock 1-hour files

  file:    by_date/stock_1hour/2024/2024-05-09.parquet
  size:    1.3 MB
  rows:    58,141
  symbols: 957

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-05-09 04:00:00	AAPL	Stock	182.75	182.75	182.13	182.2	3703.0
2024-05-09 05:00:00	AAPL	Stock	182.18	182.24	182.12	182.17	2602.0
2024-05-09 06:00:00	AAPL	Stock	182.3	182.55	182.3	182.35	7612.0
2024-05-09 07:00:00	AAPL	Stock	182.4	182.46	182.25	182.42	10029.0
2024-05-09 08:00:00	AAPL	Stock	182.41	182.8599	182.25	182.56	64643.0
2024-05-09 09:00:00	AAPL	Stock	182.55	183.8299	182.11	183.75	5133731.0
2024-05-09 10:00:00	AAPL	Stock	183.75	183.86	183.11	183.2999	5705218.0
2024-05-09 11:00:00	AAPL	Stock	183.3	183.845	183.24	183.541	3713973.0
2024-05-09 12:00:00	AAPL	Stock	183.55	184.05	183.435	184.02	3423766.0
2024-05-09 13:00:00	AAPL	Stock	184.02	184.65	183.89	184.48	5306966.0
2024-05-09 14:00:00	AAPL	Stock	184.48	184.615	184.06	184.52	3564300.0
2024-05-09 15:00:00	AAPL	Stock	184.52	184.66	184.22	184.65	6464383.0
2024-05-09 16:00:00	AAPL	Stock	184.57	184.78	184.47	184.66	6004743.0
2024-05-09 17:00:00	AAPL	Stock	184.651	185.0	184.57	184.66	65793.0
2024-05-09 18:00:00	AAPL	Stock	184.57	184.85	184.57	184.8	13231.0
2024-05-09 19:00:00	AAPL	Stock	184.75	184.86	184.7	184.79	30689.0
2024-05-09 04:00:00	MSFT	Stock	409.61	410.0	409.4	409.84	512.0
2024-05-09 05:00:00	MSFT	Stock	409.64	409.7	409.64	409.7	200.0
2024-05-09 06:00:00	MSFT	Stock	409.85	410.51	409.85	410.42	987.0
2024-05-09 07:00:00	MSFT	Stock	410.0	410.1	409.05	409.61	1163.0
2024-05-09 08:00:00	MSFT	Stock	409.8543	410.988	409.513	410.8	16762.0
2024-05-09 09:00:00	MSFT	Stock	410.7	411.33	409.1	410.41	770495.0
2024-05-09 10:00:00	MSFT	Stock	410.415	412.23	409.5501	412.18	894138.0
2024-05-09 11:00:00	MSFT	Stock	412.18	412.72	411.13	411.29	649232.0
2024-05-09 12:00:00	MSFT	Stock	411.23	411.63	410.7001	411.56	489554.0
2024-05-09 13:00:00	MSFT	Stock	411.564	412.13	411.24	411.68	535375.0
2024-05-09 14:00:00	MSFT	Stock	411.67	412.52	411.3	412.4	500700.0
2024-05-09 15:00:00	MSFT	Stock	412.39	412.6	412.0	412.29	1355201.0
2024-05-09 16:00:00	MSFT	Stock	412.32	413.1	412.32	412.68	2216219.0
2024-05-09 17:00:00	MSFT	Stock	412.53	412.7	412.32	412.68	3840.0
2024-05-09 18:00:00	MSFT	Stock	412.32	412.88	412.32	412.7419	4153.0
2024-05-09 19:00:00	MSFT	Stock	412.74	412.99	412.74	412.99	10026.0
2024-05-09 04:00:00	NVDA	Stock	89.795	90.045	89.791	89.911	69030.0
2024-05-09 05:00:00	NVDA	Stock	89.911	89.911	89.703	89.868	35070.0
2024-05-09 06:00:00	NVDA	Stock	89.949	89.975	89.875	89.946	23260.0
2024-05-09 07:00:00	NVDA	Stock	89.916	90.13	89.751	90.075	283900.0
2024-05-09 08:00:00	NVDA	Stock	89.82	90.648	89.7518	90.584	1945460.0
2024-05-09 09:00:00	NVDA	Stock	90.567	91.072	88.353	89.1	56569810.0
2024-05-09 10:00:00	NVDA	Stock	89.0765	89.4	88.231	89.0755	58022640.0
2024-05-09 11:00:00	NVDA	Stock	89.0625	89.699	88.686	88.8015	38449930.0
2024-05-09 12:00:00	NVDA	Stock	88.8	89.4418	88.68	89.337	26026890.0
2024-05-09 13:00:00	NVDA	Stock	89.337	89.496	88.752	88.9125	25163900.0
2024-05-09 14:00:00	NVDA	Stock	88.9155	89.13	88.717	88.9798	21079180.0
2024-05-09 15:00:00	NVDA	Stock	89.0	89.24	88.45	88.731	38686060.0
2024-05-09 16:00:00	NVDA	Stock	88.747	88.788	88.6	88.625	12226060.0
2024-05-09 17:00:00	NVDA	Stock	88.63	88.875	88.625	88.844	309140.0
2024-05-09 18:00:00	NVDA	Stock	88.844	88.99	88.747	88.871	346050.0
2024-05-09 19:00:00	NVDA	Stock	88.883	88.911	88.81	88.866	453620.0
2024-05-09 04:00:00	AMZN	Stock	187.25	187.44	187.21	187.4	3345.0
2024-05-09 05:00:00	AMZN	Stock	187.39	187.53	187.3	187.53	2678.0

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

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