PREVIEW / etf_30min / 2025-06-05

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-06-05.parquet
  size:    963 KB
  rows:    40,382

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-05 04:00:00	SPY	ETF	596.5	597.63	596.5	597.63	17048.0
2025-06-05 04:30:00	SPY	ETF	597.53	597.7	596.57	596.87	27439.0
2025-06-05 05:00:00	SPY	ETF	596.83	596.87	596.37	596.65	14525.0
2025-06-05 05:30:00	SPY	ETF	596.57	596.75	596.33	596.45	6966.0
2025-06-05 06:00:00	SPY	ETF	596.59	597.02	596.59	596.82	6045.0
2025-06-05 06:30:00	SPY	ETF	596.86	597.07	596.08	596.42	14663.0
2025-06-05 07:00:00	SPY	ETF	596.4	596.57	595.92	595.97	24864.0
2025-06-05 07:30:00	SPY	ETF	596.01	596.59	596.0	596.41	23550.0
2025-06-05 08:00:00	SPY	ETF	595.8	597.49	595.484	596.4	106162.0
2025-06-05 08:30:00	SPY	ETF	596.35	599.73	595.3	597.33	1143368.0
2025-06-05 09:00:00	SPY	ETF	597.27	597.9	597.1	597.63	255137.0
2025-06-05 09:30:00	SPY	ETF	597.63	597.905	593.91	594.2896	6157986.0
2025-06-05 10:00:00	SPY	ETF	594.29	596.21	594.17	596.165	3456517.0
2025-06-05 10:30:00	SPY	ETF	596.16	597.58	594.0	597.295	7042886.0
2025-06-05 11:00:00	SPY	ETF	597.29	598.735	597.06	598.6601	3733433.0
2025-06-05 11:30:00	SPY	ETF	598.65	599.0	598.17	598.7799	2493887.0
2025-06-05 12:00:00	SPY	ETF	598.76	598.95	597.03	597.89	2947282.0
2025-06-05 12:30:00	SPY	ETF	597.9	598.02	594.26	594.76	4617068.0
2025-06-05 13:00:00	SPY	ETF	594.75	596.68	594.305	596.47	3118824.0
2025-06-05 13:30:00	SPY	ETF	596.45	596.9797	595.68	595.82	2036505.0
2025-06-05 14:00:00	SPY	ETF	595.84	596.02	593.06	595.3388	4366262.0
2025-06-05 14:30:00	SPY	ETF	595.34	596.12	595.09	595.24	2745296.0
2025-06-05 15:00:00	SPY	ETF	595.24	595.51	591.05	592.46	8042779.0
2025-06-05 15:30:00	SPY	ETF	592.47	594.77	592.2	593.01	11503948.0
2025-06-05 16:00:00	SPY	ETF	592.99	593.7	592.27	593.06	2597341.0
2025-06-05 16:30:00	SPY	ETF	593.0	593.11	592.11	592.17	209512.0
2025-06-05 17:00:00	SPY	ETF	592.19	592.4	591.8	592.0	123736.0
2025-06-05 17:30:00	SPY	ETF	591.99	592.08	591.5	591.5	84489.0
2025-06-05 18:00:00	SPY	ETF	591.42	592.4	591.33	592.4	66513.0
2025-06-05 18:30:00	SPY	ETF	592.409	592.96	592.14	592.8802	50312.0
2025-06-05 19:00:00	SPY	ETF	592.94	593.08	592.53	592.77	31523.0
2025-06-05 19:30:00	SPY	ETF	592.78	593.3199	592.56	592.83	32669.0
2025-06-05 04:00:00	QQQ	ETF	530.07	530.83	529.12	530.71	35597.0
2025-06-05 04:30:00	QQQ	ETF	530.7	530.86	529.26	529.68	21238.0
2025-06-05 05:00:00	QQQ	ETF	529.67	529.67	529.05	529.35	19864.0
2025-06-05 05:30:00	QQQ	ETF	529.24	529.62	529.11	529.29	12823.0
2025-06-05 06:00:00	QQQ	ETF	529.31	529.89	529.31	529.71	9443.0
2025-06-05 06:30:00	QQQ	ETF	529.66	529.96	528.78	529.32	33928.0
2025-06-05 07:00:00	QQQ	ETF	529.36	529.409	528.6	528.7	32849.0
2025-06-05 07:30:00	QQQ	ETF	528.74	529.35	528.6	529.1	49839.0
2025-06-05 08:00:00	QQQ	ETF	528.55	530.77	528.05	529.03	92191.0
2025-06-05 08:30:00	QQQ	ETF	528.78	532.14	527.81	529.87	472089.0
2025-06-05 09:00:00	QQQ	ETF	529.86	530.37	529.67	530.18	216631.0
2025-06-05 09:30:00	QQQ	ETF	530.18	530.85	527.27	528.028	3647365.0
2025-06-05 10:00:00	QQQ	ETF	528.04	529.98	527.55	529.92	2737918.0
2025-06-05 10:30:00	QQQ	ETF	529.91	531.75	527.59	531.29	4400110.0
2025-06-05 11:00:00	QQQ	ETF	531.29	532.94	530.96	532.7893	2457571.0
2025-06-05 11:30:00	QQQ	ETF	532.78	533.05	532.23	532.79	1543587.0
2025-06-05 12:00:00	QQQ	ETF	532.78	532.85	530.21	531.3799	2210200.0
2025-06-05 12:30:00	QQQ	ETF	531.36	531.52	526.78	527.175	3012716.0

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

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