PREVIEW / etf_30min / 2000-06-23

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-06-23.parquet
  size:    10 KB
  rows:    230

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-06-23 09:30:00	SPY	ETF	145.8125	146.125	145.3438	145.375	492800.0
2000-06-23 10:00:00	SPY	ETF	145.3125	145.7188	144.8438	145.5625	485600.0
2000-06-23 10:30:00	SPY	ETF	145.4062	145.6562	145.25	145.6562	95000.0
2000-06-23 11:00:00	SPY	ETF	145.75	146.0	145.625	145.875	458200.0
2000-06-23 11:30:00	SPY	ETF	145.9062	145.9062	145.4375	145.5938	610300.0
2000-06-23 12:00:00	SPY	ETF	145.4375	145.75	145.2812	145.2812	34900.0
2000-06-23 12:30:00	SPY	ETF	145.25	145.5	144.875	145.25	103900.0
2000-06-23 13:00:00	SPY	ETF	145.25	145.5938	145.125	145.3125	102800.0
2000-06-23 13:30:00	SPY	ETF	145.3125	145.375	144.75	144.9688	148300.0
2000-06-23 14:00:00	SPY	ETF	144.9375	145.4062	144.75	145.125	196700.0
2000-06-23 14:30:00	SPY	ETF	145.0625	145.125	144.0312	144.1875	252900.0
2000-06-23 15:00:00	SPY	ETF	144.125	144.5625	144.0312	144.0312	435600.0
2000-06-23 15:30:00	SPY	ETF	144.0312	144.6875	143.875	144.375	571100.0
2000-06-23 16:00:00	SPY	ETF	144.3125	144.4688	144.1875	144.3125	709100.0
2000-06-23 09:30:00	QQQ	ETF	95.0	95.5	93.7188	93.8125	4419400.0
2000-06-23 10:00:00	QQQ	ETF	93.7188	94.4375	93.0	94.3125	3595000.0
2000-06-23 10:30:00	QQQ	ETF	94.3125	94.3125	93.4375	94.0	1454100.0
2000-06-23 11:00:00	QQQ	ETF	93.9062	94.75	93.7812	94.75	1864300.0
2000-06-23 11:30:00	QQQ	ETF	94.75	94.8125	94.0625	94.1875	846400.0
2000-06-23 12:00:00	QQQ	ETF	94.1875	94.3438	93.5	93.625	511800.0
2000-06-23 12:30:00	QQQ	ETF	93.625	94.0	93.25	93.8125	744100.0
2000-06-23 13:00:00	QQQ	ETF	93.625	94.125	93.4375	93.5625	578800.0
2000-06-23 13:30:00	QQQ	ETF	93.625	93.7188	93.0938	93.3125	689900.0
2000-06-23 14:00:00	QQQ	ETF	93.3125	93.9375	93.1875	93.5	1580700.0
2000-06-23 14:30:00	QQQ	ETF	93.5	93.5625	92.3125	92.5	2422900.0
2000-06-23 15:00:00	QQQ	ETF	92.5	92.875	92.0	92.0	1569200.0
2000-06-23 15:30:00	QQQ	ETF	92.0	92.875	91.4375	91.8125	3360200.0
2000-06-23 16:00:00	QQQ	ETF	91.875	92.0	91.5	91.5	1110600.0
2000-06-23 16:30:00	QQQ	ETF	91.5	91.6875	91.375	91.6875	1000.0
2000-06-23 17:00:00	QQQ	ETF	91.6875	91.6875	91.625	91.6875	1100.0
2000-06-23 17:30:00	QQQ	ETF	92.0	92.0	92.0	92.0	200.0
2000-06-23 18:00:00	QQQ	ETF	91.6875	91.6875	91.5	91.5	200.0
2000-06-23 09:30:00	IWM	ETF	51.75	51.75	51.5	51.5	53400.0
2000-06-23 10:00:00	IWM	ETF	51.0	51.0938	50.8438	51.0938	43400.0
2000-06-23 10:30:00	IWM	ETF	51.1094	51.1094	51.1094	51.1094	2000.0
2000-06-23 11:00:00	IWM	ETF	51.375	51.375	51.3125	51.3125	2400.0
2000-06-23 11:30:00	IWM	ETF	51.5	51.5	51.4844	51.4844	2600.0
2000-06-23 12:30:00	IWM	ETF	51.3438	51.3438	51.3438	51.3438	400.0
2000-06-23 13:00:00	IWM	ETF	51.3125	51.3125	51.2188	51.2188	22000.0
2000-06-23 13:30:00	IWM	ETF	51.4062	51.4219	51.1875	51.1875	1800.0
2000-06-23 14:00:00	IWM	ETF	51.125	51.125	51.125	51.125	22200.0
2000-06-23 14:30:00	IWM	ETF	51.125	51.125	50.875	50.875	44000.0
2000-06-23 15:00:00	IWM	ETF	50.875	50.9062	50.7656	50.7656	8000.0
2000-06-23 15:30:00	IWM	ETF	50.5	50.6562	50.5	50.6562	2800.0
2000-06-23 16:00:00	IWM	ETF	50.7812	50.9062	50.7812	50.9062	30800.0
2000-06-23 09:30:00	DIA	ETF	104.2188	104.5	104.0312	104.0312	110100.0
2000-06-23 10:00:00	DIA	ETF	104.0312	104.375	103.7812	104.375	31500.0
2000-06-23 10:30:00	DIA	ETF	104.375	104.625	104.1562	104.625	31700.0
2000-06-23 11:00:00	DIA	ETF	104.5625	104.9688	104.5625	104.7812	101000.0
2000-06-23 11:30:00	DIA	ETF	104.5625	104.7188	104.4375	104.5938	69800.0

> showing 50 of 230 rows — these rows as CSV

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