PREVIEW / etf_30min / 2025-10-07

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-10-07.parquet
  size:    1.0 MB
  rows:    44,367

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-07 04:00:00	SPY	ETF	670.87	670.96	670.46	670.5	10108.0
2025-10-07 04:30:00	SPY	ETF	670.55	671.22	670.35	671.19	5469.0
2025-10-07 05:00:00	SPY	ETF	671.2	671.49	671.14	671.44	6467.0
2025-10-07 05:30:00	SPY	ETF	671.48	671.55	671.39	671.52	5673.0
2025-10-07 06:00:00	SPY	ETF	671.52	671.61	671.37	671.58	2250.0
2025-10-07 06:30:00	SPY	ETF	671.66	671.84	671.47	671.5	33748.0
2025-10-07 07:00:00	SPY	ETF	671.42	671.57	671.41	671.5	8422.0
2025-10-07 07:30:00	SPY	ETF	671.53	672.02	671.39	672.02	50935.0
2025-10-07 08:00:00	SPY	ETF	670.8	672.05	670.47	672.0	106661.0
2025-10-07 08:30:00	SPY	ETF	672.02	672.79	671.91	672.7	118784.0
2025-10-07 09:00:00	SPY	ETF	672.72	673.1	672.46	672.55	218069.0
2025-10-07 09:30:00	SPY	ETF	672.55	672.99	672.07	672.23	5504041.0
2025-10-07 10:00:00	SPY	ETF	672.23	672.37	671.26	671.27	3238716.0
2025-10-07 10:30:00	SPY	ETF	671.275	671.69	670.58	670.9	3837268.0
2025-10-07 11:00:00	SPY	ETF	670.93	671.09	668.81	669.29	8725460.0
2025-10-07 11:30:00	SPY	ETF	669.28	669.4	667.67	668.25	7298207.0
2025-10-07 12:00:00	SPY	ETF	668.26	668.845	667.67	668.4	4239924.0
2025-10-07 12:30:00	SPY	ETF	668.4	669.54	668.13	668.3692	2938322.0
2025-10-07 13:00:00	SPY	ETF	668.365	669.39	668.18	668.99	2072944.0
2025-10-07 13:30:00	SPY	ETF	668.92	669.19	668.29	668.33	1733500.0
2025-10-07 14:00:00	SPY	ETF	668.34	668.92	667.81	668.625	2209842.0
2025-10-07 14:30:00	SPY	ETF	668.63	669.0779	668.55	669.05	1672460.0
2025-10-07 15:00:00	SPY	ETF	669.035	669.14	668.53	668.57	2209847.0
2025-10-07 15:30:00	SPY	ETF	668.57	669.4	668.55	669.13	6690702.0
2025-10-07 16:00:00	SPY	ETF	669.13	669.61	669.0622	669.51	2945923.0
2025-10-07 16:30:00	SPY	ETF	669.5	669.62	669.39	669.39	168347.0
2025-10-07 17:00:00	SPY	ETF	669.37	669.48	669.31	669.32	19110.0
2025-10-07 17:30:00	SPY	ETF	669.464	669.464	669.29	669.32	9546.0
2025-10-07 18:00:00	SPY	ETF	669.32	669.75	669.32	669.72	36803.0
2025-10-07 18:30:00	SPY	ETF	669.66	669.87	669.66	669.83	30070.0
2025-10-07 19:00:00	SPY	ETF	669.77	669.77	668.98	669.1101	33890.0
2025-10-07 19:30:00	SPY	ETF	669.1001	669.1192	668.8	668.87	24042.0
2025-10-07 20:00:00	SPY	ETF	668.85	668.85	668.85	668.85	480.0
2025-10-07 04:00:00	QQQ	ETF	607.2	607.38	606.67	606.71	46944.0
2025-10-07 04:30:00	QQQ	ETF	606.76	607.55	606.5	607.51	33245.0
2025-10-07 05:00:00	QQQ	ETF	607.53	607.92	607.42	607.79	31208.0
2025-10-07 05:30:00	QQQ	ETF	607.79	608.0	607.73	607.98	35536.0
2025-10-07 06:00:00	QQQ	ETF	607.97	607.97	607.56	607.89	22414.0
2025-10-07 06:30:00	QQQ	ETF	607.9	608.1	607.55	607.57	28206.0
2025-10-07 07:00:00	QQQ	ETF	607.59	607.81	607.5	607.77	22727.0
2025-10-07 07:30:00	QQQ	ETF	607.83	608.45	607.74	608.44	34346.0
2025-10-07 08:00:00	QQQ	ETF	608.45	608.56	606.79	608.5	157574.0
2025-10-07 08:30:00	QQQ	ETF	608.5	609.53	608.43	609.45	198914.0
2025-10-07 09:00:00	QQQ	ETF	609.46	609.94	608.95	609.05	281212.0
2025-10-07 09:30:00	QQQ	ETF	609.03	609.71	608.58	609.16	4375144.0
2025-10-07 10:00:00	QQQ	ETF	609.17	609.54	608.34	608.475	2614543.0
2025-10-07 10:30:00	QQQ	ETF	608.485	608.9	607.53	607.84	2569638.0
2025-10-07 11:00:00	QQQ	ETF	607.85	607.96	604.67	605.21	6141992.0
2025-10-07 11:30:00	QQQ	ETF	605.18	605.29	603.03	604.14	5144940.0
2025-10-07 12:00:00	QQQ	ETF	604.13	604.88	603.36	604.31	3323023.0

> showing 50 of 44,367 rows — these rows as CSV

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