PREVIEW / stock_30min / 2023-09-20

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-09-20.parquet
  size:    2.0 MB
  rows:    96,590
  symbols: 1,433

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-20 04:00:00	AAPL	Stock	178.98	179.2	178.85	179.2	7694.0
2023-09-20 04:30:00	AAPL	Stock	179.19	179.36	179.19	179.29	6656.0
2023-09-20 05:00:00	AAPL	Stock	179.33	179.45	179.25	179.25	1861.0
2023-09-20 05:30:00	AAPL	Stock	179.25	179.38	179.25	179.35	4128.0
2023-09-20 06:00:00	AAPL	Stock	179.36	179.4	179.2	179.25	3719.0
2023-09-20 06:30:00	AAPL	Stock	179.22	179.3	179.16	179.3	6405.0
2023-09-20 07:00:00	AAPL	Stock	179.25	179.39	178.52	178.52	46179.0
2023-09-20 07:30:00	AAPL	Stock	178.59	178.77	178.56	178.65	27158.0
2023-09-20 08:00:00	AAPL	Stock	179.32	179.38	178.31	178.685	91528.0
2023-09-20 08:30:00	AAPL	Stock	178.71	179.28	178.67	179.28	114538.0
2023-09-20 09:00:00	AAPL	Stock	179.25	179.5	179.0	179.3	132743.0
2023-09-20 09:30:00	AAPL	Stock	179.26	179.695	177.98	178.41	5832368.0
2023-09-20 10:00:00	AAPL	Stock	178.4	178.425	177.26	177.58	4057371.0
2023-09-20 10:30:00	AAPL	Stock	177.59	178.02	177.3374	177.43	2845240.0
2023-09-20 11:00:00	AAPL	Stock	177.43	177.575	176.86	176.985	2781811.0
2023-09-20 11:30:00	AAPL	Stock	176.985	177.58	176.945	177.55	2067352.0
2023-09-20 12:00:00	AAPL	Stock	177.56	177.64	177.32	177.64	1341051.0
2023-09-20 12:30:00	AAPL	Stock	177.65	177.76	177.51	177.725	1250578.0
2023-09-20 13:00:00	AAPL	Stock	177.72	177.72	177.31	177.5	1235757.0
2023-09-20 13:30:00	AAPL	Stock	177.5	177.7951	177.1752	177.7951	1890534.0
2023-09-20 14:00:00	AAPL	Stock	177.79	177.79	176.58	177.17	4638708.0
2023-09-20 14:30:00	AAPL	Stock	177.17	177.78	176.8	177.14	3946752.0
2023-09-20 15:00:00	AAPL	Stock	177.13	177.31	176.34	176.76	2946897.0
2023-09-20 15:30:00	AAPL	Stock	176.77	176.83	175.4	175.49	7067030.0
2023-09-20 16:00:00	AAPL	Stock	175.49	175.66	175.33	175.55	5047259.0
2023-09-20 16:30:00	AAPL	Stock	175.55	175.63	175.43	175.51	93127.0
2023-09-20 17:00:00	AAPL	Stock	175.55	175.55	175.45	175.55	694590.0
2023-09-20 17:30:00	AAPL	Stock	175.51	175.62	175.45	175.59	21706.0
2023-09-20 18:00:00	AAPL	Stock	175.6	175.65	175.37	175.46	16534.0
2023-09-20 18:30:00	AAPL	Stock	175.3733	175.47	175.32	175.42	12798.0
2023-09-20 19:00:00	AAPL	Stock	175.4	175.5001	175.37	175.5001	13131.0
2023-09-20 19:30:00	AAPL	Stock	175.5	175.56	175.0	175.0	32198.0
2023-09-20 04:00:00	MSFT	Stock	328.5	328.75	328.22	328.68	4326.0
2023-09-20 04:30:00	MSFT	Stock	328.65	328.95	328.65	328.95	730.0
2023-09-20 05:30:00	MSFT	Stock	329.0	329.11	329.0	329.11	225.0
2023-09-20 06:00:00	MSFT	Stock	329.19	329.19	329.19	329.19	100.0
2023-09-20 06:30:00	MSFT	Stock	329.01	329.05	329.01	329.05	550.0
2023-09-20 07:00:00	MSFT	Stock	329.25	329.39	329.2	329.2	1563.0
2023-09-20 07:30:00	MSFT	Stock	329.12	329.13	329.05	329.05	1803.0
2023-09-20 08:00:00	MSFT	Stock	329.6	329.77	328.25	329.4	10193.0
2023-09-20 08:30:00	MSFT	Stock	329.35	330.2	329.35	330.16	10826.0
2023-09-20 09:00:00	MSFT	Stock	329.87	330.3839	329.35	329.51	19482.0
2023-09-20 09:30:00	MSFT	Stock	329.51	329.59	327.9	328.9	1507601.0
2023-09-20 10:00:00	MSFT	Stock	328.9	329.16	327.39	327.6793	775823.0
2023-09-20 10:30:00	MSFT	Stock	327.64	328.38	327.2	327.28	658228.0
2023-09-20 11:00:00	MSFT	Stock	327.28	327.36	326.2718	326.535	545076.0
2023-09-20 11:30:00	MSFT	Stock	326.4808	327.22	325.03	327.2	543302.0
2023-09-20 12:00:00	MSFT	Stock	327.19	327.2282	326.22	326.7216	450115.0
2023-09-20 12:30:00	MSFT	Stock	326.7278	326.985	326.36	326.65	368056.0
2023-09-20 13:00:00	MSFT	Stock	326.65	326.65	325.92	326.06	331781.0

> showing 50 of 96,590 rows — these rows as CSV

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