PREVIEW / etf_30min / 2025-07-16

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-07-16.parquet
  size:    1009 KB
  rows:    41,437

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-16 04:00:00	SPY	ETF	621.88	621.88	620.89	621.4	31965.0
2025-07-16 04:30:00	SPY	ETF	621.4	622.0	621.4	621.73	11427.0
2025-07-16 05:00:00	SPY	ETF	621.85	621.85	621.44	621.55	7802.0
2025-07-16 05:30:00	SPY	ETF	621.38	621.78	621.31	621.75	12712.0
2025-07-16 06:00:00	SPY	ETF	621.71	621.89	621.67	621.86	2563.0
2025-07-16 06:30:00	SPY	ETF	621.85	622.15	621.64	622.0	31962.0
2025-07-16 07:00:00	SPY	ETF	621.98	622.2	621.75	622.08	47289.0
2025-07-16 07:30:00	SPY	ETF	621.98	622.22	621.67	622.21	48363.0
2025-07-16 08:00:00	SPY	ETF	622.21	622.65	619.8	622.48	176348.0
2025-07-16 08:30:00	SPY	ETF	622.49	623.93	622.43	623.65	475632.0
2025-07-16 09:00:00	SPY	ETF	623.65	623.81	623.31	623.74	259199.0
2025-07-16 09:30:00	SPY	ETF	623.76	624.12	622.02	622.1101	5095082.0
2025-07-16 10:00:00	SPY	ETF	622.12	622.86	621.68	622.49	3182956.0
2025-07-16 10:30:00	SPY	ETF	622.49	623.37	621.51	622.17	6427712.0
2025-07-16 11:00:00	SPY	ETF	622.17	623.36	619.46	621.315	12828048.0
2025-07-16 11:30:00	SPY	ETF	621.35	622.54	618.05	621.96	14695784.0
2025-07-16 12:00:00	SPY	ETF	621.95	622.24	621.04	621.67	4277293.0
2025-07-16 12:30:00	SPY	ETF	621.675	623.135	621.14	623.1048	2905171.0
2025-07-16 13:00:00	SPY	ETF	623.1	623.79	622.91	623.1	2464222.0
2025-07-16 13:30:00	SPY	ETF	623.1	623.375	622.92	623.0857	1526603.0
2025-07-16 14:00:00	SPY	ETF	623.09	623.4601	622.72	623.35	1983660.0
2025-07-16 14:30:00	SPY	ETF	623.345	624.3599	623.345	624.3489	2369013.0
2025-07-16 15:00:00	SPY	ETF	624.34	624.52	623.825	624.1401	2511181.0
2025-07-16 15:30:00	SPY	ETF	624.14	624.73	623.885	624.18	6345621.0
2025-07-16 16:00:00	SPY	ETF	624.18	624.23	623.63	623.68	2212085.0
2025-07-16 16:30:00	SPY	ETF	623.67	623.91	623.66	623.81	185656.0
2025-07-16 17:00:00	SPY	ETF	623.82	623.98	623.8	623.95	44347.0
2025-07-16 17:30:00	SPY	ETF	623.95	624.0	623.85	623.85	36789.0
2025-07-16 18:00:00	SPY	ETF	623.9	623.92	623.25	623.369	64374.0
2025-07-16 18:30:00	SPY	ETF	623.369	623.43	623.08	623.19	72058.0
2025-07-16 19:00:00	SPY	ETF	623.23	623.34	623.12	623.12	15929.0
2025-07-16 19:30:00	SPY	ETF	623.19	623.33	623.08	623.18	29508.0
2025-07-16 04:00:00	QQQ	ETF	555.12	555.77	554.9	555.28	21911.0
2025-07-16 04:30:00	QQQ	ETF	555.3	555.88	555.3	555.58	16730.0
2025-07-16 05:00:00	QQQ	ETF	555.6	555.61	555.11	555.16	10578.0
2025-07-16 05:30:00	QQQ	ETF	555.1	555.52	555.05	555.52	12198.0
2025-07-16 06:00:00	QQQ	ETF	555.51	555.62	555.35	555.52	14426.0
2025-07-16 06:30:00	QQQ	ETF	555.56	556.01	555.5	555.84	29883.0
2025-07-16 07:00:00	QQQ	ETF	555.83	556.1	555.71	555.8	55571.0
2025-07-16 07:30:00	QQQ	ETF	555.78	556.04	555.46	556.04	39900.0
2025-07-16 08:00:00	QQQ	ETF	555.96	556.36	553.95	556.12	130107.0
2025-07-16 08:30:00	QQQ	ETF	556.26	557.51	556.26	557.27	294152.0
2025-07-16 09:00:00	QQQ	ETF	557.28	557.4	556.96	557.32	146859.0
2025-07-16 09:30:00	QQQ	ETF	557.28	557.67	554.52	554.77	3534119.0
2025-07-16 10:00:00	QQQ	ETF	554.78	555.7951	554.31	555.655	2584437.0
2025-07-16 10:30:00	QQQ	ETF	555.66	556.3	554.6	555.27	2959939.0
2025-07-16 11:00:00	QQQ	ETF	555.31	556.58	553.07	555.0448	4493237.0
2025-07-16 11:30:00	QQQ	ETF	555.04	556.08	551.56	555.27	6505839.0
2025-07-16 12:00:00	QQQ	ETF	555.27	555.68	554.4	555.1	1880679.0
2025-07-16 12:30:00	QQQ	ETF	555.14	556.66	554.6	556.595	1716651.0

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

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