PREVIEW / etf_30min / 2025-08-06

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-08-06.parquet
  size:    1017 KB
  rows:    41,250

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-08-06 04:00:00	SPY	ETF	631.21	631.3	630.55	630.58	35705.0
2025-08-06 04:30:00	SPY	ETF	630.51	630.64	629.96	630.12	17060.0
2025-08-06 05:00:00	SPY	ETF	630.23	630.35	629.76	629.81	15819.0
2025-08-06 05:30:00	SPY	ETF	629.81	629.86	629.3	629.58	13684.0
2025-08-06 06:00:00	SPY	ETF	629.42	629.87	629.17	629.72	17180.0
2025-08-06 06:30:00	SPY	ETF	629.54	629.66	628.82	629.54	12020.0
2025-08-06 07:00:00	SPY	ETF	629.5	629.86	629.25	629.5	30539.0
2025-08-06 07:30:00	SPY	ETF	629.56	629.84	629.37	629.47	16834.0
2025-08-06 08:00:00	SPY	ETF	629.56	631.25	628.71	628.95	159175.0
2025-08-06 08:30:00	SPY	ETF	628.9	629.53	628.82	629.46	111122.0
2025-08-06 09:00:00	SPY	ETF	629.46	629.84	629.04	629.1	162253.0
2025-08-06 09:30:00	SPY	ETF	629.05	629.98	628.27	628.93	5391550.0
2025-08-06 10:00:00	SPY	ETF	628.92	630.61	628.13	628.795	3969711.0
2025-08-06 10:30:00	SPY	ETF	628.795	631.01	628.38	630.885	3325397.0
2025-08-06 11:00:00	SPY	ETF	630.88	632.05	630.41	631.927	3141447.0
2025-08-06 11:30:00	SPY	ETF	631.91	632.9104	631.16	632.66	3555000.0
2025-08-06 12:00:00	SPY	ETF	632.67	632.85	632.18	632.37	1887256.0
2025-08-06 12:30:00	SPY	ETF	632.3899	632.9799	631.85	632.25	1951309.0
2025-08-06 13:00:00	SPY	ETF	632.2401	632.63	631.94	632.29	1478694.0
2025-08-06 13:30:00	SPY	ETF	632.31	632.7	632.0	632.23	1643061.0
2025-08-06 14:00:00	SPY	ETF	632.235	633.11	632.1798	632.92	1882801.0
2025-08-06 14:30:00	SPY	ETF	632.92	633.19	632.49	632.62	1959566.0
2025-08-06 15:00:00	SPY	ETF	632.62	633.16	632.56	633.02	2337418.0
2025-08-06 15:30:00	SPY	ETF	633.01	633.44	632.39	632.67	8677905.0
2025-08-06 16:00:00	SPY	ETF	632.67	632.78	632.3	632.61	2255222.0
2025-08-06 16:30:00	SPY	ETF	632.6	632.63	632.31	632.56	182002.0
2025-08-06 17:00:00	SPY	ETF	632.45	632.78	631.68	631.72	139805.0
2025-08-06 17:30:00	SPY	ETF	631.75	632.95	631.2603	632.64	146976.0
2025-08-06 18:00:00	SPY	ETF	632.64	633.92	632.0	633.92	121378.0
2025-08-06 18:30:00	SPY	ETF	633.76	634.14	633.53	633.77	76155.0
2025-08-06 19:00:00	SPY	ETF	633.81	634.21	633.78	633.8001	82996.0
2025-08-06 19:30:00	SPY	ETF	633.771	633.9	633.478	633.61	24238.0
2025-08-06 04:00:00	QQQ	ETF	562.34	562.44	561.63	561.67	31896.0
2025-08-06 04:30:00	QQQ	ETF	561.55	561.6	560.8	561.04	23619.0
2025-08-06 05:00:00	QQQ	ETF	561.07	561.35	560.6	560.63	21587.0
2025-08-06 05:30:00	QQQ	ETF	560.62	560.68	560.23	560.58	21400.0
2025-08-06 06:00:00	QQQ	ETF	560.4	560.76	559.95	560.56	19762.0
2025-08-06 06:30:00	QQQ	ETF	560.59	560.59	559.64	560.44	25178.0
2025-08-06 07:00:00	QQQ	ETF	560.51	561.25	560.34	561.21	32734.0
2025-08-06 07:30:00	QQQ	ETF	561.35	561.63	561.23	561.3	41151.0
2025-08-06 08:00:00	QQQ	ETF	561.09	562.28	559.85	560.69	191904.0
2025-08-06 08:30:00	QQQ	ETF	560.65	561.44	560.6	561.281	54573.0
2025-08-06 09:00:00	QQQ	ETF	561.38	561.67	561.02	561.09	125048.0
2025-08-06 09:30:00	QQQ	ETF	561.11	562.93	560.63	561.92	4102842.0
2025-08-06 10:00:00	QQQ	ETF	561.91	563.89	561.0	561.83	3023431.0
2025-08-06 10:30:00	QQQ	ETF	561.85	563.93	561.36	563.8351	2266920.0
2025-08-06 11:00:00	QQQ	ETF	563.84	565.035	563.27	564.88	2444099.0
2025-08-06 11:30:00	QQQ	ETF	564.86	566.09	564.26	565.91	2089749.0
2025-08-06 12:00:00	QQQ	ETF	565.91	566.34	565.66	565.92	1725548.0
2025-08-06 12:30:00	QQQ	ETF	565.915	566.42	565.38	565.98	1261263.0

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

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