PREVIEW / stock_30min / 2023-06-01

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-06-01.parquet
  size:    2.1 MB
  rows:    101,123
  symbols: 1,643

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-06-01 04:00:00	AAPL	Stock	177.8	177.87	177.35	177.6	12601.0
2023-06-01 04:30:00	AAPL	Stock	177.71	177.95	177.68	177.95	3276.0
2023-06-01 05:00:00	AAPL	Stock	177.94	177.94	177.6	177.65	13266.0
2023-06-01 05:30:00	AAPL	Stock	177.65	177.77	177.56	177.73	4718.0
2023-06-01 06:00:00	AAPL	Stock	177.72	177.9	177.72	177.9	8343.0
2023-06-01 06:30:00	AAPL	Stock	177.93	177.93	177.75	177.75	7289.0
2023-06-01 07:00:00	AAPL	Stock	177.76	178.18	177.76	178.0	22347.0
2023-06-01 07:30:00	AAPL	Stock	178.0	178.0	177.67	177.83	19529.0
2023-06-01 08:00:00	AAPL	Stock	177.8403	178.18	177.06	177.58	111001.0
2023-06-01 08:30:00	AAPL	Stock	177.7	177.9296	177.51	177.63	69823.0
2023-06-01 09:00:00	AAPL	Stock	177.6	177.96	177.55	177.7	104940.0
2023-06-01 09:30:00	AAPL	Stock	177.7	177.865	176.9306	177.31	5591831.0
2023-06-01 10:00:00	AAPL	Stock	177.32	178.36	177.28	178.1	3870388.0
2023-06-01 10:30:00	AAPL	Stock	178.11	179.285	178.0	178.95	4083866.0
2023-06-01 11:00:00	AAPL	Stock	178.96	179.645	178.77	179.48	3920830.0
2023-06-01 11:30:00	AAPL	Stock	179.485	179.63	179.21	179.58	2314847.0
2023-06-01 12:00:00	AAPL	Stock	179.58	179.9667	179.58	179.8	2541885.0
2023-06-01 12:30:00	AAPL	Stock	179.8	180.0	179.77	179.9001	2237225.0
2023-06-01 13:00:00	AAPL	Stock	179.91	180.0	179.465	179.61	3014702.0
2023-06-01 13:30:00	AAPL	Stock	179.6131	179.9	179.48	179.89	2375555.0
2023-06-01 14:00:00	AAPL	Stock	179.885	180.0	179.71	179.875	2446646.0
2023-06-01 14:30:00	AAPL	Stock	179.88	180.12	179.56	179.8192	4002252.0
2023-06-01 15:00:00	AAPL	Stock	179.8191	180.01	179.64	179.78	2687843.0
2023-06-01 15:30:00	AAPL	Stock	179.79	180.12	179.22	180.1	6945207.0
2023-06-01 16:00:00	AAPL	Stock	180.1	180.44	180.01	180.32	8722396.0
2023-06-01 16:30:00	AAPL	Stock	180.33	180.49	180.09	180.4	154695.0
2023-06-01 17:00:00	AAPL	Stock	180.3812	180.59	180.3802	180.46	59547.0
2023-06-01 17:30:00	AAPL	Stock	180.46	180.54	180.38	180.49	33559.0
2023-06-01 18:00:00	AAPL	Stock	180.49	180.54	180.46	180.54	7022.0
2023-06-01 18:30:00	AAPL	Stock	180.54	180.59	180.44	180.54	15154.0
2023-06-01 19:00:00	AAPL	Stock	180.54	180.6	180.46	180.55	13790.0
2023-06-01 19:30:00	AAPL	Stock	180.61	180.68	180.49	180.49	35634.0
2023-06-01 04:00:00	MSFT	Stock	328.96	329.2	327.46	327.5	6280.0
2023-06-01 04:30:00	MSFT	Stock	327.56	327.87	327.48	327.8	2167.0
2023-06-01 05:00:00	MSFT	Stock	327.96	327.97	327.65	327.65	1423.0
2023-06-01 05:30:00	MSFT	Stock	327.23	327.7	327.2	327.7	1313.0
2023-06-01 06:00:00	MSFT	Stock	327.7	327.76	327.58	327.58	728.0
2023-06-01 06:30:00	MSFT	Stock	328.0	328.0	327.83	327.88	2111.0
2023-06-01 07:00:00	MSFT	Stock	328.01	329.1	328.0	329.0	2592.0
2023-06-01 07:30:00	MSFT	Stock	328.83	329.03	327.88	327.88	5392.0
2023-06-01 08:00:00	MSFT	Stock	329.09	329.2599	326.08	327.0	31858.0
2023-06-01 08:30:00	MSFT	Stock	327.03	327.8	327.03	327.75	8425.0
2023-06-01 09:00:00	MSFT	Stock	327.55	328.27	325.72	326.13	43257.0
2023-06-01 09:30:00	MSFT	Stock	326.13	328.47	324.72	327.895	2518910.0
2023-06-01 10:00:00	MSFT	Stock	327.94	328.59	326.42	327.55	1068268.0
2023-06-01 10:30:00	MSFT	Stock	327.575	329.0	326.885	328.38	911801.0
2023-06-01 11:00:00	MSFT	Stock	328.42	329.59	328.01	329.12	923455.0
2023-06-01 11:30:00	MSFT	Stock	329.11	330.2	329.05	330.15	826631.0
2023-06-01 12:00:00	MSFT	Stock	330.17	331.34	330.17	331.01	775063.0
2023-06-01 12:30:00	MSFT	Stock	331.03	331.12	330.64	330.92	559571.0

> showing 50 of 101,123 rows — these rows as CSV

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