PREVIEW / etf_30min / 2000-01-31

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-01-31.parquet
  size:    10 KB
  rows:    213

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-31 09:30:00	SPY	ETF	135.8125	136.3125	135.5	136.0625	822900.0
2000-01-31 10:00:00	SPY	ETF	136.1875	136.8438	135.9062	136.1875	1200500.0
2000-01-31 10:30:00	SPY	ETF	136.0	136.1562	135.0938	135.5938	572400.0
2000-01-31 11:00:00	SPY	ETF	135.5	136.1875	135.4375	135.5938	300600.0
2000-01-31 11:30:00	SPY	ETF	135.75	135.75	135.25	135.3125	558400.0
2000-01-31 12:00:00	SPY	ETF	135.25	136.2188	135.0	136.0	979200.0
2000-01-31 12:30:00	SPY	ETF	136.0	136.4375	135.6875	136.3125	374600.0
2000-01-31 13:00:00	SPY	ETF	136.375	136.625	136.1875	136.3125	550900.0
2000-01-31 13:30:00	SPY	ETF	136.1875	136.625	136.1875	136.2188	159200.0
2000-01-31 14:00:00	SPY	ETF	136.1562	136.8438	135.8125	136.8438	759000.0
2000-01-31 14:30:00	SPY	ETF	136.75	137.75	136.625	137.75	1080300.0
2000-01-31 15:00:00	SPY	ETF	137.875	138.7812	137.5625	138.5	1380400.0
2000-01-31 15:30:00	SPY	ETF	138.5	139.4375	138.25	139.4375	1285100.0
2000-01-31 16:00:00	SPY	ETF	139.3125	139.6562	139.1562	139.625	594500.0
2000-01-31 16:30:00	SPY	ETF	139.5625	139.5625	139.5625	139.5625	100.0
2000-01-31 09:30:00	QQQ	ETF	85.875	86.1875	85.125	85.6875	3794800.0
2000-01-31 10:00:00	QQQ	ETF	85.625	87.2188	85.5312	86.5	4013400.0
2000-01-31 10:30:00	QQQ	ETF	86.5	86.5156	84.5625	85.25	2697800.0
2000-01-31 11:00:00	QQQ	ETF	84.875	85.875	84.75	85.0	2274600.0
2000-01-31 11:30:00	QQQ	ETF	84.9062	85.0	83.75	83.875	2128600.0
2000-01-31 12:00:00	QQQ	ETF	83.875	85.5	83.5	85.0625	3882800.0
2000-01-31 12:30:00	QQQ	ETF	85.0625	85.875	84.7812	85.875	1544600.0
2000-01-31 13:00:00	QQQ	ETF	85.75	86.3125	85.2812	85.3594	1430800.0
2000-01-31 13:30:00	QQQ	ETF	85.3125	85.8125	85.0312	85.0312	614000.0
2000-01-31 14:00:00	QQQ	ETF	85.0	85.875	84.4375	85.875	2011800.0
2000-01-31 14:30:00	QQQ	ETF	85.9375	87.1875	85.6406	87.0625	2495400.0
2000-01-31 15:00:00	QQQ	ETF	87.0625	88.3438	86.875	88.0	5215800.0
2000-01-31 15:30:00	QQQ	ETF	88.25	89.125	87.625	89.0	2767800.0
2000-01-31 16:00:00	QQQ	ETF	89.0	89.8125	88.875	89.8125	733400.0
2000-01-31 16:30:00	QQQ	ETF	89.5625	90.0	89.5625	89.75	3800.0
2000-01-31 17:00:00	QQQ	ETF	89.875	90.0	89.5	89.9375	41600.0
2000-01-31 18:00:00	QQQ	ETF	89.75	89.75	89.6875	89.6875	1000.0
2000-01-31 09:30:00	DIA	ETF	107.125	107.9062	107.0312	107.9062	159100.0
2000-01-31 10:00:00	DIA	ETF	107.9062	108.3438	107.6875	107.75	163100.0
2000-01-31 10:30:00	DIA	ETF	107.625	107.7188	107.0312	107.4375	85600.0
2000-01-31 11:00:00	DIA	ETF	107.5625	107.875	107.25	107.6562	59800.0
2000-01-31 11:30:00	DIA	ETF	107.5	107.75	107.2812	107.5312	61200.0
2000-01-31 12:00:00	DIA	ETF	107.5	108.125	107.3438	107.9375	43200.0
2000-01-31 12:30:00	DIA	ETF	107.9375	108.25	107.7188	107.8438	22300.0
2000-01-31 13:00:00	DIA	ETF	108.0938	108.25	107.8438	108.1562	28100.0
2000-01-31 13:30:00	DIA	ETF	108.0	108.25	108.0	108.0312	40600.0
2000-01-31 14:00:00	DIA	ETF	108.0312	108.5625	107.8438	108.5625	44600.0
2000-01-31 14:30:00	DIA	ETF	108.5938	108.7812	108.125	108.7812	87000.0
2000-01-31 15:00:00	DIA	ETF	108.875	109.4375	108.5938	109.0938	62800.0
2000-01-31 15:30:00	DIA	ETF	108.9062	109.5625	108.8125	109.1875	73400.0
2000-01-31 16:00:00	DIA	ETF	109.25	109.625	109.1875	109.5	60200.0

> showing 46 of 213 rows — these rows as CSV

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