PREVIEW / etf_30min / 2025-07-25

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-07-25.parquet
  size:    976 KB
  rows:    39,525

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-07-25 04:00:00	SPY	ETF	635.01	635.19	634.71	635.11	17670.0
2025-07-25 04:30:00	SPY	ETF	635.26	635.37	635.16	635.17	26639.0
2025-07-25 05:00:00	SPY	ETF	635.18	635.18	634.94	635.18	2662.0
2025-07-25 05:30:00	SPY	ETF	635.25	635.38	635.15	635.3	12848.0
2025-07-25 06:00:00	SPY	ETF	635.26	635.31	635.15	635.3	5086.0
2025-07-25 06:30:00	SPY	ETF	635.33	635.56	635.29	635.44	8513.0
2025-07-25 07:00:00	SPY	ETF	635.48	635.48	635.25	635.33	10025.0
2025-07-25 07:30:00	SPY	ETF	635.33	635.33	635.0	635.16	29313.0
2025-07-25 08:00:00	SPY	ETF	635.28	636.4	634.92	635.35	90139.0
2025-07-25 08:30:00	SPY	ETF	635.37	635.55	635.24	635.28	109129.0
2025-07-25 09:00:00	SPY	ETF	635.27	635.39	634.78	635.07	427247.0
2025-07-25 09:30:00	SPY	ETF	635.06	635.6	634.84	635.24	3897936.0
2025-07-25 10:00:00	SPY	ETF	635.25	635.61	634.87	635.47	2699884.0
2025-07-25 10:30:00	SPY	ETF	635.47	636.13	635.29	635.825	2939381.0
2025-07-25 11:00:00	SPY	ETF	635.81	636.095	635.7	636.02	1740347.0
2025-07-25 11:30:00	SPY	ETF	636.02	636.08	635.61	635.93	1577038.0
2025-07-25 12:00:00	SPY	ETF	635.93	636.93	635.79	636.76	3032531.0
2025-07-25 12:30:00	SPY	ETF	636.76	636.96	636.6	636.845	1823362.0
2025-07-25 13:00:00	SPY	ETF	636.845	637.13	636.67	637.0452	1514342.0
2025-07-25 13:30:00	SPY	ETF	637.05	637.36	637.045	637.1314	1899244.0
2025-07-25 14:00:00	SPY	ETF	637.132	637.53	636.97	637.33	2165531.0
2025-07-25 14:30:00	SPY	ETF	637.33	637.54	637.19	637.195	1702036.0
2025-07-25 15:00:00	SPY	ETF	637.19	637.5799	637.175	637.34	2261623.0
2025-07-25 15:30:00	SPY	ETF	637.33	637.49	636.625	637.03	8506849.0
2025-07-25 16:00:00	SPY	ETF	637.02	637.1	636.6	637.06	2536289.0
2025-07-25 16:30:00	SPY	ETF	637.02	637.3846	637.0	637.25	391147.0
2025-07-25 17:00:00	SPY	ETF	637.18	637.28	637.07	637.26	62189.0
2025-07-25 17:30:00	SPY	ETF	637.23	637.27	637.08	637.2699	12867.0
2025-07-25 18:00:00	SPY	ETF	637.3	637.35	637.26	637.35	10148.0
2025-07-25 18:30:00	SPY	ETF	637.26	637.35	637.2501	637.35	1490.0
2025-07-25 19:00:00	SPY	ETF	637.3298	637.39	637.31	637.39	4034.0
2025-07-25 19:30:00	SPY	ETF	637.4	637.5	637.35	637.4598	6219.0
2025-07-25 04:00:00	QQQ	ETF	565.08	565.3	564.79	565.2	14020.0
2025-07-25 04:30:00	QQQ	ETF	565.24	565.43	565.22	565.3	4678.0
2025-07-25 05:00:00	QQQ	ETF	565.27	565.27	564.86	565.13	15317.0
2025-07-25 05:30:00	QQQ	ETF	565.22	565.3	565.08	565.25	5650.0
2025-07-25 06:00:00	QQQ	ETF	565.26	565.37	565.19	565.28	5806.0
2025-07-25 06:30:00	QQQ	ETF	565.34	565.68	565.34	565.59	10611.0
2025-07-25 07:00:00	QQQ	ETF	565.62	565.63	565.23	565.38	13377.0
2025-07-25 07:30:00	QQQ	ETF	565.22	565.44	565.0	565.09	15015.0
2025-07-25 08:00:00	QQQ	ETF	565.33	566.55	564.587	565.37	118981.0
2025-07-25 08:30:00	QQQ	ETF	565.32	565.57	565.11	565.2299	49810.0
2025-07-25 09:00:00	QQQ	ETF	565.21	565.29	564.63	564.95	131029.0
2025-07-25 09:30:00	QQQ	ETF	564.93	566.11	564.27	565.652	3595988.0
2025-07-25 10:00:00	QQQ	ETF	565.68	566.31	565.53	566.03	1923115.0
2025-07-25 10:30:00	QQQ	ETF	566.03	566.37	565.66	566.02	1751681.0
2025-07-25 11:00:00	QQQ	ETF	566.02	566.43	565.73	566.355	1157416.0
2025-07-25 11:30:00	QQQ	ETF	566.35	566.54	565.95	566.3901	1084812.0
2025-07-25 12:00:00	QQQ	ETF	566.39	567.59	566.29	567.415	1930332.0
2025-07-25 12:30:00	QQQ	ETF	567.4	567.695	567.02	567.1	882688.0

> showing 50 of 39,525 rows — these rows as CSV

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