PREVIEW / stock_30min / 2023-07-28

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-07-28.parquet
  size:    2.1 MB
  rows:    100,451
  symbols: 1,529

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-28 04:00:00	AAPL	Stock	194.03	194.48	194.03	194.3	9955.0
2023-07-28 04:30:00	AAPL	Stock	194.32	194.67	194.32	194.67	7326.0
2023-07-28 05:00:00	AAPL	Stock	194.55	194.55	194.44	194.45	2036.0
2023-07-28 05:30:00	AAPL	Stock	194.5	194.9	194.5	194.9	5488.0
2023-07-28 06:00:00	AAPL	Stock	194.9	194.9	194.7	194.7	3624.0
2023-07-28 06:30:00	AAPL	Stock	194.65	194.88	194.65	194.88	2740.0
2023-07-28 07:00:00	AAPL	Stock	194.76	194.79	194.65	194.72	14746.0
2023-07-28 07:30:00	AAPL	Stock	194.7	194.75	194.6	194.69	13522.0
2023-07-28 08:00:00	AAPL	Stock	194.75	194.99	193.84	194.95	115308.0
2023-07-28 08:30:00	AAPL	Stock	194.98	195.2	194.8	195.05	74272.0
2023-07-28 09:00:00	AAPL	Stock	195.05	195.25	194.6	194.7	100138.0
2023-07-28 09:30:00	AAPL	Stock	194.7	195.98	194.14	195.65	5177696.0
2023-07-28 10:00:00	AAPL	Stock	195.66	196.06	195.43	195.62	3240098.0
2023-07-28 10:30:00	AAPL	Stock	195.62	196.15	195.31	195.72	2233865.0
2023-07-28 11:00:00	AAPL	Stock	195.73	196.4479	195.7	196.2	2111983.0
2023-07-28 11:30:00	AAPL	Stock	196.2	196.626	196.1	196.51	1843889.0
2023-07-28 12:00:00	AAPL	Stock	196.52	196.52	196.09	196.4211	1490330.0
2023-07-28 12:30:00	AAPL	Stock	196.42	196.4299	195.88	195.945	1355875.0
2023-07-28 13:00:00	AAPL	Stock	195.94	195.95	195.55	195.59	1151722.0
2023-07-28 13:30:00	AAPL	Stock	195.58	195.77	195.03	195.725	1807619.0
2023-07-28 14:00:00	AAPL	Stock	195.73	196.1417	195.6802	196.0902	1372466.0
2023-07-28 14:30:00	AAPL	Stock	196.09	196.2	195.545	195.93	1465590.0
2023-07-28 15:00:00	AAPL	Stock	195.925	196.15	195.74	195.765	1741034.0
2023-07-28 15:30:00	AAPL	Stock	195.765	196.0	195.42	195.84	4926998.0
2023-07-28 16:00:00	AAPL	Stock	195.83	195.86	195.44	195.77	6977188.0
2023-07-28 16:30:00	AAPL	Stock	195.77	195.83	195.62	195.66	118320.0
2023-07-28 17:00:00	AAPL	Stock	195.66	195.83	195.63	195.7102	335512.0
2023-07-28 17:30:00	AAPL	Stock	195.75	195.78	195.65	195.77	13008.0
2023-07-28 18:00:00	AAPL	Stock	195.73	195.8	195.73	195.78	10524.0
2023-07-28 18:30:00	AAPL	Stock	195.8	195.86	195.76	195.85	5735.0
2023-07-28 19:00:00	AAPL	Stock	195.85	195.89	195.82	195.82	3674.0
2023-07-28 19:30:00	AAPL	Stock	195.8	195.94	195.78	195.89	10200.0
2023-07-28 04:00:00	MSFT	Stock	332.01	333.33	332.01	332.6	6922.0
2023-07-28 04:30:00	MSFT	Stock	332.7	333.08	332.7	333.0	487.0
2023-07-28 05:00:00	MSFT	Stock	332.91	333.0	332.9	333.0	2484.0
2023-07-28 05:30:00	MSFT	Stock	332.98	333.2	332.95	333.2	3671.0
2023-07-28 06:00:00	MSFT	Stock	333.4	334.0	333.4	333.98	4871.0
2023-07-28 06:30:00	MSFT	Stock	333.61	334.05	333.4	334.01	4815.0
2023-07-28 07:00:00	MSFT	Stock	333.84	333.85	333.16	333.5	23341.0
2023-07-28 07:30:00	MSFT	Stock	333.4	333.5	333.11	333.33	9408.0
2023-07-28 08:00:00	MSFT	Stock	333.87	333.885	332.0	333.6	86123.0
2023-07-28 08:30:00	MSFT	Stock	333.5	333.6	332.7	333.36	42284.0
2023-07-28 09:00:00	MSFT	Stock	333.22	333.81	332.97	333.75	44616.0
2023-07-28 09:30:00	MSFT	Stock	333.67	337.07	333.17	335.67	4142037.0
2023-07-28 10:00:00	MSFT	Stock	335.72	337.52	335.685	337.16	1762482.0
2023-07-28 10:30:00	MSFT	Stock	337.1349	337.66	335.1401	336.24	1448475.0
2023-07-28 11:00:00	MSFT	Stock	336.26	337.85	336.26	337.66	1086013.0
2023-07-28 11:30:00	MSFT	Stock	337.64	340.01	337.42	339.25	1610774.0
2023-07-28 12:00:00	MSFT	Stock	339.1701	339.26	338.07	339.215	1129759.0
2023-07-28 12:30:00	MSFT	Stock	339.21	339.4	338.5701	338.69	656308.0

> showing 50 of 100,451 rows — these rows as CSV

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