PREVIEW / etf_30min / 2025-07-02

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-07-02.parquet
  size:    1019 KB
  rows:    41,382

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-07-02 04:00:00	SPY	ETF	618.49	618.79	618.15	618.37	26238.0
2025-07-02 04:30:00	SPY	ETF	618.22	618.41	618.02	618.26	12346.0
2025-07-02 05:00:00	SPY	ETF	618.26	618.44	618.07	618.37	14585.0
2025-07-02 05:30:00	SPY	ETF	618.4	618.45	618.14	618.43	9398.0
2025-07-02 06:00:00	SPY	ETF	618.4	618.44	618.24	618.24	3773.0
2025-07-02 06:30:00	SPY	ETF	618.22	618.39	617.99	618.25	26310.0
2025-07-02 07:00:00	SPY	ETF	618.25	618.49	618.14	618.42	20594.0
2025-07-02 07:30:00	SPY	ETF	618.47	618.58	617.4	617.78	62390.0
2025-07-02 08:00:00	SPY	ETF	617.7325	619.68	617.04	617.46	193524.0
2025-07-02 08:30:00	SPY	ETF	617.44	617.5	616.35	616.72	317925.0
2025-07-02 09:00:00	SPY	ETF	616.77	617.36	616.54	617.26	189779.0
2025-07-02 09:30:00	SPY	ETF	617.24	617.64	616.61	617.3094	4265546.0
2025-07-02 10:00:00	SPY	ETF	617.31	618.72	617.28	618.6	4200097.0
2025-07-02 10:30:00	SPY	ETF	618.6	619.165	618.2	618.74	4268516.0
2025-07-02 11:00:00	SPY	ETF	618.77	619.12	618.55	618.79	2592518.0
2025-07-02 11:30:00	SPY	ETF	618.79	619.455	618.74	619.2719	2527311.0
2025-07-02 12:00:00	SPY	ETF	619.27	619.33	618.86	619.155	1975848.0
2025-07-02 12:30:00	SPY	ETF	619.16	619.601	619.0	619.585	2049224.0
2025-07-02 13:00:00	SPY	ETF	619.58	619.675	619.12	619.48	1848950.0
2025-07-02 13:30:00	SPY	ETF	619.47	619.72	619.28	619.4199	1705707.0
2025-07-02 14:00:00	SPY	ETF	619.42	619.6901	619.23	619.59	2244873.0
2025-07-02 14:30:00	SPY	ETF	619.58	619.94	619.575	619.855	2424913.0
2025-07-02 15:00:00	SPY	ETF	619.855	620.17	619.72	619.76	2973249.0
2025-07-02 15:30:00	SPY	ETF	619.75	620.49	619.61	620.39	7747760.0
2025-07-02 16:00:00	SPY	ETF	620.37	620.45	619.19	620.11	2353199.0
2025-07-02 16:30:00	SPY	ETF	620.1	620.76	620.07	620.54	260075.0
2025-07-02 17:00:00	SPY	ETF	620.59	620.71	620.51	620.68	79462.0
2025-07-02 17:30:00	SPY	ETF	620.65	620.71	620.5354	620.54	31638.0
2025-07-02 18:00:00	SPY	ETF	620.54	620.72	620.2	620.27	59139.0
2025-07-02 18:30:00	SPY	ETF	620.27	620.57	620.25	620.51	11758.0
2025-07-02 19:00:00	SPY	ETF	620.58	620.6	620.49	620.56	2804.0
2025-07-02 19:30:00	SPY	ETF	620.59	620.669	620.55	620.6492	20524.0
2025-07-02 20:00:00	SPY	ETF	620.62	620.62	620.62	620.62	200.0
2025-07-02 04:00:00	QQQ	ETF	547.87	548.19	547.61	547.8	21608.0
2025-07-02 04:30:00	QQQ	ETF	547.63	547.76	547.39	547.48	29107.0
2025-07-02 05:00:00	QQQ	ETF	547.59	547.59	547.16	547.5	15878.0
2025-07-02 05:30:00	QQQ	ETF	547.59	547.65	547.24	547.61	19618.0
2025-07-02 06:00:00	QQQ	ETF	547.57	547.7	547.11	547.14	5620.0
2025-07-02 06:30:00	QQQ	ETF	547.08	547.37	546.67	546.95	38130.0
2025-07-02 07:00:00	QQQ	ETF	546.95	547.23	546.83	547.16	39425.0
2025-07-02 07:30:00	QQQ	ETF	547.14	547.35	545.82	546.42	43840.0
2025-07-02 08:00:00	QQQ	ETF	547.14	549.1	545.43	545.8	218406.0
2025-07-02 08:30:00	QQQ	ETF	545.81	548.94	544.54	545.28	186409.0
2025-07-02 09:00:00	QQQ	ETF	545.31	546.25	544.97	546.17	249686.0
2025-07-02 09:30:00	QQQ	ETF	546.16	547.958	546.12	547.42	3542272.0
2025-07-02 10:00:00	QQQ	ETF	547.41	549.64	547.34	549.465	2531519.0
2025-07-02 10:30:00	QQQ	ETF	549.45	550.4112	549.03	549.93	2638011.0
2025-07-02 11:00:00	QQQ	ETF	549.94	550.7599	549.62	549.73	2375616.0
2025-07-02 11:30:00	QQQ	ETF	549.74	550.31	549.66	550.18	1370523.0
2025-07-02 12:00:00	QQQ	ETF	550.17	550.7	549.88	550.42	1268258.0

> showing 50 of 41,382 rows — these rows as CSV

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