PREVIEW / etf_30min / 2025-10-28

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-10-28.parquet
  size:    1.1 MB
  rows:    45,569

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-28 04:00:00	SPY	ETF	684.9	685.02	684.7	684.83	18621.0
2025-10-28 04:30:00	SPY	ETF	684.88	685.21	684.69	685.12	8536.0
2025-10-28 05:00:00	SPY	ETF	685.18	685.3	684.96	684.97	15695.0
2025-10-28 05:30:00	SPY	ETF	685.03	685.29	684.94	685.27	9227.0
2025-10-28 06:00:00	SPY	ETF	685.25	685.55	685.2	685.42	51359.0
2025-10-28 06:30:00	SPY	ETF	685.42	685.48	685.18	685.28	5361.0
2025-10-28 07:00:00	SPY	ETF	685.28	685.7	685.2	685.61	26588.0
2025-10-28 07:30:00	SPY	ETF	685.6	685.9	685.57	685.83	41686.0
2025-10-28 08:00:00	SPY	ETF	685.28	686.33	684.72	686.24	136011.0
2025-10-28 08:30:00	SPY	ETF	686.17	686.279	685.99	686.09	54010.0
2025-10-28 09:00:00	SPY	ETF	686.1309	687.23	686.12	687.07	260715.0
2025-10-28 09:30:00	SPY	ETF	687.07	687.225	685.12	685.6201	5843779.0
2025-10-28 10:00:00	SPY	ETF	685.71	686.1582	685.5	686.13	2247175.0
2025-10-28 10:30:00	SPY	ETF	686.12	686.37	685.59	685.85	2471564.0
2025-10-28 11:00:00	SPY	ETF	685.86	686.21	685.37	685.53	1299258.0
2025-10-28 11:30:00	SPY	ETF	685.52	685.61	684.83	685.58	1972599.0
2025-10-28 12:00:00	SPY	ETF	685.58	686.2245	685.58	686.182	1545316.0
2025-10-28 12:30:00	SPY	ETF	686.18	688.32	686.06	686.9	3525982.0
2025-10-28 13:00:00	SPY	ETF	686.88	687.37	686.86	687.01	1703813.0
2025-10-28 13:30:00	SPY	ETF	687.02	687.71	686.875	687.6017	2016940.0
2025-10-28 14:00:00	SPY	ETF	687.61	688.4	687.54	688.051	2426055.0
2025-10-28 14:30:00	SPY	ETF	688.055	688.19	687.78	688.155	1858137.0
2025-10-28 15:00:00	SPY	ETF	688.148	688.905	687.82	688.69	3110260.0
2025-10-28 15:30:00	SPY	ETF	688.7	688.71	686.905	686.98	8395909.0
2025-10-28 16:00:00	SPY	ETF	686.98	687.2	686.1	687.02	2172531.0
2025-10-28 16:30:00	SPY	ETF	686.9719	687.21	686.91	687.19	233504.0
2025-10-28 17:00:00	SPY	ETF	687.21	687.26	687.01	687.11	36450.0
2025-10-28 17:30:00	SPY	ETF	687.08	687.34	687.05	687.34	15228.0
2025-10-28 18:00:00	SPY	ETF	687.27	687.53	687.12	687.4695	30647.0
2025-10-28 18:30:00	SPY	ETF	687.46	687.46	686.96	687.01	10891.0
2025-10-28 19:00:00	SPY	ETF	687.0299	687.3	686.9	687.07	20209.0
2025-10-28 19:30:00	SPY	ETF	687.1	687.33	687.04	687.28	20243.0
2025-10-28 04:00:00	QQQ	ETF	628.09	628.58	627.74	627.86	70148.0
2025-10-28 04:30:00	QQQ	ETF	627.96	628.47	627.84	628.33	48515.0
2025-10-28 05:00:00	QQQ	ETF	628.35	628.55	628.25	628.31	30589.0
2025-10-28 05:30:00	QQQ	ETF	628.38	628.62	628.22	628.56	22261.0
2025-10-28 06:00:00	QQQ	ETF	628.53	628.82	628.34	628.74	47229.0
2025-10-28 06:30:00	QQQ	ETF	628.75	629.0	628.45	628.57	36896.0
2025-10-28 07:00:00	QQQ	ETF	628.58	629.18	628.57	629.0	107217.0
2025-10-28 07:30:00	QQQ	ETF	629.01	629.2	628.91	629.03	58046.0
2025-10-28 08:00:00	QQQ	ETF	627.91	629.7	627.619	629.57	317151.0
2025-10-28 08:30:00	QQQ	ETF	629.59	629.61	629.16	629.42	94318.0
2025-10-28 09:00:00	QQQ	ETF	629.37	630.58	629.37	630.36	458773.0
2025-10-28 09:30:00	QQQ	ETF	630.36	631.36	629.77	630.585	4884479.0
2025-10-28 10:00:00	QQQ	ETF	630.66	630.9084	629.8999	630.19	2637725.0
2025-10-28 10:30:00	QQQ	ETF	630.19	630.321	629.28	629.9071	1915702.0
2025-10-28 11:00:00	QQQ	ETF	629.91	630.4	629.83	630.155	1086540.0
2025-10-28 11:30:00	QQQ	ETF	630.15	630.535	629.25	630.5299	1461996.0
2025-10-28 12:00:00	QQQ	ETF	630.55	631.36	630.5484	631.295	1912189.0
2025-10-28 12:30:00	QQQ	ETF	631.295	632.58	630.97	631.665	3065915.0

> showing 50 of 45,569 rows — these rows as CSV

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