PREVIEW / etf_30min / 2025-10-17

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-10-17.parquet
  size:    1.0 MB
  rows:    45,035

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-17 04:00:00	SPY	ETF	656.83	656.83	651.41	652.82	125420.0
2025-10-17 04:30:00	SPY	ETF	652.82	653.93	652.64	653.41	49100.0
2025-10-17 05:00:00	SPY	ETF	653.21	654.91	653.17	654.39	28499.0
2025-10-17 05:30:00	SPY	ETF	654.35	654.96	653.36	653.36	60100.0
2025-10-17 06:00:00	SPY	ETF	653.5	654.58	653.32	653.52	64134.0
2025-10-17 06:30:00	SPY	ETF	653.49	655.71	653.49	655.71	150463.0
2025-10-17 07:00:00	SPY	ETF	655.74	659.67	655.42	658.82	602304.0
2025-10-17 07:30:00	SPY	ETF	658.72	659.35	657.91	659.33	235727.0
2025-10-17 08:00:00	SPY	ETF	654.37	661.21	651.56	660.61	801871.0
2025-10-17 08:30:00	SPY	ETF	660.68	661.25	659.78	659.91	302627.0
2025-10-17 09:00:00	SPY	ETF	659.86	660.75	659.42	659.5	435171.0
2025-10-17 09:30:00	SPY	ETF	659.52	662.48	658.23	660.68	10330794.0
2025-10-17 10:00:00	SPY	ETF	660.67	663.715	659.66	662.31	5037619.0
2025-10-17 10:30:00	SPY	ETF	662.31	662.4	659.33	659.58	3795282.0
2025-10-17 11:00:00	SPY	ETF	659.56	661.68	658.51	659.42	3730080.0
2025-10-17 11:30:00	SPY	ETF	659.44	662.24	658.14	661.71	3693481.0
2025-10-17 12:00:00	SPY	ETF	661.7	663.36	661.63	663.11	2570114.0
2025-10-17 12:30:00	SPY	ETF	663.13	663.635	661.25	662.0	2699142.0
2025-10-17 13:00:00	SPY	ETF	662.02	662.13	660.55	661.19	2085472.0
2025-10-17 13:30:00	SPY	ETF	661.16	663.06	660.71	662.885	2577049.0
2025-10-17 14:00:00	SPY	ETF	662.87	665.04	662.87	664.63	3258946.0
2025-10-17 14:30:00	SPY	ETF	664.65	665.1	664.03	664.38	2457648.0
2025-10-17 15:00:00	SPY	ETF	664.39	665.755	664.365	665.13	3062819.0
2025-10-17 15:30:00	SPY	ETF	665.13	665.13	664.03	664.32	7283178.0
2025-10-17 16:00:00	SPY	ETF	664.32	665.24	664.13	665.01	2722861.0
2025-10-17 16:30:00	SPY	ETF	665.0	665.15	664.39	665.07	431416.0
2025-10-17 17:00:00	SPY	ETF	665.09	665.1	664.93	665.1	96613.0
2025-10-17 17:30:00	SPY	ETF	665.1	665.3499	665.04	665.17	59380.0
2025-10-17 18:00:00	SPY	ETF	665.17	665.3	665.01	665.01	36863.0
2025-10-17 18:30:00	SPY	ETF	665.01	665.01	664.72	664.77	27762.0
2025-10-17 19:00:00	SPY	ETF	664.81	664.81	664.5984	664.6	24780.0
2025-10-17 19:30:00	SPY	ETF	664.6	665.35	664.5	665.28	17299.0
2025-10-17 04:00:00	QQQ	ETF	591.56	591.99	590.11	591.75	196890.0
2025-10-17 04:30:00	QQQ	ETF	591.79	592.92	591.47	592.06	133409.0
2025-10-17 05:00:00	QQQ	ETF	591.98	593.72	591.9	593.08	121179.0
2025-10-17 05:30:00	QQQ	ETF	593.07	593.68	592.05	592.18	133842.0
2025-10-17 06:00:00	QQQ	ETF	592.2	593.37	591.86	592.05	126811.0
2025-10-17 06:30:00	QQQ	ETF	592.04	594.08	592.04	594.05	143011.0
2025-10-17 07:00:00	QQQ	ETF	594.06	598.07	593.9	597.2	361257.0
2025-10-17 07:30:00	QQQ	ETF	597.21	597.81	596.34	597.75	263443.0
2025-10-17 08:00:00	QQQ	ETF	597.71	599.541	590.41	598.69	591131.0
2025-10-17 08:30:00	QQQ	ETF	598.78	599.41	597.83	597.99	267097.0
2025-10-17 09:00:00	QQQ	ETF	597.93	598.84	597.52	597.92	321556.0
2025-10-17 09:30:00	QQQ	ETF	597.95	601.61	596.37	600.0	5339209.0
2025-10-17 10:00:00	QQQ	ETF	599.97	603.32	598.91	602.08	3484502.0
2025-10-17 10:30:00	QQQ	ETF	602.07	602.185	598.2	598.57	2727010.0
2025-10-17 11:00:00	QQQ	ETF	598.55	600.78	597.02	597.87	2551912.0
2025-10-17 11:30:00	QQQ	ETF	597.9	601.19	596.424	600.6007	2410458.0
2025-10-17 12:00:00	QQQ	ETF	600.62	603.1793	600.6	602.9999	2428823.0
2025-10-17 12:30:00	QQQ	ETF	602.95	603.58	601.06	601.87	2390001.0

> showing 50 of 45,035 rows — these rows as CSV

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