PREVIEW / etf_30min / 2025-06-26

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-06-26.parquet
  size:    993 KB
  rows:    40,707

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
2025-06-26 04:00:00	SPY	ETF	607.72	609.47	607.72	609.29	22447.0
2025-06-26 04:30:00	SPY	ETF	609.29	609.35	609.08	609.09	3200.0
2025-06-26 05:00:00	SPY	ETF	609.06	609.12	608.88	608.88	3580.0
2025-06-26 05:30:00	SPY	ETF	608.84	608.9	608.66	608.8	9700.0
2025-06-26 06:00:00	SPY	ETF	608.74	609.47	608.64	609.35	23439.0
2025-06-26 06:30:00	SPY	ETF	609.36	609.44	608.87	608.89	12782.0
2025-06-26 07:00:00	SPY	ETF	608.87	609.39	608.86	609.15	100458.0
2025-06-26 07:30:00	SPY	ETF	609.24	609.41	608.97	609.35	72428.0
2025-06-26 08:00:00	SPY	ETF	609.35	609.47	607.72	609.23	123040.0
2025-06-26 08:30:00	SPY	ETF	609.4	609.4	608.25	609.07	340175.0
2025-06-26 09:00:00	SPY	ETF	609.06	609.21	608.59	608.98	185358.0
2025-06-26 09:30:00	SPY	ETF	609.01	609.39	608.37	609.12	5107315.0
2025-06-26 10:00:00	SPY	ETF	609.13	609.98	609.07	609.945	3269529.0
2025-06-26 10:30:00	SPY	ETF	609.93	610.58	609.92	610.3693	3349878.0
2025-06-26 11:00:00	SPY	ETF	610.37	610.865	610.06	610.09	2463711.0
2025-06-26 11:30:00	SPY	ETF	610.07	610.66	609.83	610.53	2056465.0
2025-06-26 12:00:00	SPY	ETF	610.52	611.1283	610.46	610.88	1983085.0
2025-06-26 12:30:00	SPY	ETF	610.9	611.125	610.675	610.845	1335669.0
2025-06-26 13:00:00	SPY	ETF	610.8329	611.28	610.64	611.19	1481892.0
2025-06-26 13:30:00	SPY	ETF	611.2	611.59	611.2	611.271	1863914.0
2025-06-26 14:00:00	SPY	ETF	611.28	612.12	611.15	611.72	3052309.0
2025-06-26 14:30:00	SPY	ETF	611.73	611.915	611.095	611.45	2852140.0
2025-06-26 15:00:00	SPY	ETF	611.44	611.82	611.26	611.64	3096703.0
2025-06-26 15:30:00	SPY	ETF	611.63	612.31	611.23	611.89	10458998.0
2025-06-26 16:00:00	SPY	ETF	611.88	611.93	611.26	611.63	2653635.0
2025-06-26 16:30:00	SPY	ETF	611.6682	611.95	611.59	611.86	161301.0
2025-06-26 17:00:00	SPY	ETF	611.83	612.05	611.77	612.05	83675.0
2025-06-26 17:30:00	SPY	ETF	612.07	612.26	611.7306	612.17	534345.0
2025-06-26 18:00:00	SPY	ETF	612.09	612.82	611.88	612.65	88027.0
2025-06-26 18:30:00	SPY	ETF	612.611	612.69	612.45	612.5	31049.0
2025-06-26 19:00:00	SPY	ETF	612.6	612.61	612.0702	612.21	23866.0
2025-06-26 19:30:00	SPY	ETF	612.21	612.23	611.9	612.0982	33473.0
2025-06-26 04:00:00	QQQ	ETF	541.0	543.96	541.0	543.78	31236.0
2025-06-26 04:30:00	QQQ	ETF	543.77	543.96	543.57	543.6	22345.0
2025-06-26 05:00:00	QQQ	ETF	543.63	543.7	543.42	543.44	19089.0
2025-06-26 05:30:00	QQQ	ETF	543.4	543.44	543.18	543.34	19972.0
2025-06-26 06:00:00	QQQ	ETF	543.4	544.02	543.18	543.86	19234.0
2025-06-26 06:30:00	QQQ	ETF	543.86	543.93	543.43	543.46	18024.0
2025-06-26 07:00:00	QQQ	ETF	543.45	543.84	543.41	543.6	98175.0
2025-06-26 07:30:00	QQQ	ETF	543.62	543.89	543.42	543.88	197523.0
2025-06-26 08:00:00	QQQ	ETF	543.49	544.05	540.755	543.82	141520.0
2025-06-26 08:30:00	QQQ	ETF	543.8135	544.0	542.65	543.35	154856.0
2025-06-26 09:00:00	QQQ	ETF	543.39	543.6	542.81	543.36	217843.0
2025-06-26 09:30:00	QQQ	ETF	543.35	543.7	541.52	543.13	3938322.0
2025-06-26 10:00:00	QQQ	ETF	543.14	543.865	543.0	543.76	2215690.0
2025-06-26 10:30:00	QQQ	ETF	543.755	544.39	543.45	543.762	1769132.0
2025-06-26 11:00:00	QQQ	ETF	543.76	544.75	543.61	543.645	1562101.0
2025-06-26 11:30:00	QQQ	ETF	543.65	544.88	543.3125	544.7096	1699555.0
2025-06-26 12:00:00	QQQ	ETF	544.71	545.23	544.63	544.815	1046001.0
2025-06-26 12:30:00	QQQ	ETF	544.82	545.04	544.41	544.65	846995.0

> showing 50 of 40,707 rows — these rows as CSV

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