PREVIEW / etf_30min / 2026-04-23

all etf 30-min files

  file:    by_date/etf_30min/2026/2026-04-23.parquet
  size:    1.1 MB
  rows:    46,373

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-04-23 04:00:00	SPY	ETF	708.7	709.08	706.49	708.44	127351.0
2026-04-23 04:30:00	SPY	ETF	708.31	708.37	707.32	707.58	13868.0
2026-04-23 05:00:00	SPY	ETF	707.38	708.04	706.89	707.77	35903.0
2026-04-23 05:30:00	SPY	ETF	707.86	708.1601	707.7344	707.75	6243.0
2026-04-23 06:00:00	SPY	ETF	707.67	707.95	707.19	707.78	32736.0
2026-04-23 06:30:00	SPY	ETF	707.6361	708.51	707.62	708.36	28627.0
2026-04-23 07:00:00	SPY	ETF	708.44	708.74	707.9	708.16	90329.0
2026-04-23 07:30:00	SPY	ETF	708.13	710.34	707.75	710.1	233050.0
2026-04-23 08:00:00	SPY	ETF	710.16	711.2	709.87	710.1492	255699.0
2026-04-23 08:30:00	SPY	ETF	710.17	710.36	707.9	709.4922	554808.0
2026-04-23 09:00:00	SPY	ETF	709.51	709.79	708.53	709.5	293304.0
2026-04-23 09:30:00	SPY	ETF	709.5	711.285	709.22	710.21	3327000.0
2026-04-23 10:00:00	SPY	ETF	710.19	710.96	709.13	710.53	2767139.0
2026-04-23 10:30:00	SPY	ETF	710.51	712.055	710.4	711.71	2163109.0
2026-04-23 11:00:00	SPY	ETF	711.7	712.28	711.4499	711.99	1744834.0
2026-04-23 11:30:00	SPY	ETF	711.99	712.3598	710.7	711.105	2123536.0
2026-04-23 12:00:00	SPY	ETF	711.105	711.24	710.305	710.73	1437483.0
2026-04-23 12:30:00	SPY	ETF	710.7489	711.27	710.58	710.87	965804.0
2026-04-23 13:00:00	SPY	ETF	710.88	711.08	705.88	706.05	5600351.0
2026-04-23 13:30:00	SPY	ETF	706.0406	707.7	702.2802	706.635	8812115.0
2026-04-23 14:00:00	SPY	ETF	706.67	708.59	706.22	708.51	3822050.0
2026-04-23 14:30:00	SPY	ETF	708.51	709.48	706.74	707.1262	2639428.0
2026-04-23 15:00:00	SPY	ETF	707.1325	708.66	706.76	708.405	2116207.0
2026-04-23 15:30:00	SPY	ETF	708.42	708.91	706.47	708.44	5443920.0
2026-04-23 16:00:00	SPY	ETF	708.37	708.69	707.11	707.95	2359665.0
2026-04-23 16:30:00	SPY	ETF	707.88	708.11	707.25	707.49	107053.0
2026-04-23 17:00:00	SPY	ETF	707.499	708.4	707.33	708.21	115226.0
2026-04-23 17:30:00	SPY	ETF	708.24	708.66	708.1717	708.4	115655.0
2026-04-23 18:00:00	SPY	ETF	708.35	708.9109	708.27	708.65	62474.0
2026-04-23 18:30:00	SPY	ETF	708.7	709.04	708.45	708.77	46038.0
2026-04-23 19:00:00	SPY	ETF	708.89	708.98	708.66	708.98	15799.0
2026-04-23 19:30:00	SPY	ETF	708.98	709.56	708.98	709.54	41199.0
2026-04-23 04:00:00	QQQ	ETF	656.2	656.2	650.6	652.52	146192.0
2026-04-23 04:30:00	QQQ	ETF	652.48	652.48	651.17	651.44	43668.0
2026-04-23 05:00:00	QQQ	ETF	651.36	652.01	650.6	651.69	83525.0
2026-04-23 05:30:00	QQQ	ETF	651.96	652.2	651.71	651.755	39329.0
2026-04-23 06:00:00	QQQ	ETF	651.72	651.99	651.2	651.84	52971.0
2026-04-23 06:30:00	QQQ	ETF	651.66	652.8	651.66	652.63	52329.0
2026-04-23 07:00:00	QQQ	ETF	652.7	653.02	652.14	652.35	162237.0
2026-04-23 07:30:00	QQQ	ETF	652.46	654.34	651.77	653.86	219271.0
2026-04-23 08:00:00	QQQ	ETF	653.83	655.601	653.7	654.03	210929.0
2026-04-23 08:30:00	QQQ	ETF	653.96	654.37	652.17	653.33	253532.0
2026-04-23 09:00:00	QQQ	ETF	653.45	653.85	652.68	653.55	230509.0
2026-04-23 09:30:00	QQQ	ETF	653.49	655.62	652.31	653.58	2974285.0
2026-04-23 10:00:00	QQQ	ETF	653.58	653.9	652.4	653.54	1840298.0
2026-04-23 10:30:00	QQQ	ETF	653.545	655.6998	653.2902	655.41	1546337.0
2026-04-23 11:00:00	QQQ	ETF	655.42	656.78	655.42	656.33	1514006.0
2026-04-23 11:30:00	QQQ	ETF	656.32	656.92	654.65	655.4074	1411531.0
2026-04-23 12:00:00	QQQ	ETF	655.42	655.69	654.12	655.31	954181.0
2026-04-23 12:30:00	QQQ	ETF	655.31	656.02	654.96	655.26	779274.0

> showing 50 of 46,373 rows — these rows as CSV

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