PREVIEW / etf_30min / 2025-04-04

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-04-04.parquet
  size:    1.1 MB
  rows:    47,724

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-04-04 04:00:00	SPY	ETF	535.28	535.28	533.46	534.35	40270.0
2025-04-04 04:30:00	SPY	ETF	534.16	534.37	533.14	533.44	23631.0
2025-04-04 05:00:00	SPY	ETF	533.53	533.8	532.61	532.75	15871.0
2025-04-04 05:30:00	SPY	ETF	532.77	533.85	532.07	532.88	62291.0
2025-04-04 06:00:00	SPY	ETF	533.24	533.88	523.33	523.54	889634.0
2025-04-04 06:30:00	SPY	ETF	523.76	526.45	520.75	521.8	990716.0
2025-04-04 07:00:00	SPY	ETF	521.97	523.69	517.24	517.59	1088751.0
2025-04-04 07:30:00	SPY	ETF	517.49	523.24	515.95	523.01	1345628.0
2025-04-04 08:00:00	SPY	ETF	523.01	537.0	516.0	523.11	1583353.0
2025-04-04 08:30:00	SPY	ETF	523.3	525.68	520.8	524.82	2071361.0
2025-04-04 09:00:00	SPY	ETF	524.93	526.56	522.82	523.73	1858781.0
2025-04-04 09:30:00	SPY	ETF	523.73	525.87	519.15	523.18	14615349.0
2025-04-04 10:00:00	SPY	ETF	523.18	523.26	516.24	516.29	8360824.0
2025-04-04 10:30:00	SPY	ETF	516.26	517.53	510.05	515.525	12437021.0
2025-04-04 11:00:00	SPY	ETF	515.47	522.59	514.79	516.35	14942819.0
2025-04-04 11:30:00	SPY	ETF	516.4	518.35	514.0	514.96	7089477.0
2025-04-04 12:00:00	SPY	ETF	514.98	517.4585	511.86	512.39	4756509.0
2025-04-04 12:30:00	SPY	ETF	512.34	514.36	510.91	512.075	5528163.0
2025-04-04 13:00:00	SPY	ETF	512.08	513.59	508.325	511.16	6917405.0
2025-04-04 13:30:00	SPY	ETF	511.16	514.64	509.749	514.57	6353151.0
2025-04-04 14:00:00	SPY	ETF	514.59	515.82	508.56	508.8	6981430.0
2025-04-04 14:30:00	SPY	ETF	508.91	509.26	505.52	507.78	7895063.0
2025-04-04 15:00:00	SPY	ETF	507.78	512.04	506.39	510.52	8891432.0
2025-04-04 15:30:00	SPY	ETF	510.53	513.9197	505.06	505.5	24363314.0
2025-04-04 16:00:00	SPY	ETF	505.5	514.4198	502.19	503.02	12993014.0
2025-04-04 16:30:00	SPY	ETF	503.2	505.52	502.86	504.5	1068863.0
2025-04-04 17:00:00	SPY	ETF	504.6725	505.25	504.56	505.03	356884.0
2025-04-04 17:30:00	SPY	ETF	505.03	506.26	504.87	505.0799	228992.0
2025-04-04 18:00:00	SPY	ETF	504.94	505.59	504.6404	505.2387	1469863.0
2025-04-04 18:30:00	SPY	ETF	505.3	505.55	504.78	505.2	96318.0
2025-04-04 19:00:00	SPY	ETF	504.95	505.14	504.5	504.84	55142.0
2025-04-04 19:30:00	SPY	ETF	504.81	505.67	504.45	505.5	83377.0
2025-04-04 04:00:00	QQQ	ETF	450.0	450.15	448.09	449.57	85306.0
2025-04-04 04:30:00	QQQ	ETF	449.54	449.61	448.19	448.54	28914.0
2025-04-04 05:00:00	QQQ	ETF	448.57	448.7	447.44	447.46	55177.0
2025-04-04 05:30:00	QQQ	ETF	447.5	448.62	446.95	448.15	75278.0
2025-04-04 06:00:00	QQQ	ETF	448.26	448.71	436.83	436.89	787390.0
2025-04-04 06:30:00	QQQ	ETF	436.87	440.6	435.23	436.37	729266.0
2025-04-04 07:00:00	QQQ	ETF	436.44	438.21	431.5	432.17	708578.0
2025-04-04 07:30:00	QQQ	ETF	432.0	437.93	430.23	437.46	1106211.0
2025-04-04 08:00:00	QQQ	ETF	437.66	450.5	430.4784	437.81	1110271.0
2025-04-04 08:30:00	QQQ	ETF	438.69	440.7	435.82	439.54	1083919.0
2025-04-04 09:00:00	QQQ	ETF	439.55	441.0	437.44	437.97	708829.0
2025-04-04 09:30:00	QQQ	ETF	438.14	440.37	434.48	439.09	10592380.0
2025-04-04 10:00:00	QQQ	ETF	439.05	439.19	432.31	432.39	6174037.0
2025-04-04 10:30:00	QQQ	ETF	432.37	433.64	426.1	430.93	9492344.0
2025-04-04 11:00:00	QQQ	ETF	430.91	437.92	430.21	433.0	8070566.0
2025-04-04 11:30:00	QQQ	ETF	433.03	434.86	430.63	431.54	3779232.0
2025-04-04 12:00:00	QQQ	ETF	431.53	433.88	428.08	428.72	3036268.0
2025-04-04 12:30:00	QQQ	ETF	428.69	430.64	427.4	428.43	3658624.0

> showing 50 of 47,724 rows — these rows as CSV

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