PREVIEW / etf_30min / 2000-01-27

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-01-27.parquet
  size:    10 KB
  rows:    220

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-27 09:30:00	SPY	ETF	141.8438	141.8438	141.25	141.2812	2904200.0
2000-01-27 10:00:00	SPY	ETF	141.4688	142.125	141.4688	141.7812	889700.0
2000-01-27 10:30:00	SPY	ETF	141.8125	142.2188	141.6875	141.8125	605900.0
2000-01-27 11:00:00	SPY	ETF	141.9688	142.1562	141.3125	141.4375	404300.0
2000-01-27 11:30:00	SPY	ETF	141.4375	141.5	140.875	141.0	462400.0
2000-01-27 12:00:00	SPY	ETF	141.125	141.1875	140.6875	140.6875	345100.0
2000-01-27 12:30:00	SPY	ETF	140.6875	140.7812	139.6875	139.8125	1042300.0
2000-01-27 13:00:00	SPY	ETF	139.7188	140.5625	139.7188	140.5625	539400.0
2000-01-27 13:30:00	SPY	ETF	140.5938	140.75	140.2188	140.375	291400.0
2000-01-27 14:00:00	SPY	ETF	140.2812	140.625	140.0	140.25	176800.0
2000-01-27 14:30:00	SPY	ETF	140.125	140.125	138.375	138.625	725600.0
2000-01-27 15:00:00	SPY	ETF	138.625	139.0625	138.125	138.9375	1176900.0
2000-01-27 15:30:00	SPY	ETF	138.875	140.2188	138.75	140.0	940800.0
2000-01-27 16:00:00	SPY	ETF	140.1562	140.6875	140.1562	140.3125	297700.0
2000-01-27 16:30:00	SPY	ETF	140.25	140.25	140.25	140.25	44500.0
2000-01-27 09:30:00	QQQ	ETF	91.75	92.0625	91.1719	91.625	3127200.0
2000-01-27 10:00:00	QQQ	ETF	91.6094	92.25	91.6094	91.8125	2670800.0
2000-01-27 10:30:00	QQQ	ETF	91.8438	92.2188	91.7969	92.0938	1185000.0
2000-01-27 11:00:00	QQQ	ETF	92.1094	92.5	91.0	91.0	1770200.0
2000-01-27 11:30:00	QQQ	ETF	91.0	91.5	90.375	91.0	2485400.0
2000-01-27 12:00:00	QQQ	ETF	90.9062	91.2188	90.5625	90.5938	716600.0
2000-01-27 12:30:00	QQQ	ETF	90.8125	90.875	89.3125	89.5	2860200.0
2000-01-27 13:00:00	QQQ	ETF	89.5	90.5	89.3125	90.5	2830400.0
2000-01-27 13:30:00	QQQ	ETF	90.5156	90.7812	90.0625	90.1094	1176600.0
2000-01-27 14:00:00	QQQ	ETF	90.0625	90.4375	89.9062	90.0	1193400.0
2000-01-27 14:30:00	QQQ	ETF	89.875	89.9375	88.125	88.6562	2716400.0
2000-01-27 15:00:00	QQQ	ETF	88.6719	88.875	87.625	88.6875	3103800.0
2000-01-27 15:30:00	QQQ	ETF	88.6719	89.9688	88.625	89.9688	3837600.0
2000-01-27 16:00:00	QQQ	ETF	89.9375	90.25	89.8125	90.25	669600.0
2000-01-27 16:30:00	QQQ	ETF	90.5	90.5	90.5	90.5	200.0
2000-01-27 17:00:00	QQQ	ETF	90.5	90.5	90.5	90.5	800.0
2000-01-27 17:30:00	QQQ	ETF	90.375	90.5	90.375	90.375	2800.0
2000-01-27 18:00:00	QQQ	ETF	90.5625	90.5625	90.5625	90.5625	200.0
2000-01-27 09:30:00	DIA	ETF	111.125	111.25	110.8125	110.9375	100900.0
2000-01-27 10:00:00	DIA	ETF	111.0	111.5	110.875	111.25	57300.0
2000-01-27 10:30:00	DIA	ETF	111.3125	111.5938	111.3125	111.4688	39700.0
2000-01-27 11:00:00	DIA	ETF	111.5	111.5938	111.125	111.125	25700.0
2000-01-27 11:30:00	DIA	ETF	111.125	111.25	110.75	110.9062	32100.0
2000-01-27 12:00:00	DIA	ETF	110.8438	111.0625	110.75	110.8125	42000.0
2000-01-27 12:30:00	DIA	ETF	110.75	110.9062	109.875	109.9375	95500.0
2000-01-27 13:00:00	DIA	ETF	109.875	110.5625	109.75	110.5625	70500.0
2000-01-27 13:30:00	DIA	ETF	110.5	110.7188	110.375	110.5	17200.0
2000-01-27 14:00:00	DIA	ETF	110.5	110.7812	110.2812	110.5	38700.0
2000-01-27 14:30:00	DIA	ETF	110.5	110.5	109.3125	109.5	67600.0
2000-01-27 15:00:00	DIA	ETF	109.4375	109.875	109.1875	109.7188	106400.0
2000-01-27 15:30:00	DIA	ETF	109.625	110.4375	109.625	110.3438	120500.0
2000-01-27 16:00:00	DIA	ETF	110.375	110.7188	110.375	110.4688	18100.0

> showing 47 of 220 rows — these rows as CSV

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