PREVIEW / etf_30min / 2025-06-09

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-06-09.parquet
  size:    969 KB
  rows:    40,376

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-09 04:00:00	SPY	ETF	599.45	599.82	599.31	599.31	76533.0
2025-06-09 04:30:00	SPY	ETF	599.18	600.0	599.1	599.88	7076.0
2025-06-09 05:00:00	SPY	ETF	599.94	599.95	599.5	599.84	10585.0
2025-06-09 05:30:00	SPY	ETF	599.82	599.89	599.55	599.55	3609.0
2025-06-09 06:00:00	SPY	ETF	599.48	599.63	599.31	599.36	5292.0
2025-06-09 06:30:00	SPY	ETF	599.4	599.57	599.12	599.33	9654.0
2025-06-09 07:00:00	SPY	ETF	599.35	599.99	599.32	599.69	76368.0
2025-06-09 07:30:00	SPY	ETF	599.81	600.37	599.75	600.15	98697.0
2025-06-09 08:00:00	SPY	ETF	599.58	600.37	598.1	600.09	117963.0
2025-06-09 08:30:00	SPY	ETF	600.08	600.21	599.51	599.76	134320.0
2025-06-09 09:00:00	SPY	ETF	599.79	600.1	599.63	599.79	149422.0
2025-06-09 09:30:00	SPY	ETF	599.74	599.99	598.49	598.895	4052834.0
2025-06-09 10:00:00	SPY	ETF	598.93	599.97	598.79	599.71	3342253.0
2025-06-09 10:30:00	SPY	ETF	599.71	600.4	599.03	599.51	3477342.0
2025-06-09 11:00:00	SPY	ETF	599.52	599.86	599.05	599.215	1813267.0
2025-06-09 11:30:00	SPY	ETF	599.22	600.01	599.19	599.85	1678442.0
2025-06-09 12:00:00	SPY	ETF	599.86	600.015	599.36	599.79	1603342.0
2025-06-09 12:30:00	SPY	ETF	599.78	601.1	599.78	600.67	2266566.0
2025-06-09 13:00:00	SPY	ETF	600.69	601.13	600.105	600.83	1860387.0
2025-06-09 13:30:00	SPY	ETF	600.83	601.215	600.56	600.94	1558386.0
2025-06-09 14:00:00	SPY	ETF	600.94	601.25	600.74	601.05	1489727.0
2025-06-09 14:30:00	SPY	ETF	601.02	601.22	600.34	600.995	2686322.0
2025-06-09 15:00:00	SPY	ETF	601.0	601.14	600.33	600.54	2138543.0
2025-06-09 15:30:00	SPY	ETF	600.53	600.74	599.42	599.56	8196432.0
2025-06-09 16:00:00	SPY	ETF	599.56	599.77	599.24	599.44	1735706.0
2025-06-09 16:30:00	SPY	ETF	599.42	599.7	599.4	599.7	83152.0
2025-06-09 17:00:00	SPY	ETF	599.72	599.75	599.64	599.75	58141.0
2025-06-09 17:30:00	SPY	ETF	599.75	599.8	599.71	599.74	33499.0
2025-06-09 18:00:00	SPY	ETF	599.78	600.2	599.68	600.0	65869.0
2025-06-09 18:30:00	SPY	ETF	599.92	599.92	599.74	599.79	19853.0
2025-06-09 19:00:00	SPY	ETF	599.909	599.9493	599.77	599.8517	10566.0
2025-06-09 19:30:00	SPY	ETF	599.9599	599.9599	599.85	599.88	19127.0
2025-06-09 04:00:00	QQQ	ETF	530.01	530.18	529.4	529.5	32307.0
2025-06-09 04:30:00	QQQ	ETF	529.5	530.16	529.21	529.99	21576.0
2025-06-09 05:00:00	QQQ	ETF	529.97	530.04	529.57	529.91	11063.0
2025-06-09 05:30:00	QQQ	ETF	529.9	529.94	529.69	529.73	14128.0
2025-06-09 06:00:00	QQQ	ETF	529.69	529.94	529.6	529.68	27418.0
2025-06-09 06:30:00	QQQ	ETF	529.68	529.84	529.32	529.6	21390.0
2025-06-09 07:00:00	QQQ	ETF	529.57	530.31	529.57	530.0	48213.0
2025-06-09 07:30:00	QQQ	ETF	529.98	530.75	529.94	530.44	48393.0
2025-06-09 08:00:00	QQQ	ETF	529.5899	530.7286	528.59	530.37	79327.0
2025-06-09 08:30:00	QQQ	ETF	530.34	530.55	530.07	530.13	74130.0
2025-06-09 09:00:00	QQQ	ETF	530.1	530.52	530.08	530.18	95605.0
2025-06-09 09:30:00	QQQ	ETF	530.14	530.67	529.01	529.88	3335927.0
2025-06-09 10:00:00	QQQ	ETF	529.92	531.79	529.91	531.46	2143289.0
2025-06-09 10:30:00	QQQ	ETF	531.46	532.35	530.93	531.22	2005506.0
2025-06-09 11:00:00	QQQ	ETF	531.22	531.85	530.53	530.7907	1516609.0
2025-06-09 11:30:00	QQQ	ETF	530.81	531.33	530.68	531.13	1243219.0
2025-06-09 12:00:00	QQQ	ETF	531.15	531.39	530.59	530.92	925235.0
2025-06-09 12:30:00	QQQ	ETF	530.93	532.23	530.92	531.8864	1412874.0

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

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