PREVIEW / stock_1hour / 2023-09-14

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-09-14.parquet
  size:    1.3 MB
  rows:    58,667
  symbols: 1,424

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-14 04:00:00	AAPL	Stock	174.58	174.9	174.22	174.7	19423.0
2023-09-14 05:00:00	AAPL	Stock	174.7	174.85	174.65	174.72	6625.0
2023-09-14 06:00:00	AAPL	Stock	174.74	175.19	174.72	175.0	20754.0
2023-09-14 07:00:00	AAPL	Stock	174.97	175.02	174.4	174.55	184378.0
2023-09-14 08:00:00	AAPL	Stock	174.88	175.14	174.1	174.44	469785.0
2023-09-14 09:00:00	AAPL	Stock	174.41	175.63	173.58	175.37	8514613.0
2023-09-14 10:00:00	AAPL	Stock	175.4	175.57	174.31	175.22	8136020.0
2023-09-14 11:00:00	AAPL	Stock	175.225	175.76	174.83	175.5	5206859.0
2023-09-14 12:00:00	AAPL	Stock	175.5	176.0	175.02	175.87	4958346.0
2023-09-14 13:00:00	AAPL	Stock	175.8759	176.04	175.46	175.745	3713130.0
2023-09-14 14:00:00	AAPL	Stock	175.74	175.9	175.3	175.725	4053702.0
2023-09-14 15:00:00	AAPL	Stock	175.73	176.1	175.56	175.73	6961483.0
2023-09-14 16:00:00	AAPL	Stock	175.72	175.88	175.54	175.61	6934534.0
2023-09-14 17:00:00	AAPL	Stock	175.66	175.7125	175.47	175.65	66016.0
2023-09-14 18:00:00	AAPL	Stock	175.65	175.81	175.61	175.8	39046.0
2023-09-14 19:00:00	AAPL	Stock	175.77	175.93	175.7	175.86	25261.0
2023-09-14 04:00:00	MSFT	Stock	336.92	336.92	336.41	336.41	3345.0
2023-09-14 05:00:00	MSFT	Stock	336.62	336.79	336.62	336.79	350.0
2023-09-14 06:00:00	MSFT	Stock	336.58	337.9	336.58	337.76	5118.0
2023-09-14 07:00:00	MSFT	Stock	337.65	338.51	337.5	338.28	26694.0
2023-09-14 08:00:00	MSFT	Stock	338.1908	338.55	336.75	338.15	85810.0
2023-09-14 09:00:00	MSFT	Stock	337.75	340.4699	336.57	337.74	2337412.0
2023-09-14 10:00:00	MSFT	Stock	337.755	340.03	336.62	339.84	1652863.0
2023-09-14 11:00:00	MSFT	Stock	339.86	340.86	338.395	340.19	1671944.0
2023-09-14 12:00:00	MSFT	Stock	340.2046	340.71	339.428	340.15	1127847.0
2023-09-14 13:00:00	MSFT	Stock	340.16	340.16	339.2	339.2	672866.0
2023-09-14 14:00:00	MSFT	Stock	339.185	339.185	338.38	338.84	794878.0
2023-09-14 15:00:00	MSFT	Stock	338.84	339.78	338.18	338.68	2285399.0
2023-09-14 16:00:00	MSFT	Stock	338.67	340.25	338.67	339.63	3513944.0
2023-09-14 17:00:00	MSFT	Stock	339.61	339.76	339.22	339.53	16922.0
2023-09-14 18:00:00	MSFT	Stock	339.4	339.7	339.33	339.7	2527.0
2023-09-14 19:00:00	MSFT	Stock	339.7	340.3	339.7	340.2	18666.0
2023-09-14 04:00:00	NVDA	Stock	45.862	45.95	45.762	45.899	104790.0
2023-09-14 05:00:00	NVDA	Stock	45.9	45.97	45.888	45.925	26760.0
2023-09-14 06:00:00	NVDA	Stock	45.947	46.017	45.947	45.958	66880.0
2023-09-14 07:00:00	NVDA	Stock	45.97	46.089	45.961	46.01	657790.0
2023-09-14 08:00:00	NVDA	Stock	45.9745	46.15	45.772	45.872	2475010.0
2023-09-14 09:00:00	NVDA	Stock	45.9	45.987	45.38	45.684	47472400.0
2023-09-14 10:00:00	NVDA	Stock	45.688	45.8391	45.309	45.6612	50843560.0
2023-09-14 11:00:00	NVDA	Stock	45.661	45.889	45.552	45.7	29593420.0
2023-09-14 12:00:00	NVDA	Stock	45.704	45.812	45.41	45.5585	29987000.0
2023-09-14 13:00:00	NVDA	Stock	45.55	45.5862	45.212	45.218	24159910.0
2023-09-14 14:00:00	NVDA	Stock	45.212	45.453	45.131	45.429	30063120.0
2023-09-14 15:00:00	NVDA	Stock	45.428	45.662	45.3722	45.592	45639600.0
2023-09-14 16:00:00	NVDA	Stock	45.581	45.614	45.477	45.545	12603510.0
2023-09-14 17:00:00	NVDA	Stock	45.529	45.5588	45.505	45.5399	170930.0
2023-09-14 18:00:00	NVDA	Stock	45.5382	45.59	45.5073	45.551	237400.0
2023-09-14 19:00:00	NVDA	Stock	45.551	45.6	45.528	45.59	324270.0
2023-09-14 04:00:00	AMZN	Stock	145.6	145.84	145.37	145.78	20051.0
2023-09-14 05:00:00	AMZN	Stock	145.65	145.8	145.65	145.7	9827.0

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

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