PREVIEW / etf_30min / 2000-04-26

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-04-26.parquet
  size:    9 KB
  rows:    197

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-04-26 09:30:00	SPY	ETF	147.9688	148.1875	147.5	148.0	813200.0
2000-04-26 10:00:00	SPY	ETF	148.1875	148.625	147.6562	148.0	686300.0
2000-04-26 10:30:00	SPY	ETF	147.9375	148.75	147.7812	148.4062	406700.0
2000-04-26 11:00:00	SPY	ETF	148.3438	148.5938	147.625	147.625	441800.0
2000-04-26 11:30:00	SPY	ETF	147.6562	147.9688	147.2812	147.375	380500.0
2000-04-26 12:00:00	SPY	ETF	147.5	147.6562	147.0	147.375	655000.0
2000-04-26 12:30:00	SPY	ETF	147.375	147.5938	147.0625	147.0938	193700.0
2000-04-26 13:00:00	SPY	ETF	147.125	147.3125	146.75	147.0	444800.0
2000-04-26 13:30:00	SPY	ETF	147.0938	147.75	146.9062	147.25	453800.0
2000-04-26 14:00:00	SPY	ETF	147.3438	147.5	147.0	147.0312	234900.0
2000-04-26 14:30:00	SPY	ETF	146.9375	147.2812	146.6875	147.0312	460800.0
2000-04-26 15:00:00	SPY	ETF	146.9688	147.375	146.5625	146.6875	325900.0
2000-04-26 15:30:00	SPY	ETF	146.625	146.7812	146.0	146.375	1829000.0
2000-04-26 16:00:00	SPY	ETF	146.5	146.5625	146.25	146.4688	315500.0
2000-04-26 16:30:00	SPY	ETF	146.4688	146.4688	146.4688	146.4688	500.0
2000-04-26 09:30:00	QQQ	ETF	90.625	91.0	88.75	90.0	3585800.0
2000-04-26 10:00:00	QQQ	ETF	90.125	91.5	90.0	90.9375	2388200.0
2000-04-26 10:30:00	QQQ	ETF	91.0	92.4062	90.625	91.75	1665200.0
2000-04-26 11:00:00	QQQ	ETF	91.625	91.75	90.0312	90.0625	1740300.0
2000-04-26 11:30:00	QQQ	ETF	90.0625	90.625	89.5	89.5	1643900.0
2000-04-26 12:00:00	QQQ	ETF	89.5	89.9688	88.75	89.4375	2683300.0
2000-04-26 12:30:00	QQQ	ETF	89.4375	89.9688	89.0	89.375	728400.0
2000-04-26 13:00:00	QQQ	ETF	89.375	89.625	88.75	89.3125	1059900.0
2000-04-26 13:30:00	QQQ	ETF	89.3125	90.5938	89.125	90.0	2167900.0
2000-04-26 14:00:00	QQQ	ETF	90.0	90.1875	89.125	89.125	644200.0
2000-04-26 14:30:00	QQQ	ETF	89.0312	89.625	88.6875	89.125	1636700.0
2000-04-26 15:00:00	QQQ	ETF	89.125	89.625	88.375	88.375	1352200.0
2000-04-26 15:30:00	QQQ	ETF	88.5	89.0	87.25	87.25	3904700.0
2000-04-26 16:00:00	QQQ	ETF	87.25	87.875	87.125	87.125	403100.0
2000-04-26 16:30:00	QQQ	ETF	87.5	87.625	87.125	87.375	6600.0
2000-04-26 17:00:00	QQQ	ETF	87.375	87.5	87.25	87.5	5900.0
2000-04-26 17:30:00	QQQ	ETF	87.5	87.5	87.25	87.375	2700.0
2000-04-26 18:00:00	QQQ	ETF	87.375	87.375	87.375	87.375	500.0
2000-04-26 09:30:00	DIA	ETF	111.5625	111.5625	111.0	111.5625	188800.0
2000-04-26 10:00:00	DIA	ETF	111.5625	111.5625	110.75	110.8438	87700.0
2000-04-26 10:30:00	DIA	ETF	110.625	111.0	110.625	110.8125	77400.0
2000-04-26 11:00:00	DIA	ETF	110.9688	110.9688	110.125	110.2812	155500.0
2000-04-26 11:30:00	DIA	ETF	110.2812	110.5312	110.0625	110.1562	108800.0
2000-04-26 12:00:00	DIA	ETF	110.0625	110.3438	109.75	110.0625	71400.0
2000-04-26 12:30:00	DIA	ETF	110.0625	110.2188	109.875	109.875	46000.0
2000-04-26 13:00:00	DIA	ETF	110.0	110.0	109.5312	109.7812	87500.0
2000-04-26 13:30:00	DIA	ETF	109.8125	110.3125	109.8125	110.0625	60500.0
2000-04-26 14:00:00	DIA	ETF	110.0938	110.0938	109.625	109.625	20900.0
2000-04-26 14:30:00	DIA	ETF	109.75	109.9062	109.375	109.8438	174400.0
2000-04-26 15:00:00	DIA	ETF	109.8125	110.0312	109.5	109.5	140500.0
2000-04-26 15:30:00	DIA	ETF	109.5	109.625	108.9375	109.3125	821900.0
2000-04-26 16:00:00	DIA	ETF	109.2188	109.4688	109.125	109.4688	7200.0
2000-04-26 18:00:00	DIA	ETF	109.0	109.0	109.0	109.0	100.0

> showing 48 of 197 rows — these rows as CSV

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