PREVIEW / etf_30min / 2026-07-24

all etf 30-min files

  file:    by_date/etf_30min/2026/2026-07-24.parquet
  size:    1.0 MB
  rows:    44,955

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
2026-07-24 04:00:00	SPY	ETF	739.84	740.47	737.68	740.01	45783.0
2026-07-24 04:30:00	SPY	ETF	739.98	740.321	739.77	739.9	9833.0
2026-07-24 05:00:00	SPY	ETF	739.9	740.64	739.82	740.5	8647.0
2026-07-24 05:30:00	SPY	ETF	740.54	740.84	740.37	740.8	11588.0
2026-07-24 06:00:00	SPY	ETF	740.69	740.79	740.12	740.37	27999.0
2026-07-24 06:30:00	SPY	ETF	740.49	740.58	739.98	740.1604	9698.0
2026-07-24 07:00:00	SPY	ETF	740.03	740.4	740.01	740.09	22105.0
2026-07-24 07:30:00	SPY	ETF	740.0714	740.94	739.5	740.63	82426.0
2026-07-24 08:00:00	SPY	ETF	740.7	740.88	739.95	740.72	68229.0
2026-07-24 08:30:00	SPY	ETF	740.58	741.02	739.08	739.15	112921.0
2026-07-24 09:00:00	SPY	ETF	739.27	739.45	738.46	738.49	179829.0
2026-07-24 09:30:00	SPY	ETF	738.54	739.88	737.43	737.53	3022616.0
2026-07-24 10:00:00	SPY	ETF	737.5	739.95	737.333	739.18	2857090.0
2026-07-24 10:30:00	SPY	ETF	739.19	740.7	737.43	740.59	2098262.0
2026-07-24 11:00:00	SPY	ETF	740.59	743.13	739.58	742.61	2763285.0
2026-07-24 11:30:00	SPY	ETF	742.6	743.25	742.0	743.015	1434181.0
2026-07-24 12:00:00	SPY	ETF	743.04	743.72	742.64	743.19	1312623.0
2026-07-24 12:30:00	SPY	ETF	743.17	743.19	740.74	741.45	1553419.0
2026-07-24 13:00:00	SPY	ETF	741.47	741.84	740.2301	741.71	1373082.0
2026-07-24 13:30:00	SPY	ETF	741.75	742.1692	740.92	740.98	947807.0
2026-07-24 14:00:00	SPY	ETF	740.99	741.29	739.0	739.035	1427897.0
2026-07-24 14:30:00	SPY	ETF	739.05	739.16	737.64	738.38	2544169.0
2026-07-24 15:00:00	SPY	ETF	738.39	738.895	737.29	737.65	3143392.0
2026-07-24 15:30:00	SPY	ETF	737.72	739.1	737.64	738.85	5650807.0
2026-07-24 16:00:00	SPY	ETF	738.86	739.07	738.23	738.47	1661769.0
2026-07-24 16:30:00	SPY	ETF	738.5	738.74	738.01	738.45	193649.0
2026-07-24 17:00:00	SPY	ETF	738.55	738.76	737.7	738.71	172716.0
2026-07-24 17:30:00	SPY	ETF	738.72	739.29	738.61	738.82	47140.0
2026-07-24 18:00:00	SPY	ETF	738.8849	738.97	738.63	738.75	13301.0
2026-07-24 18:30:00	SPY	ETF	738.75	739.06	738.59	738.6	24247.0
2026-07-24 19:00:00	SPY	ETF	738.59	738.93	738.55	738.57	2698.0
2026-07-24 19:30:00	SPY	ETF	738.56	738.69	738.22	738.66	17766.0
2026-07-24 04:00:00	QQQ	ETF	692.46	693.4	688.75	692.49	171166.0
2026-07-24 04:30:00	QQQ	ETF	692.43	693.14	692.21	692.35	33133.0
2026-07-24 05:00:00	QQQ	ETF	692.5131	693.91	692.31	693.77	53762.0
2026-07-24 05:30:00	QQQ	ETF	693.6892	694.44	693.6892	694.36	46704.0
2026-07-24 06:00:00	QQQ	ETF	694.39	694.48	693.2997	693.71	59229.0
2026-07-24 06:30:00	QQQ	ETF	693.57	693.99	692.75	692.83	40643.0
2026-07-24 07:00:00	QQQ	ETF	692.89	693.49	692.76	692.96	57331.0
2026-07-24 07:30:00	QQQ	ETF	692.96	694.26	692.0	693.82	77976.0
2026-07-24 08:00:00	QQQ	ETF	693.6	694.39	692.54	694.03	118397.0
2026-07-24 08:30:00	QQQ	ETF	694.03	694.08	691.64	691.74	115593.0
2026-07-24 09:00:00	QQQ	ETF	691.84	692.32	690.47	690.47	255100.0
2026-07-24 09:30:00	QQQ	ETF	690.44	692.45	685.025	685.22	4623154.0
2026-07-24 10:00:00	QQQ	ETF	685.17	688.29	684.64	686.88	2998394.0
2026-07-24 10:30:00	QQQ	ETF	686.9064	688.539	683.546	688.28	2294555.0
2026-07-24 11:00:00	QQQ	ETF	688.3	690.85	685.975	689.47	2877499.0
2026-07-24 11:30:00	QQQ	ETF	689.5	691.49	689.12	691.2804	1575886.0
2026-07-24 12:00:00	QQQ	ETF	691.3	692.63	690.65	691.07	1126660.0
2026-07-24 12:30:00	QQQ	ETF	691.03	691.11	688.505	689.32	1287678.0

> showing 50 of 44,955 rows — these rows as CSV

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