PREVIEW / etf_30min / 2026-01-20

all etf 30-min files

  file:    by_date/etf_30min/2026/2026-01-20.parquet
  size:    1.2 MB
  rows:    51,374

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-20 04:00:00	SPY	ETF	680.68	685.86	679.66	679.75	163731.0
2026-01-20 04:30:00	SPY	ETF	679.76	679.82	679.05	679.54	124922.0
2026-01-20 05:00:00	SPY	ETF	679.56	681.11	679.15	680.87	59733.0
2026-01-20 05:30:00	SPY	ETF	680.97	681.25	680.41	680.6	62337.0
2026-01-20 06:00:00	SPY	ETF	680.63	681.71	680.54	681.13	180440.0
2026-01-20 06:30:00	SPY	ETF	681.17	681.71	680.76	681.26	200450.0
2026-01-20 07:00:00	SPY	ETF	681.33	682.23	680.98	681.85	197865.0
2026-01-20 07:30:00	SPY	ETF	681.81	683.0	681.71	682.44	210685.0
2026-01-20 08:00:00	SPY	ETF	681.39	685.18	679.0595	682.03	644791.0
2026-01-20 08:30:00	SPY	ETF	682.0	682.1	680.35	680.99	845616.0
2026-01-20 09:00:00	SPY	ETF	680.98	681.58	680.82	681.49	595916.0
2026-01-20 09:30:00	SPY	ETF	681.49	683.31	681.39	682.18	14048502.0
2026-01-20 10:00:00	SPY	ETF	682.16	684.01	680.91	683.8788	8907295.0
2026-01-20 10:30:00	SPY	ETF	683.85	684.77	682.93	683.8	5733484.0
2026-01-20 11:00:00	SPY	ETF	683.81	684.56	682.58	683.84	4332434.0
2026-01-20 11:30:00	SPY	ETF	683.83	684.345	682.32	683.69	4205693.0
2026-01-20 12:00:00	SPY	ETF	683.67	683.905	682.12	682.395	3485949.0
2026-01-20 12:30:00	SPY	ETF	682.39	682.39	680.45	681.08	4410852.0
2026-01-20 13:00:00	SPY	ETF	681.08	681.48	680.225	680.29	2528390.0
2026-01-20 13:30:00	SPY	ETF	680.28	680.42	678.025	678.72	5207149.0
2026-01-20 14:00:00	SPY	ETF	678.73	679.27	677.69	678.04	4306847.0
2026-01-20 14:30:00	SPY	ETF	678.04	678.48	677.29	677.83	4334315.0
2026-01-20 15:00:00	SPY	ETF	677.85	678.15	676.93	677.39	6802460.0
2026-01-20 15:30:00	SPY	ETF	677.4	677.74	676.57	677.61	13598729.0
2026-01-20 16:00:00	SPY	ETF	677.63	678.32	676.87	678.01	3496108.0
2026-01-20 16:30:00	SPY	ETF	678.01	678.07	677.53	677.98	166266.0
2026-01-20 17:00:00	SPY	ETF	678.0	678.15	677.97	678.0504	113018.0
2026-01-20 17:30:00	SPY	ETF	678.07	678.3	678.05	678.09	57797.0
2026-01-20 18:00:00	SPY	ETF	678.1	678.67	677.94	678.1	82155.0
2026-01-20 18:30:00	SPY	ETF	678.11	678.32	677.21	677.41	53808.0
2026-01-20 19:00:00	SPY	ETF	677.56	678.34	677.56	678.3001	51026.0
2026-01-20 19:30:00	SPY	ETF	678.25	678.7998	678.2	678.6602	95147.0
2026-01-20 04:00:00	QQQ	ETF	614.3	614.3	607.85	608.15	338851.0
2026-01-20 04:30:00	QQQ	ETF	607.99	608.16	607.05	608.02	150133.0
2026-01-20 05:00:00	QQQ	ETF	607.95	609.7	607.38	609.4	117689.0
2026-01-20 05:30:00	QQQ	ETF	609.48	609.61	608.75	608.96	75302.0
2026-01-20 06:00:00	QQQ	ETF	608.93	610.22	608.9	609.59	117386.0
2026-01-20 06:30:00	QQQ	ETF	609.62	610.03	608.99	609.62	81709.0
2026-01-20 07:00:00	QQQ	ETF	609.71	610.88	609.37	610.41	192721.0
2026-01-20 07:30:00	QQQ	ETF	610.38	611.58	610.25	610.95	164182.0
2026-01-20 08:00:00	QQQ	ETF	610.98	621.725	607.06	610.67	787620.0
2026-01-20 08:30:00	QQQ	ETF	610.6262	611.68	609.08	609.78	743654.0
2026-01-20 09:00:00	QQQ	ETF	609.78	610.76	609.49	610.51	546197.0
2026-01-20 09:30:00	QQQ	ETF	610.52	613.595	610.32	612.5	11008209.0
2026-01-20 10:00:00	QQQ	ETF	612.48	613.48	610.88	613.436	7324784.0
2026-01-20 10:30:00	QQQ	ETF	613.43	614.78	612.31	613.48	5599595.0
2026-01-20 11:00:00	QQQ	ETF	613.48	615.04	612.77	614.45	4092485.0
2026-01-20 11:30:00	QQQ	ETF	614.45	615.055	612.84	614.3	4082822.0
2026-01-20 12:00:00	QQQ	ETF	614.29	614.5	612.59	612.8807	3247754.0
2026-01-20 12:30:00	QQQ	ETF	612.88	612.88	610.9	611.77	3769960.0

> showing 50 of 51,374 rows — these rows as CSV

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