PREVIEW / etf_30min / 2025-06-20

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-06-20.parquet
  size:    968 KB
  rows:    39,917

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-20 04:00:00	SPY	ETF	595.23	596.9	595.08	595.12	41266.0
2025-06-20 04:30:00	SPY	ETF	595.0	595.0	593.67	593.7	16712.0
2025-06-20 05:00:00	SPY	ETF	593.83	594.66	593.83	594.39	23134.0
2025-06-20 05:30:00	SPY	ETF	594.25	594.99	594.25	594.94	9536.0
2025-06-20 06:00:00	SPY	ETF	594.94	595.02	594.3	594.34	13329.0
2025-06-20 06:30:00	SPY	ETF	594.29	594.98	594.29	594.76	18733.0
2025-06-20 07:00:00	SPY	ETF	594.72	595.24	594.67	595.02	49508.0
2025-06-20 07:30:00	SPY	ETF	594.99	597.3	594.93	596.16	238207.0
2025-06-20 08:00:00	SPY	ETF	595.03	597.36	594.2	596.72	251011.0
2025-06-20 08:30:00	SPY	ETF	596.72	597.9	596.66	597.72	530578.0
2025-06-20 09:00:00	SPY	ETF	597.77	599.3	597.73	598.42	536453.0
2025-06-20 09:30:00	SPY	ETF	598.38	599.46	597.16	597.35	6398726.0
2025-06-20 10:00:00	SPY	ETF	597.35	597.59	595.3112	596.15	4159205.0
2025-06-20 10:30:00	SPY	ETF	596.16	596.61	593.98	594.38	4238230.0
2025-06-20 11:00:00	SPY	ETF	594.37	595.63	593.5	595.11	3402795.0
2025-06-20 11:30:00	SPY	ETF	595.09	596.37	594.6	594.702	2711932.0
2025-06-20 12:00:00	SPY	ETF	594.71	595.3548	594.225	594.93	2162970.0
2025-06-20 12:30:00	SPY	ETF	594.92	595.7	594.88	595.315	1944309.0
2025-06-20 13:00:00	SPY	ETF	595.33	595.97	593.54	593.555	2666714.0
2025-06-20 13:30:00	SPY	ETF	593.545	594.1	592.86	594.04	2997664.0
2025-06-20 14:00:00	SPY	ETF	594.03	595.35	593.89	594.88	2428817.0
2025-06-20 14:30:00	SPY	ETF	594.88	595.225	593.36	593.6	2171999.0
2025-06-20 15:00:00	SPY	ETF	593.62	594.01	593.24	593.47	3139322.0
2025-06-20 15:30:00	SPY	ETF	593.46	594.97	593.25	594.23	9814086.0
2025-06-20 16:00:00	SPY	ETF	594.23	595.74	593.99	594.85	7142320.0
2025-06-20 16:30:00	SPY	ETF	594.85	595.27	594.75	595.08	207118.0
2025-06-20 17:00:00	SPY	ETF	595.09	595.1	594.88	595.05	92156.0
2025-06-20 17:30:00	SPY	ETF	594.95	595.15	594.8001	594.85	33940.0
2025-06-20 18:00:00	SPY	ETF	595.13	595.3999	594.98	595.37	51534.0
2025-06-20 18:30:00	SPY	ETF	595.3701	595.55	595.15	595.21	25357.0
2025-06-20 19:00:00	SPY	ETF	595.21	595.48	595.17	595.35	17237.0
2025-06-20 19:30:00	SPY	ETF	595.28	595.48	595.28	595.31	13421.0
2025-06-20 04:00:00	QQQ	ETF	528.57	529.16	528.39	528.39	37217.0
2025-06-20 04:30:00	QQQ	ETF	528.37	528.37	527.1	527.19	23697.0
2025-06-20 05:00:00	QQQ	ETF	527.34	528.16	527.26	527.78	22092.0
2025-06-20 05:30:00	QQQ	ETF	527.73	528.27	527.6	528.12	12298.0
2025-06-20 06:00:00	QQQ	ETF	528.15	528.28	527.69	527.78	10143.0
2025-06-20 06:30:00	QQQ	ETF	527.76	528.32	527.68	528.07	45550.0
2025-06-20 07:00:00	QQQ	ETF	528.08	528.54	528.04	528.3	22978.0
2025-06-20 07:30:00	QQQ	ETF	528.25	530.6	528.21	529.72	101796.0
2025-06-20 08:00:00	QQQ	ETF	528.27	530.47	527.4496	530.06	145752.0
2025-06-20 08:30:00	QQQ	ETF	530.1	531.45	530.03	531.13	173535.0
2025-06-20 09:00:00	QQQ	ETF	531.16	533.0	531.0801	532.28	497549.0
2025-06-20 09:30:00	QQQ	ETF	532.26	533.56	530.7	530.86	4449575.0
2025-06-20 10:00:00	QQQ	ETF	530.86	531.17	527.78	528.92	2901110.0
2025-06-20 10:30:00	QQQ	ETF	528.93	529.6	525.64	526.13	3327664.0
2025-06-20 11:00:00	QQQ	ETF	526.11	527.57	525.1	527.105	3005390.0
2025-06-20 11:30:00	QQQ	ETF	527.08	528.6	526.67	526.842	2239311.0
2025-06-20 12:00:00	QQQ	ETF	526.85	527.76	526.52	527.22	1695079.0
2025-06-20 12:30:00	QQQ	ETF	527.21	528.14	527.11	527.73	1481732.0

> showing 50 of 39,917 rows — these rows as CSV

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