PREVIEW / etf_30min / 2026-07-02

all etf 30-min files

  file:    by_date/etf_30min/2026/2026-07-02.parquet
  size:    1.1 MB
  rows:    45,965

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-02 04:00:00	SPY	ETF	745.24	747.4	744.01	745.7	58733.0
2026-07-02 04:30:00	SPY	ETF	745.57	746.41	745.44	746.17	11724.0
2026-07-02 05:00:00	SPY	ETF	746.13	746.14	745.48	745.75	9137.0
2026-07-02 05:30:00	SPY	ETF	745.69	746.16	745.61	745.63	15896.0
2026-07-02 06:00:00	SPY	ETF	745.62	745.75	745.2	745.5501	5816.0
2026-07-02 06:30:00	SPY	ETF	745.77	746.3	745.77	746.22	11345.0
2026-07-02 07:00:00	SPY	ETF	746.171	746.34	745.8	746.2296	69313.0
2026-07-02 07:30:00	SPY	ETF	746.11	746.84	746.11	746.2665	36353.0
2026-07-02 08:00:00	SPY	ETF	746.15	747.46	746.03	747.27	66057.0
2026-07-02 08:30:00	SPY	ETF	747.6	749.54	746.8	748.0565	585593.0
2026-07-02 09:00:00	SPY	ETF	748.1	748.47	747.24	747.4	257325.0
2026-07-02 09:30:00	SPY	ETF	747.4	751.245	747.1	750.76	3747272.0
2026-07-02 10:00:00	SPY	ETF	750.78	751.31	747.61	747.94	2847994.0
2026-07-02 10:30:00	SPY	ETF	747.95	749.38	746.015	747.66	2657888.0
2026-07-02 11:00:00	SPY	ETF	747.65	747.828	744.2	744.91	2825650.0
2026-07-02 11:30:00	SPY	ETF	744.88	746.71	744.05	744.645	1767967.0
2026-07-02 12:00:00	SPY	ETF	744.65	744.87	743.37	743.54	1338749.0
2026-07-02 12:30:00	SPY	ETF	743.56	743.57	741.81	742.18	1856264.0
2026-07-02 13:00:00	SPY	ETF	742.2	742.28	740.37	741.53	1972178.0
2026-07-02 13:30:00	SPY	ETF	741.54	742.1	740.03	740.24	1603740.0
2026-07-02 14:00:00	SPY	ETF	740.26	742.9	740.05	742.72	1785515.0
2026-07-02 14:30:00	SPY	ETF	742.71	743.51	742.53	742.9895	1349418.0
2026-07-02 15:00:00	SPY	ETF	742.99	743.1302	741.27	742.31	1957684.0
2026-07-02 15:30:00	SPY	ETF	742.33	745.58	742.17	744.8	8414103.0
2026-07-02 16:00:00	SPY	ETF	744.8799	745.5312	743.98	744.2	3727003.0
2026-07-02 16:30:00	SPY	ETF	744.21	744.61	744.07	744.51	252638.0
2026-07-02 17:00:00	SPY	ETF	744.56	744.78	744.2	744.4	107720.0
2026-07-02 17:30:00	SPY	ETF	744.4	744.75	744.36	744.64	67670.0
2026-07-02 18:00:00	SPY	ETF	744.64	745.2	744.6	744.96	57110.0
2026-07-02 18:30:00	SPY	ETF	744.89	745.64	744.89	745.64	25565.0
2026-07-02 19:00:00	SPY	ETF	745.63	745.78	745.1	745.6566	9540.0
2026-07-02 19:30:00	SPY	ETF	745.68	745.85	745.46	745.7101	9886.0
2026-07-02 04:00:00	QQQ	ETF	721.71	728.0	719.45	721.86	278093.0
2026-07-02 04:30:00	QQQ	ETF	721.67	724.5	721.67	724.43	84944.0
2026-07-02 05:00:00	QQQ	ETF	724.27	724.27	722.29	723.21	67039.0
2026-07-02 05:30:00	QQQ	ETF	723.11	723.88	722.56	722.58	45360.0
2026-07-02 06:00:00	QQQ	ETF	722.6	722.6	721.69	722.15	38317.0
2026-07-02 06:30:00	QQQ	ETF	722.54	723.74	722.5157	723.65	54714.0
2026-07-02 07:00:00	QQQ	ETF	723.68	724.11	722.85	723.8	95098.0
2026-07-02 07:30:00	QQQ	ETF	723.69	725.5	723.4504	724.5	137399.0
2026-07-02 08:00:00	QQQ	ETF	724.44	728.01	724.19	727.83	260800.0
2026-07-02 08:30:00	QQQ	ETF	727.83	731.33	726.58	728.12	646008.0
2026-07-02 09:00:00	QQQ	ETF	728.15	728.8	725.54	725.58	299148.0
2026-07-02 09:30:00	QQQ	ETF	725.56	730.0	723.871	729.9	3777422.0
2026-07-02 10:00:00	QQQ	ETF	729.94	730.83	721.52	722.13	3103220.0
2026-07-02 10:30:00	QQQ	ETF	722.18	723.83	717.21	719.815	4321259.0
2026-07-02 11:00:00	QQQ	ETF	719.845	720.1	714.2827	715.79	3053069.0
2026-07-02 11:30:00	QQQ	ETF	715.76	719.31	714.91	715.87	1889658.0
2026-07-02 12:00:00	QQQ	ETF	715.92	716.1579	712.766	713.01	2085030.0
2026-07-02 12:30:00	QQQ	ETF	713.02	713.12	710.12	710.785	2241359.0

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

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