PREVIEW / stock_30min / 2023-09-05

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-09-05.parquet
  size:    2.0 MB
  rows:    99,496
  symbols: 1,440

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-05 04:00:00	AAPL	Stock	188.5	189.2	187.31	187.45	47574.0
2023-09-05 04:30:00	AAPL	Stock	187.45	187.71	187.42	187.65	8480.0
2023-09-05 05:00:00	AAPL	Stock	187.66	187.9	187.6	187.9	7374.0
2023-09-05 05:30:00	AAPL	Stock	187.96	188.0	187.61	187.68	11502.0
2023-09-05 06:00:00	AAPL	Stock	187.66	187.79	187.54	187.69	20066.0
2023-09-05 06:30:00	AAPL	Stock	187.67	187.78	187.6	187.6	15370.0
2023-09-05 07:00:00	AAPL	Stock	187.65	187.75	187.47	187.57	43603.0
2023-09-05 07:30:00	AAPL	Stock	187.55	187.88	187.55	187.78	19998.0
2023-09-05 08:00:00	AAPL	Stock	187.53	189.75	187.45	187.49	221098.0
2023-09-05 08:30:00	AAPL	Stock	187.49	187.93	187.48	187.67	258986.0
2023-09-05 09:00:00	AAPL	Stock	187.67	188.26	187.2	188.22	294764.0
2023-09-05 09:30:00	AAPL	Stock	188.22	188.63	187.61	188.06	6223022.0
2023-09-05 10:00:00	AAPL	Stock	188.06	189.07	187.82	188.67	3699831.0
2023-09-05 10:30:00	AAPL	Stock	188.665	189.31	188.29	189.05	2936664.0
2023-09-05 11:00:00	AAPL	Stock	189.06	189.61	189.045	189.15	2859301.0
2023-09-05 11:30:00	AAPL	Stock	189.165	189.41	188.98	189.4	1605448.0
2023-09-05 12:00:00	AAPL	Stock	189.409	189.76	189.3702	189.5873	1481721.0
2023-09-05 12:30:00	AAPL	Stock	189.59	189.81	189.5599	189.64	1231032.0
2023-09-05 13:00:00	AAPL	Stock	189.65	189.6999	189.195	189.23	1142303.0
2023-09-05 13:30:00	AAPL	Stock	189.23	189.507	189.16	189.435	966437.0
2023-09-05 14:00:00	AAPL	Stock	189.44	189.88	189.32	189.84	1177792.0
2023-09-05 14:30:00	AAPL	Stock	189.845	189.95	189.52	189.94	1399589.0
2023-09-05 15:00:00	AAPL	Stock	189.93	189.94	189.47	189.5478	1557172.0
2023-09-05 15:30:00	AAPL	Stock	189.545	189.98	189.52	189.7	3695844.0
2023-09-05 16:00:00	AAPL	Stock	189.7	189.78	189.58	189.65	4806883.0
2023-09-05 16:30:00	AAPL	Stock	189.64	189.7	189.51	189.56	30072.0
2023-09-05 17:00:00	AAPL	Stock	189.55	189.59	189.54	189.56	6730.0
2023-09-05 17:30:00	AAPL	Stock	189.56	189.58	189.54	189.55	4638.0
2023-09-05 18:00:00	AAPL	Stock	189.55	189.69	189.5	189.69	12816.0
2023-09-05 18:30:00	AAPL	Stock	189.6398	189.73	189.55	189.73	11400.0
2023-09-05 19:00:00	AAPL	Stock	189.7	189.75	189.62	189.69	7863.0
2023-09-05 19:30:00	AAPL	Stock	189.7	189.7	189.53	189.7	11266.0
2023-09-05 04:00:00	MSFT	Stock	327.57	327.57	326.67	326.85	1612.0
2023-09-05 04:30:00	MSFT	Stock	326.66	326.85	326.55	326.85	1515.0
2023-09-05 05:00:00	MSFT	Stock	326.8	326.98	326.78	326.98	3018.0
2023-09-05 05:30:00	MSFT	Stock	327.09	327.19	327.0	327.0	514.0
2023-09-05 06:00:00	MSFT	Stock	327.18	327.39	327.11	327.39	1656.0
2023-09-05 06:30:00	MSFT	Stock	327.39	327.4	327.39	327.4	691.0
2023-09-05 07:00:00	MSFT	Stock	327.39	327.39	326.87	326.87	4000.0
2023-09-05 07:30:00	MSFT	Stock	327.15	327.46	327.15	327.3	2880.0
2023-09-05 08:00:00	MSFT	Stock	327.3	328.66	326.85	327.51	8335.0
2023-09-05 08:30:00	MSFT	Stock	327.5	328.76	327.28	328.46	18310.0
2023-09-05 09:00:00	MSFT	Stock	328.25	329.19	327.3	329.13	26538.0
2023-09-05 09:30:00	MSFT	Stock	329.13	330.8705	328.76	329.055	1576285.0
2023-09-05 10:00:00	MSFT	Stock	329.08	330.85	328.66	330.48	742665.0
2023-09-05 10:30:00	MSFT	Stock	330.45	332.06	330.3	331.88	958421.0
2023-09-05 11:00:00	MSFT	Stock	331.89	334.85	331.89	333.28	1514732.0
2023-09-05 11:30:00	MSFT	Stock	333.3	333.56	332.56	332.86	636055.0
2023-09-05 12:00:00	MSFT	Stock	332.86	334.12	332.81	333.5292	490169.0
2023-09-05 12:30:00	MSFT	Stock	333.545	333.94	333.14	333.395	350249.0

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

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