PREVIEW / etf_30min / 2000-01-28

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-01-28.parquet
  size:    10 KB
  rows:    221

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-28 09:30:00	SPY	ETF	139.4375	139.875	138.4375	139.625	1235300.0
2000-01-28 10:00:00	SPY	ETF	139.5312	140.0625	139.1875	139.5625	639000.0
2000-01-28 10:30:00	SPY	ETF	139.625	139.6875	138.5	138.8438	542700.0
2000-01-28 11:00:00	SPY	ETF	138.6562	138.9062	138.0	138.5625	421900.0
2000-01-28 11:30:00	SPY	ETF	138.7188	139.0938	138.0	138.0	742000.0
2000-01-28 12:00:00	SPY	ETF	138.0625	138.1875	137.0312	137.5	946500.0
2000-01-28 12:30:00	SPY	ETF	137.5625	138.0	137.0	137.2188	601300.0
2000-01-28 13:00:00	SPY	ETF	137.125	137.9688	136.625	137.5	1526900.0
2000-01-28 13:30:00	SPY	ETF	137.4375	138.25	137.125	138.1875	278100.0
2000-01-28 14:00:00	SPY	ETF	138.1875	138.3438	137.2812	137.5625	650400.0
2000-01-28 14:30:00	SPY	ETF	137.5625	138.375	137.125	137.4062	340800.0
2000-01-28 15:00:00	SPY	ETF	137.5625	137.625	136.6875	136.6875	481600.0
2000-01-28 15:30:00	SPY	ETF	136.7812	137.0	135.5312	136.4688	2478200.0
2000-01-28 16:00:00	SPY	ETF	136.375	136.375	135.75	135.875	933100.0
2000-01-28 09:30:00	QQQ	ETF	90.0	90.4688	88.125	90.0156	4663200.0
2000-01-28 10:00:00	QQQ	ETF	90.0156	90.4375	89.5	89.9219	3058600.0
2000-01-28 10:30:00	QQQ	ETF	89.875	89.9375	88.7812	89.0312	1633800.0
2000-01-28 11:00:00	QQQ	ETF	89.0	89.0469	88.0156	88.875	2209400.0
2000-01-28 11:30:00	QQQ	ETF	88.8281	89.0625	88.0625	88.0625	1062200.0
2000-01-28 12:00:00	QQQ	ETF	88.0312	88.1875	86.625	87.375	3377200.0
2000-01-28 12:30:00	QQQ	ETF	87.4844	87.875	86.625	86.6562	1930800.0
2000-01-28 13:00:00	QQQ	ETF	86.625	87.4375	86.1875	87.1875	3779200.0
2000-01-28 13:30:00	QQQ	ETF	87.125	87.75	86.5625	87.625	2334800.0
2000-01-28 14:00:00	QQQ	ETF	87.625	87.75	86.75	86.875	1530600.0
2000-01-28 14:30:00	QQQ	ETF	87.0	87.4375	86.125	86.375	2112800.0
2000-01-28 15:00:00	QQQ	ETF	86.3906	86.75	85.8125	85.9062	1817800.0
2000-01-28 15:30:00	QQQ	ETF	86.0	86.1562	84.75	86.125	4647200.0
2000-01-28 16:00:00	QQQ	ETF	86.25	86.3438	85.8125	85.9375	752600.0
2000-01-28 16:30:00	QQQ	ETF	86.0	86.25	85.75	86.0	5400.0
2000-01-28 17:00:00	QQQ	ETF	86.0	86.125	85.75	85.75	1600.0
2000-01-28 17:30:00	QQQ	ETF	86.0	86.0	86.0	86.0	200.0
2000-01-28 09:30:00	DIA	ETF	109.8438	110.0625	109.0312	109.7812	137500.0
2000-01-28 10:00:00	DIA	ETF	109.7188	109.9688	109.375	109.75	61200.0
2000-01-28 10:30:00	DIA	ETF	109.75	109.875	109.25	109.3125	33400.0
2000-01-28 11:00:00	DIA	ETF	109.4062	109.5938	108.5938	109.25	58400.0
2000-01-28 11:30:00	DIA	ETF	109.2812	109.6562	109.0	109.0	21700.0
2000-01-28 12:00:00	DIA	ETF	109.0	109.0	108.125	108.5938	178900.0
2000-01-28 12:30:00	DIA	ETF	108.5	108.9062	108.4375	108.4375	19700.0
2000-01-28 13:00:00	DIA	ETF	108.375	108.8438	107.7188	108.3438	113700.0
2000-01-28 13:30:00	DIA	ETF	108.5625	109.125	108.25	109.0312	23700.0
2000-01-28 14:00:00	DIA	ETF	109.0625	109.1875	108.2812	108.375	153800.0
2000-01-28 14:30:00	DIA	ETF	108.375	109.0312	108.3125	108.625	108800.0
2000-01-28 15:00:00	DIA	ETF	108.7188	108.7188	108.0312	108.0312	67700.0
2000-01-28 15:30:00	DIA	ETF	108.1875	108.375	107.25	107.8125	207000.0
2000-01-28 16:00:00	DIA	ETF	107.7812	107.7812	107.125	107.4062	66100.0

> showing 45 of 221 rows — these rows as CSV

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