PREVIEW / etf_30min / 2025-11-18

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-11-18.parquet
  size:    1.1 MB
  rows:    45,299

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-18 04:00:00	SPY	ETF	663.96	664.85	663.33	663.8	27595.0
2025-11-18 04:30:00	SPY	ETF	663.74	664.68	663.2	664.61	22100.0
2025-11-18 05:00:00	SPY	ETF	664.45	664.62	663.54	663.67	9413.0
2025-11-18 05:30:00	SPY	ETF	663.7	664.63	663.48	664.37	10113.0
2025-11-18 06:00:00	SPY	ETF	664.4	664.59	663.44	663.89	15413.0
2025-11-18 06:30:00	SPY	ETF	663.76	663.85	662.99	663.85	28700.0
2025-11-18 07:00:00	SPY	ETF	663.88	663.92	661.84	662.13	200061.0
2025-11-18 07:30:00	SPY	ETF	662.19	662.91	660.5	661.4	372456.0
2025-11-18 08:00:00	SPY	ETF	665.5674	665.5674	660.05	662.18	446914.0
2025-11-18 08:30:00	SPY	ETF	662.1	663.14	662.0	662.55	175973.0
2025-11-18 09:00:00	SPY	ETF	662.5	663.01	661.68	662.1	377014.0
2025-11-18 09:30:00	SPY	ETF	662.09	664.26	658.61	658.65	14869402.0
2025-11-18 10:00:00	SPY	ETF	658.64	660.31	656.8	659.085	10932634.0
2025-11-18 10:30:00	SPY	ETF	659.08	660.2	657.12	657.22	6844537.0
2025-11-18 11:00:00	SPY	ETF	657.23	661.87	655.86	661.575	7441334.0
2025-11-18 11:30:00	SPY	ETF	661.56	662.37	660.72	661.17	5093373.0
2025-11-18 12:00:00	SPY	ETF	661.14	661.86	658.56	658.62	3818728.0
2025-11-18 12:30:00	SPY	ETF	658.61	664.375	657.91	663.67	5763559.0
2025-11-18 13:00:00	SPY	ETF	663.72	664.46	663.1	663.33	3930043.0
2025-11-18 13:30:00	SPY	ETF	663.35	665.12	662.7	663.01	4566261.0
2025-11-18 14:00:00	SPY	ETF	663.05	664.25	662.57	662.93	3556404.0
2025-11-18 14:30:00	SPY	ETF	662.93	664.96	662.434	664.42	4658543.0
2025-11-18 15:00:00	SPY	ETF	664.43	664.94	661.5	662.42	5493577.0
2025-11-18 15:30:00	SPY	ETF	662.42	662.78	660.0	660.14	12332599.0
2025-11-18 16:00:00	SPY	ETF	660.16	660.24	658.93	659.49	2812571.0
2025-11-18 16:30:00	SPY	ETF	659.465	659.79	659.0	659.2	241097.0
2025-11-18 17:00:00	SPY	ETF	659.2	659.4	659.07	659.33	59288.0
2025-11-18 17:30:00	SPY	ETF	659.3301	659.38	659.21	659.28	13912.0
2025-11-18 18:00:00	SPY	ETF	659.28	661.02	659.28	660.99	95529.0
2025-11-18 18:30:00	SPY	ETF	661.07	661.0733	660.3	660.59	23843.0
2025-11-18 19:00:00	SPY	ETF	660.47	660.685	658.75	659.03	61507.0
2025-11-18 19:30:00	SPY	ETF	659.0287	660.24	658.9587	659.95	51488.0
2025-11-18 04:00:00	QQQ	ETF	601.74	602.94	598.3	601.62	167549.0
2025-11-18 04:30:00	QQQ	ETF	601.55	602.75	600.8	602.49	100510.0
2025-11-18 05:00:00	QQQ	ETF	602.52	602.66	601.38	601.53	75873.0
2025-11-18 05:30:00	QQQ	ETF	601.67	602.45	601.3	602.31	39794.0
2025-11-18 06:00:00	QQQ	ETF	602.16	602.43	601.1	601.5	56999.0
2025-11-18 06:30:00	QQQ	ETF	601.53	601.66	600.63	601.55	194946.0
2025-11-18 07:00:00	QQQ	ETF	601.58	601.58	599.24	599.72	284046.0
2025-11-18 07:30:00	QQQ	ETF	599.7	600.63	598.2	598.99	309032.0
2025-11-18 08:00:00	QQQ	ETF	603.5854	603.5854	596.9	599.54	579259.0
2025-11-18 08:30:00	QQQ	ETF	599.49	600.9	599.38	599.95	256933.0
2025-11-18 09:00:00	QQQ	ETF	599.88	600.56	599.05	599.58	379285.0
2025-11-18 09:30:00	QQQ	ETF	599.62	602.31	594.8	594.86	11542008.0
2025-11-18 10:00:00	QQQ	ETF	594.83	596.92	592.59	595.38	9079284.0
2025-11-18 10:30:00	QQQ	ETF	595.38	596.49	592.795	593.28	5255323.0
2025-11-18 11:00:00	QQQ	ETF	593.29	598.325	591.34	597.87	6007606.0
2025-11-18 11:30:00	QQQ	ETF	597.87	599.15	597.15	597.98	3966901.0
2025-11-18 12:00:00	QQQ	ETF	597.96	598.94	594.963	595.1292	3277374.0
2025-11-18 12:30:00	QQQ	ETF	595.08	601.13	594.1	600.4	4314056.0

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

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