PREVIEW / etf_30min / 2025-01-24

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-01-24.parquet
  size:    956 KB
  rows:    38,170

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-01-24 04:00:00	SPY	ETF	609.16	609.59	609.09	609.42	5832.0
2025-01-24 04:30:00	SPY	ETF	609.48	609.48	609.22	609.3	2295.0
2025-01-24 05:00:00	SPY	ETF	609.22	609.22	608.87	608.88	5282.0
2025-01-24 05:30:00	SPY	ETF	608.89	609.0	608.58	608.96	7328.0
2025-01-24 06:00:00	SPY	ETF	608.98	609.03	608.9	609.03	2720.0
2025-01-24 06:30:00	SPY	ETF	608.83	609.09	608.82	609.01	3027.0
2025-01-24 07:00:00	SPY	ETF	609.03	609.56	609.03	609.5	45306.0
2025-01-24 07:30:00	SPY	ETF	609.52	609.52	609.04	609.21	14537.0
2025-01-24 08:00:00	SPY	ETF	609.04	609.5	608.8	608.99	71562.0
2025-01-24 08:30:00	SPY	ETF	609.05	609.06	608.69	609.0	78397.0
2025-01-24 09:00:00	SPY	ETF	608.95	609.86	608.95	609.79	158205.0
2025-01-24 09:30:00	SPY	ETF	609.81	610.78	609.65	610.33	2493548.0
2025-01-24 10:00:00	SPY	ETF	610.35	610.54	609.25	609.35	1447915.0
2025-01-24 10:30:00	SPY	ETF	609.35	609.65	609.06	609.1801	754534.0
2025-01-24 11:00:00	SPY	ETF	609.18	609.8898	609.08	609.8898	888388.0
2025-01-24 11:30:00	SPY	ETF	609.88	610.325	609.39	609.53	809839.0
2025-01-24 12:00:00	SPY	ETF	609.53	610.05	609.3	609.43	1002662.0
2025-01-24 12:30:00	SPY	ETF	609.425	609.62	608.52	608.7	1125112.0
2025-01-24 13:00:00	SPY	ETF	608.6797	608.91	608.08	608.43	969297.0
2025-01-24 13:30:00	SPY	ETF	608.45	608.74	607.2	607.421	1012755.0
2025-01-24 14:00:00	SPY	ETF	607.42	607.855	606.93	607.43	1667575.0
2025-01-24 14:30:00	SPY	ETF	607.4	607.92	607.32	607.38	1075581.0
2025-01-24 15:00:00	SPY	ETF	607.375	607.84	606.94	607.07	1785471.0
2025-01-24 15:30:00	SPY	ETF	607.08	608.15	606.8	607.95	4113692.0
2025-01-24 16:00:00	SPY	ETF	607.92	608.58	607.18	607.6	3162595.0
2025-01-24 16:30:00	SPY	ETF	607.59	607.98	607.49	607.83	143548.0
2025-01-24 17:00:00	SPY	ETF	607.82	607.86	607.7	607.71	14759.0
2025-01-24 17:30:00	SPY	ETF	607.73	607.78	607.55	607.57	4165.0
2025-01-24 18:00:00	SPY	ETF	607.56	607.653	607.56	607.653	420.0
2025-01-24 18:30:00	SPY	ETF	607.678	607.7958	607.5511	607.5511	1930.0
2025-01-24 19:00:00	SPY	ETF	607.55	607.64	607.54	607.54	1716.0
2025-01-24 19:30:00	SPY	ETF	607.54	607.55	607.4	607.49	19905.0
2025-01-24 04:00:00	QQQ	ETF	531.53	532.4	531.51	532.25	14786.0
2025-01-24 04:30:00	QQQ	ETF	532.36	532.45	532.04	532.04	6672.0
2025-01-24 05:00:00	QQQ	ETF	532.06	532.09	531.84	531.84	8870.0
2025-01-24 05:30:00	QQQ	ETF	531.85	532.11	531.64	532.06	25301.0
2025-01-24 06:00:00	QQQ	ETF	532.12	532.19	531.85	531.85	5614.0
2025-01-24 06:30:00	QQQ	ETF	532.07	532.19	531.75	532.19	14151.0
2025-01-24 07:00:00	QQQ	ETF	532.13	532.869	532.13	532.85	35210.0
2025-01-24 07:30:00	QQQ	ETF	532.88	532.95	532.39	532.64	28159.0
2025-01-24 08:00:00	QQQ	ETF	532.46	533.039	531.37	532.37	107842.0
2025-01-24 08:30:00	QQQ	ETF	532.42	532.42	531.86	532.2	55628.0
2025-01-24 09:00:00	QQQ	ETF	532.2	533.2	532.14	533.02	286871.0
2025-01-24 09:30:00	QQQ	ETF	533.02	533.79	531.9	533.34	1995540.0
2025-01-24 10:00:00	QQQ	ETF	533.35	533.6	531.63	531.74	1055755.0
2025-01-24 10:30:00	QQQ	ETF	531.77	532.37	531.4	531.59	904731.0
2025-01-24 11:00:00	QQQ	ETF	531.58	532.275	531.2072	532.21	700658.0
2025-01-24 11:30:00	QQQ	ETF	532.24	532.75	531.33	531.49	753631.0
2025-01-24 12:00:00	QQQ	ETF	531.45	532.095	531.16	531.38	677919.0
2025-01-24 12:30:00	QQQ	ETF	531.35	531.61	530.25	530.485	879856.0

> showing 50 of 38,170 rows — these rows as CSV

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