PREVIEW / etf_30min / 2025-06-17

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-06-17.parquet
  size:    973 KB
  rows:    40,618

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-17 04:00:00	SPY	ETF	599.07	599.89	598.84	599.83	71704.0
2025-06-17 04:30:00	SPY	ETF	599.67	600.24	599.05	599.83	72046.0
2025-06-17 05:00:00	SPY	ETF	599.99	600.24	598.77	599.25	40690.0
2025-06-17 05:30:00	SPY	ETF	599.2	599.44	598.9	599.22	12991.0
2025-06-17 06:00:00	SPY	ETF	599.24	599.65	599.09	599.12	32769.0
2025-06-17 06:30:00	SPY	ETF	599.13	599.33	598.27	599.33	53144.0
2025-06-17 07:00:00	SPY	ETF	599.31	600.21	599.19	600.01	101627.0
2025-06-17 07:30:00	SPY	ETF	599.99	600.43	599.67	600.41	185516.0
2025-06-17 08:00:00	SPY	ETF	599.29	602.6181	598.4696	600.46	252599.0
2025-06-17 08:30:00	SPY	ETF	600.4	600.73	599.55	599.78	331274.0
2025-06-17 09:00:00	SPY	ETF	599.67	600.28	599.37	600.14	238624.0
2025-06-17 09:30:00	SPY	ETF	600.22	600.95	599.18	600.865	5796031.0
2025-06-17 10:00:00	SPY	ETF	600.86	601.64	600.3308	601.17	3271865.0
2025-06-17 10:30:00	SPY	ETF	601.14	601.4	600.37	600.4799	2501129.0
2025-06-17 11:00:00	SPY	ETF	600.49	601.75	600.38	600.47	2536357.0
2025-06-17 11:30:00	SPY	ETF	600.47	601.22	600.22	600.705	2322788.0
2025-06-17 12:00:00	SPY	ETF	600.74	601.5801	600.54	601.15	2456558.0
2025-06-17 12:30:00	SPY	ETF	601.15	601.59	599.5	599.78	3608965.0
2025-06-17 13:00:00	SPY	ETF	599.79	600.2	598.99	599.0	3510718.0
2025-06-17 13:30:00	SPY	ETF	598.99	599.9	597.41	598.02	4815537.0
2025-06-17 14:00:00	SPY	ETF	598.02	598.18	596.96	597.39	5200761.0
2025-06-17 14:30:00	SPY	ETF	597.4	598.16	596.76	598.12	3992162.0
2025-06-17 15:00:00	SPY	ETF	598.12	598.37	597.38	598.25	3912177.0
2025-06-17 15:30:00	SPY	ETF	598.24	598.61	597.29	597.55	8947961.0
2025-06-17 16:00:00	SPY	ETF	597.57	598.15	597.09	597.52	6693066.0
2025-06-17 16:30:00	SPY	ETF	597.52	597.78	597.23	597.5	174664.0
2025-06-17 17:00:00	SPY	ETF	597.5596	597.5596	597.15	597.34	49267.0
2025-06-17 17:30:00	SPY	ETF	597.3	597.49	597.07	597.29	65441.0
2025-06-17 18:00:00	SPY	ETF	597.1	597.2	596.33	596.41	101159.0
2025-06-17 18:30:00	SPY	ETF	596.47	596.53	595.62	595.69	163800.0
2025-06-17 19:00:00	SPY	ETF	595.76	596.2693	595.57	596.13	73293.0
2025-06-17 19:30:00	SPY	ETF	596.1	596.64	595.93	596.1104	67056.0
2025-06-17 20:00:00	SPY	ETF	596.2	596.2	596.2	596.2	100.0
2025-06-17 04:00:00	QQQ	ETF	531.11	531.63	530.67	531.51	26756.0
2025-06-17 04:30:00	QQQ	ETF	531.45	532.09	530.87	531.66	41208.0
2025-06-17 05:00:00	QQQ	ETF	531.66	532.07	530.72	531.05	28270.0
2025-06-17 05:30:00	QQQ	ETF	531.0	531.3	530.74	530.93	15596.0
2025-06-17 06:00:00	QQQ	ETF	530.85	531.35	530.71	530.74	12638.0
2025-06-17 06:30:00	QQQ	ETF	530.81	531.06	530.0	531.03	32374.0
2025-06-17 07:00:00	QQQ	ETF	531.02	531.81	530.89	531.57	44077.0
2025-06-17 07:30:00	QQQ	ETF	531.55	531.87	531.22	531.83	30309.0
2025-06-17 08:00:00	QQQ	ETF	531.04	533.0	530.4	532.23	147741.0
2025-06-17 08:30:00	QQQ	ETF	531.77	532.44	531.12	531.52	157332.0
2025-06-17 09:00:00	QQQ	ETF	531.42	532.0	531.03	531.6908	90491.0
2025-06-17 09:30:00	QQQ	ETF	531.71	532.78	530.8051	532.41	3155036.0
2025-06-17 10:00:00	QQQ	ETF	532.41	533.32	531.84	532.58	1947395.0
2025-06-17 10:30:00	QQQ	ETF	532.56	532.81	531.81	531.95	1533665.0
2025-06-17 11:00:00	QQQ	ETF	531.94	533.325	531.88	532.28	1633662.0
2025-06-17 11:30:00	QQQ	ETF	532.29	533.04	531.99	532.44	1238849.0
2025-06-17 12:00:00	QQQ	ETF	532.43	533.24	532.26	532.71	1191576.0

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

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