PREVIEW / stock_1hour / 2023-06-13

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-06-13.parquet
  size:    1.4 MB
  rows:    62,006
  symbols: 1,637

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-06-13 04:00:00	AAPL	Stock	182.76	182.87	182.01	182.53	44490.0
2023-06-13 05:00:00	AAPL	Stock	182.53	182.53	182.15	182.26	61448.0
2023-06-13 06:00:00	AAPL	Stock	182.17	182.35	182.13	182.2	30669.0
2023-06-13 07:00:00	AAPL	Stock	182.25	182.75	182.15	182.29	110001.0
2023-06-13 08:00:00	AAPL	Stock	182.2485	183.75	182.17	183.07	634943.0
2023-06-13 09:00:00	AAPL	Stock	183.07	184.15	182.65	183.22	8276221.0
2023-06-13 10:00:00	AAPL	Stock	183.26	183.63	182.46	182.95	6937068.0
2023-06-13 11:00:00	AAPL	Stock	182.95	183.7505	182.82	183.12	4168597.0
2023-06-13 12:00:00	AAPL	Stock	183.12	183.53	182.9601	183.46	3080255.0
2023-06-13 13:00:00	AAPL	Stock	183.465	183.55	182.76	183.0199	3541448.0
2023-06-13 14:00:00	AAPL	Stock	183.02	183.09	182.44	182.92	3816779.0
2023-06-13 15:00:00	AAPL	Stock	182.9197	183.38	182.68	183.32	5361633.0
2023-06-13 16:00:00	AAPL	Stock	183.32	183.34	183.17	183.21	5265074.0
2023-06-13 17:00:00	AAPL	Stock	183.22	183.31	183.2	183.23	33970.0
2023-06-13 18:00:00	AAPL	Stock	183.22	183.28	183.2	183.26	16884.0
2023-06-13 19:00:00	AAPL	Stock	183.26	183.26	183.05	183.0799	33820.0
2023-06-13 04:00:00	MSFT	Stock	335.75	335.75	333.68	334.88	4917.0
2023-06-13 05:00:00	MSFT	Stock	334.76	334.77	333.8	333.96	2710.0
2023-06-13 06:00:00	MSFT	Stock	334.0	334.15	333.0	333.54	4075.0
2023-06-13 07:00:00	MSFT	Stock	333.65	333.75	332.66	332.66	11831.0
2023-06-13 08:00:00	MSFT	Stock	333.3	336.1	332.12	334.472	63239.0
2023-06-13 09:00:00	MSFT	Stock	334.48	336.98	332.05	332.4	2869521.0
2023-06-13 10:00:00	MSFT	Stock	332.46	333.08	330.39	332.3	2549608.0
2023-06-13 11:00:00	MSFT	Stock	332.305	333.31	331.54	331.755	1410934.0
2023-06-13 12:00:00	MSFT	Stock	331.8	333.64	331.4	333.6101	1032401.0
2023-06-13 13:00:00	MSFT	Stock	333.65	334.4	333.0426	333.94	1210307.0
2023-06-13 14:00:00	MSFT	Stock	333.95	334.17	332.78	333.91	1279536.0
2023-06-13 15:00:00	MSFT	Stock	333.92	334.49	333.2	334.32	1915531.0
2023-06-13 16:00:00	MSFT	Stock	334.33	334.57	333.76	334.41	3030874.0
2023-06-13 17:00:00	MSFT	Stock	334.41	334.51	334.1229	334.3	8178.0
2023-06-13 18:00:00	MSFT	Stock	334.3	334.4498	333.9	334.3	4605.0
2023-06-13 19:00:00	MSFT	Stock	334.39	334.39	333.3	333.7	5319.0
2023-06-13 04:00:00	NVDA	Stock	39.71	40.005	39.652	39.943	365160.0
2023-06-13 05:00:00	NVDA	Stock	39.948	40.1	39.849	39.849	330510.0
2023-06-13 06:00:00	NVDA	Stock	39.86	39.897	39.77	39.82	138030.0
2023-06-13 07:00:00	NVDA	Stock	39.813	39.834	39.663	39.724	557010.0
2023-06-13 08:00:00	NVDA	Stock	39.77	40.195	39.595	40.158	5360850.0
2023-06-13 09:00:00	NVDA	Stock	40.171	40.498	39.759	39.975	67661770.0
2023-06-13 10:00:00	NVDA	Stock	39.986	40.3305	39.74	40.292	70810200.0
2023-06-13 11:00:00	NVDA	Stock	40.291	40.8999	40.204	40.6371	79089450.0
2023-06-13 12:00:00	NVDA	Stock	40.6328	40.778	40.48	40.7536	38935310.0
2023-06-13 13:00:00	NVDA	Stock	40.751	40.9	40.527	40.771	41741050.0
2023-06-13 14:00:00	NVDA	Stock	40.774	40.986	40.1	40.919	62576180.0
2023-06-13 15:00:00	NVDA	Stock	40.917	41.101	40.778	41.023	80079900.0
2023-06-13 16:00:00	NVDA	Stock	41.025	41.131	40.988	41.047	19867480.0
2023-06-13 17:00:00	NVDA	Stock	41.047	41.3362	41.0069	41.24	1458240.0
2023-06-13 18:00:00	NVDA	Stock	41.23	41.24	41.066	41.18	471390.0
2023-06-13 19:00:00	NVDA	Stock	41.175	41.325	41.15	41.325	1115800.0
2023-06-13 04:00:00	AMZN	Stock	127.13	127.98	127.13	127.95	27125.0
2023-06-13 05:00:00	AMZN	Stock	127.93	128.1	127.7	127.92	15185.0

> showing 50 of 62,006 rows — these rows as CSV

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