PREVIEW / etf_30min / 2026-01-27

all etf 30-min files

  file:    by_date/etf_30min/2026/2026-01-27.parquet
  size:    1.1 MB
  rows:    47,434

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-01-27 04:00:00	SPY	ETF	694.45	694.66	694.3	694.49	15345.0
2026-01-27 04:30:00	SPY	ETF	694.42	694.55	694.2	694.23	34049.0
2026-01-27 05:00:00	SPY	ETF	694.3	694.65	694.23	694.61	70384.0
2026-01-27 05:30:00	SPY	ETF	694.59	694.72	694.46	694.64	27898.0
2026-01-27 06:00:00	SPY	ETF	694.6	694.62	694.42	694.59	13420.0
2026-01-27 06:30:00	SPY	ETF	694.56	695.08	694.56	694.87	35450.0
2026-01-27 07:00:00	SPY	ETF	694.82	694.89	694.25	694.32	85643.0
2026-01-27 07:30:00	SPY	ETF	694.32	694.65	694.21	694.41	39745.0
2026-01-27 08:00:00	SPY	ETF	694.83	695.3	694.13	694.39	211677.0
2026-01-27 08:30:00	SPY	ETF	694.4	694.62	694.15	694.2712	89675.0
2026-01-27 09:00:00	SPY	ETF	694.28	694.5	693.94	694.18	139818.0
2026-01-27 09:30:00	SPY	ETF	694.18	695.48	693.57	695.17	5860162.0
2026-01-27 10:00:00	SPY	ETF	695.18	695.44	694.51	694.78	3609471.0
2026-01-27 10:30:00	SPY	ETF	694.77	696.14	694.715	696.0	3167311.0
2026-01-27 11:00:00	SPY	ETF	696.0	696.48	695.98	696.19	2670379.0
2026-01-27 11:30:00	SPY	ETF	696.19	696.53	696.01	696.01	2556668.0
2026-01-27 12:00:00	SPY	ETF	696.01	696.14	695.38	695.985	2671119.0
2026-01-27 12:30:00	SPY	ETF	695.98	696.08	695.38	695.425	1663630.0
2026-01-27 13:00:00	SPY	ETF	695.42	695.97	694.91	695.795	2105962.0
2026-01-27 13:30:00	SPY	ETF	695.8	696.21	695.71	696.03	1573474.0
2026-01-27 14:00:00	SPY	ETF	696.02	696.2	695.74	696.17	1584655.0
2026-01-27 14:30:00	SPY	ETF	696.17	696.36	696.0	696.075	1827768.0
2026-01-27 15:00:00	SPY	ETF	696.07	696.4	695.94	695.9999	2653333.0
2026-01-27 15:30:00	SPY	ETF	695.99	696.18	695.4	695.54	8316067.0
2026-01-27 16:00:00	SPY	ETF	695.55	695.75	695.24	695.54	2867840.0
2026-01-27 16:30:00	SPY	ETF	695.52	695.85	695.4903	695.6123	121073.0
2026-01-27 17:00:00	SPY	ETF	695.64	695.85	695.43	695.61	48429.0
2026-01-27 17:30:00	SPY	ETF	695.61	695.83	695.6	695.75	11668.0
2026-01-27 18:00:00	SPY	ETF	695.72	696.16	695.72	696.03	22383.0
2026-01-27 18:30:00	SPY	ETF	696.0	696.05	695.87	695.95	10174.0
2026-01-27 19:00:00	SPY	ETF	695.96	696.63	695.9104	696.56	20306.0
2026-01-27 19:30:00	SPY	ETF	696.58	697.28	696.58	697.16	57043.0
2026-01-27 04:00:00	QQQ	ETF	628.91	629.18	628.63	628.94	59017.0
2026-01-27 04:30:00	QQQ	ETF	628.96	629.03	628.56	628.72	30066.0
2026-01-27 05:00:00	QQQ	ETF	628.77	629.31	628.69	629.31	51388.0
2026-01-27 05:30:00	QQQ	ETF	629.23	629.51	629.12	629.47	47452.0
2026-01-27 06:00:00	QQQ	ETF	629.46	629.53	629.15	629.44	28843.0
2026-01-27 06:30:00	QQQ	ETF	629.42	630.35	629.4	630.1	80158.0
2026-01-27 07:00:00	QQQ	ETF	630.09	630.1	629.23	629.23	64383.0
2026-01-27 07:30:00	QQQ	ETF	629.2	629.73	629.12	629.44	46597.0
2026-01-27 08:00:00	QQQ	ETF	630.02	630.27	624.991	629.37	247438.0
2026-01-27 08:30:00	QQQ	ETF	629.36	629.5	628.93	629.09	155043.0
2026-01-27 09:00:00	QQQ	ETF	629.1	629.53	628.87	628.9	194616.0
2026-01-27 09:30:00	QQQ	ETF	628.91	630.69	627.34	630.56	5675815.0
2026-01-27 10:00:00	QQQ	ETF	630.62	631.07	629.85	630.32	3233526.0
2026-01-27 10:30:00	QQQ	ETF	630.33	631.64	630.24	631.1703	2673681.0
2026-01-27 11:00:00	QQQ	ETF	631.18	631.83	631.035	631.44	1737428.0
2026-01-27 11:30:00	QQQ	ETF	631.46	631.66	631.13	631.18	1347211.0
2026-01-27 12:00:00	QQQ	ETF	631.19	631.405	630.51	631.3	1675890.0
2026-01-27 12:30:00	QQQ	ETF	631.29	631.49	630.69	630.775	1229685.0

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

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