PREVIEW / etf_30min / 2025-09-19

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-09-19.parquet
  size:    1.0 MB
  rows:    42,717

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-09-19 04:00:00	SPY	ETF	660.5	661.1	660.38	660.95	19139.0
2025-09-19 04:30:00	SPY	ETF	661.02	661.11	660.84	660.97	9301.0
2025-09-19 05:00:00	SPY	ETF	660.95	661.24	660.89	661.16	3329.0
2025-09-19 05:30:00	SPY	ETF	661.16	661.4	660.92	661.06	8382.0
2025-09-19 06:00:00	SPY	ETF	660.88	661.3	660.81	661.19	14608.0
2025-09-19 06:30:00	SPY	ETF	661.15	661.4	661.01	661.39	34546.0
2025-09-19 07:00:00	SPY	ETF	661.38	661.66	661.12	661.47	48245.0
2025-09-19 07:30:00	SPY	ETF	661.4	661.65	661.3	661.61	69859.0
2025-09-19 08:00:00	SPY	ETF	661.57	662.16	659.62	662.07	134986.0
2025-09-19 08:30:00	SPY	ETF	662.04	662.2	661.79	661.87	137480.0
2025-09-19 09:00:00	SPY	ETF	661.85	662.83	661.79	662.33	218767.0
2025-09-19 09:30:00	SPY	ETF	662.33	662.7	661.32	662.15	8111205.0
2025-09-19 10:00:00	SPY	ETF	662.14	662.4	661.67	661.92	3231104.0
2025-09-19 10:30:00	SPY	ETF	661.9	662.21	660.96	661.59	3392354.0
2025-09-19 11:00:00	SPY	ETF	661.59	661.945	660.63	660.76	2832858.0
2025-09-19 11:30:00	SPY	ETF	660.74	661.615	660.37	661.6	2429411.0
2025-09-19 12:00:00	SPY	ETF	661.59	662.68	661.57	662.49	3026192.0
2025-09-19 12:30:00	SPY	ETF	662.48	662.76	662.13	662.53	2150423.0
2025-09-19 13:00:00	SPY	ETF	662.54	662.66	662.21	662.48	1573348.0
2025-09-19 13:30:00	SPY	ETF	662.48	662.89	662.455	662.69	2047780.0
2025-09-19 14:00:00	SPY	ETF	662.69	662.83	662.325	662.53	2857625.0
2025-09-19 14:30:00	SPY	ETF	662.52	663.11	662.42	663.09	2505986.0
2025-09-19 15:00:00	SPY	ETF	663.09	664.05	663.04	663.8	4981279.0
2025-09-19 15:30:00	SPY	ETF	663.79	664.55	663.385	663.64	11942783.0
2025-09-19 16:00:00	SPY	ETF	663.62	663.96	663.29	663.32	4249720.0
2025-09-19 16:30:00	SPY	ETF	663.35	663.64	663.28	663.3702	334194.0
2025-09-19 17:00:00	SPY	ETF	663.47	663.7661	662.99	662.99	861728.0
2025-09-19 17:30:00	SPY	ETF	662.99	663.7661	662.9	663.22	957400.0
2025-09-19 18:00:00	SPY	ETF	663.3	663.68	663.25	663.67	44347.0
2025-09-19 18:30:00	SPY	ETF	663.62	663.62	663.46	663.5	8541.0
2025-09-19 19:00:00	SPY	ETF	663.59	663.6	663.47	663.48	5401.0
2025-09-19 19:30:00	SPY	ETF	663.5	663.5	663.24	663.47	43460.0
2025-09-19 04:00:00	QQQ	ETF	595.29	595.89	595.19	595.89	24992.0
2025-09-19 04:30:00	QQQ	ETF	595.89	596.0	595.7	595.81	14339.0
2025-09-19 05:00:00	QQQ	ETF	595.83	596.2	595.75	596.12	16694.0
2025-09-19 05:30:00	QQQ	ETF	596.14	596.34	595.78	595.78	16874.0
2025-09-19 06:00:00	QQQ	ETF	595.83	596.31	595.68	596.25	17400.0
2025-09-19 06:30:00	QQQ	ETF	596.25	596.4	596.0	596.27	23033.0
2025-09-19 07:00:00	QQQ	ETF	596.31	596.52	596.02	596.25	31266.0
2025-09-19 07:30:00	QQQ	ETF	596.2	596.52	596.11	596.52	21006.0
2025-09-19 08:00:00	QQQ	ETF	596.11	596.95	594.61	596.86	124897.0
2025-09-19 08:30:00	QQQ	ETF	596.87	596.94	596.49	596.58	113922.0
2025-09-19 09:00:00	QQQ	ETF	596.55	597.8	596.5025	597.32	384649.0
2025-09-19 09:30:00	QQQ	ETF	597.32	598.43	596.555	597.83	5577437.0
2025-09-19 10:00:00	QQQ	ETF	597.83	598.22	596.96	597.62	2811797.0
2025-09-19 10:30:00	QQQ	ETF	597.62	597.788	596.51	597.18	2454196.0
2025-09-19 11:00:00	QQQ	ETF	597.19	597.545	596.11	596.29	2255351.0
2025-09-19 11:30:00	QQQ	ETF	596.28	597.415	595.85	597.36	2134802.0
2025-09-19 12:00:00	QQQ	ETF	597.34	598.6	597.33	598.43	2864471.0
2025-09-19 12:30:00	QQQ	ETF	598.42	598.8181	598.0401	598.49	1514528.0

> showing 50 of 42,717 rows — these rows as CSV

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