PREVIEW / etf_30min / 2026-07-28

all etf 30-min files

  file:    by_date/etf_30min/2026/2026-07-28.parquet
  size:    1.1 MB
  rows:    47,042

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-07-28 04:00:00	SPY	ETF	737.0	738.74	736.16	738.52	71543.0
2026-07-28 04:30:00	SPY	ETF	738.49	739.06	738.2	738.45	17693.0
2026-07-28 05:00:00	SPY	ETF	738.45	738.85	738.38	738.85	11342.0
2026-07-28 05:30:00	SPY	ETF	738.68	738.77	738.1	738.26	7136.0
2026-07-28 06:00:00	SPY	ETF	738.28	738.51	737.965	738.5	9386.0
2026-07-28 06:30:00	SPY	ETF	738.51	738.63	737.69	738.52	40043.0
2026-07-28 07:00:00	SPY	ETF	738.471	739.16	737.59	738.11	104687.0
2026-07-28 07:30:00	SPY	ETF	738.14	739.49	737.6241	739.36	73660.0
2026-07-28 08:00:00	SPY	ETF	739.39	740.06	737.51	739.95	281708.0
2026-07-28 08:30:00	SPY	ETF	739.99	741.0	739.32	739.88	172758.0
2026-07-28 09:00:00	SPY	ETF	739.87	740.48	739.14	739.19	231472.0
2026-07-28 09:30:00	SPY	ETF	739.24	739.49	735.98	736.5	5223062.0
2026-07-28 10:00:00	SPY	ETF	736.49	738.215	736.27	737.7	2254992.0
2026-07-28 10:30:00	SPY	ETF	737.72	739.82	737.15	738.64	2648533.0
2026-07-28 11:00:00	SPY	ETF	738.7	741.9	738.01	741.2	2457561.0
2026-07-28 11:30:00	SPY	ETF	741.17	742.45	740.991	742.215	1431605.0
2026-07-28 12:00:00	SPY	ETF	742.205	742.35	741.21	741.21	1314051.0
2026-07-28 12:30:00	SPY	ETF	741.23	742.7901	740.92	742.61	1021568.0
2026-07-28 13:00:00	SPY	ETF	742.61	742.78	741.08	741.31	1122843.0
2026-07-28 13:30:00	SPY	ETF	741.3	741.92	740.51	741.19	1122930.0
2026-07-28 14:00:00	SPY	ETF	741.2	741.52	740.42	740.59	1450193.0
2026-07-28 14:30:00	SPY	ETF	740.59	741.615	740.5	741.45	1285626.0
2026-07-28 15:00:00	SPY	ETF	741.45	741.96	741.31	741.7	1535444.0
2026-07-28 15:30:00	SPY	ETF	741.71	741.73	740.43	740.76	4746588.0
2026-07-28 16:00:00	SPY	ETF	740.79	741.6	740.08	741.44	2768551.0
2026-07-28 16:30:00	SPY	ETF	741.44	741.53	740.77	741.03	138449.0
2026-07-28 17:00:00	SPY	ETF	740.95	741.05	740.85	740.9216	23907.0
2026-07-28 17:30:00	SPY	ETF	741.06	741.19	740.78	740.78	21005.0
2026-07-28 18:00:00	SPY	ETF	740.91	741.6	740.01	740.46	142383.0
2026-07-28 18:30:00	SPY	ETF	740.37	740.4799	739.3	739.61	125860.0
2026-07-28 19:00:00	SPY	ETF	739.38	741.2191	739.15	741.07	103047.0
2026-07-28 19:30:00	SPY	ETF	741.021	743.63	740.94	743.57	70197.0
2026-07-28 04:00:00	QQQ	ETF	676.82	678.52	673.67	677.6	261887.0
2026-07-28 04:30:00	QQQ	ETF	677.62	678.69	677.0	677.31	77265.0
2026-07-28 05:00:00	QQQ	ETF	677.34	677.92	677.13	677.85	24312.0
2026-07-28 05:30:00	QQQ	ETF	677.8	677.83	676.18	676.35	39742.0
2026-07-28 06:00:00	QQQ	ETF	676.47	676.78	675.96	676.75	57652.0
2026-07-28 06:30:00	QQQ	ETF	676.83	677.04	675.3	676.14	104224.0
2026-07-28 07:00:00	QQQ	ETF	676.17	676.5	674.26	674.76	262371.0
2026-07-28 07:30:00	QQQ	ETF	674.7	676.85	673.97	676.64	214186.0
2026-07-28 08:00:00	QQQ	ETF	676.6	678.09	676.03	677.82	177443.0
2026-07-28 08:30:00	QQQ	ETF	677.78	682.631	676.5	677.41	166386.0
2026-07-28 09:00:00	QQQ	ETF	677.44	678.19	676.01	676.4	272520.0
2026-07-28 09:30:00	QQQ	ETF	676.29	677.32	668.8564	669.38	7853815.0
2026-07-28 10:00:00	QQQ	ETF	669.33	672.433	667.88	670.33	4270296.0
2026-07-28 10:30:00	QQQ	ETF	670.39	674.83	669.45	672.69	3057067.0
2026-07-28 11:00:00	QQQ	ETF	672.71	677.75	671.83	676.598	3219260.0
2026-07-28 11:30:00	QQQ	ETF	676.63	678.99	676.22	678.61	1991150.0
2026-07-28 12:00:00	QQQ	ETF	678.63	679.15	677.08	677.3047	1687766.0
2026-07-28 12:30:00	QQQ	ETF	677.34	679.4	676.33	678.81	1328522.0

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

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