PREVIEW / etf_30min / 2025-06-30

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-06-30.parquet
  size:    1018 KB
  rows:    42,584

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-30 04:00:00	SPY	ETF	617.33	617.57	617.03	617.28	23145.0
2025-06-30 04:30:00	SPY	ETF	617.26	617.32	617.12	617.24	6014.0
2025-06-30 05:00:00	SPY	ETF	617.23	617.63	617.08	617.63	22589.0
2025-06-30 05:30:00	SPY	ETF	617.64	617.85	617.16	617.28	39772.0
2025-06-30 06:00:00	SPY	ETF	617.31	617.69	617.24	617.67	27786.0
2025-06-30 06:30:00	SPY	ETF	617.66	617.74	617.5	617.58	32435.0
2025-06-30 07:00:00	SPY	ETF	617.58	617.86	617.42	617.83	57472.0
2025-06-30 07:30:00	SPY	ETF	617.805	617.87	617.45	617.52	95887.0
2025-06-30 08:00:00	SPY	ETF	617.74	617.9	617.0	617.32	224026.0
2025-06-30 08:30:00	SPY	ETF	617.3	617.32	616.79	617.09	201241.0
2025-06-30 09:00:00	SPY	ETF	617.07	617.62	617.04	617.39	246282.0
2025-06-30 09:30:00	SPY	ETF	617.36	617.49	615.96	616.433	5630926.0
2025-06-30 10:00:00	SPY	ETF	616.44	616.82	615.93	616.7	3788893.0
2025-06-30 10:30:00	SPY	ETF	616.7	616.775	615.688	616.01	2485632.0
2025-06-30 11:00:00	SPY	ETF	616.01	616.59	615.71	616.205	3069542.0
2025-06-30 11:30:00	SPY	ETF	616.21	616.925	616.1	616.465	2165863.0
2025-06-30 12:00:00	SPY	ETF	616.47	616.9	616.11	616.2552	1575150.0
2025-06-30 12:30:00	SPY	ETF	616.24	617.13	616.195	616.64	2029128.0
2025-06-30 13:00:00	SPY	ETF	616.64	616.82	616.22	616.515	1688138.0
2025-06-30 13:30:00	SPY	ETF	616.515	616.64	615.04	615.84	3247712.0
2025-06-30 14:00:00	SPY	ETF	615.847	616.44	615.63	616.045	3371708.0
2025-06-30 14:30:00	SPY	ETF	616.04	616.94	615.32	616.93	4004338.0
2025-06-30 15:00:00	SPY	ETF	616.935	618.25	616.91	617.9	6768739.0
2025-06-30 15:30:00	SPY	ETF	617.9	619.22	617.4	617.88	16680567.0
2025-06-30 16:00:00	SPY	ETF	617.91	618.17	617.12	617.44	5408576.0
2025-06-30 16:30:00	SPY	ETF	617.45	617.66	617.3	617.3	228044.0
2025-06-30 17:00:00	SPY	ETF	617.32	617.4195	617.22	617.34	50744.0
2025-06-30 17:30:00	SPY	ETF	617.35	617.43	617.2157	617.4	14268.0
2025-06-30 18:00:00	SPY	ETF	617.27	617.68	617.16	617.55	75833.0
2025-06-30 18:30:00	SPY	ETF	617.58	617.6	617.05	617.05	8535.0
2025-06-30 19:00:00	SPY	ETF	617.14	617.32	617.07	617.07	9937.0
2025-06-30 19:30:00	SPY	ETF	617.05	617.779	616.94	617.71	27967.0
2025-06-30 04:00:00	QQQ	ETF	550.62	551.74	550.62	551.21	36237.0
2025-06-30 04:30:00	QQQ	ETF	551.21	551.42	550.93	551.33	13725.0
2025-06-30 05:00:00	QQQ	ETF	551.3	551.99	551.22	551.96	24211.0
2025-06-30 05:30:00	QQQ	ETF	551.97	552.26	551.45	551.46	33601.0
2025-06-30 06:00:00	QQQ	ETF	551.46	552.04	551.43	551.97	29685.0
2025-06-30 06:30:00	QQQ	ETF	552.0	552.09	551.68	551.74	15230.0
2025-06-30 07:00:00	QQQ	ETF	551.65	551.98	551.46	551.93	38583.0
2025-06-30 07:30:00	QQQ	ETF	551.84	552.03	551.5	551.76	43479.0
2025-06-30 08:00:00	QQQ	ETF	551.5	552.0	548.37	551.56	154878.0
2025-06-30 08:30:00	QQQ	ETF	551.47	551.54	550.82	551.15	109243.0
2025-06-30 09:00:00	QQQ	ETF	551.16	551.68	551.12	551.26	150872.0
2025-06-30 09:30:00	QQQ	ETF	551.26	551.31	549.01	550.13	3915418.0
2025-06-30 10:00:00	QQQ	ETF	550.13	550.76	549.7	550.4999	2331787.0
2025-06-30 10:30:00	QQQ	ETF	550.515	550.57	549.71	549.99	1562351.0
2025-06-30 11:00:00	QQQ	ETF	550.0	550.48	549.53	549.89	1519419.0
2025-06-30 11:30:00	QQQ	ETF	549.91	550.89	549.7005	550.5299	1258531.0
2025-06-30 12:00:00	QQQ	ETF	550.53	551.098	550.27	550.36	1215920.0
2025-06-30 12:30:00	QQQ	ETF	550.35	551.08	550.3	550.48	1145051.0

> showing 50 of 42,584 rows — these rows as CSV

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