PREVIEW / etf_30min / 2026-07-06

all etf 30-min files

  file:    by_date/etf_30min/2026/2026-07-06.parquet
  size:    1.0 MB
  rows:    45,655

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-06 04:00:00	SPY	ETF	747.5	748.81	746.25	748.4	47303.0
2026-07-06 04:30:00	SPY	ETF	748.4	748.55	748.06	748.47	8877.0
2026-07-06 05:00:00	SPY	ETF	748.47	748.64	748.14	748.51	13935.0
2026-07-06 05:30:00	SPY	ETF	748.48	748.76	748.0	748.75	18879.0
2026-07-06 06:00:00	SPY	ETF	748.72	748.85	748.3	748.5	21692.0
2026-07-06 06:30:00	SPY	ETF	748.5	748.76	748.21	748.46	7211.0
2026-07-06 07:00:00	SPY	ETF	748.501	748.7198	748.0501	748.2	56744.0
2026-07-06 07:30:00	SPY	ETF	748.2	748.39	747.77	747.78	50560.0
2026-07-06 08:00:00	SPY	ETF	747.78	748.68	747.67	748.02	115159.0
2026-07-06 08:30:00	SPY	ETF	747.98	748.5	747.87	748.38	91960.0
2026-07-06 09:00:00	SPY	ETF	748.44	748.58	747.4	748.52	113956.0
2026-07-06 09:30:00	SPY	ETF	748.69	749.54	747.41	748.5	4332953.0
2026-07-06 10:00:00	SPY	ETF	748.54	749.98	747.97	749.93	2064950.0
2026-07-06 10:30:00	SPY	ETF	749.9301	750.275	749.1	750.275	1944907.0
2026-07-06 11:00:00	SPY	ETF	750.28	750.81	749.61	750.76	2151548.0
2026-07-06 11:30:00	SPY	ETF	750.78	750.97	750.35	750.84	1822699.0
2026-07-06 12:00:00	SPY	ETF	750.83	751.12	750.55	750.65	1579042.0
2026-07-06 12:30:00	SPY	ETF	750.65	751.08	750.37	750.46	1364020.0
2026-07-06 13:00:00	SPY	ETF	750.48	751.53	750.405	750.7	1424942.0
2026-07-06 13:30:00	SPY	ETF	750.7	750.75	749.63	750.1299	1383117.0
2026-07-06 14:00:00	SPY	ETF	750.13	751.6064	750.13	751.33	1683020.0
2026-07-06 14:30:00	SPY	ETF	751.33	752.025	751.01	751.93	1544568.0
2026-07-06 15:00:00	SPY	ETF	751.94	752.41	751.66	752.29	2658252.0
2026-07-06 15:30:00	SPY	ETF	752.28	752.29	750.77	751.3	8685687.0
2026-07-06 16:00:00	SPY	ETF	751.32	751.9	751.0465	751.56	2669609.0
2026-07-06 16:30:00	SPY	ETF	751.6	751.84	751.47	751.67	220470.0
2026-07-06 17:00:00	SPY	ETF	751.64	751.85	751.5647	751.78	37855.0
2026-07-06 17:30:00	SPY	ETF	751.81	751.85	751.78	751.8	14601.0
2026-07-06 18:00:00	SPY	ETF	751.8	752.15	751.66	751.86	41526.0
2026-07-06 18:30:00	SPY	ETF	751.79	752.02	751.35	751.48	16187.0
2026-07-06 19:00:00	SPY	ETF	751.55	751.85	751.24	751.45	18457.0
2026-07-06 19:30:00	SPY	ETF	751.38	751.38	750.52	750.66	21018.0
2026-07-06 04:00:00	QQQ	ETF	720.33	721.08	716.84	719.87	174352.0
2026-07-06 04:30:00	QQQ	ETF	719.88	720.8	719.39	720.8	23676.0
2026-07-06 05:00:00	QQQ	ETF	720.65	720.88	720.28	720.56	28151.0
2026-07-06 05:30:00	QQQ	ETF	720.69	721.14	719.74	720.94	26263.0
2026-07-06 06:00:00	QQQ	ETF	720.95	721.39	720.39	720.56	27598.0
2026-07-06 06:30:00	QQQ	ETF	720.65	721.13	720.31	721.13	31877.0
2026-07-06 07:00:00	QQQ	ETF	721.1	721.39	720.13	721.06	83170.0
2026-07-06 07:30:00	QQQ	ETF	720.94	721.79	720.77	720.98	85690.0
2026-07-06 08:00:00	QQQ	ETF	720.91	722.35	720.66	721.31	224046.0
2026-07-06 08:30:00	QQQ	ETF	721.25	722.25	721.2	722.25	98348.0
2026-07-06 09:00:00	QQQ	ETF	722.22	722.3	719.6	719.84	267777.0
2026-07-06 09:30:00	QQQ	ETF	719.84	723.99	718.45	722.18	4545013.0
2026-07-06 10:00:00	QQQ	ETF	722.27	724.835	721.5	724.1	2126268.0
2026-07-06 10:30:00	QQQ	ETF	724.15	725.4184	723.52	724.41	1617910.0
2026-07-06 11:00:00	QQQ	ETF	724.54	725.32	722.44	725.28	1345095.0
2026-07-06 11:30:00	QQQ	ETF	725.28	725.84	724.6101	725.58	1208570.0
2026-07-06 12:00:00	QQQ	ETF	725.57	726.08	724.45	724.6	680764.0
2026-07-06 12:30:00	QQQ	ETF	724.64	724.9	723.41	723.58	763847.0

> showing 50 of 45,655 rows — these rows as CSV

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