PREVIEW / etf_30min / 2026-07-14

all etf 30-min files

  file:    by_date/etf_30min/2026/2026-07-14.parquet
  size:    1.0 MB
  rows:    46,365

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-14 04:00:00	SPY	ETF	747.89	750.42	746.91	749.27	68518.0
2026-07-14 04:30:00	SPY	ETF	749.35	749.35	748.275	748.41	5801.0
2026-07-14 05:00:00	SPY	ETF	748.18	749.2902	748.18	748.44	21572.0
2026-07-14 05:30:00	SPY	ETF	748.4	749.08	748.4	748.72	4956.0
2026-07-14 06:00:00	SPY	ETF	748.6681	749.0	748.52	748.74	18262.0
2026-07-14 06:30:00	SPY	ETF	748.83	749.54	748.4	748.64	31796.0
2026-07-14 07:00:00	SPY	ETF	748.72	749.4	747.37	748.86	295771.0
2026-07-14 07:30:00	SPY	ETF	748.91	749.1865	748.32	748.48	45749.0
2026-07-14 08:00:00	SPY	ETF	748.5	749.18	747.51	749.14	122803.0
2026-07-14 08:30:00	SPY	ETF	749.26	754.24	749.14	750.9	977032.0
2026-07-14 09:00:00	SPY	ETF	750.92	751.42	750.11	750.86	158088.0
2026-07-14 09:30:00	SPY	ETF	750.89	751.79	749.44	751.31	3376821.0
2026-07-14 10:00:00	SPY	ETF	751.32	751.48	748.66	750.71	2295494.0
2026-07-14 10:30:00	SPY	ETF	750.71	753.34	750.47	751.71	2315886.0
2026-07-14 11:00:00	SPY	ETF	751.71	753.08	751.28	752.66	1859898.0
2026-07-14 11:30:00	SPY	ETF	752.64	752.9	750.62	750.98	1367356.0
2026-07-14 12:00:00	SPY	ETF	750.99	751.05	750.0	750.78	1419542.0
2026-07-14 12:30:00	SPY	ETF	750.78	751.85	750.62	751.85	1024978.0
2026-07-14 13:00:00	SPY	ETF	751.87	752.61	751.5	752.3	1004839.0
2026-07-14 13:30:00	SPY	ETF	752.32	752.49	751.76	752.275	708037.0
2026-07-14 14:00:00	SPY	ETF	752.28	752.77	751.93	752.5	1000028.0
2026-07-14 14:30:00	SPY	ETF	752.485	752.6	751.66	752.1704	1327728.0
2026-07-14 15:00:00	SPY	ETF	752.19	752.45	751.77	752.15	1525285.0
2026-07-14 15:30:00	SPY	ETF	752.16	752.52	751.71	751.85	4707023.0
2026-07-14 16:00:00	SPY	ETF	751.89	752.18	751.52	751.59	2000227.0
2026-07-14 16:30:00	SPY	ETF	751.53	752.07	751.53	752.07	53501.0
2026-07-14 17:00:00	SPY	ETF	751.99	752.1	751.84	751.97	49196.0
2026-07-14 17:30:00	SPY	ETF	751.99	752.08	751.86	751.89	8120.0
2026-07-14 18:00:00	SPY	ETF	751.92	752.1	751.3104	752.0	24259.0
2026-07-14 18:30:00	SPY	ETF	752.0996	752.11	751.83	751.87	11505.0
2026-07-14 19:00:00	SPY	ETF	751.77	752.87	751.75	752.87	18577.0
2026-07-14 19:30:00	SPY	ETF	752.971	753.25	752.93	753.1	30013.0
2026-07-14 04:00:00	QQQ	ETF	713.43	716.16	709.6	715.53	250815.0
2026-07-14 04:30:00	QQQ	ETF	715.27	715.94	714.4	714.53	33753.0
2026-07-14 05:00:00	QQQ	ETF	714.38	715.75	714.07	714.42	27438.0
2026-07-14 05:30:00	QQQ	ETF	714.48	715.58	714.48	715.02	17962.0
2026-07-14 06:00:00	QQQ	ETF	715.01	715.55	714.72	715.0	21164.0
2026-07-14 06:30:00	QQQ	ETF	715.0	715.83	714.52	715.15	42343.0
2026-07-14 07:00:00	QQQ	ETF	715.19	716.71	714.0	716.06	193540.0
2026-07-14 07:30:00	QQQ	ETF	716.03	716.65	715.37	715.821	137623.0
2026-07-14 08:00:00	QQQ	ETF	715.8416	717.17	714.34	717.17	198848.0
2026-07-14 08:30:00	QQQ	ETF	717.25	722.72	716.5	719.21	942335.0
2026-07-14 09:00:00	QQQ	ETF	719.22	720.61	718.54	720.28	273832.0
2026-07-14 09:30:00	QQQ	ETF	720.22	720.286	717.12	719.39	3094407.0
2026-07-14 10:00:00	QQQ	ETF	719.43	720.0	714.34	717.18	2156749.0
2026-07-14 10:30:00	QQQ	ETF	717.13	720.93	716.538	719.3	2364314.0
2026-07-14 11:00:00	QQQ	ETF	719.37	722.085	718.86	722.01	1660248.0
2026-07-14 11:30:00	QQQ	ETF	722.05	722.29	719.05	719.65	1244039.0
2026-07-14 12:00:00	QQQ	ETF	719.73	719.8	717.72	719.52	1017012.0
2026-07-14 12:30:00	QQQ	ETF	719.535	720.7106	718.84	720.62	797120.0

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

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