PREVIEW / stock_30min / 2023-09-18

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-09-18.parquet
  size:    2.0 MB
  rows:    98,174
  symbols: 1,438

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-18 04:00:00	AAPL	Stock	175.9	175.9	175.55	175.69	34677.0
2023-09-18 04:30:00	AAPL	Stock	175.69	175.85	175.65	175.75	22227.0
2023-09-18 05:00:00	AAPL	Stock	175.73	175.9	175.67	175.7	14717.0
2023-09-18 05:30:00	AAPL	Stock	175.76	175.9	175.76	175.84	7367.0
2023-09-18 06:00:00	AAPL	Stock	175.82	175.88	175.63	175.8	25869.0
2023-09-18 06:30:00	AAPL	Stock	175.8	175.96	175.77	175.77	71169.0
2023-09-18 07:00:00	AAPL	Stock	175.84	175.84	175.42	175.47	76116.0
2023-09-18 07:30:00	AAPL	Stock	175.46	175.46	174.6	174.72	85705.0
2023-09-18 08:00:00	AAPL	Stock	175.65	176.07	174.6	175.32	196215.0
2023-09-18 08:30:00	AAPL	Stock	175.31	175.89	175.1702	175.8394	281879.0
2023-09-18 09:00:00	AAPL	Stock	175.82	176.65	175.7465	176.57	444505.0
2023-09-18 09:30:00	AAPL	Stock	176.57	178.98	176.17	177.05	13217130.0
2023-09-18 10:00:00	AAPL	Stock	177.025	177.62	176.71	177.0219	4902575.0
2023-09-18 10:30:00	AAPL	Stock	177.0319	177.26	176.44	177.135	3659218.0
2023-09-18 11:00:00	AAPL	Stock	177.135	177.84	177.0899	177.81	2936932.0
2023-09-18 11:30:00	AAPL	Stock	177.8	178.31	177.745	178.265	2897923.0
2023-09-18 12:00:00	AAPL	Stock	178.265	178.65	178.11	178.545	2301841.0
2023-09-18 12:30:00	AAPL	Stock	178.545	179.18	178.545	178.8601	3110995.0
2023-09-18 13:00:00	AAPL	Stock	178.88	179.21	178.7301	179.115	2364819.0
2023-09-18 13:30:00	AAPL	Stock	179.12	179.38	178.87	179.005	2359655.0
2023-09-18 14:00:00	AAPL	Stock	179.01	179.22	178.895	178.96	1649581.0
2023-09-18 14:30:00	AAPL	Stock	178.965	179.07	178.4246	178.61	1953539.0
2023-09-18 15:00:00	AAPL	Stock	178.6	178.76	178.27	178.4191	2228268.0
2023-09-18 15:30:00	AAPL	Stock	178.415	178.415	177.775	177.98	5328863.0
2023-09-18 16:00:00	AAPL	Stock	177.97	178.02	177.84	177.86	5371033.0
2023-09-18 16:30:00	AAPL	Stock	177.85	177.98	177.82	177.9	166892.0
2023-09-18 17:00:00	AAPL	Stock	177.9	177.97	177.85	177.87	59752.0
2023-09-18 17:30:00	AAPL	Stock	177.88	177.98	177.85	177.95	24438.0
2023-09-18 18:00:00	AAPL	Stock	177.98	178.6	177.95	178.5	54486.0
2023-09-18 18:30:00	AAPL	Stock	178.48	178.56	178.35	178.4	19545.0
2023-09-18 19:00:00	AAPL	Stock	178.36	178.46	178.26	178.35	11947.0
2023-09-18 19:30:00	AAPL	Stock	178.32	178.5	178.21	178.5	41164.0
2023-09-18 04:00:00	MSFT	Stock	330.5	331.29	330.5	330.91	1955.0
2023-09-18 04:30:00	MSFT	Stock	330.99	330.99	330.8	330.8	1617.0
2023-09-18 05:00:00	MSFT	Stock	330.95	330.95	330.95	330.95	141.0
2023-09-18 05:30:00	MSFT	Stock	330.65	330.65	330.5	330.5	516.0
2023-09-18 06:00:00	MSFT	Stock	330.22	330.22	330.22	330.22	100.0
2023-09-18 06:30:00	MSFT	Stock	330.56	330.56	330.56	330.56	2802.0
2023-09-18 07:00:00	MSFT	Stock	330.64	330.67	330.13	330.14	2933.0
2023-09-18 07:30:00	MSFT	Stock	330.15	330.15	328.71	328.71	9102.0
2023-09-18 08:00:00	MSFT	Stock	330.49	331.0	328.6	328.9999	32929.0
2023-09-18 08:30:00	MSFT	Stock	329.0	329.5	328.88	329.0	11692.0
2023-09-18 09:00:00	MSFT	Stock	329.0	329.0	327.0	327.63	39647.0
2023-09-18 09:30:00	MSFT	Stock	327.64	330.315	326.85	329.19	2044458.0
2023-09-18 10:00:00	MSFT	Stock	329.14	329.8	328.48	328.9	808839.0
2023-09-18 10:30:00	MSFT	Stock	328.95	329.02	328.06	328.78	599300.0
2023-09-18 11:00:00	MSFT	Stock	328.77	329.83	328.372	329.81	595534.0
2023-09-18 11:30:00	MSFT	Stock	329.77	330.4	329.59	329.925	491474.0
2023-09-18 12:00:00	MSFT	Stock	329.98	330.08	328.9	329.26	422506.0
2023-09-18 12:30:00	MSFT	Stock	329.29	329.62	328.65	328.67	348610.0

> showing 50 of 98,174 rows — these rows as CSV

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