PREVIEW / etf_30min / 2025-06-23

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-06-23.parquet
  size:    1013 KB
  rows:    42,443

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-23 04:00:00	SPY	ETF	594.22	596.41	592.55	595.8	63962.0
2025-06-23 04:30:00	SPY	ETF	595.58	595.93	595.58	595.74	16991.0
2025-06-23 05:00:00	SPY	ETF	595.7	596.33	595.31	595.6	47663.0
2025-06-23 05:30:00	SPY	ETF	595.6	595.81	595.52	595.6	7306.0
2025-06-23 06:00:00	SPY	ETF	595.49	596.25	594.99	595.05	63972.0
2025-06-23 06:30:00	SPY	ETF	595.0	595.25	594.59	594.73	57926.0
2025-06-23 07:00:00	SPY	ETF	594.71	594.85	593.25	593.6	108368.0
2025-06-23 07:30:00	SPY	ETF	593.58	593.88	592.81	593.84	351022.0
2025-06-23 08:00:00	SPY	ETF	594.62	596.0404	592.63	594.12	244306.0
2025-06-23 08:30:00	SPY	ETF	594.1	595.26	594.0	595.2199	136266.0
2025-06-23 09:00:00	SPY	ETF	595.16	595.37	594.44	595.04	375424.0
2025-06-23 09:30:00	SPY	ETF	595.04	596.67	593.6	596.65	5645905.0
2025-06-23 10:00:00	SPY	ETF	596.66	598.29	596.66	597.54	4663623.0
2025-06-23 10:30:00	SPY	ETF	597.55	597.77	596.42	596.465	3011049.0
2025-06-23 11:00:00	SPY	ETF	596.47	597.66	596.345	596.39	2527289.0
2025-06-23 11:30:00	SPY	ETF	596.38	596.73	595.75	595.86	2697291.0
2025-06-23 12:00:00	SPY	ETF	595.86	596.08	594.16	594.31	2943850.0
2025-06-23 12:30:00	SPY	ETF	594.28	595.46	591.89	593.58	9226279.0
2025-06-23 13:00:00	SPY	ETF	593.61	598.0	593.19	597.71	5836603.0
2025-06-23 13:30:00	SPY	ETF	597.75	599.34	597.715	598.53	4776706.0
2025-06-23 14:00:00	SPY	ETF	598.54	599.13	598.32	598.36	3040369.0
2025-06-23 14:30:00	SPY	ETF	598.37	598.8	597.99	598.5086	3213042.0
2025-06-23 15:00:00	SPY	ETF	598.51	599.44	598.41	599.24	3965202.0
2025-06-23 15:30:00	SPY	ETF	599.235	600.54	598.92	600.13	8724116.0
2025-06-23 16:00:00	SPY	ETF	600.11	600.19	599.66	600.06	5398856.0
2025-06-23 16:30:00	SPY	ETF	600.07	600.3294	600.01	600.13	172706.0
2025-06-23 17:00:00	SPY	ETF	600.14	600.17	600.02	600.08	30396.0
2025-06-23 17:30:00	SPY	ETF	600.09	600.15	600.09	600.09	30832.0
2025-06-23 18:00:00	SPY	ETF	600.15	602.95	599.9612	602.49	337377.0
2025-06-23 18:30:00	SPY	ETF	602.5	602.71	601.82	602.5892	237171.0
2025-06-23 19:00:00	SPY	ETF	602.6	603.69	602.58	603.37	189843.0
2025-06-23 19:30:00	SPY	ETF	603.38	603.65	602.99	603.3384	98657.0
2025-06-23 04:00:00	QQQ	ETF	527.49	528.52	526.8	527.69	57497.0
2025-06-23 04:30:00	QQQ	ETF	527.74	528.0	527.55	527.74	22830.0
2025-06-23 05:00:00	QQQ	ETF	527.71	528.33	527.11	527.52	26677.0
2025-06-23 05:30:00	QQQ	ETF	527.48	527.68	527.19	527.19	9267.0
2025-06-23 06:00:00	QQQ	ETF	527.15	528.09	526.75	526.9	38249.0
2025-06-23 06:30:00	QQQ	ETF	526.85	527.1	526.32	526.54	20703.0
2025-06-23 07:00:00	QQQ	ETF	526.53	526.72	524.99	525.45	46964.0
2025-06-23 07:30:00	QQQ	ETF	525.42	525.81	524.6	525.77	51686.0
2025-06-23 08:00:00	QQQ	ETF	527.54	527.67	524.11	526.08	158762.0
2025-06-23 08:30:00	QQQ	ETF	526.0255	527.2	526.01	527.16	89948.0
2025-06-23 09:00:00	QQQ	ETF	527.13	527.28	526.5	526.61	214092.0
2025-06-23 09:30:00	QQQ	ETF	526.82	528.235	524.16	528.1536	3446921.0
2025-06-23 10:00:00	QQQ	ETF	528.17	530.21	528.17	529.5366	3168599.0
2025-06-23 10:30:00	QQQ	ETF	529.56	530.35	528.75	528.83	1832874.0
2025-06-23 11:00:00	QQQ	ETF	528.85	530.07	528.63	528.67	1444689.0
2025-06-23 11:30:00	QQQ	ETF	528.66	529.142	528.1	528.45	1595068.0
2025-06-23 12:00:00	QQQ	ETF	528.463	528.61	526.43	526.56	1883586.0
2025-06-23 12:30:00	QQQ	ETF	526.56	527.9	523.65	526.08	5250169.0

> showing 50 of 42,443 rows — these rows as CSV

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