PREVIEW / etf_30min / 2025-11-07

all etf 30-min files

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

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-07 04:00:00	SPY	ETF	671.0	672.19	669.96	671.24	79643.0
2025-11-07 04:30:00	SPY	ETF	671.18	671.34	670.46	670.69	63932.0
2025-11-07 05:00:00	SPY	ETF	670.75	671.17	669.35	669.87	89262.0
2025-11-07 05:30:00	SPY	ETF	669.99	670.43	669.78	670.02	32165.0
2025-11-07 06:00:00	SPY	ETF	669.91	669.91	667.51	667.96	135333.0
2025-11-07 06:30:00	SPY	ETF	667.9	669.5	667.2	669.37	155284.0
2025-11-07 07:00:00	SPY	ETF	669.35	669.41	668.31	668.49	198726.0
2025-11-07 07:30:00	SPY	ETF	668.48	668.53	666.8	667.34	217597.0
2025-11-07 08:00:00	SPY	ETF	667.33	672.6	666.83	667.35	414338.0
2025-11-07 08:30:00	SPY	ETF	667.39	668.44	667.14	667.93	250064.0
2025-11-07 09:00:00	SPY	ETF	667.85	668.08	667.18	667.89	490026.0
2025-11-07 09:30:00	SPY	ETF	667.91	667.98	664.35	666.25	10912647.0
2025-11-07 10:00:00	SPY	ETF	666.16	667.22	663.97	665.93	6776019.0
2025-11-07 10:30:00	SPY	ETF	665.915	666.31	663.29	663.33	6411358.0
2025-11-07 11:00:00	SPY	ETF	663.32	664.03	662.25	662.825	6406872.0
2025-11-07 11:30:00	SPY	ETF	662.82	663.37	661.33	661.975	4741171.0
2025-11-07 12:00:00	SPY	ETF	661.97	664.275	661.205	663.575	4523286.0
2025-11-07 12:30:00	SPY	ETF	663.52	664.05	662.01	663.94	3597040.0
2025-11-07 13:00:00	SPY	ETF	663.94	665.575	663.58	665.31	3318612.0
2025-11-07 13:30:00	SPY	ETF	665.3	666.09	664.22	665.615	3154153.0
2025-11-07 14:00:00	SPY	ETF	665.61	666.68	665.2	666.45	3604294.0
2025-11-07 14:30:00	SPY	ETF	666.48	669.98	666.48	669.9	8331605.0
2025-11-07 15:00:00	SPY	ETF	669.89	670.03	667.92	668.665	6722335.0
2025-11-07 15:30:00	SPY	ETF	668.66	671.08	668.66	670.94	9393264.0
2025-11-07 16:00:00	SPY	ETF	670.92	671.98	670.8986	671.51	3427583.0
2025-11-07 16:30:00	SPY	ETF	671.54	672.07	671.54	671.98	296843.0
2025-11-07 17:00:00	SPY	ETF	671.94	672.0996	671.94	672.03	106808.0
2025-11-07 17:30:00	SPY	ETF	672.03	672.1	672.03	672.04	21397.0
2025-11-07 18:00:00	SPY	ETF	672.05	672.0908	671.75	672.03	50518.0
2025-11-07 18:30:00	SPY	ETF	672.02	672.12	671.95	672.12	11456.0
2025-11-07 19:00:00	SPY	ETF	672.0424	672.3	672.0424	672.2	16703.0
2025-11-07 19:30:00	SPY	ETF	672.23	672.35	672.12	672.35	33936.0
2025-11-07 20:00:00	SPY	ETF	672.36	672.36	672.36	672.36	97.0
2025-11-07 04:00:00	QQQ	ETF	612.12	613.68	612.12	612.45	69699.0
2025-11-07 04:30:00	QQQ	ETF	612.44	612.58	611.62	612.02	66874.0
2025-11-07 05:00:00	QQQ	ETF	611.84	612.42	610.3	611.03	110027.0
2025-11-07 05:30:00	QQQ	ETF	611.06	611.66	610.83	611.0	59112.0
2025-11-07 06:00:00	QQQ	ETF	610.89	610.92	608.16	608.7	256759.0
2025-11-07 06:30:00	QQQ	ETF	608.73	610.35	607.79	610.1	254218.0
2025-11-07 07:00:00	QQQ	ETF	610.07	610.47	609.3	609.56	142123.0
2025-11-07 07:30:00	QQQ	ETF	609.6	609.6	607.27	607.98	290898.0
2025-11-07 08:00:00	QQQ	ETF	609.8	614.3	607.3	607.63	631102.0
2025-11-07 08:30:00	QQQ	ETF	607.63	613.81	607.29	608.42	540722.0
2025-11-07 09:00:00	QQQ	ETF	608.3769	608.65	607.52	608.34	322793.0
2025-11-07 09:30:00	QQQ	ETF	608.31	608.33	603.68	606.08	9257216.0
2025-11-07 10:00:00	QQQ	ETF	605.91	606.79	602.85	604.95	5561033.0
2025-11-07 10:30:00	QQQ	ETF	604.93	605.24	601.41	601.42	5301786.0
2025-11-07 11:00:00	QQQ	ETF	601.41	602.34	600.16	600.75	4939425.0
2025-11-07 11:30:00	QQQ	ETF	600.75	601.4	598.89	599.58	3927649.0
2025-11-07 12:00:00	QQQ	ETF	599.57	602.41	598.67	601.65	4256961.0

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

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