PREVIEW / etf_30min / 2025-10-27

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-10-27.parquet
  size:    1.1 MB
  rows:    46,887

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
2025-10-27 04:00:00	SPY	ETF	682.66	682.9	682.15	682.26	71799.0
2025-10-27 04:30:00	SPY	ETF	682.25	682.68	682.15	682.55	22939.0
2025-10-27 05:00:00	SPY	ETF	682.5	682.67	682.41	682.43	5760.0
2025-10-27 05:30:00	SPY	ETF	682.39	683.14	682.39	683.06	15607.0
2025-10-27 06:00:00	SPY	ETF	683.12	683.15	682.87	683.09	8432.0
2025-10-27 06:30:00	SPY	ETF	683.0	683.21	682.95	683.04	274445.0
2025-10-27 07:00:00	SPY	ETF	683.06	683.24	682.77	682.83	51698.0
2025-10-27 07:30:00	SPY	ETF	682.79	682.86	682.32	682.41	89493.0
2025-10-27 08:00:00	SPY	ETF	682.65	683.2201	682.16	682.62	194292.0
2025-10-27 08:30:00	SPY	ETF	682.689	682.83	682.46	682.71	96290.0
2025-10-27 09:00:00	SPY	ETF	682.67	683.09	682.48	682.73	223079.0
2025-10-27 09:30:00	SPY	ETF	682.73	683.23	682.115	683.08	5766662.0
2025-10-27 10:00:00	SPY	ETF	683.09	683.61	682.4	683.03	4077524.0
2025-10-27 10:30:00	SPY	ETF	683.03	683.36	682.57	682.69	2591323.0
2025-10-27 11:00:00	SPY	ETF	682.69	683.37	682.55	683.36	1955886.0
2025-10-27 11:30:00	SPY	ETF	683.36	683.6	683.2	683.42	1859510.0
2025-10-27 12:00:00	SPY	ETF	683.4124	683.78	683.375	683.5	1838244.0
2025-10-27 12:30:00	SPY	ETF	683.51	683.88	683.5058	683.74	1535490.0
2025-10-27 13:00:00	SPY	ETF	683.75	683.79	683.17	683.4399	1865179.0
2025-10-27 13:30:00	SPY	ETF	683.44	683.99	683.315	683.94	2526549.0
2025-10-27 14:00:00	SPY	ETF	683.93	683.965	683.76	683.85	1267826.0
2025-10-27 14:30:00	SPY	ETF	683.855	684.25	683.855	684.145	2457911.0
2025-10-27 15:00:00	SPY	ETF	684.15	684.3	684.0	684.23	2568224.0
2025-10-27 15:30:00	SPY	ETF	684.23	685.54	684.185	685.18	10451148.0
2025-10-27 16:00:00	SPY	ETF	685.19	685.78	685.0	685.78	3903480.0
2025-10-27 16:30:00	SPY	ETF	685.77	686.02	685.74	685.74	92387.0
2025-10-27 17:00:00	SPY	ETF	685.736	685.76	685.53	685.6797	88302.0
2025-10-27 17:30:00	SPY	ETF	685.65	685.75	685.58	685.69	12549.0
2025-10-27 18:00:00	SPY	ETF	685.73	685.74	685.47	685.63	37806.0
2025-10-27 18:30:00	SPY	ETF	685.6126	685.7	685.51	685.59	29214.0
2025-10-27 19:00:00	SPY	ETF	685.59	686.09	685.54	686.08	14842.0
2025-10-27 19:30:00	SPY	ETF	686.0319	686.1	685.52	685.59	17409.0
2025-10-27 04:00:00	QQQ	ETF	624.0	624.12	623.07	623.63	130046.0
2025-10-27 04:30:00	QQQ	ETF	623.61	624.34	623.42	624.24	73863.0
2025-10-27 05:00:00	QQQ	ETF	624.26	624.29	623.93	623.99	50331.0
2025-10-27 05:30:00	QQQ	ETF	623.98	625.1	623.98	625.1	87392.0
2025-10-27 06:00:00	QQQ	ETF	625.11	625.3	624.86	625.26	45849.0
2025-10-27 06:30:00	QQQ	ETF	625.25	625.41	625.06	625.08	73174.0
2025-10-27 07:00:00	QQQ	ETF	625.07	625.28	624.81	625.01	93488.0
2025-10-27 07:30:00	QQQ	ETF	624.95	625.04	624.46	624.66	99335.0
2025-10-27 08:00:00	QQQ	ETF	625.04	625.4	623.06	624.99	451589.0
2025-10-27 08:30:00	QQQ	ETF	624.94	625.0	624.71	624.85	136376.0
2025-10-27 09:00:00	QQQ	ETF	624.85	625.11	624.5	624.51	285338.0
2025-10-27 09:30:00	QQQ	ETF	624.51	625.53	624.03	625.3	4563197.0
2025-10-27 10:00:00	QQQ	ETF	625.3	625.94	624.7	625.795	2892317.0
2025-10-27 10:30:00	QQQ	ETF	625.79	626.34	625.39	625.54	2403239.0
2025-10-27 11:00:00	QQQ	ETF	625.54	626.58	625.48	626.5	2176240.0
2025-10-27 11:30:00	QQQ	ETF	626.51	626.75	626.29	626.39	1768996.0
2025-10-27 12:00:00	QQQ	ETF	626.41	626.83	626.31	626.64	1817737.0
2025-10-27 12:30:00	QQQ	ETF	626.65	626.98	626.58	626.9	1445200.0

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

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