PREVIEW / etf_30min / 2025-07-31

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-07-31.parquet
  size:    1023 KB
  rows:    42,798

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
2025-07-31 04:00:00	SPY	ETF	640.64	641.34	640.22	641.11	44518.0
2025-07-31 04:30:00	SPY	ETF	641.09	641.46	640.86	640.98	22178.0
2025-07-31 05:00:00	SPY	ETF	641.0	641.02	640.69	640.79	26850.0
2025-07-31 05:30:00	SPY	ETF	640.62	640.64	640.4	640.57	10861.0
2025-07-31 06:00:00	SPY	ETF	640.56	640.83	640.42	640.8	9822.0
2025-07-31 06:30:00	SPY	ETF	640.75	640.95	639.97	640.08	104365.0
2025-07-31 07:00:00	SPY	ETF	640.01	640.4	639.69	639.9	108894.0
2025-07-31 07:30:00	SPY	ETF	639.94	640.41	639.73	639.83	125847.0
2025-07-31 08:00:00	SPY	ETF	640.23	641.52	639.66	640.19	273931.0
2025-07-31 08:30:00	SPY	ETF	640.1	640.55	639.79	640.39	257117.0
2025-07-31 09:00:00	SPY	ETF	640.34	640.39	639.4	639.47	355771.0
2025-07-31 09:30:00	SPY	ETF	639.47	639.85	637.69	639.34	8730722.0
2025-07-31 10:00:00	SPY	ETF	639.345	639.809	638.495	638.82	4482730.0
2025-07-31 10:30:00	SPY	ETF	638.81	639.15	636.5099	636.61	4432843.0
2025-07-31 11:00:00	SPY	ETF	636.605	637.38	635.06	636.19	4827195.0
2025-07-31 11:30:00	SPY	ETF	636.19	637.55	636.11	637.54	2927755.0
2025-07-31 12:00:00	SPY	ETF	637.55	638.23	637.21	638.08	2218820.0
2025-07-31 12:30:00	SPY	ETF	638.0852	638.31	637.51	637.79	2480243.0
2025-07-31 13:00:00	SPY	ETF	637.78	637.79	634.41	634.84	3610763.0
2025-07-31 13:30:00	SPY	ETF	634.86	635.655	633.065	633.47	5561462.0
2025-07-31 14:00:00	SPY	ETF	633.47	634.26	631.43	634.21	6054724.0
2025-07-31 14:30:00	SPY	ETF	634.2	635.125	634.04	634.15	3767934.0
2025-07-31 15:00:00	SPY	ETF	634.16	634.85	632.62	632.78	4928071.0
2025-07-31 15:30:00	SPY	ETF	632.795	633.68	630.765	631.97	15348166.0
2025-07-31 16:00:00	SPY	ETF	631.97	634.2	630.65	631.36	3982591.0
2025-07-31 16:30:00	SPY	ETF	632.0	632.9	631.47	631.76	460244.0
2025-07-31 17:00:00	SPY	ETF	631.66	632.47	631.5	632.37	196144.0
2025-07-31 17:30:00	SPY	ETF	632.43	632.47	631.26	631.26	107296.0
2025-07-31 18:00:00	SPY	ETF	631.2	632.17	630.97	631.15	146824.0
2025-07-31 18:30:00	SPY	ETF	631.17	631.25	629.99	630.73	98804.0
2025-07-31 19:00:00	SPY	ETF	630.74	631.15	630.36	630.621	29842.0
2025-07-31 19:30:00	SPY	ETF	630.62	631.21	630.55	631.08	71476.0
2025-07-31 04:00:00	QQQ	ETF	576.05	577.0	575.84	575.96	87787.0
2025-07-31 04:30:00	QQQ	ETF	575.91	576.32	575.67	575.79	48520.0
2025-07-31 05:00:00	QQQ	ETF	575.82	575.93	575.58	575.8	43874.0
2025-07-31 05:30:00	QQQ	ETF	575.6	575.64	575.39	575.41	21042.0
2025-07-31 06:00:00	QQQ	ETF	575.44	575.74	575.36	575.72	13969.0
2025-07-31 06:30:00	QQQ	ETF	575.72	575.9	575.21	575.38	24715.0
2025-07-31 07:00:00	QQQ	ETF	575.25	575.8	575.05	575.07	91899.0
2025-07-31 07:30:00	QQQ	ETF	575.18	575.31	574.7	574.96	70984.0
2025-07-31 08:00:00	QQQ	ETF	574.98	576.93	574.7	575.73	200795.0
2025-07-31 08:30:00	QQQ	ETF	575.45	576.06	575.2	575.91	153517.0
2025-07-31 09:00:00	QQQ	ETF	575.91	575.92	574.48	574.54	235563.0
2025-07-31 09:30:00	QQQ	ETF	574.54	574.63	571.2	572.66	6599535.0
2025-07-31 10:00:00	QQQ	ETF	572.665	573.37	571.5	571.9301	2624288.0
2025-07-31 10:30:00	QQQ	ETF	571.93	572.32	569.42	569.58	2746750.0
2025-07-31 11:00:00	QQQ	ETF	569.57	570.59	568.175	569.42	3308730.0
2025-07-31 11:30:00	QQQ	ETF	569.43	570.6	569.3	570.6	1884691.0
2025-07-31 12:00:00	QQQ	ETF	570.6	571.35	570.33	571.14	1436160.0
2025-07-31 12:30:00	QQQ	ETF	571.15	571.42	569.975	570.275	1450573.0

> showing 50 of 42,798 rows — these rows as CSV

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