PREVIEW / stock_30min / 2023-08-25

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-08-25.parquet
  size:    1.9 MB
  rows:    94,130
  symbols: 1,424

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-25 04:00:00	AAPL	Stock	176.46	176.9	176.36	176.77	5979.0
2023-08-25 04:30:00	AAPL	Stock	176.87	176.87	176.54	176.73	4155.0
2023-08-25 05:00:00	AAPL	Stock	176.65	176.8	176.58	176.79	3841.0
2023-08-25 05:30:00	AAPL	Stock	176.82	177.21	176.81	176.84	29948.0
2023-08-25 06:00:00	AAPL	Stock	176.94	177.12	176.83	177.1	8074.0
2023-08-25 06:30:00	AAPL	Stock	177.07	177.09	176.96	176.99	3708.0
2023-08-25 07:00:00	AAPL	Stock	177.04	177.05	176.83	176.83	17866.0
2023-08-25 07:30:00	AAPL	Stock	176.88	177.2	176.76	177.2	14071.0
2023-08-25 08:00:00	AAPL	Stock	177.0	177.37	176.21	177.18	61989.0
2023-08-25 08:30:00	AAPL	Stock	177.25	177.4	177.12	177.19	45574.0
2023-08-25 09:00:00	AAPL	Stock	177.17	177.41	176.38	177.41	131201.0
2023-08-25 09:30:00	AAPL	Stock	177.41	178.1395	177.23	177.6342	3810464.0
2023-08-25 10:00:00	AAPL	Stock	177.62	178.63	176.82	177.015	3959332.0
2023-08-25 10:30:00	AAPL	Stock	177.01	177.28	175.82	175.89	3421127.0
2023-08-25 11:00:00	AAPL	Stock	175.8999	177.41	175.87	177.36	2845145.0
2023-08-25 11:30:00	AAPL	Stock	177.36	177.77	176.55	176.66	1952646.0
2023-08-25 12:00:00	AAPL	Stock	176.66	177.75	176.64	177.75	1532643.0
2023-08-25 12:30:00	AAPL	Stock	177.75	177.84	177.16	177.49	1479497.0
2023-08-25 13:00:00	AAPL	Stock	177.49	177.65	177.09	177.3999	1140359.0
2023-08-25 13:30:00	AAPL	Stock	177.38	177.46	176.94	177.42	1121783.0
2023-08-25 14:00:00	AAPL	Stock	177.415	178.49	177.3401	178.45	1974851.0
2023-08-25 14:30:00	AAPL	Stock	178.46	178.7391	178.13	178.61	1913768.0
2023-08-25 15:00:00	AAPL	Stock	178.61	179.14	178.43	179.125	2489808.0
2023-08-25 15:30:00	AAPL	Stock	179.1224	179.15	178.44	178.6	4833901.0
2023-08-25 16:00:00	AAPL	Stock	178.6	178.68	178.4	178.51	6398550.0
2023-08-25 16:30:00	AAPL	Stock	178.5	178.57	178.5	178.53	10751.0
2023-08-25 17:00:00	AAPL	Stock	178.53	178.61	178.53	178.57	101724.0
2023-08-25 17:30:00	AAPL	Stock	178.57	178.58	178.53	178.55	5311.0
2023-08-25 18:00:00	AAPL	Stock	178.55	178.55	178.36	178.44	10133.0
2023-08-25 18:30:00	AAPL	Stock	178.38	178.61	178.38	178.44	5233.0
2023-08-25 19:00:00	AAPL	Stock	178.45	178.47	178.45	178.47	2093.0
2023-08-25 19:30:00	AAPL	Stock	178.47	178.59	178.45	178.5899	12559.0
2023-08-25 04:00:00	MSFT	Stock	319.81	320.42	319.81	320.21	2974.0
2023-08-25 04:30:00	MSFT	Stock	320.0	320.07	320.0	320.07	351.0
2023-08-25 05:30:00	MSFT	Stock	320.0	320.34	320.0	320.1	3626.0
2023-08-25 06:00:00	MSFT	Stock	320.2	320.68	320.2	320.68	660.0
2023-08-25 06:30:00	MSFT	Stock	320.68	321.12	320.6	321.0	2928.0
2023-08-25 07:00:00	MSFT	Stock	321.0	321.0	320.35	320.38	4478.0
2023-08-25 07:30:00	MSFT	Stock	320.46	320.75	320.46	320.75	3450.0
2023-08-25 08:00:00	MSFT	Stock	320.65	321.6999	318.91	321.45	23361.0
2023-08-25 08:30:00	MSFT	Stock	321.7	321.79	321.1701	321.1701	12026.0
2023-08-25 09:00:00	MSFT	Stock	321.1701	321.55	320.72	321.54	18195.0
2023-08-25 09:30:00	MSFT	Stock	321.47	323.73	321.31	323.57	1519195.0
2023-08-25 10:00:00	MSFT	Stock	323.51	325.36	320.79	321.52	1509809.0
2023-08-25 10:30:00	MSFT	Stock	321.48	321.97	319.06	319.18	1044311.0
2023-08-25 11:00:00	MSFT	Stock	319.21	320.89	318.8001	320.7811	1029788.0
2023-08-25 11:30:00	MSFT	Stock	320.75	321.46	319.16	319.63	830277.0
2023-08-25 12:00:00	MSFT	Stock	319.55	321.21	319.46	321.09	563405.0
2023-08-25 12:30:00	MSFT	Stock	321.1	321.21	320.22	321.0055	412132.0
2023-08-25 13:00:00	MSFT	Stock	320.96	321.62	320.435	320.81	383735.0

> showing 50 of 94,130 rows — these rows as CSV

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