PREVIEW / etf_30min / 2026-01-13

all etf 30-min files

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

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-13 04:00:00	SPY	ETF	694.31	694.97	694.31	694.8	23397.0
2026-01-13 04:30:00	SPY	ETF	694.8	694.83	694.41	694.63	9519.0
2026-01-13 05:00:00	SPY	ETF	694.57	694.6	694.01	694.27	10176.0
2026-01-13 05:30:00	SPY	ETF	694.21	694.4	694.19	694.25	7586.0
2026-01-13 06:00:00	SPY	ETF	694.23	694.49	694.23	694.45	5409.0
2026-01-13 06:30:00	SPY	ETF	694.33	694.75	694.15	694.68	48438.0
2026-01-13 07:00:00	SPY	ETF	694.73	694.83	694.55	694.8	28540.0
2026-01-13 07:30:00	SPY	ETF	694.75	694.85	694.31	694.38	56912.0
2026-01-13 08:00:00	SPY	ETF	694.59	695.09	694.0396	694.42	125760.0
2026-01-13 08:30:00	SPY	ETF	694.45	697.3	694.34	695.67	1009218.0
2026-01-13 09:00:00	SPY	ETF	695.67	696.42	695.49	695.53	311656.0
2026-01-13 09:30:00	SPY	ETF	695.52	696.09	694.23	694.245	9224289.0
2026-01-13 10:00:00	SPY	ETF	694.23	694.51	692.09	692.73	6022171.0
2026-01-13 10:30:00	SPY	ETF	692.72	694.04	692.5652	693.76	4307373.0
2026-01-13 11:00:00	SPY	ETF	693.76	694.2801	692.41	693.4801	3320854.0
2026-01-13 11:30:00	SPY	ETF	693.48	695.2	693.25	694.92	4154647.0
2026-01-13 12:00:00	SPY	ETF	694.92	695.12	693.93	694.56	2550019.0
2026-01-13 12:30:00	SPY	ETF	694.55	694.715	692.525	692.94	3980536.0
2026-01-13 13:00:00	SPY	ETF	692.92	693.49	692.42	692.92	3253787.0
2026-01-13 13:30:00	SPY	ETF	692.91	693.65	692.54	692.8	2579737.0
2026-01-13 14:00:00	SPY	ETF	692.8	693.08	692.23	693.01	3727293.0
2026-01-13 14:30:00	SPY	ETF	693.005	693.205	692.57	692.92	2977260.0
2026-01-13 15:00:00	SPY	ETF	692.92	692.92	691.94	692.0	4498305.0
2026-01-13 15:30:00	SPY	ETF	692.0	693.96	691.35	693.75	11291544.0
2026-01-13 16:00:00	SPY	ETF	693.75	694.05	693.65	693.79	3892829.0
2026-01-13 16:30:00	SPY	ETF	693.79	693.79	693.44	693.6	183054.0
2026-01-13 17:00:00	SPY	ETF	693.51	693.78	693.1	693.3995	38150.0
2026-01-13 17:30:00	SPY	ETF	693.4	693.53	693.32	693.53	29976.0
2026-01-13 18:00:00	SPY	ETF	693.52	693.76	693.29	693.311	45075.0
2026-01-13 18:30:00	SPY	ETF	693.34	693.6	693.34	693.37	13155.0
2026-01-13 19:00:00	SPY	ETF	693.35	693.86	693.28	693.82	16698.0
2026-01-13 19:30:00	SPY	ETF	693.84	693.85	693.57	693.5987	11594.0
2026-01-13 04:00:00	QQQ	ETF	626.5	626.93	626.22	626.68	44276.0
2026-01-13 04:30:00	QQQ	ETF	626.63	626.71	625.94	626.36	24337.0
2026-01-13 05:00:00	QQQ	ETF	626.36	626.42	625.44	625.66	29939.0
2026-01-13 05:30:00	QQQ	ETF	625.66	625.99	625.52	625.54	12564.0
2026-01-13 06:00:00	QQQ	ETF	625.64	625.98	625.52	625.79	12354.0
2026-01-13 06:30:00	QQQ	ETF	625.79	626.06	625.4	626.03	42278.0
2026-01-13 07:00:00	QQQ	ETF	626.11	626.5	625.86	626.47	49247.0
2026-01-13 07:30:00	QQQ	ETF	626.44	626.52	625.83	625.95	101763.0
2026-01-13 08:00:00	QQQ	ETF	626.06	626.88	625.42	626.34	199552.0
2026-01-13 08:30:00	QQQ	ETF	626.4	629.51	626.4	627.75	853129.0
2026-01-13 09:00:00	QQQ	ETF	627.75	628.49	627.22	627.25	195669.0
2026-01-13 09:30:00	QQQ	ETF	627.27	629.47	626.79	627.2	5641072.0
2026-01-13 10:00:00	QQQ	ETF	627.18	627.7	623.94	624.66	3823250.0
2026-01-13 10:30:00	QQQ	ETF	624.62	626.15	623.88	625.95	2819205.0
2026-01-13 11:00:00	QQQ	ETF	625.92	626.65	624.8	626.1882	1881162.0
2026-01-13 11:30:00	QQQ	ETF	626.13	629.04	625.91	628.62	2801106.0
2026-01-13 12:00:00	QQQ	ETF	628.62	628.84	627.09	627.6299	2074850.0
2026-01-13 12:30:00	QQQ	ETF	627.63	627.91	625.01	625.46	2362916.0

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

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