PREVIEW / stock_30min / 2023-08-17

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-08-17.parquet
  size:    2.0 MB
  rows:    99,415
  symbols: 1,465

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-08-17 04:00:00	AAPL	Stock	176.51	176.69	176.51	176.63	9134.0
2023-08-17 04:30:00	AAPL	Stock	176.61	176.86	176.57	176.8	2398.0
2023-08-17 05:00:00	AAPL	Stock	176.76	176.76	176.76	176.76	510.0
2023-08-17 05:30:00	AAPL	Stock	176.75	176.78	176.65	176.68	4477.0
2023-08-17 06:00:00	AAPL	Stock	176.7	176.89	176.7	176.86	5132.0
2023-08-17 06:30:00	AAPL	Stock	176.75	176.75	176.51	176.65	5968.0
2023-08-17 07:00:00	AAPL	Stock	176.65	176.79	176.62	176.68	17164.0
2023-08-17 07:30:00	AAPL	Stock	176.66	176.74	176.58	176.74	13157.0
2023-08-17 08:00:00	AAPL	Stock	176.65	176.8	176.1	176.73	83551.0
2023-08-17 08:30:00	AAPL	Stock	176.73	176.99	176.57	176.94	291413.0
2023-08-17 09:00:00	AAPL	Stock	176.92	177.2	176.6	177.2	147684.0
2023-08-17 09:30:00	AAPL	Stock	177.2	177.5054	175.23	175.625	6145269.0
2023-08-17 10:00:00	AAPL	Stock	175.625	175.63	174.285	174.74	6271991.0
2023-08-17 10:30:00	AAPL	Stock	174.73	175.0	173.885	174.09	4108019.0
2023-08-17 11:00:00	AAPL	Stock	174.1	174.65	173.83	174.27	2403352.0
2023-08-17 11:30:00	AAPL	Stock	174.27	174.67	174.1	174.63	2055396.0
2023-08-17 12:00:00	AAPL	Stock	174.64	175.02	174.41	174.9514	1996365.0
2023-08-17 12:30:00	AAPL	Stock	174.96	175.065	174.64	175.065	1569351.0
2023-08-17 13:00:00	AAPL	Stock	175.07	175.09	174.52	174.56	1699559.0
2023-08-17 13:30:00	AAPL	Stock	174.56	174.56	174.08	174.215	1935943.0
2023-08-17 14:00:00	AAPL	Stock	174.22	174.35	173.945	174.25	1876017.0
2023-08-17 14:30:00	AAPL	Stock	174.255	174.28	173.715	173.94	2288431.0
2023-08-17 15:00:00	AAPL	Stock	173.93	174.15	173.48	174.08	2938013.0
2023-08-17 15:30:00	AAPL	Stock	174.07	174.89	173.66	173.99	5921429.0
2023-08-17 16:00:00	AAPL	Stock	174.0	174.1	173.51	173.59	5166716.0
2023-08-17 16:30:00	AAPL	Stock	173.57	174.0	173.31	173.4	252839.0
2023-08-17 17:00:00	AAPL	Stock	173.4	174.0	173.12	173.24	133772.0
2023-08-17 17:30:00	AAPL	Stock	173.2501	173.62	173.18	173.36	39757.0
2023-08-17 18:00:00	AAPL	Stock	173.36	173.49	173.25	173.29	29661.0
2023-08-17 18:30:00	AAPL	Stock	173.32	173.33	173.13	173.3063	20625.0
2023-08-17 19:00:00	AAPL	Stock	173.28	173.45	173.26	173.36	17203.0
2023-08-17 19:30:00	AAPL	Stock	173.34	173.65	173.34	173.3999	23071.0
2023-08-17 04:00:00	MSFT	Stock	319.32	322.0	319.32	320.45	2175.0
2023-08-17 04:30:00	MSFT	Stock	320.5	320.61	320.0	320.0	1232.0
2023-08-17 05:00:00	MSFT	Stock	320.28	320.29	320.28	320.29	366.0
2023-08-17 05:30:00	MSFT	Stock	320.16	320.26	320.16	320.26	706.0
2023-08-17 06:00:00	MSFT	Stock	320.19	320.43	320.19	320.43	1435.0
2023-08-17 06:30:00	MSFT	Stock	320.37	320.53	320.3	320.36	5140.0
2023-08-17 07:00:00	MSFT	Stock	320.34	320.51	320.2	320.5	4433.0
2023-08-17 07:30:00	MSFT	Stock	320.5	320.55	320.4	320.55	3154.0
2023-08-17 08:00:00	MSFT	Stock	320.4	320.66	318.14	320.54	25866.0
2023-08-17 08:30:00	MSFT	Stock	320.35	321.28	320.35	321.11	25537.0
2023-08-17 09:00:00	MSFT	Stock	321.11	321.11	319.92	320.68	24703.0
2023-08-17 09:30:00	MSFT	Stock	320.68	321.87	318.7001	319.85	1579576.0
2023-08-17 10:00:00	MSFT	Stock	319.85	320.2	318.94	319.1818	731306.0
2023-08-17 10:30:00	MSFT	Stock	319.1776	320.22	318.73	319.45	844896.0
2023-08-17 11:00:00	MSFT	Stock	319.49	319.64	318.76	318.7813	774339.0
2023-08-17 11:30:00	MSFT	Stock	318.7901	319.81	318.68	319.68	663079.0
2023-08-17 12:00:00	MSFT	Stock	319.69	320.6	319.04	320.3201	627815.0
2023-08-17 12:30:00	MSFT	Stock	320.365	320.82	319.87	320.81	443010.0

> showing 50 of 99,415 rows — these rows as CSV

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