PREVIEW / stock_30min / 2024-07-22

all stock 30-min files

  file:    by_date/stock_30min/2024/2024-07-22.parquet
  size:    2.0 MB
  rows:    99,093
  symbols: 893

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
2024-07-22 04:00:00	AAPL	Stock	224.35	225.45	224.35	225.34	5678.0
2024-07-22 04:30:00	AAPL	Stock	225.38	225.55	225.38	225.4	4017.0
2024-07-22 05:00:00	AAPL	Stock	225.4	225.49	225.4	225.49	1440.0
2024-07-22 05:30:00	AAPL	Stock	225.49	225.65	225.4	225.65	3486.0
2024-07-22 06:00:00	AAPL	Stock	225.62	226.79	225.61	226.5	5781.0
2024-07-22 06:30:00	AAPL	Stock	226.66	226.8	226.5	226.5	9000.0
2024-07-22 07:00:00	AAPL	Stock	226.5	226.79	226.29	226.73	19115.0
2024-07-22 07:30:00	AAPL	Stock	226.7	226.83	226.48	226.78	14550.0
2024-07-22 08:00:00	AAPL	Stock	226.4091	227.45	224.72	227.43	130438.0
2024-07-22 08:30:00	AAPL	Stock	227.43	227.55	226.72	226.8	84438.0
2024-07-22 09:00:00	AAPL	Stock	226.8	227.2997	226.77	227.0	82631.0
2024-07-22 09:30:00	AAPL	Stock	226.99	227.75	225.58	226.71	4868780.0
2024-07-22 10:00:00	AAPL	Stock	226.7	227.78	226.195	226.8	2803909.0
2024-07-22 10:30:00	AAPL	Stock	226.8	227.1251	225.77	225.96	2129444.0
2024-07-22 11:00:00	AAPL	Stock	225.96	226.23	223.72	223.8299	3003440.0
2024-07-22 11:30:00	AAPL	Stock	223.78	224.14	223.22	224.0007	2479951.0
2024-07-22 12:00:00	AAPL	Stock	224.0	224.06	223.09	223.835	1696206.0
2024-07-22 12:30:00	AAPL	Stock	223.83	224.34	223.7	224.28	1358211.0
2024-07-22 13:00:00	AAPL	Stock	224.31	224.59	224.0002	224.39	1403118.0
2024-07-22 13:30:00	AAPL	Stock	224.37	225.24	224.33	225.19	1299274.0
2024-07-22 14:00:00	AAPL	Stock	225.21	225.43	224.92	225.05	1178030.0
2024-07-22 14:30:00	AAPL	Stock	225.06	225.63	225.06	225.14	1119307.0
2024-07-22 15:00:00	AAPL	Stock	225.14	225.21	224.63	224.68	1362540.0
2024-07-22 15:30:00	AAPL	Stock	224.68	225.04	223.78	223.93	3473392.0
2024-07-22 16:00:00	AAPL	Stock	223.95	224.1493	223.51	223.95	7249391.0
2024-07-22 16:30:00	AAPL	Stock	223.93	224.1	223.9101	224.03	758109.0
2024-07-22 17:00:00	AAPL	Stock	224.02	224.05	224.0	224.0234	5409.0
2024-07-22 17:30:00	AAPL	Stock	224.0	224.19	224.0	224.02	6954.0
2024-07-22 18:00:00	AAPL	Stock	224.1	224.19	224.02	224.18	3901.0
2024-07-22 18:30:00	AAPL	Stock	224.16	224.24	224.13	224.16	6520.0
2024-07-22 19:00:00	AAPL	Stock	224.1597	224.2	224.01	224.1	5691.0
2024-07-22 19:30:00	AAPL	Stock	224.06	224.09	223.8	223.89	12611.0
2024-07-22 04:00:00	MSFT	Stock	437.61	440.22	437.61	440.22	3947.0
2024-07-22 04:30:00	MSFT	Stock	440.39	440.7	440.38	440.38	906.0
2024-07-22 05:00:00	MSFT	Stock	440.31	440.51	440.05	440.05	950.0
2024-07-22 05:30:00	MSFT	Stock	440.43	440.43	440.08	440.19	1312.0
2024-07-22 06:00:00	MSFT	Stock	440.25	440.28	439.9	440.15	2566.0
2024-07-22 06:30:00	MSFT	Stock	440.05	440.39	440.0	440.3	2840.0
2024-07-22 07:00:00	MSFT	Stock	440.13	440.3	439.12	439.6	9764.0
2024-07-22 07:30:00	MSFT	Stock	439.49	440.4	439.49	440.2	5359.0
2024-07-22 08:00:00	MSFT	Stock	440.25	440.42	437.67	440.3	19121.0
2024-07-22 08:30:00	MSFT	Stock	440.3	440.37	440.0	440.1498	11030.0
2024-07-22 09:00:00	MSFT	Stock	440.11	442.4	439.99	442.02	27207.0
2024-07-22 09:30:00	MSFT	Stock	441.58	443.9	440.15	443.3127	1510210.0
2024-07-22 10:00:00	MSFT	Stock	443.315	443.86	441.8301	443.72	656354.0
2024-07-22 10:30:00	MSFT	Stock	443.755	444.6	442.5	442.56	551742.0
2024-07-22 11:00:00	MSFT	Stock	442.57	443.56	439.73	440.0452	491788.0
2024-07-22 11:30:00	MSFT	Stock	440.0299	440.13	438.9125	440.08	368977.0
2024-07-22 12:00:00	MSFT	Stock	440.01	441.08	439.27	440.56	249644.0
2024-07-22 12:30:00	MSFT	Stock	440.54	442.73	440.54	442.4	261517.0

> showing 50 of 99,093 rows — these rows as CSV

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