PREVIEW / etf_30min / 2025-04-08

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-04-08.parquet
  size:    1.0 MB
  rows:    45,494

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-08 04:00:00	SPY	ETF	510.22	513.53	510.07	510.42	91778.0
2025-04-08 04:30:00	SPY	ETF	510.55	512.91	510.5	512.88	47336.0
2025-04-08 05:00:00	SPY	ETF	512.5	512.98	511.35	511.63	80740.0
2025-04-08 05:30:00	SPY	ETF	511.78	512.71	510.61	510.67	38698.0
2025-04-08 06:00:00	SPY	ETF	510.59	511.35	510.0	511.14	113277.0
2025-04-08 06:30:00	SPY	ETF	511.08	512.76	511.0	511.74	161965.0
2025-04-08 07:00:00	SPY	ETF	511.94	513.77	511.19	513.2	372061.0
2025-04-08 07:30:00	SPY	ETF	513.13	518.3	512.98	518.22	612726.0
2025-04-08 08:00:00	SPY	ETF	518.0	519.3	509.04	518.01	1034077.0
2025-04-08 08:30:00	SPY	ETF	517.68	518.19	515.8	517.03	487833.0
2025-04-08 09:00:00	SPY	ETF	517.0	522.2	516.49	521.95	2810241.0
2025-04-08 09:30:00	SPY	ETF	521.87	523.29	517.79	522.5926	12994296.0
2025-04-08 10:00:00	SPY	ETF	522.59	524.98	522.14	523.37	6942516.0
2025-04-08 10:30:00	SPY	ETF	523.36	524.21	517.81	517.85	5481365.0
2025-04-08 11:00:00	SPY	ETF	517.86	519.27	514.1	514.16	6733420.0
2025-04-08 11:30:00	SPY	ETF	514.19	518.525	514.0	516.77	5137330.0
2025-04-08 12:00:00	SPY	ETF	516.74	517.29	511.8	513.96	4223114.0
2025-04-08 12:30:00	SPY	ETF	513.95	514.6	507.02	507.1442	11517192.0
2025-04-08 13:00:00	SPY	ETF	507.08	508.57	502.25	502.45	9746385.0
2025-04-08 13:30:00	SPY	ETF	502.37	509.11	502.03	506.72	7557494.0
2025-04-08 14:00:00	SPY	ETF	506.76	507.12	502.07	502.41	4541247.0
2025-04-08 14:30:00	SPY	ETF	502.44	507.82	501.4	501.69	6836101.0
2025-04-08 15:00:00	SPY	ETF	501.71	502.12	494.34	497.51	10354838.0
2025-04-08 15:30:00	SPY	ETF	497.53	497.59	489.16	496.74	24035824.0
2025-04-08 16:00:00	SPY	ETF	496.75	498.64	486.2007	494.68	6374757.0
2025-04-08 16:30:00	SPY	ETF	494.68	496.38	494.64	496.0	593397.0
2025-04-08 17:00:00	SPY	ETF	495.95	496.26	495.5	495.87	161434.0
2025-04-08 17:30:00	SPY	ETF	495.8699	496.5	495.84	495.85	227126.0
2025-04-08 18:00:00	SPY	ETF	495.84	496.22	489.93	491.3801	674382.0
2025-04-08 18:30:00	SPY	ETF	491.6	492.68	490.2	492.25	132482.0
2025-04-08 19:00:00	SPY	ETF	492.15	492.15	487.82	488.1	288967.0
2025-04-08 19:30:00	SPY	ETF	488.2	490.6	487.75	490.5665	324643.0
2025-04-08 04:00:00	QQQ	ETF	431.25	432.0	427.73	428.26	122876.0
2025-04-08 04:30:00	QQQ	ETF	428.38	430.52	428.25	430.3	92515.0
2025-04-08 05:00:00	QQQ	ETF	429.89	430.41	428.65	428.9	75702.0
2025-04-08 05:30:00	QQQ	ETF	429.11	429.85	427.91	427.91	73870.0
2025-04-08 06:00:00	QQQ	ETF	427.9	428.79	427.32	428.47	89706.0
2025-04-08 06:30:00	QQQ	ETF	428.43	430.22	428.35	429.3	33004.0
2025-04-08 07:00:00	QQQ	ETF	429.4	431.12	428.87	430.42	321221.0
2025-04-08 07:30:00	QQQ	ETF	430.29	435.05	430.12	434.88	399505.0
2025-04-08 08:00:00	QQQ	ETF	429.94	436.0	426.74	434.85	786062.0
2025-04-08 08:30:00	QQQ	ETF	434.66	435.0	432.8	434.18	345253.0
2025-04-08 09:00:00	QQQ	ETF	434.03	438.52	433.8	438.23	1272390.0
2025-04-08 09:30:00	QQQ	ETF	438.11	440.969	436.06	440.57	9907116.0
2025-04-08 10:00:00	QQQ	ETF	440.53	443.1384	439.905	441.385	4953501.0
2025-04-08 10:30:00	QQQ	ETF	441.39	442.52	437.331	437.36	3695070.0
2025-04-08 11:00:00	QQQ	ETF	437.3901	438.92	434.06	434.09	4488688.0
2025-04-08 11:30:00	QQQ	ETF	434.155	437.81	433.39	435.75	3088220.0
2025-04-08 12:00:00	QQQ	ETF	435.75	436.2899	430.7	432.58	3101164.0
2025-04-08 12:30:00	QQQ	ETF	432.57	433.22	426.2005	426.38	6091979.0

> showing 50 of 45,494 rows — these rows as CSV

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