PREVIEW / stock_30min / 2023-12-14

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-12-14.parquet
  size:    2.2 MB
  rows:    107,438
  symbols: 1,274

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-12-14 04:00:00	AAPL	Stock	198.53	198.6	197.95	198.02	24917.0
2023-12-14 04:30:00	AAPL	Stock	197.98	198.0	197.8	197.99	4937.0
2023-12-14 05:00:00	AAPL	Stock	197.99	198.19	197.91	198.17	6458.0
2023-12-14 05:30:00	AAPL	Stock	198.17	198.28	198.16	198.19	6423.0
2023-12-14 06:00:00	AAPL	Stock	198.09	198.1	197.83	197.83	8866.0
2023-12-14 06:30:00	AAPL	Stock	197.83	197.95	197.78	197.95	5117.0
2023-12-14 07:00:00	AAPL	Stock	197.98	198.15	197.93	198.02	39725.0
2023-12-14 07:30:00	AAPL	Stock	198.07	198.15	197.97	198.0	16763.0
2023-12-14 08:00:00	AAPL	Stock	197.98	198.97	197.95	198.1	138912.0
2023-12-14 08:30:00	AAPL	Stock	198.08	198.3	197.9	198.26	111443.0
2023-12-14 09:00:00	AAPL	Stock	198.26	198.33	197.5	198.06	320286.0
2023-12-14 09:30:00	AAPL	Stock	198.01	199.62	198.0	199.2	9561064.0
2023-12-14 10:00:00	AAPL	Stock	199.19	199.6	198.745	198.79	5564923.0
2023-12-14 10:30:00	AAPL	Stock	198.8	199.385	198.6584	199.12	3337811.0
2023-12-14 11:00:00	AAPL	Stock	199.125	199.215	198.145	198.36	3159262.0
2023-12-14 11:30:00	AAPL	Stock	198.355	198.56	197.76	197.7979	2535524.0
2023-12-14 12:00:00	AAPL	Stock	197.795	198.49	197.59	198.4	2245113.0
2023-12-14 12:30:00	AAPL	Stock	198.39	198.56	197.7	197.71	1919275.0
2023-12-14 13:00:00	AAPL	Stock	197.71	197.71	196.715	196.855	2601193.0
2023-12-14 13:30:00	AAPL	Stock	196.85	197.19	196.16	196.7977	1980414.0
2023-12-14 14:00:00	AAPL	Stock	196.795	197.9	196.77	197.895	2146182.0
2023-12-14 14:30:00	AAPL	Stock	197.895	197.905	197.235	197.715	1947990.0
2023-12-14 15:00:00	AAPL	Stock	197.72	198.0799	197.69	197.9101	2493455.0
2023-12-14 15:30:00	AAPL	Stock	197.91	198.16	197.56	198.14	5862013.0
2023-12-14 16:00:00	AAPL	Stock	198.11	198.27	197.85	197.98	7594386.0
2023-12-14 16:30:00	AAPL	Stock	197.99	198.11	197.92	198.0	44854.0
2023-12-14 17:00:00	AAPL	Stock	198.0	198.02	197.86	197.86	13833.0
2023-12-14 17:30:00	AAPL	Stock	197.9	197.953	197.81	197.89	3881.0
2023-12-14 18:00:00	AAPL	Stock	197.94	198.08	197.8	198.0	14729.0
2023-12-14 18:30:00	AAPL	Stock	198.0483	198.0483	197.92	197.94	4105.0
2023-12-14 19:00:00	AAPL	Stock	197.92	198.14	197.92	198.13	5502.0
2023-12-14 19:30:00	AAPL	Stock	198.1	198.14	197.9	197.9	11087.0
2023-12-14 04:00:00	MSFT	Stock	376.0	376.0	375.22	375.22	3251.0
2023-12-14 04:30:00	MSFT	Stock	375.17	375.25	375.16	375.25	1862.0
2023-12-14 05:00:00	MSFT	Stock	375.24	375.24	375.05	375.1	1300.0
2023-12-14 05:30:00	MSFT	Stock	375.07	375.5	375.07	375.5	2593.0
2023-12-14 06:00:00	MSFT	Stock	375.43	375.43	375.1	375.1	1639.0
2023-12-14 06:30:00	MSFT	Stock	375.3	375.48	375.2	375.4	2931.0
2023-12-14 07:00:00	MSFT	Stock	375.4	375.77	375.4	375.45	11589.0
2023-12-14 07:30:00	MSFT	Stock	375.45	375.45	374.5	374.5	18682.0
2023-12-14 08:00:00	MSFT	Stock	375.65	376.2	374.28	374.88	43363.0
2023-12-14 08:30:00	MSFT	Stock	374.75	375.17	374.15	374.9	32876.0
2023-12-14 09:00:00	MSFT	Stock	374.93	375.5	372.95	373.31	94643.0
2023-12-14 09:30:00	MSFT	Stock	373.31	373.76	369.685	370.27	4752928.0
2023-12-14 10:00:00	MSFT	Stock	370.315	370.315	368.24	368.355	2489516.0
2023-12-14 10:30:00	MSFT	Stock	368.35	369.66	367.65	369.17	1863364.0
2023-12-14 11:00:00	MSFT	Stock	369.17	369.25	366.05	366.51	2067341.0
2023-12-14 11:30:00	MSFT	Stock	366.5	367.72	366.405	367.1	1309754.0
2023-12-14 12:00:00	MSFT	Stock	367.1	367.6319	366.54	367.57	1100329.0
2023-12-14 12:30:00	MSFT	Stock	367.57	368.04	366.54	366.55	1033651.0

> showing 50 of 107,438 rows — these rows as CSV

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