PREVIEW / etf_30min / 2000-08-18

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-08-18.parquet
  size:    11 KB
  rows:    265

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-08-18 09:30:00	SPY	ETF	150.375	150.375	149.75	149.875	1038100.0
2000-08-18 10:00:00	SPY	ETF	149.875	150.1562	149.8125	150.0938	359000.0
2000-08-18 10:30:00	SPY	ETF	150.0312	150.375	149.875	150.1562	394700.0
2000-08-18 11:00:00	SPY	ETF	150.1562	150.25	149.5	149.5938	216800.0
2000-08-18 11:30:00	SPY	ETF	149.7188	149.8125	149.5625	149.5938	91500.0
2000-08-18 12:00:00	SPY	ETF	149.5312	149.8125	149.4375	149.6875	240100.0
2000-08-18 12:30:00	SPY	ETF	149.6875	149.875	149.6562	149.75	94300.0
2000-08-18 13:00:00	SPY	ETF	149.75	149.9375	149.625	149.75	107800.0
2000-08-18 13:30:00	SPY	ETF	149.625	149.75	149.2188	149.375	336000.0
2000-08-18 14:00:00	SPY	ETF	149.4375	149.6875	149.3125	149.4375	254200.0
2000-08-18 14:30:00	SPY	ETF	149.5	149.6562	149.375	149.5	246000.0
2000-08-18 15:00:00	SPY	ETF	149.4375	149.9688	149.4062	149.75	337200.0
2000-08-18 15:30:00	SPY	ETF	149.8438	150.0312	149.375	149.6562	606500.0
2000-08-18 16:00:00	SPY	ETF	149.5625	149.75	149.5625	149.6875	276500.0
2000-08-18 16:30:00	SPY	ETF	149.6875	149.6875	149.6875	149.6875	500.0
2000-08-18 09:30:00	QQQ	ETF	95.9375	96.1875	94.9688	95.25	3287200.0
2000-08-18 10:00:00	QQQ	ETF	95.2188	96.0312	95.1875	95.875	2034000.0
2000-08-18 10:30:00	QQQ	ETF	95.8125	96.625	95.6875	96.0625	1433700.0
2000-08-18 11:00:00	QQQ	ETF	96.0625	96.3125	95.125	95.5	969200.0
2000-08-18 11:30:00	QQQ	ETF	95.5	95.75	95.375	95.375	410500.0
2000-08-18 12:00:00	QQQ	ETF	95.4062	95.9062	95.2812	95.5	302700.0
2000-08-18 12:30:00	QQQ	ETF	95.5	95.9375	95.5	95.5938	670100.0
2000-08-18 13:00:00	QQQ	ETF	95.5938	95.7188	95.375	95.5625	208500.0
2000-08-18 13:30:00	QQQ	ETF	95.5625	95.625	94.6875	95.0	762300.0
2000-08-18 14:00:00	QQQ	ETF	95.0625	95.1562	94.8125	95.0	484400.0
2000-08-18 14:30:00	QQQ	ETF	94.9375	95.1875	94.875	94.9688	448700.0
2000-08-18 15:00:00	QQQ	ETF	94.9375	95.5625	94.8125	95.3125	1607200.0
2000-08-18 15:30:00	QQQ	ETF	95.3125	95.7188	94.9375	94.9375	1443300.0
2000-08-18 16:00:00	QQQ	ETF	94.9688	95.3125	94.9375	95.25	598600.0
2000-08-18 16:30:00	QQQ	ETF	95.1875	95.1875	95.125	95.1875	2700.0
2000-08-18 17:00:00	QQQ	ETF	95.2188	95.25	95.2188	95.25	1700.0
2000-08-18 17:30:00	QQQ	ETF	95.25	95.25	95.25	95.25	300.0
2000-08-18 09:30:00	IWM	ETF	51.8125	51.9375	51.8125	51.9375	1400.0
2000-08-18 10:00:00	IWM	ETF	51.75	51.7969	51.75	51.7969	6400.0
2000-08-18 10:30:00	IWM	ETF	51.7812	51.7812	51.7812	51.7812	2000.0
2000-08-18 11:30:00	IWM	ETF	51.6094	51.6094	51.6094	51.6094	7600.0
2000-08-18 13:00:00	IWM	ETF	51.6094	51.7812	51.6094	51.7812	2000.0
2000-08-18 13:30:00	IWM	ETF	51.6094	51.6094	51.4375	51.4375	25000.0
2000-08-18 14:00:00	IWM	ETF	51.5	51.6562	51.5	51.5	1200.0
2000-08-18 14:30:00	IWM	ETF	51.5625	51.5625	51.5625	51.5625	200.0
2000-08-18 15:00:00	IWM	ETF	51.5	51.5312	51.5	51.5312	1600.0
2000-08-18 15:30:00	IWM	ETF	51.5625	51.625	51.5469	51.5469	1000.0
2000-08-18 09:30:00	DIA	ETF	110.9375	110.9375	110.4375	110.4375	55800.0
2000-08-18 10:00:00	DIA	ETF	110.6562	110.75	110.5	110.7188	29400.0
2000-08-18 10:30:00	DIA	ETF	110.5625	110.875	110.4688	110.5625	51000.0
2000-08-18 11:00:00	DIA	ETF	110.625	110.75	110.1875	110.3125	39600.0
2000-08-18 11:30:00	DIA	ETF	110.3125	110.5312	110.2188	110.2188	26100.0
2000-08-18 12:00:00	DIA	ETF	110.1875	110.5312	110.1562	110.5312	16300.0
2000-08-18 12:30:00	DIA	ETF	110.4375	110.5312	110.3125	110.3125	22500.0
2000-08-18 13:00:00	DIA	ETF	110.3438	110.4688	110.2188	110.4688	4400.0

> showing 50 of 265 rows — these rows as CSV

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