PREVIEW / etf_30min / 2000-11-06

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-11-06.parquet
  size:    12 KB
  rows:    301

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-11-06 09:30:00	SPY	ETF	143.1562	143.4688	143.125	143.125	650800.0
2000-11-06 10:00:00	SPY	ETF	143.2188	143.75	143.1875	143.4062	378600.0
2000-11-06 10:30:00	SPY	ETF	143.5	144.2188	143.4062	144.0625	416700.0
2000-11-06 11:00:00	SPY	ETF	144.0	144.0938	143.4688	143.75	303600.0
2000-11-06 11:30:00	SPY	ETF	143.6875	144.125	143.5312	144.0	191300.0
2000-11-06 12:00:00	SPY	ETF	144.0	144.0938	143.875	143.875	114400.0
2000-11-06 12:30:00	SPY	ETF	143.875	144.1875	143.6875	144.0312	80100.0
2000-11-06 13:00:00	SPY	ETF	144.0312	144.25	144.0	144.0312	109100.0
2000-11-06 13:30:00	SPY	ETF	144.0938	144.125	143.6562	143.875	108000.0
2000-11-06 14:00:00	SPY	ETF	143.8438	144.0	143.625	143.7812	214500.0
2000-11-06 14:30:00	SPY	ETF	143.8438	143.9688	143.75	143.8438	139300.0
2000-11-06 15:00:00	SPY	ETF	144.0	144.0312	143.5312	143.6875	286300.0
2000-11-06 15:30:00	SPY	ETF	143.6875	143.6875	143.0312	143.6875	292900.0
2000-11-06 16:00:00	SPY	ETF	143.625	143.9688	143.5	143.7812	166900.0
2000-11-06 16:30:00	SPY	ETF	143.7812	143.7812	143.7812	143.7812	1000.0
2000-11-06 17:30:00	SPY	ETF	143.3125	143.3125	143.3125	143.3125	50000.0
2000-11-06 09:30:00	QQQ	ETF	83.625	83.875	83.125	83.4062	3363800.0
2000-11-06 10:00:00	QQQ	ETF	83.5	84.125	83.4062	83.7188	2232000.0
2000-11-06 10:30:00	QQQ	ETF	83.7188	84.125	83.5	83.6562	793500.0
2000-11-06 11:00:00	QQQ	ETF	83.6875	83.6875	82.6875	83.0	2562300.0
2000-11-06 11:30:00	QQQ	ETF	82.9375	83.375	82.6875	83.0	1503400.0
2000-11-06 12:00:00	QQQ	ETF	83.0	83.1875	82.75	82.8125	1063100.0
2000-11-06 12:30:00	QQQ	ETF	82.75	83.0938	82.5625	83.0312	1133100.0
2000-11-06 13:00:00	QQQ	ETF	83.0938	83.25	82.875	83.0625	661600.0
2000-11-06 13:30:00	QQQ	ETF	83.0625	83.125	82.625	82.9062	860200.0
2000-11-06 14:00:00	QQQ	ETF	82.8125	83.0	82.4375	82.875	1399500.0
2000-11-06 14:30:00	QQQ	ETF	82.75	83.2188	82.5625	83.0	777200.0
2000-11-06 15:00:00	QQQ	ETF	83.0	83.1875	82.5	82.625	822000.0
2000-11-06 15:30:00	QQQ	ETF	82.625	82.7188	82.0	82.1875	2691400.0
2000-11-06 16:00:00	QQQ	ETF	82.2188	83.25	81.75	83.0938	1149500.0
2000-11-06 16:30:00	QQQ	ETF	83.0312	83.25	81.75	82.25	292300.0
2000-11-06 17:00:00	QQQ	ETF	82.25	82.4375	81.375	81.5	133700.0
2000-11-06 17:30:00	QQQ	ETF	81.2188	81.875	81.0	81.875	54800.0
2000-11-06 18:00:00	QQQ	ETF	81.8125	82.5938	81.8125	82.25	51800.0
2000-11-06 09:30:00	IWM	ETF	51.0938	51.0938	50.7188	50.9062	5200.0
2000-11-06 10:00:00	IWM	ETF	50.75	50.9375	50.75	50.9375	13800.0
2000-11-06 10:30:00	IWM	ETF	50.875	50.9688	50.75	50.75	2800.0
2000-11-06 11:00:00	IWM	ETF	50.8906	50.8906	50.625	50.625	1600.0
2000-11-06 11:30:00	IWM	ETF	50.7188	50.8281	50.7188	50.8281	2800.0
2000-11-06 12:00:00	IWM	ETF	50.6875	50.7812	50.6875	50.7812	2000.0
2000-11-06 12:30:00	IWM	ETF	50.7812	50.7812	50.7188	50.7812	1800.0
2000-11-06 13:00:00	IWM	ETF	50.6562	50.7344	50.6562	50.7344	600.0
2000-11-06 13:30:00	IWM	ETF	50.7812	50.7812	50.5312	50.625	18400.0
2000-11-06 14:30:00	IWM	ETF	50.5312	50.5312	50.5312	50.5312	800.0
2000-11-06 15:00:00	IWM	ETF	50.5	50.625	50.5	50.5	10600.0
2000-11-06 15:30:00	IWM	ETF	50.2188	50.4375	50.2188	50.4062	6400.0
2000-11-06 16:00:00	IWM	ETF	50.2656	50.2656	50.2656	50.2656	200.0
2000-11-06 09:30:00	DIA	ETF	108.4688	108.6562	108.2188	108.5	124200.0
2000-11-06 10:00:00	DIA	ETF	108.4688	109.0938	108.3438	108.875	209100.0
2000-11-06 10:30:00	DIA	ETF	108.875	109.7188	108.8125	109.5	96300.0

> showing 50 of 301 rows — these rows as CSV

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