PREVIEW / etf_30min / 2025-07-08

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-07-08.parquet
  size:    985 KB
  rows:    40,660

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-08 04:00:00	SPY	ETF	621.22	621.92	621.22	621.59	18226.0
2025-07-08 04:30:00	SPY	ETF	621.62	621.67	621.37	621.57	4178.0
2025-07-08 05:00:00	SPY	ETF	621.52	621.67	621.25	621.58	5872.0
2025-07-08 05:30:00	SPY	ETF	621.49	621.49	620.93	621.17	5615.0
2025-07-08 06:00:00	SPY	ETF	621.0	621.16	620.72	621.0	8568.0
2025-07-08 06:30:00	SPY	ETF	621.02	621.85	621.02	621.5	43022.0
2025-07-08 07:00:00	SPY	ETF	621.59	621.9	621.34	621.75	50737.0
2025-07-08 07:30:00	SPY	ETF	621.72	621.97	621.44	621.499	70110.0
2025-07-08 08:00:00	SPY	ETF	621.42	622.0	620.85	621.45	101452.0
2025-07-08 08:30:00	SPY	ETF	621.4411	621.47	620.95	621.46	66145.0
2025-07-08 09:00:00	SPY	ETF	621.49	621.66	621.24	621.32	88552.0
2025-07-08 09:30:00	SPY	ETF	621.35	621.665	620.55	620.66	3897370.0
2025-07-08 10:00:00	SPY	ETF	620.68	620.93	619.642	620.01	3102096.0
2025-07-08 10:30:00	SPY	ETF	620.025	621.495	619.52	620.43	4542516.0
2025-07-08 11:00:00	SPY	ETF	620.43	621.1001	619.72	619.964	2711187.0
2025-07-08 11:30:00	SPY	ETF	619.98	621.22	619.98	621.065	2019113.0
2025-07-08 12:00:00	SPY	ETF	621.0612	622.11	620.52	621.875	2901209.0
2025-07-08 12:30:00	SPY	ETF	621.89	622.05	620.4	620.8	3680653.0
2025-07-08 13:00:00	SPY	ETF	620.79	620.9499	619.84	620.835	2442816.0
2025-07-08 13:30:00	SPY	ETF	620.83	621.31	620.2	621.17	1859003.0
2025-07-08 14:00:00	SPY	ETF	621.15	621.3022	620.61	620.65	2004482.0
2025-07-08 14:30:00	SPY	ETF	620.66	620.925	620.3	620.52	2028344.0
2025-07-08 15:00:00	SPY	ETF	620.52	620.64	620.09	620.51	2709879.0
2025-07-08 15:30:00	SPY	ETF	620.51	620.81	619.99	620.31	7602480.0
2025-07-08 16:00:00	SPY	ETF	620.3	620.65	620.14	620.49	2180420.0
2025-07-08 16:30:00	SPY	ETF	620.5	620.55	620.36	620.4	111510.0
2025-07-08 17:00:00	SPY	ETF	620.42	620.45	620.3	620.34	5129.0
2025-07-08 17:30:00	SPY	ETF	620.32	620.44	620.3	620.38	11561.0
2025-07-08 18:00:00	SPY	ETF	620.41	620.8	620.41	620.5781	20854.0
2025-07-08 18:30:00	SPY	ETF	620.36	620.5999	620.36	620.5412	10344.0
2025-07-08 19:00:00	SPY	ETF	620.6	620.83	620.2603	620.47	33444.0
2025-07-08 19:30:00	SPY	ETF	620.4	620.5	620.26	620.26	58136.0
2025-07-08 04:00:00	QQQ	ETF	553.95	554.01	553.5	553.65	31158.0
2025-07-08 04:30:00	QQQ	ETF	553.63	553.79	553.37	553.68	14710.0
2025-07-08 05:00:00	QQQ	ETF	553.45	553.78	553.27	553.63	10740.0
2025-07-08 05:30:00	QQQ	ETF	553.55	553.6	553.04	553.14	9148.0
2025-07-08 06:00:00	QQQ	ETF	553.2	553.2	552.7	553.11	14764.0
2025-07-08 06:30:00	QQQ	ETF	553.08	553.78	553.06	553.61	32632.0
2025-07-08 07:00:00	QQQ	ETF	553.59	553.72	553.251	553.63	23844.0
2025-07-08 07:30:00	QQQ	ETF	553.6	553.86	553.41	553.53	12485.0
2025-07-08 08:00:00	QQQ	ETF	553.45	554.26	551.616	553.57	103507.0
2025-07-08 08:30:00	QQQ	ETF	553.51	553.51	552.89	553.38	95955.0
2025-07-08 09:00:00	QQQ	ETF	553.45	553.84	553.271	553.33	93074.0
2025-07-08 09:30:00	QQQ	ETF	553.38	553.55	552.1	552.11	2788029.0
2025-07-08 10:00:00	QQQ	ETF	552.11	552.5	551.29	551.9	2119726.0
2025-07-08 10:30:00	QQQ	ETF	551.9	553.53	551.1	552.359	3259821.0
2025-07-08 11:00:00	QQQ	ETF	552.35	552.86	551.4351	551.77	1904955.0
2025-07-08 11:30:00	QQQ	ETF	551.77	552.78	551.77	552.65	1042369.0
2025-07-08 12:00:00	QQQ	ETF	552.66	554.01	552.5	553.64	1382898.0
2025-07-08 12:30:00	QQQ	ETF	553.65	553.77	552.24	552.91	1911787.0

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

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