PREVIEW / etf_30min / 2025-07-22

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-07-22.parquet
  size:    991 KB
  rows:    41,340

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-22 04:00:00	SPY	ETF	628.31	628.66	627.99	628.11	20464.0
2025-07-22 04:30:00	SPY	ETF	628.14	628.28	627.93	628.05	10923.0
2025-07-22 05:00:00	SPY	ETF	628.03	628.18	627.9	627.99	4474.0
2025-07-22 05:30:00	SPY	ETF	627.97	628.1	627.87	628.04	16949.0
2025-07-22 06:00:00	SPY	ETF	628.11	628.35	628.1	628.2	15989.0
2025-07-22 06:30:00	SPY	ETF	628.21	628.32	628.01	628.28	5465.0
2025-07-22 07:00:00	SPY	ETF	628.28	628.68	628.13	628.36	25915.0
2025-07-22 07:30:00	SPY	ETF	628.36	629.01	628.06	628.96	42894.0
2025-07-22 08:00:00	SPY	ETF	628.91	629.18	628.0902	629.16	257008.0
2025-07-22 08:30:00	SPY	ETF	629.13	629.21	628.91	629.09	91464.0
2025-07-22 09:00:00	SPY	ETF	629.11	629.25	628.91	629.05	176321.0
2025-07-22 09:30:00	SPY	ETF	629.08	629.19	626.19	626.88	6888823.0
2025-07-22 10:00:00	SPY	ETF	626.89	627.41	626.2499	627.09	3652246.0
2025-07-22 10:30:00	SPY	ETF	627.08	628.035	626.9721	627.95	2781379.0
2025-07-22 11:00:00	SPY	ETF	627.955	628.115	627.33	627.64	2090763.0
2025-07-22 11:30:00	SPY	ETF	627.64	628.06	627.43	627.65	2219191.0
2025-07-22 12:00:00	SPY	ETF	627.66	628.125	627.04	627.24	2242091.0
2025-07-22 12:30:00	SPY	ETF	627.25	627.975	627.07	627.855	1893086.0
2025-07-22 13:00:00	SPY	ETF	627.86	629.22	627.78	629.05	2205517.0
2025-07-22 13:30:00	SPY	ETF	629.05	629.18	628.3	628.3547	1970522.0
2025-07-22 14:00:00	SPY	ETF	628.35	628.767	627.52	628.425	2845209.0
2025-07-22 14:30:00	SPY	ETF	628.42	629.53	628.37	629.34	2885584.0
2025-07-22 15:00:00	SPY	ETF	629.34	629.46	628.97	629.2	2730885.0
2025-07-22 15:30:00	SPY	ETF	629.19	629.73	628.75	628.83	7278218.0
2025-07-22 16:00:00	SPY	ETF	628.83	628.9342	628.57	628.8	2738253.0
2025-07-22 16:30:00	SPY	ETF	628.82	628.98	628.77	628.97	170256.0
2025-07-22 17:00:00	SPY	ETF	628.9	628.99	628.87	628.92	30699.0
2025-07-22 17:30:00	SPY	ETF	628.87	628.93	628.87	628.92	14807.0
2025-07-22 18:00:00	SPY	ETF	628.91	629.26	628.78	628.82	45324.0
2025-07-22 18:30:00	SPY	ETF	628.81	628.85	628.57	628.68	23471.0
2025-07-22 19:00:00	SPY	ETF	628.75	630.47	628.74	630.0	119426.0
2025-07-22 19:30:00	SPY	ETF	629.98	630.62	629.81	630.51	65845.0
2025-07-22 04:00:00	QQQ	ETF	563.28	563.55	562.68	562.92	36734.0
2025-07-22 04:30:00	QQQ	ETF	562.84	563.05	562.53	562.64	15218.0
2025-07-22 05:00:00	QQQ	ETF	562.62	562.87	562.47	562.65	67479.0
2025-07-22 05:30:00	QQQ	ETF	562.65	562.84	562.46	562.8	77247.0
2025-07-22 06:00:00	QQQ	ETF	562.85	563.25	562.84	562.99	41583.0
2025-07-22 06:30:00	QQQ	ETF	563.02	563.23	562.7	563.2	21927.0
2025-07-22 07:00:00	QQQ	ETF	563.23	563.83	563.12	563.42	40040.0
2025-07-22 07:30:00	QQQ	ETF	563.4	564.0	563.26	564.0	33606.0
2025-07-22 08:00:00	QQQ	ETF	563.65	564.3	562.75	564.14	128874.0
2025-07-22 08:30:00	QQQ	ETF	564.1407	564.1407	563.8025	564.03	59219.0
2025-07-22 09:00:00	QQQ	ETF	564.03	564.29	563.95	564.17	116808.0
2025-07-22 09:30:00	QQQ	ETF	564.31	564.36	558.63	559.335	6670511.0
2025-07-22 10:00:00	QQQ	ETF	559.34	560.74	558.61	560.01	3522807.0
2025-07-22 10:30:00	QQQ	ETF	560.0	561.48	559.96	561.352	2163540.0
2025-07-22 11:00:00	QQQ	ETF	561.36	561.49	560.635	560.97	1376781.0
2025-07-22 11:30:00	QQQ	ETF	560.96	561.61	560.83	560.935	1417195.0
2025-07-22 12:00:00	QQQ	ETF	560.95	561.3599	559.91	560.1	1647798.0
2025-07-22 12:30:00	QQQ	ETF	560.1	560.77	559.78	560.71	1416660.0

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

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