PREVIEW / etf_30min / 2025-06-13

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-06-13.parquet
  size:    948 KB
  rows:    40,384

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-13 04:00:00	SPY	ETF	596.34	597.5	594.48	596.87	177974.0
2025-06-13 04:30:00	SPY	ETF	596.87	596.93	595.96	596.39	43515.0
2025-06-13 05:00:00	SPY	ETF	596.41	597.41	595.86	597.14	100951.0
2025-06-13 05:30:00	SPY	ETF	597.09	597.16	596.41	596.91	41083.0
2025-06-13 06:00:00	SPY	ETF	597.02	597.45	596.4	597.22	74427.0
2025-06-13 06:30:00	SPY	ETF	597.11	597.87	596.91	597.63	122451.0
2025-06-13 07:00:00	SPY	ETF	597.7	598.6	597.5	597.58	379304.0
2025-06-13 07:30:00	SPY	ETF	597.63	598.7	597.58	598.48	271860.0
2025-06-13 08:00:00	SPY	ETF	598.0	598.97	593.79	598.6386	371123.0
2025-06-13 08:30:00	SPY	ETF	598.68	599.1	597.87	598.09	224904.0
2025-06-13 09:00:00	SPY	ETF	598.11	599.04	597.25	598.53	430807.0
2025-06-13 09:30:00	SPY	ETF	598.5	600.37	597.86	598.15	6882853.0
2025-06-13 10:00:00	SPY	ETF	598.17	599.167	596.63	596.77	4485818.0
2025-06-13 10:30:00	SPY	ETF	596.77	599.42	596.65	599.14	4282701.0
2025-06-13 11:00:00	SPY	ETF	599.14	600.67	598.92	600.58	2917881.0
2025-06-13 11:30:00	SPY	ETF	600.57	601.71	600.292	601.25	3363794.0
2025-06-13 12:00:00	SPY	ETF	601.24	601.85	600.74	600.88	1985598.0
2025-06-13 12:30:00	SPY	ETF	600.89	601.49	600.285	601.065	2078956.0
2025-06-13 13:00:00	SPY	ETF	601.05	601.17	599.17	599.53	3030385.0
2025-06-13 13:30:00	SPY	ETF	599.52	600.15	598.96	599.78	2657747.0
2025-06-13 14:00:00	SPY	ETF	599.8	600.29	597.0	597.11	4945958.0
2025-06-13 14:30:00	SPY	ETF	597.1	597.36	595.59	597.21	6948972.0
2025-06-13 15:00:00	SPY	ETF	597.19	597.685	596.04	596.2692	5407103.0
2025-06-13 15:30:00	SPY	ETF	596.28	597.25	595.48	596.95	11314408.0
2025-06-13 16:00:00	SPY	ETF	596.95	597.7	596.66	597.0987	3841395.0
2025-06-13 16:30:00	SPY	ETF	597.1299	597.45	596.62	596.88	258453.0
2025-06-13 17:00:00	SPY	ETF	596.76	597.12	596.69	597.0	90599.0
2025-06-13 17:30:00	SPY	ETF	597.02	597.21	596.99	597.0	17564.0
2025-06-13 18:00:00	SPY	ETF	597.01	597.37	597.0	597.19	65117.0
2025-06-13 18:30:00	SPY	ETF	597.11	597.41	597.1	597.3	22559.0
2025-06-13 19:00:00	SPY	ETF	597.34	597.5	597.31	597.41	43726.0
2025-06-13 19:30:00	SPY	ETF	597.37	597.5	597.3018	597.49	25483.0
2025-06-13 04:00:00	QQQ	ETF	526.45	527.24	524.61	526.38	68600.0
2025-06-13 04:30:00	QQQ	ETF	526.29	526.39	525.33	525.68	38871.0
2025-06-13 05:00:00	QQQ	ETF	525.69	526.76	525.25	526.45	71886.0
2025-06-13 05:30:00	QQQ	ETF	526.37	526.52	525.69	526.31	40287.0
2025-06-13 06:00:00	QQQ	ETF	526.28	526.49	525.64	526.37	54105.0
2025-06-13 06:30:00	QQQ	ETF	526.21	527.0	526.02	526.88	63480.0
2025-06-13 07:00:00	QQQ	ETF	526.97	528.17	526.8	526.89	156193.0
2025-06-13 07:30:00	QQQ	ETF	526.91	528.03	526.82	527.79	165495.0
2025-06-13 08:00:00	QQQ	ETF	527.18	528.14	523.88	527.7683	301262.0
2025-06-13 08:30:00	QQQ	ETF	527.8	528.18	526.79	527.13	165586.0
2025-06-13 09:00:00	QQQ	ETF	527.06	527.69	526.4	527.69	257477.0
2025-06-13 09:30:00	QQQ	ETF	527.67	530.4	527.25	528.67	4449355.0
2025-06-13 10:00:00	QQQ	ETF	528.88	529.8079	526.14	526.37	3031525.0
2025-06-13 10:30:00	QQQ	ETF	526.3602	529.79	526.23	529.17	3229575.0
2025-06-13 11:00:00	QQQ	ETF	529.17	530.74	529.0	530.51	1971646.0
2025-06-13 11:30:00	QQQ	ETF	530.5	531.59	530.1812	531.37	1935324.0
2025-06-13 12:00:00	QQQ	ETF	531.36	531.87	530.91	531.025	1458946.0
2025-06-13 12:30:00	QQQ	ETF	531.04	531.605	530.52	531.25	1466009.0

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

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