PREVIEW / etf_30min / 2025-11-03

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-11-03.parquet
  size:    1.1 MB
  rows:    46,314

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-11-03 04:00:00	SPY	ETF	683.65	685.0	683.61	684.98	62908.0
2025-11-03 04:30:00	SPY	ETF	685.05	685.12	684.36	684.45	33364.0
2025-11-03 05:00:00	SPY	ETF	684.46	684.7	684.25	684.38	12382.0
2025-11-03 05:30:00	SPY	ETF	684.57	684.98	684.38	684.49	24338.0
2025-11-03 06:00:00	SPY	ETF	684.62	685.2	684.58	684.8	32424.0
2025-11-03 06:30:00	SPY	ETF	684.77	684.95	684.54	684.58	16073.0
2025-11-03 07:00:00	SPY	ETF	684.55	684.93	684.15	684.15	180178.0
2025-11-03 07:30:00	SPY	ETF	684.19	684.58	684.01	684.05	78004.0
2025-11-03 08:00:00	SPY	ETF	684.0	685.06	682.35	683.77	168420.0
2025-11-03 08:30:00	SPY	ETF	683.78	684.59	683.78	684.47	119957.0
2025-11-03 09:00:00	SPY	ETF	684.53	685.75	684.53	685.66	465273.0
2025-11-03 09:30:00	SPY	ETF	685.66	685.8	682.175	682.53	6969999.0
2025-11-03 10:00:00	SPY	ETF	682.55	683.01	680.24	680.46	4983752.0
2025-11-03 10:30:00	SPY	ETF	680.45	682.8	679.94	682.375	3989573.0
2025-11-03 11:00:00	SPY	ETF	682.37	682.9	681.825	682.0501	2044101.0
2025-11-03 11:30:00	SPY	ETF	682.06	683.61	681.95	683.41	2286413.0
2025-11-03 12:00:00	SPY	ETF	683.41	683.9	682.4298	682.748	2151604.0
2025-11-03 12:30:00	SPY	ETF	682.75	683.975	682.73	683.83	1551870.0
2025-11-03 13:00:00	SPY	ETF	683.85	684.21	683.5305	683.63	1476263.0
2025-11-03 13:30:00	SPY	ETF	683.64	684.23	683.4	683.59	1329672.0
2025-11-03 14:00:00	SPY	ETF	683.59	683.88	683.08	683.26	2227676.0
2025-11-03 14:30:00	SPY	ETF	683.25	683.64	682.58	683.4	2369573.0
2025-11-03 15:00:00	SPY	ETF	683.4	683.655	683.03	683.13	2255697.0
2025-11-03 15:30:00	SPY	ETF	683.14	683.38	682.45	683.35	7124315.0
2025-11-03 16:00:00	SPY	ETF	683.35	684.04	683.08	683.14	2502873.0
2025-11-03 16:30:00	SPY	ETF	683.15	683.37	683.11	683.29	94557.0
2025-11-03 17:00:00	SPY	ETF	683.2511	683.44	683.04	683.33	151181.0
2025-11-03 17:30:00	SPY	ETF	683.4	683.43	683.16	683.16	14105.0
2025-11-03 18:00:00	SPY	ETF	683.1	683.23	682.64	682.86	79106.0
2025-11-03 18:30:00	SPY	ETF	682.86	682.86	682.4	682.52	18019.0
2025-11-03 19:00:00	SPY	ETF	682.4	682.4	681.26	681.35	70239.0
2025-11-03 19:30:00	SPY	ETF	681.32	681.95	681.32	681.89	20758.0
2025-11-03 04:00:00	QQQ	ETF	632.0	633.05	630.43	633.05	136112.0
2025-11-03 04:30:00	QQQ	ETF	633.04	633.22	632.51	632.62	89758.0
2025-11-03 05:00:00	QQQ	ETF	632.67	633.0	632.47	632.84	99338.0
2025-11-03 05:30:00	QQQ	ETF	632.87	633.38	632.69	632.85	100640.0
2025-11-03 06:00:00	QQQ	ETF	632.86	633.75	632.86	633.38	109012.0
2025-11-03 06:30:00	QQQ	ETF	633.37	633.66	633.11	633.18	77407.0
2025-11-03 07:00:00	QQQ	ETF	633.18	633.83	633.09	633.15	182374.0
2025-11-03 07:30:00	QQQ	ETF	633.14	633.62	632.96	633.12	139168.0
2025-11-03 08:00:00	QQQ	ETF	633.09	633.8009	629.2	632.9	337568.0
2025-11-03 08:30:00	QQQ	ETF	632.89	634.0	632.89	633.94	217739.0
2025-11-03 09:00:00	QQQ	ETF	633.96	635.5	633.96	635.05	584022.0
2025-11-03 09:30:00	QQQ	ETF	635.12	635.82	632.33	632.76	4560535.0
2025-11-03 10:00:00	QQQ	ETF	632.82	633.2	630.28	630.5299	3120884.0
2025-11-03 10:30:00	QQQ	ETF	630.53	632.18	629.85	631.61	2708397.0
2025-11-03 11:00:00	QQQ	ETF	631.62	631.95	630.56	630.695	1663128.0
2025-11-03 11:30:00	QQQ	ETF	630.69	632.51	630.505	632.305	1899771.0
2025-11-03 12:00:00	QQQ	ETF	632.33	632.92	631.47	631.9	1757983.0
2025-11-03 12:30:00	QQQ	ETF	631.91	633.29	631.875	633.07	1384133.0

> showing 50 of 46,314 rows — these rows as CSV

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