PREVIEW / stock_30min / 2023-09-07

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-09-07.parquet
  size:    2.0 MB
  rows:    97,580
  symbols: 1,416

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-07 04:00:00	AAPL	Stock	181.48	181.9	177.0	177.89	194866.0
2023-09-07 04:30:00	AAPL	Stock	177.89	178.47	177.5	177.8	120309.0
2023-09-07 05:00:00	AAPL	Stock	177.99	178.19	177.25	177.82	75622.0
2023-09-07 05:30:00	AAPL	Stock	177.84	178.36	177.8	177.9	42823.0
2023-09-07 06:00:00	AAPL	Stock	177.96	178.9	177.85	178.0	59580.0
2023-09-07 06:30:00	AAPL	Stock	178.0	178.05	177.22	177.43	96955.0
2023-09-07 07:00:00	AAPL	Stock	177.45	178.35	177.4	177.74	226828.0
2023-09-07 07:30:00	AAPL	Stock	177.74	178.49	177.65	178.39	153606.0
2023-09-07 08:00:00	AAPL	Stock	177.55	182.52	177.31	177.54	665275.0
2023-09-07 08:30:00	AAPL	Stock	177.51	177.55	176.06	176.1729	1031315.0
2023-09-07 09:00:00	AAPL	Stock	176.1707	176.38	174.2	175.19	1462910.0
2023-09-07 09:30:00	AAPL	Stock	175.19	177.79	173.54	176.23	25274917.0
2023-09-07 10:00:00	AAPL	Stock	176.23	176.87	175.69	176.06	9551760.0
2023-09-07 10:30:00	AAPL	Stock	176.06	177.175	175.73	176.6999	6334484.0
2023-09-07 11:00:00	AAPL	Stock	176.69	178.21	176.65	177.3216	5954222.0
2023-09-07 11:30:00	AAPL	Stock	177.32	177.725	176.72	176.975	4291498.0
2023-09-07 12:00:00	AAPL	Stock	176.97	177.4	176.65	177.26	3551771.0
2023-09-07 12:30:00	AAPL	Stock	177.25	177.68	176.7103	176.735	2745069.0
2023-09-07 13:00:00	AAPL	Stock	176.7335	176.88	175.95	176.5815	3901466.0
2023-09-07 13:30:00	AAPL	Stock	176.59	177.1	176.283	177.03	3031764.0
2023-09-07 14:00:00	AAPL	Stock	177.025	177.15	176.52	176.525	3242082.0
2023-09-07 14:30:00	AAPL	Stock	176.52	177.39	176.49	177.19	3147604.0
2023-09-07 15:00:00	AAPL	Stock	177.185	177.46	176.78	177.46	3476045.0
2023-09-07 15:30:00	AAPL	Stock	177.469	178.14	177.44	177.56	8651283.0
2023-09-07 16:00:00	AAPL	Stock	177.56	178.3	176.7087	178.09	7409592.0
2023-09-07 16:30:00	AAPL	Stock	178.09	178.22	177.56	178.22	242839.0
2023-09-07 17:00:00	AAPL	Stock	178.2	178.3	178.09	178.09	77329.0
2023-09-07 17:30:00	AAPL	Stock	178.09	178.14	177.94	178.01	42691.0
2023-09-07 18:00:00	AAPL	Stock	178.0131	178.14	178.01	178.03	14154.0
2023-09-07 18:30:00	AAPL	Stock	178.03	178.04	177.95	178.03	13661.0
2023-09-07 19:00:00	AAPL	Stock	178.04	178.1	177.77	178.1	28336.0
2023-09-07 19:30:00	AAPL	Stock	178.04	178.22	178.0	178.04	25565.0
2023-09-07 04:00:00	MSFT	Stock	332.32	332.43	330.5	330.7	5414.0
2023-09-07 04:30:00	MSFT	Stock	331.1	332.09	330.99	332.09	5405.0
2023-09-07 05:00:00	MSFT	Stock	332.36	332.36	331.99	331.99	1109.0
2023-09-07 05:30:00	MSFT	Stock	331.73	332.5	331.73	332.39	2027.0
2023-09-07 06:00:00	MSFT	Stock	332.4	332.4	332.21	332.3	2345.0
2023-09-07 06:30:00	MSFT	Stock	332.21	332.26	331.91	331.94	2712.0
2023-09-07 07:00:00	MSFT	Stock	332.02	332.56	332.01	332.1	3146.0
2023-09-07 07:30:00	MSFT	Stock	331.7	332.33	331.7	331.81	4908.0
2023-09-07 08:00:00	MSFT	Stock	332.05	332.55	331.22	331.31	25237.0
2023-09-07 08:30:00	MSFT	Stock	331.22	331.22	329.19	329.7	39278.0
2023-09-07 09:00:00	MSFT	Stock	329.46	331.35	329.46	331.21	41366.0
2023-09-07 09:30:00	MSFT	Stock	331.29	332.01	330.02	331.1499	1342736.0
2023-09-07 10:00:00	MSFT	Stock	331.15	332.05	330.425	331.04	768591.0
2023-09-07 10:30:00	MSFT	Stock	331.04	333.08	330.58	331.68	839105.0
2023-09-07 11:00:00	MSFT	Stock	331.71	332.42	330.64	330.65	684673.0
2023-09-07 11:30:00	MSFT	Stock	330.66	331.6899	330.47	330.5	379555.0
2023-09-07 12:00:00	MSFT	Stock	330.49	332.13	330.4	331.51	473458.0
2023-09-07 12:30:00	MSFT	Stock	331.56	331.75	330.42	330.5	441283.0

> showing 50 of 97,580 rows — these rows as CSV

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