PREVIEW / etf_30min / 2026-07-29

all etf 30-min files

  file:    by_date/etf_30min/2026/2026-07-29.parquet
  size:    1.1 MB
  rows:    48,276

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-29 04:00:00	SPY	ETF	743.26	743.48	738.2	741.39	67139.0
2026-07-29 04:30:00	SPY	ETF	741.31	742.82	741.31	742.2614	11061.0
2026-07-29 05:00:00	SPY	ETF	742.38	742.62	742.22	742.27	8989.0
2026-07-29 05:30:00	SPY	ETF	742.33	743.44	742.05	742.91	22169.0
2026-07-29 06:00:00	SPY	ETF	742.75	743.06	742.39	742.75	40515.0
2026-07-29 06:30:00	SPY	ETF	742.76	742.85	741.9	741.92	21517.0
2026-07-29 07:00:00	SPY	ETF	742.04	742.7276	742.02	742.46	94367.0
2026-07-29 07:30:00	SPY	ETF	742.4463	742.55	742.0	742.25	63951.0
2026-07-29 08:00:00	SPY	ETF	742.36	742.42	740.0	740.25	133742.0
2026-07-29 08:30:00	SPY	ETF	740.2	740.98	739.9	740.65	128309.0
2026-07-29 09:00:00	SPY	ETF	740.67	740.81	739.54	739.97	281259.0
2026-07-29 09:30:00	SPY	ETF	739.97	740.39	736.61	737.36	3353198.0
2026-07-29 10:00:00	SPY	ETF	737.43	738.33	734.26	734.92	3108324.0
2026-07-29 10:30:00	SPY	ETF	734.91	735.84	733.79	734.82	2467535.0
2026-07-29 11:00:00	SPY	ETF	734.82	735.66	734.35	734.42	1638201.0
2026-07-29 11:30:00	SPY	ETF	734.44	734.99	733.02	733.73	1353340.0
2026-07-29 12:00:00	SPY	ETF	733.76	734.03	731.73	733.85	2050173.0
2026-07-29 12:30:00	SPY	ETF	733.84	734.87	732.88	734.87	1531968.0
2026-07-29 13:00:00	SPY	ETF	734.88	737.24	734.74	735.74	2022934.0
2026-07-29 13:30:00	SPY	ETF	735.75	736.42	735.27	736.4074	1393110.0
2026-07-29 14:00:00	SPY	ETF	736.37	739.55	736.3183	737.31	3728433.0
2026-07-29 14:30:00	SPY	ETF	737.36	742.68	735.95	741.95	3908361.0
2026-07-29 15:00:00	SPY	ETF	741.945	742.59	734.2806	735.15	4618631.0
2026-07-29 15:30:00	SPY	ETF	735.21	735.74	729.1	729.51	13816550.0
2026-07-29 16:00:00	SPY	ETF	729.53	730.2	725.98	727.6	3781186.0
2026-07-29 16:30:00	SPY	ETF	727.56	729.14	727.02	728.11	483411.0
2026-07-29 17:00:00	SPY	ETF	728.11	737.2756	727.5	728.07	648861.0
2026-07-29 17:30:00	SPY	ETF	728.1	728.17	726.68	727.89	93175.0
2026-07-29 18:00:00	SPY	ETF	727.94	732.04	727.75	731.7364	199025.0
2026-07-29 18:30:00	SPY	ETF	731.69	732.06	731.16	731.257	72662.0
2026-07-29 19:00:00	SPY	ETF	731.6	732.48	731.52	732.29	46019.0
2026-07-29 19:30:00	SPY	ETF	732.41	733.0	732.06	732.4	47932.0
2026-07-29 04:00:00	QQQ	ETF	676.2	676.53	668.95	673.4469	325440.0
2026-07-29 04:30:00	QQQ	ETF	673.7	676.08	673.46	675.1	59311.0
2026-07-29 05:00:00	QQQ	ETF	675.43	677.22	675.05	676.74	208860.0
2026-07-29 05:30:00	QQQ	ETF	677.1	678.98	676.52	678.03	57094.0
2026-07-29 06:00:00	QQQ	ETF	678.03	678.46	677.26	677.95	72375.0
2026-07-29 06:30:00	QQQ	ETF	678.0	678.01	675.92	676.15	76352.0
2026-07-29 07:00:00	QQQ	ETF	676.38	678.09	676.01	677.59	102379.0
2026-07-29 07:30:00	QQQ	ETF	677.54	677.71	676.55	677.61	61522.0
2026-07-29 08:00:00	QQQ	ETF	677.6	677.7	673.99	674.6424	251521.0
2026-07-29 08:30:00	QQQ	ETF	674.36	675.89	673.8124	675.33	147083.0
2026-07-29 09:00:00	QQQ	ETF	675.32	676.1	674.11	675.49	238459.0
2026-07-29 09:30:00	QQQ	ETF	675.505	677.46	669.56	671.1899	4020716.0
2026-07-29 10:00:00	QQQ	ETF	671.19	673.4	666.485	667.28	2840136.0
2026-07-29 10:30:00	QQQ	ETF	667.27	669.2	665.76	668.0	2423150.0
2026-07-29 11:00:00	QQQ	ETF	667.99	669.3	666.7	666.83	1300542.0
2026-07-29 11:30:00	QQQ	ETF	666.88	667.81	664.64	665.93	1654804.0
2026-07-29 12:00:00	QQQ	ETF	665.93	666.85	663.28	666.74	2173337.0
2026-07-29 12:30:00	QQQ	ETF	666.7	668.0	665.15	667.96	1655688.0

> showing 50 of 48,276 rows — these rows as CSV

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