PREVIEW / stock_30min / 2023-06-27

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-06-27.parquet
  size:    2.1 MB
  rows:    99,985
  symbols: 1,577

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-27 04:00:00	AAPL	Stock	185.85	186.15	185.85	186.01	3371.0
2023-06-27 04:30:00	AAPL	Stock	185.95	185.97	185.65	185.65	3731.0
2023-06-27 05:00:00	AAPL	Stock	185.81	185.97	185.81	185.93	1331.0
2023-06-27 05:30:00	AAPL	Stock	185.87	185.87	185.8	185.81	645.0
2023-06-27 06:00:00	AAPL	Stock	185.7	185.72	185.7	185.72	219.0
2023-06-27 06:30:00	AAPL	Stock	185.81	185.88	185.8	185.83	1991.0
2023-06-27 07:00:00	AAPL	Stock	185.8	185.86	185.64	185.7	14607.0
2023-06-27 07:30:00	AAPL	Stock	185.64	185.65	185.42	185.55	15985.0
2023-06-27 08:00:00	AAPL	Stock	185.82	186.05	185.27	185.65	59150.0
2023-06-27 08:30:00	AAPL	Stock	185.6	185.98	185.55	185.87	49609.0
2023-06-27 09:00:00	AAPL	Stock	185.84	186.0102	185.75	185.91	101480.0
2023-06-27 09:30:00	AAPL	Stock	185.89	187.0442	185.67	186.89	5582417.0
2023-06-27 10:00:00	AAPL	Stock	186.87	187.0	186.23	186.85	3156228.0
2023-06-27 10:30:00	AAPL	Stock	186.84	186.9299	186.495	186.72	2195997.0
2023-06-27 11:00:00	AAPL	Stock	186.725	186.96	186.05	186.95	2445240.0
2023-06-27 11:30:00	AAPL	Stock	186.96	187.22	186.79	187.115	2039025.0
2023-06-27 12:00:00	AAPL	Stock	187.12	187.5	187.05	187.48	2070326.0
2023-06-27 12:30:00	AAPL	Stock	187.47	187.84	187.4501	187.665	2157054.0
2023-06-27 13:00:00	AAPL	Stock	187.66	187.9367	187.52	187.785	1868554.0
2023-06-27 13:30:00	AAPL	Stock	187.79	188.19	187.79	188.13	2492156.0
2023-06-27 14:00:00	AAPL	Stock	188.13	188.24	187.93	188.195	1423829.0
2023-06-27 14:30:00	AAPL	Stock	188.2	188.285	188.01	188.015	1741241.0
2023-06-27 15:00:00	AAPL	Stock	188.02	188.39	188.015	188.305	2463318.0
2023-06-27 15:30:00	AAPL	Stock	188.305	188.355	187.96	188.04	4578900.0
2023-06-27 16:00:00	AAPL	Stock	188.04	188.08	187.8	187.88	6527576.0
2023-06-27 16:30:00	AAPL	Stock	187.881	188.06	187.83	187.96	374105.0
2023-06-27 17:00:00	AAPL	Stock	187.94	187.96	187.86	187.9316	9345.0
2023-06-27 17:30:00	AAPL	Stock	187.93	187.98	187.86	187.9	9616.0
2023-06-27 18:00:00	AAPL	Stock	187.9	187.98	187.7	187.8499	44125.0
2023-06-27 18:30:00	AAPL	Stock	187.84	187.88	187.71	187.8498	20850.0
2023-06-27 19:00:00	AAPL	Stock	187.84	187.95	187.72	187.95	26777.0
2023-06-27 19:30:00	AAPL	Stock	187.95	188.08	187.82	187.9999	16951.0
2023-06-27 04:00:00	MSFT	Stock	329.47	329.5	329.3	329.5	2992.0
2023-06-27 04:30:00	MSFT	Stock	329.4	329.89	329.4	329.89	3222.0
2023-06-27 05:00:00	MSFT	Stock	329.61	329.61	329.61	329.61	105.0
2023-06-27 05:30:00	MSFT	Stock	330.2	330.2	330.05	330.15	714.0
2023-06-27 06:00:00	MSFT	Stock	330.5	330.5	330.5	330.5	200.0
2023-06-27 06:30:00	MSFT	Stock	330.15	331.0	330.15	330.4	2908.0
2023-06-27 07:00:00	MSFT	Stock	330.46	330.61	330.18	330.22	8493.0
2023-06-27 07:30:00	MSFT	Stock	330.39	330.6	330.23	330.46	10386.0
2023-06-27 08:00:00	MSFT	Stock	330.46	330.95	329.0	330.8395	24766.0
2023-06-27 08:30:00	MSFT	Stock	330.33	331.41	330.33	330.45	21101.0
2023-06-27 09:00:00	MSFT	Stock	330.5013	332.193	330.5	331.92	34926.0
2023-06-27 09:30:00	MSFT	Stock	331.87	334.1144	331.36	333.24	2065357.0
2023-06-27 10:00:00	MSFT	Stock	333.235	333.75	331.12	332.0	1231362.0
2023-06-27 10:30:00	MSFT	Stock	331.99	332.1073	330.28	330.77	973213.0
2023-06-27 11:00:00	MSFT	Stock	330.8	331.8734	329.3	331.8734	1184958.0
2023-06-27 11:30:00	MSFT	Stock	331.92	332.84	331.87	332.47	667858.0
2023-06-27 12:00:00	MSFT	Stock	332.48	332.48	331.27	331.97	667945.0
2023-06-27 12:30:00	MSFT	Stock	331.97	333.0	331.7	332.762	658502.0

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

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