PREVIEW / etf_30min / 2025-07-23

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-07-23.parquet
  size:    1016 KB
  rows:    41,756

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-23 04:00:00	SPY	ETF	630.48	631.34	630.48	631.19	16587.0
2025-07-23 04:30:00	SPY	ETF	631.17	631.53	631.05	631.46	25300.0
2025-07-23 05:00:00	SPY	ETF	631.48	631.64	631.27	631.27	38422.0
2025-07-23 05:30:00	SPY	ETF	631.22	631.59	631.18	631.58	22047.0
2025-07-23 06:00:00	SPY	ETF	631.53	631.77	631.37	631.56	25333.0
2025-07-23 06:30:00	SPY	ETF	631.59	631.74	631.34	631.37	54326.0
2025-07-23 07:00:00	SPY	ETF	631.37	631.4	630.77	631.07	75492.0
2025-07-23 07:30:00	SPY	ETF	631.08	631.41	631.0	631.33	97107.0
2025-07-23 08:00:00	SPY	ETF	631.38	631.65	630.09	631.42	148350.0
2025-07-23 08:30:00	SPY	ETF	631.41	631.42	630.99	631.21	184162.0
2025-07-23 09:00:00	SPY	ETF	631.23	631.91	631.14	631.56	346430.0
2025-07-23 09:30:00	SPY	ETF	631.55	631.75	629.82	629.9992	5291528.0
2025-07-23 10:00:00	SPY	ETF	629.995	630.74	629.73	630.7388	3012245.0
2025-07-23 10:30:00	SPY	ETF	630.7352	630.78	630.09	630.7	2009892.0
2025-07-23 11:00:00	SPY	ETF	630.7	630.925	630.325	630.825	2235065.0
2025-07-23 11:30:00	SPY	ETF	630.82	632.79	630.47	632.065	4216935.0
2025-07-23 12:00:00	SPY	ETF	632.06	632.61	631.38	631.69	3110428.0
2025-07-23 12:30:00	SPY	ETF	631.68	632.11	631.3495	631.86	1781837.0
2025-07-23 13:00:00	SPY	ETF	631.86	632.195	631.525	632.1	1711294.0
2025-07-23 13:30:00	SPY	ETF	632.11	632.885	631.79	632.5118	3639091.0
2025-07-23 14:00:00	SPY	ETF	632.515	633.65	632.515	633.235	3016172.0
2025-07-23 14:30:00	SPY	ETF	633.235	633.48	633.105	633.265	2159215.0
2025-07-23 15:00:00	SPY	ETF	633.28	633.3899	632.955	633.36	3264609.0
2025-07-23 15:30:00	SPY	ETF	633.36	634.16	632.94	634.16	7404949.0
2025-07-23 16:00:00	SPY	ETF	634.16	635.4	633.5	633.96	2656342.0
2025-07-23 16:30:00	SPY	ETF	633.94	634.96	633.9	634.8	512506.0
2025-07-23 17:00:00	SPY	ETF	634.8	635.0	634.5803	634.5803	203801.0
2025-07-23 17:30:00	SPY	ETF	634.6295	634.76	634.39	634.58	36957.0
2025-07-23 18:00:00	SPY	ETF	634.61	634.6585	634.32	634.63	43064.0
2025-07-23 18:30:00	SPY	ETF	634.54	634.66	634.3	634.35	32684.0
2025-07-23 19:00:00	SPY	ETF	634.37	634.61	634.3	634.35	23973.0
2025-07-23 19:30:00	SPY	ETF	634.4	634.71	634.3802	634.6595	16136.0
2025-07-23 04:00:00	QQQ	ETF	562.27	562.76	562.21	562.7	19641.0
2025-07-23 04:30:00	QQQ	ETF	562.65	562.81	562.4	562.79	10653.0
2025-07-23 05:00:00	QQQ	ETF	562.77	562.86	562.41	562.42	12697.0
2025-07-23 05:30:00	QQQ	ETF	562.31	562.68	562.31	562.6	12664.0
2025-07-23 06:00:00	QQQ	ETF	562.64	562.75	562.43	562.65	7219.0
2025-07-23 06:30:00	QQQ	ETF	562.65	562.84	562.42	562.53	26594.0
2025-07-23 07:00:00	QQQ	ETF	562.38	562.43	561.69	562.05	43262.0
2025-07-23 07:30:00	QQQ	ETF	562.1	562.38	562.02	562.3	34937.0
2025-07-23 08:00:00	QQQ	ETF	562.35	562.79	561.72	562.09	141741.0
2025-07-23 08:30:00	QQQ	ETF	562.09	562.09	561.59	561.67	92590.0
2025-07-23 09:00:00	QQQ	ETF	561.76	562.58	561.68	562.2799	129063.0
2025-07-23 09:30:00	QQQ	ETF	562.34	562.37	559.93	560.05	4487354.0
2025-07-23 10:00:00	QQQ	ETF	560.03	560.69	559.58	560.69	2318542.0
2025-07-23 10:30:00	QQQ	ETF	560.68	560.94	559.67	560.848	1310748.0
2025-07-23 11:00:00	QQQ	ETF	560.84	561.27	560.35	561.045	1228601.0
2025-07-23 11:30:00	QQQ	ETF	561.04	563.07	560.78	562.22	2767101.0
2025-07-23 12:00:00	QQQ	ETF	562.21	562.365	560.71	561.09	2631985.0
2025-07-23 12:30:00	QQQ	ETF	561.09	561.7	560.94	561.54	1071862.0

> showing 50 of 41,756 rows — these rows as CSV

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