PREVIEW / stock_30min / 2023-11-13

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-11-13.parquet
  size:    2.0 MB
  rows:    97,310
  symbols: 1,305

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-13 04:00:00	AAPL	Stock	185.35	185.7	185.35	185.51	9912.0
2023-11-13 04:30:00	AAPL	Stock	185.59	185.61	185.59	185.61	541.0
2023-11-13 05:00:00	AAPL	Stock	185.6	185.65	185.55	185.65	1300.0
2023-11-13 05:30:00	AAPL	Stock	185.64	185.75	185.6	185.75	4136.0
2023-11-13 06:00:00	AAPL	Stock	185.74	185.75	185.56	185.56	3870.0
2023-11-13 06:30:00	AAPL	Stock	185.54	185.7	185.47	185.7	5769.0
2023-11-13 07:00:00	AAPL	Stock	185.7	186.26	185.7	186.1	65103.0
2023-11-13 07:30:00	AAPL	Stock	186.13	186.4	186.08	186.13	22891.0
2023-11-13 08:00:00	AAPL	Stock	185.7519	186.39	185.03	186.0	63002.0
2023-11-13 08:30:00	AAPL	Stock	186.09	186.16	185.62	185.69	51824.0
2023-11-13 09:00:00	AAPL	Stock	185.7	185.93	185.52	185.77	52213.0
2023-11-13 09:30:00	AAPL	Stock	185.77	186.03	184.27	184.6	5722322.0
2023-11-13 10:00:00	AAPL	Stock	184.6	184.86	184.21	184.7661	3265439.0
2023-11-13 10:30:00	AAPL	Stock	184.77	184.97	184.39	184.645	2552030.0
2023-11-13 11:00:00	AAPL	Stock	184.64	185.14	184.64	184.96	2263258.0
2023-11-13 11:30:00	AAPL	Stock	184.96	185.135	184.73	184.79	1975725.0
2023-11-13 12:00:00	AAPL	Stock	184.79	184.8961	184.5	184.565	1503343.0
2023-11-13 12:30:00	AAPL	Stock	184.57	184.9	184.39	184.82	1247511.0
2023-11-13 13:00:00	AAPL	Stock	184.82	184.9299	184.5486	184.56	1019466.0
2023-11-13 13:30:00	AAPL	Stock	184.57	184.99	184.46	184.7228	1377851.0
2023-11-13 14:00:00	AAPL	Stock	184.7275	185.01	184.6	184.9901	1144682.0
2023-11-13 14:30:00	AAPL	Stock	184.99	185.0	184.78	184.95	1311583.0
2023-11-13 15:00:00	AAPL	Stock	184.94	185.08	184.7299	184.95	1666281.0
2023-11-13 15:30:00	AAPL	Stock	184.96	185.01	184.6105	184.77	3528569.0
2023-11-13 16:00:00	AAPL	Stock	184.77	184.84	184.6	184.81	4863583.0
2023-11-13 16:30:00	AAPL	Stock	184.8198	184.83	184.66	184.72	43571.0
2023-11-13 17:00:00	AAPL	Stock	184.69	184.7868	184.69	184.77	8781.0
2023-11-13 17:30:00	AAPL	Stock	184.75	184.79	184.75	184.77	5238.0
2023-11-13 18:00:00	AAPL	Stock	184.71	184.75	184.71	184.74	1060.0
2023-11-13 18:30:00	AAPL	Stock	184.75	184.95	184.73	184.8999	14321.0
2023-11-13 19:00:00	AAPL	Stock	184.83	185.0	184.83	184.99	8056.0
2023-11-13 19:30:00	AAPL	Stock	184.99	185.02	184.9	185.02	5879.0
2023-11-13 04:00:00	MSFT	Stock	369.01	369.67	368.91	368.97	3733.0
2023-11-13 04:30:00	MSFT	Stock	369.5	369.65	369.42	369.48	1585.0
2023-11-13 05:00:00	MSFT	Stock	369.34	369.4	369.3	369.3	1922.0
2023-11-13 05:30:00	MSFT	Stock	369.3	369.7	369.24	369.61	1996.0
2023-11-13 06:00:00	MSFT	Stock	369.77	369.82	369.52	369.52	1069.0
2023-11-13 06:30:00	MSFT	Stock	369.48	369.66	369.47	369.66	949.0
2023-11-13 07:00:00	MSFT	Stock	369.5	369.73	368.6	368.7	20683.0
2023-11-13 07:30:00	MSFT	Stock	368.7	368.8	368.34	368.6	10038.0
2023-11-13 08:00:00	MSFT	Stock	369.55	369.8	367.69	368.9	39170.0
2023-11-13 08:30:00	MSFT	Stock	369.0	369.0	367.8	367.8156	26427.0
2023-11-13 09:00:00	MSFT	Stock	368.15	368.75	367.78	368.0	33724.0
2023-11-13 09:30:00	MSFT	Stock	368.13	368.47	365.9	366.53	2363172.0
2023-11-13 10:00:00	MSFT	Stock	366.59	367.16	366.11	366.5	1220136.0
2023-11-13 10:30:00	MSFT	Stock	366.47	368.04	366.35	367.76	1098422.0
2023-11-13 11:00:00	MSFT	Stock	367.7585	368.36	367.51	368.0	756890.0
2023-11-13 11:30:00	MSFT	Stock	367.97	368.2	367.23	367.3707	759950.0
2023-11-13 12:00:00	MSFT	Stock	367.425	367.86	366.93	367.3597	497755.0
2023-11-13 12:30:00	MSFT	Stock	367.3698	367.665	367.0	367.5649	336264.0

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

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