PREVIEW / stock_30min / 2023-07-13

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-07-13.parquet
  size:    2.1 MB
  rows:    103,329
  symbols: 1,577

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-07-13 04:00:00	AAPL	Stock	190.55	190.84	190.55	190.8	10196.0
2023-07-13 04:30:00	AAPL	Stock	190.8	190.86	190.73	190.85	6955.0
2023-07-13 05:00:00	AAPL	Stock	190.83	190.83	190.75	190.75	3812.0
2023-07-13 05:30:00	AAPL	Stock	190.76	190.76	190.55	190.67	8473.0
2023-07-13 06:00:00	AAPL	Stock	190.68	190.86	190.65	190.8	3813.0
2023-07-13 06:30:00	AAPL	Stock	190.8	190.8	190.72	190.72	2426.0
2023-07-13 07:00:00	AAPL	Stock	190.71	190.8	190.59	190.63	14915.0
2023-07-13 07:30:00	AAPL	Stock	190.61	190.75	190.57	190.75	15788.0
2023-07-13 08:00:00	AAPL	Stock	190.69	191.0993	190.15	191.01	145662.0
2023-07-13 08:30:00	AAPL	Stock	191.0	191.1	190.68	190.95	97770.0
2023-07-13 09:00:00	AAPL	Stock	190.95	191.05	190.35	190.42	167131.0
2023-07-13 09:30:00	AAPL	Stock	190.5	191.095	189.94	190.315	5394480.0
2023-07-13 10:00:00	AAPL	Stock	190.31	190.38	189.78	189.98	2926262.0
2023-07-13 10:30:00	AAPL	Stock	189.985	190.775	189.96	190.32	2321549.0
2023-07-13 11:00:00	AAPL	Stock	190.32	190.42	190.07	190.17	1306844.0
2023-07-13 11:30:00	AAPL	Stock	190.175	190.71	190.04	190.63	1635427.0
2023-07-13 12:00:00	AAPL	Stock	190.6301	190.77	190.48	190.675	1231205.0
2023-07-13 12:30:00	AAPL	Stock	190.67	190.845	190.33	190.42	1237656.0
2023-07-13 13:00:00	AAPL	Stock	190.41	190.7	190.3525	190.665	1185906.0
2023-07-13 13:30:00	AAPL	Stock	190.665	190.76	190.53	190.575	956058.0
2023-07-13 14:00:00	AAPL	Stock	190.5797	190.8792	190.54	190.58	1286695.0
2023-07-13 14:30:00	AAPL	Stock	190.59	190.73	190.5	190.67	1137945.0
2023-07-13 15:00:00	AAPL	Stock	190.67	191.19	190.63	190.89	2526565.0
2023-07-13 15:30:00	AAPL	Stock	190.89	191.08	190.53	190.54	4313511.0
2023-07-13 16:00:00	AAPL	Stock	190.54	190.59	190.359	190.4	4657362.0
2023-07-13 16:30:00	AAPL	Stock	190.4	190.54	190.32	190.33	30615.0
2023-07-13 17:00:00	AAPL	Stock	190.36	190.5	190.31	190.48	22212.0
2023-07-13 17:30:00	AAPL	Stock	190.45	190.5	190.42	190.45	6409.0
2023-07-13 18:00:00	AAPL	Stock	190.45	190.55	190.4	190.4799	14702.0
2023-07-13 18:30:00	AAPL	Stock	190.45	190.48	190.33	190.44	9178.0
2023-07-13 19:00:00	AAPL	Stock	190.38	190.49	190.38	190.41	2676.0
2023-07-13 19:30:00	AAPL	Stock	190.4	190.5	190.3	190.31	12844.0
2023-07-13 04:00:00	MSFT	Stock	339.12	339.24	338.54	339.24	1674.0
2023-07-13 04:30:00	MSFT	Stock	339.0	339.15	339.0	339.14	703.0
2023-07-13 05:00:00	MSFT	Stock	339.24	339.78	339.21	339.78	985.0
2023-07-13 05:30:00	MSFT	Stock	339.82	339.99	339.51	339.51	1463.0
2023-07-13 06:00:00	MSFT	Stock	339.91	339.98	339.91	339.98	499.0
2023-07-13 06:30:00	MSFT	Stock	340.0	340.04	339.17	339.17	1605.0
2023-07-13 07:00:00	MSFT	Stock	339.4	339.7	339.31	339.7	5512.0
2023-07-13 07:30:00	MSFT	Stock	339.7	339.9	339.43	339.43	9878.0
2023-07-13 08:00:00	MSFT	Stock	339.44	339.9047	338.46	339.9047	44661.0
2023-07-13 08:30:00	MSFT	Stock	339.56	340.28	338.72	339.1	42766.0
2023-07-13 09:00:00	MSFT	Stock	339.12	339.84	338.14	339.65	63176.0
2023-07-13 09:30:00	MSFT	Stock	339.56	342.47	339.02	340.7081	2863048.0
2023-07-13 10:00:00	MSFT	Stock	340.74	341.17	339.73	339.89	1019116.0
2023-07-13 10:30:00	MSFT	Stock	339.89	341.53	339.8835	341.425	885657.0
2023-07-13 11:00:00	MSFT	Stock	341.44	341.934	340.8	340.925	788943.0
2023-07-13 11:30:00	MSFT	Stock	340.945	341.56	340.69	341.095	599046.0
2023-07-13 12:00:00	MSFT	Stock	341.12	341.61	340.88	341.52	711607.0
2023-07-13 12:30:00	MSFT	Stock	341.52	342.17	341.0	341.14	639435.0

> showing 50 of 103,329 rows — these rows as CSV

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