PREVIEW / etf_30min / 2025-06-16

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-06-16.parquet
  size:    979 KB
  rows:    40,411

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-16 04:00:00	SPY	ETF	600.31	600.4	598.18	599.96	31757.0
2025-06-16 04:30:00	SPY	ETF	599.98	600.32	599.81	600.22	18527.0
2025-06-16 05:00:00	SPY	ETF	600.26	600.28	599.35	599.58	24595.0
2025-06-16 05:30:00	SPY	ETF	599.54	599.54	599.11	599.46	52930.0
2025-06-16 06:00:00	SPY	ETF	599.33	599.75	599.29	599.7	22061.0
2025-06-16 06:30:00	SPY	ETF	599.69	600.2	599.34	600.2	37204.0
2025-06-16 07:00:00	SPY	ETF	600.16	600.16	599.47	599.9	120759.0
2025-06-16 07:30:00	SPY	ETF	599.91	600.86	599.89	600.75	190733.0
2025-06-16 08:00:00	SPY	ETF	599.67	601.41	597.5	601.18	235270.0
2025-06-16 08:30:00	SPY	ETF	601.2	601.35	596.9301	600.74	261808.0
2025-06-16 09:00:00	SPY	ETF	600.77	601.0	600.36	600.4	243731.0
2025-06-16 09:30:00	SPY	ETF	600.4	603.41	600.22	603.05	8346933.0
2025-06-16 10:00:00	SPY	ETF	603.07	604.19	602.965	604.07	4710083.0
2025-06-16 10:30:00	SPY	ETF	604.07	604.45	603.71	603.9188	3680030.0
2025-06-16 11:00:00	SPY	ETF	603.92	604.09	603.27	603.378	3256532.0
2025-06-16 11:30:00	SPY	ETF	603.38	603.84	602.77	603.1399	3111577.0
2025-06-16 12:00:00	SPY	ETF	603.14	603.66	602.83	603.02	1885773.0
2025-06-16 12:30:00	SPY	ETF	603.02	603.21	602.47	602.73	2099762.0
2025-06-16 13:00:00	SPY	ETF	602.73	603.56	602.3301	603.38	2483155.0
2025-06-16 13:30:00	SPY	ETF	603.39	603.71	602.13	602.3099	2691370.0
2025-06-16 14:00:00	SPY	ETF	602.31	602.87	602.255	602.56	2073080.0
2025-06-16 14:30:00	SPY	ETF	602.57	602.77	601.85	602.5046	2663182.0
2025-06-16 15:00:00	SPY	ETF	602.5	602.62	601.64	602.05	4252767.0
2025-06-16 15:30:00	SPY	ETF	602.04	602.8	601.79	602.71	8901209.0
2025-06-16 16:00:00	SPY	ETF	602.71	603.2	602.63	602.88	2523085.0
2025-06-16 16:30:00	SPY	ETF	602.85	603.02	602.61	602.7	124979.0
2025-06-16 17:00:00	SPY	ETF	602.7201	603.12	602.6	602.96	90249.0
2025-06-16 17:30:00	SPY	ETF	602.96	603.17	602.8686	602.91	59811.0
2025-06-16 18:00:00	SPY	ETF	602.85	602.9	602.25	602.28	70430.0
2025-06-16 18:30:00	SPY	ETF	602.25	602.25	600.3	600.8	253478.0
2025-06-16 19:00:00	SPY	ETF	600.8383	601.5	600.3	600.55	89397.0
2025-06-16 19:30:00	SPY	ETF	600.4	600.63	598.92	598.94	399495.0
2025-06-16 04:00:00	QQQ	ETF	530.2	530.2	529.12	530.0	57190.0
2025-06-16 04:30:00	QQQ	ETF	530.0	530.28	529.84	530.17	18772.0
2025-06-16 05:00:00	QQQ	ETF	530.17	530.29	529.18	529.47	30934.0
2025-06-16 05:30:00	QQQ	ETF	529.46	529.53	528.97	529.46	17767.0
2025-06-16 06:00:00	QQQ	ETF	529.28	529.67	529.24	529.61	39642.0
2025-06-16 06:30:00	QQQ	ETF	529.6	530.17	529.29	530.17	46543.0
2025-06-16 07:00:00	QQQ	ETF	530.17	530.17	529.5	529.89	22275.0
2025-06-16 07:30:00	QQQ	ETF	529.88	530.879	529.87	530.879	113402.0
2025-06-16 08:00:00	QQQ	ETF	529.97	531.62	526.565	531.35	241678.0
2025-06-16 08:30:00	QQQ	ETF	531.38	531.55	530.92	530.99	139586.0
2025-06-16 09:00:00	QQQ	ETF	531.04	531.28	530.39	530.45	175731.0
2025-06-16 09:30:00	QQQ	ETF	530.51	534.12	530.45	533.73	4158129.0
2025-06-16 10:00:00	QQQ	ETF	533.74	534.88	533.55	534.81	2576412.0
2025-06-16 10:30:00	QQQ	ETF	534.81	535.06	534.2	534.47	1910278.0
2025-06-16 11:00:00	QQQ	ETF	534.48	535.37	534.34	534.58	1583062.0
2025-06-16 11:30:00	QQQ	ETF	534.56	534.96	533.81	534.16	1282864.0
2025-06-16 12:00:00	QQQ	ETF	534.18	534.74	533.865	534.08	984478.0
2025-06-16 12:30:00	QQQ	ETF	534.08	534.38	533.5	533.99	994902.0

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

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