PREVIEW / etf_30min / 2026-07-17

all etf 30-min files

  file:    by_date/etf_30min/2026/2026-07-17.parquet
  size:    1.0 MB
  rows:    47,125

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-17 04:00:00	SPY	ETF	745.82	745.82	743.0	743.52	125265.0
2026-07-17 04:30:00	SPY	ETF	743.49	743.91	742.58	743.4199	30986.0
2026-07-17 05:00:00	SPY	ETF	743.37	744.51	743.19	744.49	25666.0
2026-07-17 05:30:00	SPY	ETF	744.45	744.54	743.8	744.51	76076.0
2026-07-17 06:00:00	SPY	ETF	744.49	745.21	744.23	745.06	113394.0
2026-07-17 06:30:00	SPY	ETF	745.06	745.68	745.035	745.24	26974.0
2026-07-17 07:00:00	SPY	ETF	745.251	745.64	744.47	745.22	80105.0
2026-07-17 07:30:00	SPY	ETF	745.14	745.55	744.7	745.36	57483.0
2026-07-17 08:00:00	SPY	ETF	745.34	745.45	744.25	744.49	111401.0
2026-07-17 08:30:00	SPY	ETF	744.38	744.57	743.77	743.94	177095.0
2026-07-17 09:00:00	SPY	ETF	743.89	743.89	741.88	742.04	512171.0
2026-07-17 09:30:00	SPY	ETF	742.05	744.83	740.8	744.8101	6792106.0
2026-07-17 10:00:00	SPY	ETF	744.81	747.29	744.6701	746.335	3447606.0
2026-07-17 10:30:00	SPY	ETF	746.34	746.79	744.85	745.05	2397529.0
2026-07-17 11:00:00	SPY	ETF	745.05	745.57	743.96	745.445	1928211.0
2026-07-17 11:30:00	SPY	ETF	745.44	747.06	744.4401	746.87	1926152.0
2026-07-17 12:00:00	SPY	ETF	746.88	747.1	744.83	745.94	2074960.0
2026-07-17 12:30:00	SPY	ETF	745.95	747.27	745.54	746.32	1401349.0
2026-07-17 13:00:00	SPY	ETF	746.37	747.17	745.97	746.87	1539775.0
2026-07-17 13:30:00	SPY	ETF	746.88	746.99	744.38	744.58	1581879.0
2026-07-17 14:00:00	SPY	ETF	744.58	745.14	743.24	743.71	1996878.0
2026-07-17 14:30:00	SPY	ETF	743.69	744.66	743.095	744.37	1776290.0
2026-07-17 15:00:00	SPY	ETF	744.39	744.47	742.13	743.16	2397869.0
2026-07-17 15:30:00	SPY	ETF	743.17	744.4	742.6	743.23	6732657.0
2026-07-17 16:00:00	SPY	ETF	743.18	743.29	742.0	742.81	5353485.0
2026-07-17 16:30:00	SPY	ETF	742.8192	743.26	742.781	743.18	289266.0
2026-07-17 17:00:00	SPY	ETF	743.13	743.13	742.75	742.98	137539.0
2026-07-17 17:30:00	SPY	ETF	742.96	743.34	742.96	743.16	124482.0
2026-07-17 18:00:00	SPY	ETF	743.19	743.4	743.02	743.33	12471.0
2026-07-17 18:30:00	SPY	ETF	743.24	743.76	743.16	743.57	18913.0
2026-07-17 19:00:00	SPY	ETF	743.36	743.5	743.06	743.16	13224.0
2026-07-17 19:30:00	SPY	ETF	743.1699	743.1753	742.42	742.5	36272.0
2026-07-17 04:00:00	QQQ	ETF	693.48	698.9	690.9	691.7	478346.0
2026-07-17 04:30:00	QQQ	ETF	691.6	692.82	690.28	692.08	96694.0
2026-07-17 05:00:00	QQQ	ETF	691.99	694.0	691.88	693.5899	88964.0
2026-07-17 05:30:00	QQQ	ETF	693.46	694.5	692.92	694.04	93692.0
2026-07-17 06:00:00	QQQ	ETF	693.94	695.95	693.65	695.55	239396.0
2026-07-17 06:30:00	QQQ	ETF	695.54	696.8	695.38	695.8979	139325.0
2026-07-17 07:00:00	QQQ	ETF	695.88	696.44	694.51	695.1361	143689.0
2026-07-17 07:30:00	QQQ	ETF	695.1245	695.28	694.22	694.78	99412.0
2026-07-17 08:00:00	QQQ	ETF	694.82	694.93	692.9	693.17	177214.0
2026-07-17 08:30:00	QQQ	ETF	693.25	693.5697	692.51	693.09	203266.0
2026-07-17 09:00:00	QQQ	ETF	692.9	692.9	691.0	691.44	471518.0
2026-07-17 09:30:00	QQQ	ETF	691.54	693.54	686.76	693.35	7400762.0
2026-07-17 10:00:00	QQQ	ETF	693.42	698.42	693.04	697.0299	4450530.0
2026-07-17 10:30:00	QQQ	ETF	697.055	698.57	694.35	694.47	2082347.0
2026-07-17 11:00:00	QQQ	ETF	694.54	695.28	693.13	695.045	1859423.0
2026-07-17 11:30:00	QQQ	ETF	695.135	699.87	694.31	699.49	1924323.0
2026-07-17 12:00:00	QQQ	ETF	699.49	700.05	697.35	699.0	2063964.0
2026-07-17 12:30:00	QQQ	ETF	698.98	701.77	698.35	700.5	1677913.0

> showing 50 of 47,125 rows — these rows as CSV

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