PREVIEW / stock_1hour / 2023-02-14

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-02-14.parquet
  size:    1.4 MB
  rows:    60,517
  symbols: 1,869

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-02-14 04:00:00	AAPL	Stock	153.5	154.05	153.4	153.72	12438.0
2023-02-14 05:00:00	AAPL	Stock	153.75	154.2	153.72	154.09	6632.0
2023-02-14 06:00:00	AAPL	Stock	154.15	154.34	154.0	154.0	10069.0
2023-02-14 07:00:00	AAPL	Stock	154.0	154.15	153.95	154.04	50897.0
2023-02-14 08:00:00	AAPL	Stock	153.65	155.2	152.75	153.07	608504.0
2023-02-14 09:00:00	AAPL	Stock	153.09	153.24	151.0	152.8399	9061657.0
2023-02-14 10:00:00	AAPL	Stock	152.84	153.77	150.86	151.87	9646131.0
2023-02-14 11:00:00	AAPL	Stock	151.88	152.59	151.04	151.7	6650143.0
2023-02-14 12:00:00	AAPL	Stock	151.695	152.34	151.57	152.105	4069981.0
2023-02-14 13:00:00	AAPL	Stock	152.11	153.22	152.06	153.04	4610917.0
2023-02-14 14:00:00	AAPL	Stock	153.04	153.57	152.43	153.24	3926779.0
2023-02-14 15:00:00	AAPL	Stock	153.245	153.73	152.9499	153.1	6382283.0
2023-02-14 16:00:00	AAPL	Stock	153.1399	153.2	152.85	153.09	7737208.0
2023-02-14 17:00:00	AAPL	Stock	153.08	153.2	153.0166	153.18	39041.0
2023-02-14 18:00:00	AAPL	Stock	153.2	153.2	153.06	153.09	34072.0
2023-02-14 19:00:00	AAPL	Stock	153.08	153.09	152.7	152.84	42045.0
2023-02-14 04:00:00	MSFT	Stock	272.09	272.67	271.74	272.54	5488.0
2023-02-14 05:00:00	MSFT	Stock	272.58	273.95	272.58	272.88	13568.0
2023-02-14 06:00:00	MSFT	Stock	272.89	273.3	272.81	272.9	3968.0
2023-02-14 07:00:00	MSFT	Stock	273.0	273.18	272.48	272.48	30456.0
2023-02-14 08:00:00	MSFT	Stock	273.17	275.0	269.8	271.9857	403347.0
2023-02-14 09:00:00	MSFT	Stock	271.81	273.0	270.01	271.75	4775991.0
2023-02-14 10:00:00	MSFT	Stock	271.71	274.97	269.28	270.83	5767377.0
2023-02-14 11:00:00	MSFT	Stock	270.81	271.92	269.51	270.6866	3441946.0
2023-02-14 12:00:00	MSFT	Stock	270.65	271.3055	270.19	270.95	2133124.0
2023-02-14 13:00:00	MSFT	Stock	270.95	273.3392	270.81	272.79	2050816.0
2023-02-14 14:00:00	MSFT	Stock	272.8029	273.9441	271.66	273.02	2160106.0
2023-02-14 15:00:00	MSFT	Stock	273.04	273.2905	271.92	272.28	3259357.0
2023-02-14 16:00:00	MSFT	Stock	272.02	272.32	271.64	271.89	4389304.0
2023-02-14 17:00:00	MSFT	Stock	271.9396	272.15	271.85	272.08	10364.0
2023-02-14 18:00:00	MSFT	Stock	272.14	272.14	271.5	271.5	11954.0
2023-02-14 19:00:00	MSFT	Stock	271.47	271.98	271.35	271.6	22565.0
2023-02-14 04:00:00	NVDA	Stock	21.798	22.05	21.798	22.05	86030.0
2023-02-14 05:00:00	NVDA	Stock	22.046	22.196	22.04	22.17	348940.0
2023-02-14 06:00:00	NVDA	Stock	22.174	22.2	22.1	22.1	156460.0
2023-02-14 07:00:00	NVDA	Stock	22.085	22.106	21.92	21.95	764900.0
2023-02-14 08:00:00	NVDA	Stock	22.006	22.202	21.48	21.799	8908850.0
2023-02-14 09:00:00	NVDA	Stock	21.767	22.68	21.366	22.58	107282950.0
2023-02-14 10:00:00	NVDA	Stock	22.578	22.821	22.1661	22.3785	118208070.0
2023-02-14 11:00:00	NVDA	Stock	22.375	22.671	22.2835	22.4656	72999230.0
2023-02-14 12:00:00	NVDA	Stock	22.467	22.6722	22.439	22.6274	47023580.0
2023-02-14 13:00:00	NVDA	Stock	22.632	22.9	22.6194	22.8388	56167400.0
2023-02-14 14:00:00	NVDA	Stock	22.839	22.993	22.703	22.911	50696210.0
2023-02-14 15:00:00	NVDA	Stock	22.917	23.0488	22.79	22.96	68877360.0
2023-02-14 16:00:00	NVDA	Stock	22.971	22.992	22.752	22.86	25578410.0
2023-02-14 17:00:00	NVDA	Stock	22.86	22.947	22.8306	22.93	772480.0
2023-02-14 18:00:00	NVDA	Stock	22.934	22.944	22.836	22.85	435700.0
2023-02-14 19:00:00	NVDA	Stock	22.85	22.87	22.806	22.843	608550.0
2023-02-14 04:00:00	AMZN	Stock	99.4	99.76	99.37	99.69	10164.0
2023-02-14 05:00:00	AMZN	Stock	99.76	99.99	99.64	99.84	11698.0

> showing 50 of 60,517 rows — these rows as CSV

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