PREVIEW / etf_30min / 2026-07-23

all etf 30-min files

  file:    by_date/etf_30min/2026/2026-07-23.parquet
  size:    1.0 MB
  rows:    47,092

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-23 04:00:00	SPY	ETF	744.92	747.33	743.49	745.01	66481.0
2026-07-23 04:30:00	SPY	ETF	745.13	745.67	744.67	745.67	3473.0
2026-07-23 05:00:00	SPY	ETF	745.61	746.41	745.16	745.16	15489.0
2026-07-23 05:30:00	SPY	ETF	745.06	745.29	744.8	744.86	30099.0
2026-07-23 06:00:00	SPY	ETF	744.96	745.23	744.69	745.15	14955.0
2026-07-23 06:30:00	SPY	ETF	745.1	746.21	745.06	745.75	39027.0
2026-07-23 07:00:00	SPY	ETF	745.79	745.92	744.17	744.29	45316.0
2026-07-23 07:30:00	SPY	ETF	744.25	744.38	742.88	743.93	241986.0
2026-07-23 08:00:00	SPY	ETF	743.8796	743.98	741.78	742.06	263483.0
2026-07-23 08:30:00	SPY	ETF	742.0	742.16	740.15	740.49	389486.0
2026-07-23 09:00:00	SPY	ETF	740.43	740.76	739.0	739.35	453734.0
2026-07-23 09:30:00	SPY	ETF	739.35	742.56	738.47	739.575	5735318.0
2026-07-23 10:00:00	SPY	ETF	739.58	740.93	738.87	739.8	2553092.0
2026-07-23 10:30:00	SPY	ETF	739.74	740.64	738.01	738.31	2326676.0
2026-07-23 11:00:00	SPY	ETF	738.32	738.48	735.81	735.9298	3389995.0
2026-07-23 11:30:00	SPY	ETF	735.91	737.9	735.21	737.845	2623835.0
2026-07-23 12:00:00	SPY	ETF	737.845	739.66	737.53	739.45	1997739.0
2026-07-23 12:30:00	SPY	ETF	739.45	739.72	737.75	738.66	1634598.0
2026-07-23 13:00:00	SPY	ETF	738.67	739.2	737.79	738.75	1841434.0
2026-07-23 13:30:00	SPY	ETF	738.74	738.8	737.13	737.19	955094.0
2026-07-23 14:00:00	SPY	ETF	737.16	737.49	736.8001	737.42	1119742.0
2026-07-23 14:30:00	SPY	ETF	737.415	737.69	736.61	737.05	1556425.0
2026-07-23 15:00:00	SPY	ETF	737.08	737.9	736.47	737.48	1822222.0
2026-07-23 15:30:00	SPY	ETF	737.49	738.65	735.72	738.24	7606762.0
2026-07-23 16:00:00	SPY	ETF	738.22	739.66	738.18	739.3747	2371103.0
2026-07-23 16:30:00	SPY	ETF	739.38	739.67	739.08	739.37	150410.0
2026-07-23 17:00:00	SPY	ETF	739.31	739.5	738.75	738.85	69196.0
2026-07-23 17:30:00	SPY	ETF	738.88	738.96	738.62	738.69	28973.0
2026-07-23 18:00:00	SPY	ETF	738.7	739.1	738.22	738.6	112919.0
2026-07-23 18:30:00	SPY	ETF	738.67	739.2607	738.58	739.2607	11246.0
2026-07-23 19:00:00	SPY	ETF	739.19	739.25	738.71	738.88	9020.0
2026-07-23 19:30:00	SPY	ETF	738.82	739.08	738.35	738.79	13581.0
2026-07-23 04:00:00	QQQ	ETF	702.02	705.8	699.65	702.71	166890.0
2026-07-23 04:30:00	QQQ	ETF	702.67	704.09	702.28	704.09	24683.0
2026-07-23 05:00:00	QQQ	ETF	703.89	704.7	703.35	703.65	27566.0
2026-07-23 05:30:00	QQQ	ETF	703.56	703.59	702.565	702.6	15152.0
2026-07-23 06:00:00	QQQ	ETF	702.76	703.07	702.41	702.85	37093.0
2026-07-23 06:30:00	QQQ	ETF	702.8	704.4	702.73	703.87	96861.0
2026-07-23 07:00:00	QQQ	ETF	703.94	704.0	701.3	701.31	84697.0
2026-07-23 07:30:00	QQQ	ETF	701.23	701.53	699.38	700.63	207265.0
2026-07-23 08:00:00	QQQ	ETF	700.6355	700.6355	697.97	698.36	232389.0
2026-07-23 08:30:00	QQQ	ETF	698.16	698.47	695.57	696.32	418173.0
2026-07-23 09:00:00	QQQ	ETF	696.34	696.74	694.21	694.77	468742.0
2026-07-23 09:30:00	QQQ	ETF	694.67	698.66	693.21	694.46	5190375.0
2026-07-23 10:00:00	QQQ	ETF	694.49	696.71	693.76	695.09	2264106.0
2026-07-23 10:30:00	QQQ	ETF	695.015	695.99	691.29	691.75	2820388.0
2026-07-23 11:00:00	QQQ	ETF	691.8	691.9399	688.155	688.63	3167776.0
2026-07-23 11:30:00	QQQ	ETF	688.63	691.6	687.79	691.56	2068466.0
2026-07-23 12:00:00	QQQ	ETF	691.59	694.59	691.2	694.41	2183413.0
2026-07-23 12:30:00	QQQ	ETF	694.39	695.15	692.02	692.77	1534337.0

> showing 50 of 47,092 rows — these rows as CSV

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