PREVIEW / etf_30min / 2000-01-05

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-01-05.parquet
  size:    10 KB
  rows:    214

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
2000-01-05 09:30:00	SPY	ETF	139.9375	140.3438	138.375	138.375	1476400.0
2000-01-05 10:00:00	SPY	ETF	138.4375	139.625	137.25	139.625	1372800.0
2000-01-05 10:30:00	SPY	ETF	139.6875	139.875	138.8125	139.3125	563200.0
2000-01-05 11:00:00	SPY	ETF	139.2188	140.625	139.2188	139.9375	769500.0
2000-01-05 11:30:00	SPY	ETF	140.0	140.125	139.4375	139.6875	824000.0
2000-01-05 12:00:00	SPY	ETF	139.8125	139.875	139.25	139.4062	1227200.0
2000-01-05 12:30:00	SPY	ETF	139.3438	139.5625	139.0938	139.3125	372300.0
2000-01-05 13:00:00	SPY	ETF	139.3125	140.125	139.3125	139.875	377600.0
2000-01-05 13:30:00	SPY	ETF	139.8438	140.5312	139.7188	140.3125	465700.0
2000-01-05 14:00:00	SPY	ETF	140.4375	140.9375	140.0	140.9375	1008600.0
2000-01-05 14:30:00	SPY	ETF	140.75	141.1875	140.4375	140.5	1702500.0
2000-01-05 15:00:00	SPY	ETF	140.5	141.5312	140.375	141.1562	398900.0
2000-01-05 15:30:00	SPY	ETF	141.125	141.25	140.2188	140.2812	1189700.0
2000-01-05 16:00:00	SPY	ETF	140.375	140.4062	140.0	140.0	411600.0
2000-01-05 09:30:00	QQQ	ETF	87.5	87.625	85.0	85.25	5736200.0
2000-01-05 10:00:00	QQQ	ETF	85.4375	86.0	84.25	85.8125	6695400.0
2000-01-05 10:30:00	QQQ	ETF	85.8125	86.4375	84.7812	85.5	3622800.0
2000-01-05 11:00:00	QQQ	ETF	85.5156	87.375	85.4375	86.375	3769800.0
2000-01-05 11:30:00	QQQ	ETF	86.4375	86.8125	86.0	86.2969	1198400.0
2000-01-05 12:00:00	QQQ	ETF	86.2969	86.3438	85.75	85.75	1663000.0
2000-01-05 12:30:00	QQQ	ETF	85.7656	86.1094	85.4062	85.625	668800.0
2000-01-05 13:00:00	QQQ	ETF	85.5469	86.5625	85.5469	86.4062	1451600.0
2000-01-05 13:30:00	QQQ	ETF	86.4062	87.75	86.3438	87.75	2552200.0
2000-01-05 14:00:00	QQQ	ETF	87.75	88.5	87.125	88.4688	2899600.0
2000-01-05 14:30:00	QQQ	ETF	88.4531	89.125	87.7812	87.875	3320400.0
2000-01-05 15:00:00	QQQ	ETF	87.9375	89.625	87.8438	88.8125	4281400.0
2000-01-05 15:30:00	QQQ	ETF	88.8438	88.9375	87.25	87.4375	3095800.0
2000-01-05 16:00:00	QQQ	ETF	87.625	87.625	85.875	86.125	1185200.0
2000-01-05 16:30:00	QQQ	ETF	86.1875	86.1875	85.875	85.875	23000.0
2000-01-05 17:00:00	QQQ	ETF	85.875	86.1875	85.875	86.1875	9600.0
2000-01-05 18:00:00	QQQ	ETF	86.0	86.0	86.0	86.0	200.0
2000-01-05 09:30:00	DIA	ETF	110.0	110.6875	109.875	109.875	501300.0
2000-01-05 10:00:00	DIA	ETF	109.75	110.5938	109.0312	110.3125	248400.0
2000-01-05 10:30:00	DIA	ETF	110.5	110.625	110.0312	110.25	111700.0
2000-01-05 11:00:00	DIA	ETF	110.4688	111.2812	110.4688	110.8125	228500.0
2000-01-05 11:30:00	DIA	ETF	110.8125	110.9688	110.3438	110.6875	88300.0
2000-01-05 12:00:00	DIA	ETF	110.5	110.875	110.5	110.75	30400.0
2000-01-05 12:30:00	DIA	ETF	110.75	110.9062	110.5	110.75	27100.0
2000-01-05 13:00:00	DIA	ETF	110.875	111.3125	110.7812	111.125	36200.0
2000-01-05 13:30:00	DIA	ETF	111.125	111.625	110.9688	111.5625	100000.0
2000-01-05 14:00:00	DIA	ETF	111.625	111.8125	111.1562	111.8125	44500.0
2000-01-05 14:30:00	DIA	ETF	111.7188	112.0	111.4062	111.4062	124700.0
2000-01-05 15:00:00	DIA	ETF	111.6562	112.25	111.5	112.0	46700.0
2000-01-05 15:30:00	DIA	ETF	112.0	112.0	111.125	111.1875	395900.0
2000-01-05 16:00:00	DIA	ETF	111.25	111.3125	111.1562	111.1875	13900.0

> showing 45 of 214 rows — these rows as CSV

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