PREVIEW / etf_30min / 2025-06-24

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-06-24.parquet
  size:    1009 KB
  rows:    41,364

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-24 04:00:00	SPY	ETF	605.07	605.54	588.79	605.53	86134.0
2025-06-24 04:30:00	SPY	ETF	605.45	605.49	604.78	604.98	52987.0
2025-06-24 05:00:00	SPY	ETF	605.02	605.69	604.96	605.65	12841.0
2025-06-24 05:30:00	SPY	ETF	605.63	605.96	605.1	605.13	15707.0
2025-06-24 06:00:00	SPY	ETF	605.11	605.33	604.69	604.9	57255.0
2025-06-24 06:30:00	SPY	ETF	604.82	605.09	604.53	604.72	152389.0
2025-06-24 07:00:00	SPY	ETF	604.72	605.16	604.03	605.04	115929.0
2025-06-24 07:30:00	SPY	ETF	604.97	605.21	604.52	604.83	182357.0
2025-06-24 08:00:00	SPY	ETF	604.81	606.5	603.17	604.46	235492.0
2025-06-24 08:30:00	SPY	ETF	604.46	604.8099	603.85	604.4	172256.0
2025-06-24 09:00:00	SPY	ETF	604.33	605.02	604.25	604.34	361362.0
2025-06-24 09:30:00	SPY	ETF	604.33	605.45	603.8	604.05	6507872.0
2025-06-24 10:00:00	SPY	ETF	604.02	604.96	603.41	604.5999	4157874.0
2025-06-24 10:30:00	SPY	ETF	604.6	605.355	604.53	604.95	2950180.0
2025-06-24 11:00:00	SPY	ETF	604.96	605.82	604.94	605.755	2753975.0
2025-06-24 11:30:00	SPY	ETF	605.76	606.165	605.66	605.755	2125262.0
2025-06-24 12:00:00	SPY	ETF	605.77	606.595	605.655	606.492	1892106.0
2025-06-24 12:30:00	SPY	ETF	606.5	607.175	606.32	606.6399	2542445.0
2025-06-24 13:00:00	SPY	ETF	606.65	606.9601	606.3	606.33	2267846.0
2025-06-24 13:30:00	SPY	ETF	606.34	607.36	606.33	607.1701	1914447.0
2025-06-24 14:00:00	SPY	ETF	607.18	607.46	606.95	607.0	2257340.0
2025-06-24 14:30:00	SPY	ETF	607.02	607.35	606.87	607.305	2158923.0
2025-06-24 15:00:00	SPY	ETF	607.31	607.69	607.3	607.505	2882743.0
2025-06-24 15:30:00	SPY	ETF	607.51	607.8499	606.75	606.77	8766551.0
2025-06-24 16:00:00	SPY	ETF	606.76	606.91	605.891	606.72	2447693.0
2025-06-24 16:30:00	SPY	ETF	606.71	606.95	606.7	606.73	81496.0
2025-06-24 17:00:00	SPY	ETF	606.7508	607.16	606.75	606.75	412542.0
2025-06-24 17:30:00	SPY	ETF	606.81	606.98	606.5	606.7	47893.0
2025-06-24 18:00:00	SPY	ETF	606.7	606.8221	606.2701	606.51	207911.0
2025-06-24 18:30:00	SPY	ETF	606.41	606.5201	606.31	606.4599	16392.0
2025-06-24 19:00:00	SPY	ETF	606.46	606.76	606.2301	606.46	11167.0
2025-06-24 19:30:00	SPY	ETF	606.45	607.02	606.45	607.02	11230.0
2025-06-24 04:00:00	QQQ	ETF	537.47	538.03	536.12	538.03	55040.0
2025-06-24 04:30:00	QQQ	ETF	537.99	538.0	537.16	537.34	25649.0
2025-06-24 05:00:00	QQQ	ETF	537.37	538.16	537.37	538.13	70519.0
2025-06-24 05:30:00	QQQ	ETF	538.05	538.5	537.57	537.62	31259.0
2025-06-24 06:00:00	QQQ	ETF	537.6	537.77	536.86	537.08	39704.0
2025-06-24 06:30:00	QQQ	ETF	537.0	537.31	536.8	536.91	34308.0
2025-06-24 07:00:00	QQQ	ETF	536.92	537.25	536.12	537.22	59764.0
2025-06-24 07:30:00	QQQ	ETF	537.11	537.44	536.91	537.39	31055.0
2025-06-24 08:00:00	QQQ	ETF	536.71	539.0	531.252	536.93	151894.0
2025-06-24 08:30:00	QQQ	ETF	536.85	537.32	536.25	536.92	102315.0
2025-06-24 09:00:00	QQQ	ETF	536.92	537.5	536.7	536.9	159396.0
2025-06-24 09:30:00	QQQ	ETF	536.9	538.04	536.27	536.99	4361148.0
2025-06-24 10:00:00	QQQ	ETF	536.94	537.83	536.43	537.405	2812573.0
2025-06-24 10:30:00	QQQ	ETF	537.41	538.19	537.23	537.59	2230052.0
2025-06-24 11:00:00	QQQ	ETF	537.6	538.97	537.56	538.9588	2075748.0
2025-06-24 11:30:00	QQQ	ETF	538.97	539.299	538.61	538.685	1714865.0
2025-06-24 12:00:00	QQQ	ETF	538.69	539.5	538.585	539.39	1540626.0
2025-06-24 12:30:00	QQQ	ETF	539.38	540.005	539.255	539.575	1528830.0

> showing 50 of 41,364 rows — these rows as CSV

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