PREVIEW / etf_30min / 2025-09-18

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-09-18.parquet
  size:    1.0 MB
  rows:    44,201

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-18 04:00:00	SPY	ETF	663.11	663.88	663.04	663.88	51536.0
2025-09-18 04:30:00	SPY	ETF	663.86	665.02	663.81	664.95	40742.0
2025-09-18 05:00:00	SPY	ETF	664.95	665.07	664.54	664.75	34540.0
2025-09-18 05:30:00	SPY	ETF	664.75	665.1	664.66	664.67	58540.0
2025-09-18 06:00:00	SPY	ETF	664.69	664.9	664.35	664.37	75729.0
2025-09-18 06:30:00	SPY	ETF	664.37	664.4	663.85	664.12	74622.0
2025-09-18 07:00:00	SPY	ETF	664.18	664.8	663.91	664.5	138912.0
2025-09-18 07:30:00	SPY	ETF	664.47	664.47	663.78	664.1	91880.0
2025-09-18 08:00:00	SPY	ETF	664.55	665.01	661.3	664.2	212762.0
2025-09-18 08:30:00	SPY	ETF	664.23	664.3	659.2174	662.47	284339.0
2025-09-18 09:00:00	SPY	ETF	662.49	662.53	661.4	661.88	459911.0
2025-09-18 09:30:00	SPY	ETF	661.89	662.44	660.27	662.06	10735877.0
2025-09-18 10:00:00	SPY	ETF	662.06	664.49	662.0	664.4	6861017.0
2025-09-18 10:30:00	SPY	ETF	664.38	664.89	662.715	662.77	4865317.0
2025-09-18 11:00:00	SPY	ETF	662.77	663.99	662.6	663.325	3719888.0
2025-09-18 11:30:00	SPY	ETF	663.31	663.94	662.1751	662.5999	2675099.0
2025-09-18 12:00:00	SPY	ETF	662.575	663.5599	662.31	663.46	2223578.0
2025-09-18 12:30:00	SPY	ETF	663.46	664.19	663.44	664.045	2129075.0
2025-09-18 13:00:00	SPY	ETF	664.04	664.23	663.265	663.32	2102057.0
2025-09-18 13:30:00	SPY	ETF	663.32	663.45	662.52	662.79	2439051.0
2025-09-18 14:00:00	SPY	ETF	662.79	663.275	662.59	662.775	2025294.0
2025-09-18 14:30:00	SPY	ETF	662.78	663.51	662.34	663.24	2477178.0
2025-09-18 15:00:00	SPY	ETF	663.24	663.44	662.68	662.71	3733533.0
2025-09-18 15:30:00	SPY	ETF	662.7	663.04	661.955	662.28	11204537.0
2025-09-18 16:00:00	SPY	ETF	662.29	663.1308	662.18	662.82	2624332.0
2025-09-18 16:30:00	SPY	ETF	662.83	663.06	662.3648	662.98	234133.0
2025-09-18 17:00:00	SPY	ETF	662.99	663.02	662.98	663.02	42992.0
2025-09-18 17:30:00	SPY	ETF	663.02	663.04	662.99	662.99	24007.0
2025-09-18 18:00:00	SPY	ETF	663.03	663.5799	662.99	663.55	71503.0
2025-09-18 18:30:00	SPY	ETF	663.5	663.5001	662.8898	663.5	30622.0
2025-09-18 19:00:00	SPY	ETF	663.5	663.5501	663.4	663.43	10804.0
2025-09-18 19:30:00	SPY	ETF	663.49	663.66	663.4	663.41	44225.0
2025-09-18 04:00:00	QQQ	ETF	594.57	595.36	593.15	595.31	61755.0
2025-09-18 04:30:00	QQQ	ETF	595.27	596.22	595.21	596.16	56007.0
2025-09-18 05:00:00	QQQ	ETF	596.17	596.22	595.69	595.89	34339.0
2025-09-18 05:30:00	QQQ	ETF	595.92	596.2	595.8	595.91	41799.0
2025-09-18 06:00:00	QQQ	ETF	595.87	596.15	595.63	595.73	13199.0
2025-09-18 06:30:00	QQQ	ETF	595.66	595.66	595.31	595.63	57641.0
2025-09-18 07:00:00	QQQ	ETF	595.58	596.79	595.35	596.42	103822.0
2025-09-18 07:30:00	QQQ	ETF	596.4	596.7	595.84	596.46	95036.0
2025-09-18 08:00:00	QQQ	ETF	596.22	596.92	592.87	596.7	215964.0
2025-09-18 08:30:00	QQQ	ETF	596.65	596.81	595.18	595.2	157274.0
2025-09-18 09:00:00	QQQ	ETF	595.16	595.26	594.27	594.94	266669.0
2025-09-18 09:30:00	QQQ	ETF	594.91	595.72	592.96	595.32	8225784.0
2025-09-18 10:00:00	QQQ	ETF	595.32	597.4825	595.25	597.45	4564738.0
2025-09-18 10:30:00	QQQ	ETF	597.44	597.97	596.16	596.205	2982422.0
2025-09-18 11:00:00	QQQ	ETF	596.21	598.14	596.1999	597.34	3269948.0
2025-09-18 11:30:00	QQQ	ETF	597.34	597.9	596.01	596.29	2635057.0
2025-09-18 12:00:00	QQQ	ETF	596.28	597.165	595.9	597.0692	2007492.0
2025-09-18 12:30:00	QQQ	ETF	597.08	597.6	597.0696	597.47	1513390.0

> showing 50 of 44,201 rows — these rows as CSV

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