PREVIEW / etf_30min / 2025-07-21

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-07-21.parquet
  size:    1.0 MB
  rows:    42,678

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-21 04:00:00	SPY	ETF	629.11	629.56	629.05	629.39	38548.0
2025-07-21 04:30:00	SPY	ETF	629.46	629.47	629.17	629.39	6638.0
2025-07-21 05:00:00	SPY	ETF	629.38	629.59	629.35	629.46	28827.0
2025-07-21 05:30:00	SPY	ETF	629.43	629.45	629.3	629.31	5374.0
2025-07-21 06:00:00	SPY	ETF	629.35	629.53	629.21	629.43	10599.0
2025-07-21 06:30:00	SPY	ETF	629.29	629.37	629.0	629.25	27036.0
2025-07-21 07:00:00	SPY	ETF	629.23	629.28	628.99	629.151	88729.0
2025-07-21 07:30:00	SPY	ETF	629.17	629.28	629.01	629.07	37350.0
2025-07-21 08:00:00	SPY	ETF	629.27	629.37	628.2	629.03	74683.0
2025-07-21 08:30:00	SPY	ETF	629.08	629.1798	628.39	628.45	66464.0
2025-07-21 09:00:00	SPY	ETF	628.44	628.79	628.17	628.79	228039.0
2025-07-21 09:30:00	SPY	ETF	628.76	630.7	628.67	630.57	4704889.0
2025-07-21 10:00:00	SPY	ETF	630.58	631.33	630.38	631.25	3973703.0
2025-07-21 10:30:00	SPY	ETF	631.25	631.39	630.64	631.02	2895019.0
2025-07-21 11:00:00	SPY	ETF	631.025	631.35	630.88	631.2688	2139472.0
2025-07-21 11:30:00	SPY	ETF	631.27	631.54	631.08	631.1751	2228326.0
2025-07-21 12:00:00	SPY	ETF	631.17	631.17	630.535	630.77	2334503.0
2025-07-21 12:30:00	SPY	ETF	630.7752	631.32	630.725	631.25	1695690.0
2025-07-21 13:00:00	SPY	ETF	631.25	631.49	631.2213	631.395	1478436.0
2025-07-21 13:30:00	SPY	ETF	631.39	631.52	631.11	631.17	1388045.0
2025-07-21 14:00:00	SPY	ETF	631.16	631.27	631.04	631.1918	1652764.0
2025-07-21 14:30:00	SPY	ETF	631.2	631.2	630.32	630.3614	3060991.0
2025-07-21 15:00:00	SPY	ETF	630.37	630.4	629.11	629.45	5282284.0
2025-07-21 15:30:00	SPY	ETF	629.45	629.68	628.34	628.76	8656990.0
2025-07-21 16:00:00	SPY	ETF	628.74	629.07	628.5894	628.81	3011634.0
2025-07-21 16:30:00	SPY	ETF	628.83	629.03	628.83	629.0	230846.0
2025-07-21 17:00:00	SPY	ETF	629.01	629.05	628.93	628.98	33134.0
2025-07-21 17:30:00	SPY	ETF	628.93	628.9894	628.88	628.92	23805.0
2025-07-21 18:00:00	SPY	ETF	628.91	629.15	628.82	629.1	43430.0
2025-07-21 18:30:00	SPY	ETF	629.04	629.04	628.91	628.92	2734.0
2025-07-21 19:00:00	SPY	ETF	628.93	628.9898	628.9098	628.9898	2365.0
2025-07-21 19:30:00	SPY	ETF	629.0388	629.06	628.84	629.06	21051.0
2025-07-21 04:00:00	QQQ	ETF	563.01	563.33	562.78	562.98	27217.0
2025-07-21 04:30:00	QQQ	ETF	563.0	563.04	562.77	562.92	8712.0
2025-07-21 05:00:00	QQQ	ETF	562.96	563.13	562.94	563.09	16167.0
2025-07-21 05:30:00	QQQ	ETF	563.06	563.06	562.84	562.91	15666.0
2025-07-21 06:00:00	QQQ	ETF	562.9	563.29	562.81	563.11	8723.0
2025-07-21 06:30:00	QQQ	ETF	563.1	563.1	562.75	562.93	33470.0
2025-07-21 07:00:00	QQQ	ETF	562.96	562.96	562.61	562.81	25397.0
2025-07-21 07:30:00	QQQ	ETF	562.75	562.9	562.56	562.6	38349.0
2025-07-21 08:00:00	QQQ	ETF	562.91	563.11	561.89	562.58	61217.0
2025-07-21 08:30:00	QQQ	ETF	562.64	562.7	561.62	561.67	143909.0
2025-07-21 09:00:00	QQQ	ETF	561.65	562.13	561.32	562.1299	192811.0
2025-07-21 09:30:00	QQQ	ETF	562.09	565.39	562.06	564.91	3743042.0
2025-07-21 10:00:00	QQQ	ETF	564.93	565.9	564.93	565.8784	2330647.0
2025-07-21 10:30:00	QQQ	ETF	565.89	566.06	565.19	565.45	1849707.0
2025-07-21 11:00:00	QQQ	ETF	565.45	565.51	565.03	565.4298	1128583.0
2025-07-21 11:30:00	QQQ	ETF	565.43	565.6299	565.065	565.16	1139471.0
2025-07-21 12:00:00	QQQ	ETF	565.16	565.2781	564.535	564.98	1831808.0
2025-07-21 12:30:00	QQQ	ETF	564.962	565.755	564.94	565.6201	1377411.0

> showing 50 of 42,678 rows — these rows as CSV

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