PREVIEW / etf_30min / 2026-07-27

all etf 30-min files

  file:    by_date/etf_30min/2026/2026-07-27.parquet
  size:    1.0 MB
  rows:    46,667

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
2026-07-27 04:00:00	SPY	ETF	744.23	746.0	744.1	745.6283	47445.0
2026-07-27 04:30:00	SPY	ETF	745.67	746.11	745.55	746.02	27426.0
2026-07-27 05:00:00	SPY	ETF	746.04	746.09	745.78	745.93	5308.0
2026-07-27 05:30:00	SPY	ETF	745.89	746.53	745.8	746.39	14465.0
2026-07-27 06:00:00	SPY	ETF	746.35	746.43	746.0	746.25	16193.0
2026-07-27 06:30:00	SPY	ETF	746.23	746.53	746.1	746.3	74508.0
2026-07-27 07:00:00	SPY	ETF	746.28	746.33	744.93	744.99	89373.0
2026-07-27 07:30:00	SPY	ETF	745.11	745.6	745.05	745.36	68455.0
2026-07-27 08:00:00	SPY	ETF	745.53	745.65	744.62	745.0	42591.0
2026-07-27 08:30:00	SPY	ETF	744.96	745.53	744.83	745.4	86680.0
2026-07-27 09:00:00	SPY	ETF	745.46	745.63	744.83	744.9	202916.0
2026-07-27 09:30:00	SPY	ETF	744.87	745.53	741.6	741.6	3625862.0
2026-07-27 10:00:00	SPY	ETF	741.6	742.13	738.2	738.315	3653512.0
2026-07-27 10:30:00	SPY	ETF	738.33	739.88	736.54	739.6901	3482136.0
2026-07-27 11:00:00	SPY	ETF	739.72	740.31	737.88	738.29	2003290.0
2026-07-27 11:30:00	SPY	ETF	738.27	738.27	736.335	737.485	1437116.0
2026-07-27 12:00:00	SPY	ETF	737.4925	739.68	736.86	738.72	1661090.0
2026-07-27 12:30:00	SPY	ETF	738.72	739.35	736.64	737.057	974577.0
2026-07-27 13:00:00	SPY	ETF	737.07	737.1	735.87	736.2	1321716.0
2026-07-27 13:30:00	SPY	ETF	736.22	737.85	736.18	737.8	847229.0
2026-07-27 14:00:00	SPY	ETF	737.84	737.97	737.03	737.62	1133148.0
2026-07-27 14:30:00	SPY	ETF	737.64	739.25	736.62	739.06	1969240.0
2026-07-27 15:00:00	SPY	ETF	739.06	739.77	738.49	739.65	1725562.0
2026-07-27 15:30:00	SPY	ETF	739.65	739.85	738.5	739.02	4802767.0
2026-07-27 16:00:00	SPY	ETF	739.08	739.53	738.67	738.96	1507191.0
2026-07-27 16:30:00	SPY	ETF	739.02	739.81	738.96	739.41	181533.0
2026-07-27 17:00:00	SPY	ETF	739.4	739.5987	739.27	739.41	23816.0
2026-07-27 17:30:00	SPY	ETF	739.4	739.55	739.33	739.34	17737.0
2026-07-27 18:00:00	SPY	ETF	739.6	739.7	738.6	738.64	57531.0
2026-07-27 18:30:00	SPY	ETF	738.7	738.97	738.59	738.63	12779.0
2026-07-27 19:00:00	SPY	ETF	738.62	738.99	738.17	738.99	17037.0
2026-07-27 19:30:00	SPY	ETF	738.96	739.1	738.4	738.87	14021.0
2026-07-27 04:00:00	QQQ	ETF	692.23	695.05	691.9	694.8	176307.0
2026-07-27 04:30:00	QQQ	ETF	694.8495	695.52	694.45	695.22	65869.0
2026-07-27 05:00:00	QQQ	ETF	695.19	695.29	694.89	695.04	21270.0
2026-07-27 05:30:00	QQQ	ETF	694.91	695.89	694.84	695.51	38238.0
2026-07-27 06:00:00	QQQ	ETF	695.54	695.65	695.03	695.24	44368.0
2026-07-27 06:30:00	QQQ	ETF	695.32	695.66	695.0	695.3933	43181.0
2026-07-27 07:00:00	QQQ	ETF	695.331	695.4	693.18	693.25	106906.0
2026-07-27 07:30:00	QQQ	ETF	693.2576	693.94	693.21	693.7	101541.0
2026-07-27 08:00:00	QQQ	ETF	693.73	694.31	683.717	693.19	102085.0
2026-07-27 08:30:00	QQQ	ETF	693.18	694.19	692.74	694.09	130180.0
2026-07-27 09:00:00	QQQ	ETF	694.14	694.4	691.65	691.69	266326.0
2026-07-27 09:30:00	QQQ	ETF	691.68	692.3	685.6728	685.8	3706718.0
2026-07-27 10:00:00	QQQ	ETF	685.83	686.37	679.22	679.46	4784750.0
2026-07-27 10:30:00	QQQ	ETF	679.45	681.74	675.945	681.47	4622332.0
2026-07-27 11:00:00	QQQ	ETF	681.52	682.16	678.53	679.12	2358908.0
2026-07-27 11:30:00	QQQ	ETF	679.18	679.41	676.91	678.88	1495584.0
2026-07-27 12:00:00	QQQ	ETF	678.92	682.34	678.46	681.12	1972765.0
2026-07-27 12:30:00	QQQ	ETF	681.11	682.13	678.05	678.54	1467391.0

> showing 50 of 46,667 rows — these rows as CSV

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