PREVIEW / stock_30min / 2023-11-14

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-11-14.parquet
  size:    2.1 MB
  rows:    102,173
  symbols: 1,311

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-11-14 04:00:00	AAPL	Stock	184.99	185.47	184.99	185.39	3377.0
2023-11-14 04:30:00	AAPL	Stock	185.33	185.35	185.08	185.15	2002.0
2023-11-14 05:00:00	AAPL	Stock	185.12	185.28	185.04	185.27	9239.0
2023-11-14 05:30:00	AAPL	Stock	185.22	185.22	185.0	185.0	2527.0
2023-11-14 06:00:00	AAPL	Stock	185.05	185.07	185.0	185.05	1711.0
2023-11-14 07:00:00	AAPL	Stock	185.15	185.2	185.0	185.04	7534.0
2023-11-14 07:30:00	AAPL	Stock	185.05	185.13	185.03	185.05	8141.0
2023-11-14 08:00:00	AAPL	Stock	185.06	185.42	184.97	185.3	49216.0
2023-11-14 08:30:00	AAPL	Stock	185.28	188.1	185.1	187.8	388084.0
2023-11-14 09:00:00	AAPL	Stock	187.75	187.96	187.2	187.7	317399.0
2023-11-14 09:30:00	AAPL	Stock	187.69	187.73	186.3	187.26	7645428.0
2023-11-14 10:00:00	AAPL	Stock	187.265	187.52	187.0	187.45	3643292.0
2023-11-14 10:30:00	AAPL	Stock	187.44	187.48	186.85	187.025	2370083.0
2023-11-14 11:00:00	AAPL	Stock	187.03	187.16	186.68	186.9259	2060603.0
2023-11-14 11:30:00	AAPL	Stock	186.925	186.93	186.41	186.66	1975675.0
2023-11-14 12:00:00	AAPL	Stock	186.66	187.22	186.61	187.055	2012560.0
2023-11-14 12:30:00	AAPL	Stock	187.06	187.46	187.01	187.4301	1478423.0
2023-11-14 13:00:00	AAPL	Stock	187.44	187.5	187.11	187.46	1648300.0
2023-11-14 13:30:00	AAPL	Stock	187.46	187.49	187.175	187.1901	1746267.0
2023-11-14 14:00:00	AAPL	Stock	187.2	187.44	186.82	187.4137	1789640.0
2023-11-14 14:30:00	AAPL	Stock	187.415	187.99	187.415	187.905	2958102.0
2023-11-14 15:00:00	AAPL	Stock	187.9	188.11	187.76	187.92	3136966.0
2023-11-14 15:30:00	AAPL	Stock	187.925	188.03	187.21	187.44	5989415.0
2023-11-14 16:00:00	AAPL	Stock	187.44	187.57	187.21	187.41	8199931.0
2023-11-14 16:30:00	AAPL	Stock	187.4	187.44	187.13	187.2	87502.0
2023-11-14 17:00:00	AAPL	Stock	187.2	187.26	187.13	187.15	16960.0
2023-11-14 17:30:00	AAPL	Stock	187.18	187.32	187.18	187.25	12805.0
2023-11-14 18:00:00	AAPL	Stock	187.24	187.4309	187.21	187.39	12541.0
2023-11-14 18:30:00	AAPL	Stock	187.4	187.4	187.25	187.33	13055.0
2023-11-14 19:00:00	AAPL	Stock	187.31	187.34	187.18	187.19	8473.0
2023-11-14 19:30:00	AAPL	Stock	187.24	187.4	187.24	187.3301	10012.0
2023-11-14 04:00:00	MSFT	Stock	368.24	368.3	367.95	368.25	2537.0
2023-11-14 04:30:00	MSFT	Stock	368.04	368.1	367.82	367.82	3988.0
2023-11-14 05:00:00	MSFT	Stock	367.79	368.15	367.79	368.15	1907.0
2023-11-14 05:30:00	MSFT	Stock	367.8	368.0	367.8	367.91	1690.0
2023-11-14 06:00:00	MSFT	Stock	367.68	367.72	367.41	367.42	3644.0
2023-11-14 06:30:00	MSFT	Stock	367.3	367.5	367.3	367.3	3795.0
2023-11-14 07:00:00	MSFT	Stock	367.4	367.51	367.35	367.35	1148.0
2023-11-14 07:30:00	MSFT	Stock	367.41	367.41	366.7	367.03	10150.0
2023-11-14 08:00:00	MSFT	Stock	367.45	367.9	366.7	367.75	21804.0
2023-11-14 08:30:00	MSFT	Stock	367.4	373.0499	367.2	372.0	165200.0
2023-11-14 09:00:00	MSFT	Stock	371.88	372.6	371.0	371.02	119690.0
2023-11-14 09:30:00	MSFT	Stock	371.04	371.68	369.32	370.9	2740312.0
2023-11-14 10:00:00	MSFT	Stock	370.92	371.95	370.31	371.1	1387329.0
2023-11-14 10:30:00	MSFT	Stock	371.14	371.89	370.46	370.75	887924.0
2023-11-14 11:00:00	MSFT	Stock	370.74	371.6399	370.62	370.79	659547.0
2023-11-14 11:30:00	MSFT	Stock	370.84	370.95	368.61	368.69	964891.0
2023-11-14 12:00:00	MSFT	Stock	368.69	369.9	368.46	369.29	1063773.0
2023-11-14 12:30:00	MSFT	Stock	369.31	370.04	369.06	369.9	574948.0
2023-11-14 13:00:00	MSFT	Stock	369.91	370.36	369.76	370.24	530813.0

> showing 50 of 102,173 rows — these rows as CSV

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