PREVIEW / etf_30min / 2025-10-24

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-10-24.parquet
  size:    1.0 MB
  rows:    43,845

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-10-24 04:00:00	SPY	ETF	673.21	673.26	672.95	673.26	110107.0
2025-10-24 04:30:00	SPY	ETF	673.28	673.86	673.17	673.51	15850.0
2025-10-24 05:00:00	SPY	ETF	673.52	674.04	673.48	674.04	6676.0
2025-10-24 05:30:00	SPY	ETF	674.06	674.34	673.88	673.91	10955.0
2025-10-24 06:00:00	SPY	ETF	673.9	674.23	673.75	673.91	11228.0
2025-10-24 06:30:00	SPY	ETF	673.96	674.09	673.74	673.74	19665.0
2025-10-24 07:00:00	SPY	ETF	673.78	674.07	673.72	673.9	50719.0
2025-10-24 07:30:00	SPY	ETF	673.84	674.38	673.74	674.18	22233.0
2025-10-24 08:00:00	SPY	ETF	673.7214	674.4	672.88	674.09	180028.0
2025-10-24 08:30:00	SPY	ETF	673.8	678.0	673.74	675.7	901276.0
2025-10-24 09:00:00	SPY	ETF	675.73	676.64	671.76	676.4	334015.0
2025-10-24 09:30:00	SPY	ETF	676.46	677.79	675.65	677.29	6632182.0
2025-10-24 10:00:00	SPY	ETF	677.36	677.94	676.7406	676.78	3424196.0
2025-10-24 10:30:00	SPY	ETF	676.76	677.65	675.91	676.69	2815621.0
2025-10-24 11:00:00	SPY	ETF	676.68	678.38	676.475	678.15	3199027.0
2025-10-24 11:30:00	SPY	ETF	678.19	678.42	677.47	677.945	2499254.0
2025-10-24 12:00:00	SPY	ETF	677.92	678.46	677.83	677.885	1808582.0
2025-10-24 12:30:00	SPY	ETF	677.89	678.2452	677.21	677.95	1846935.0
2025-10-24 13:00:00	SPY	ETF	677.94	678.23	677.63	678.06	1040808.0
2025-10-24 13:30:00	SPY	ETF	678.052	678.43	677.95	678.0702	1335472.0
2025-10-24 14:00:00	SPY	ETF	678.07	678.34	677.87	678.17	1310443.0
2025-10-24 14:30:00	SPY	ETF	678.16	678.33	677.75	678.1844	1668725.0
2025-10-24 15:00:00	SPY	ETF	678.19	678.47	678.05	678.242	2370122.0
2025-10-24 15:30:00	SPY	ETF	678.24	678.27	676.765	677.12	9855065.0
2025-10-24 16:00:00	SPY	ETF	677.11	677.32	676.68	677.14	3631091.0
2025-10-24 16:30:00	SPY	ETF	677.14	677.34	676.93	676.93	437828.0
2025-10-24 17:00:00	SPY	ETF	677.0398	677.0398	676.97	677.02	46215.0
2025-10-24 17:30:00	SPY	ETF	677.02	677.3	676.96	677.2	481830.0
2025-10-24 18:00:00	SPY	ETF	677.23	677.29	677.2	677.2	2129.0
2025-10-24 18:30:00	SPY	ETF	677.15	677.23	677.11	677.23	2684.0
2025-10-24 19:00:00	SPY	ETF	677.18	677.3	677.15	677.3	19684.0
2025-10-24 19:30:00	SPY	ETF	677.19	677.3	677.19	677.3	16254.0
2025-10-24 04:00:00	QQQ	ETF	612.8	613.13	612.6	613.1	63265.0
2025-10-24 04:30:00	QQQ	ETF	613.12	613.68	612.85	613.25	54947.0
2025-10-24 05:00:00	QQQ	ETF	613.31	613.92	613.28	613.9	31453.0
2025-10-24 05:30:00	QQQ	ETF	613.9	614.22	613.83	613.83	31378.0
2025-10-24 06:00:00	QQQ	ETF	613.85	614.17	613.66	613.79	27992.0
2025-10-24 06:30:00	QQQ	ETF	613.84	614.05	613.58	613.59	35325.0
2025-10-24 07:00:00	QQQ	ETF	613.62	613.94	613.52	613.66	53370.0
2025-10-24 07:30:00	QQQ	ETF	613.66	614.05	613.53	613.75	51913.0
2025-10-24 08:00:00	QQQ	ETF	613.6	614.19	610.123	613.85	219139.0
2025-10-24 08:30:00	QQQ	ETF	613.56	617.28	613.22	615.8	828076.0
2025-10-24 09:00:00	QQQ	ETF	615.83	616.64	615.7	616.0	377032.0
2025-10-24 09:30:00	QQQ	ETF	615.99	617.53	615.13	616.97	5142369.0
2025-10-24 10:00:00	QQQ	ETF	617.02	617.9	616.62	616.76	3472857.0
2025-10-24 10:30:00	QQQ	ETF	616.75	617.64	615.18	616.045	2838229.0
2025-10-24 11:00:00	QQQ	ETF	616.04	617.84	615.76	617.61	2002888.0
2025-10-24 11:30:00	QQQ	ETF	617.63	617.89	616.83	617.3501	1969218.0
2025-10-24 12:00:00	QQQ	ETF	617.34	618.27	617.31	617.6656	1504733.0
2025-10-24 12:30:00	QQQ	ETF	617.67	618.27	617.28	618.0	1472200.0

> showing 50 of 43,845 rows — these rows as CSV

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