PREVIEW / etf_30min / 2000-06-16

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-06-16.parquet
  size:    11 KB
  rows:    259

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-16 09:30:00	SPY	ETF	148.3125	148.3125	147.5312	147.625	344500.0
2000-06-16 10:00:00	SPY	ETF	147.75	147.75	146.9062	147.2812	389400.0
2000-06-16 10:30:00	SPY	ETF	147.125	147.5	147.125	147.4688	147700.0
2000-06-16 11:00:00	SPY	ETF	147.4375	147.5	146.75	146.8125	137400.0
2000-06-16 11:30:00	SPY	ETF	146.9375	147.25	146.875	146.9688	132000.0
2000-06-16 12:00:00	SPY	ETF	147.1875	147.4062	147.125	147.2812	1877500.0
2000-06-16 12:30:00	SPY	ETF	147.1562	147.375	146.75	146.8125	274600.0
2000-06-16 13:00:00	SPY	ETF	146.8438	147.375	146.8125	147.2188	84700.0
2000-06-16 13:30:00	SPY	ETF	147.3125	147.6875	147.2188	147.5	78200.0
2000-06-16 14:00:00	SPY	ETF	147.375	147.625	147.3125	147.5938	107600.0
2000-06-16 14:30:00	SPY	ETF	147.375	147.5	147.0312	147.125	304600.0
2000-06-16 15:00:00	SPY	ETF	147.0312	147.1875	146.25	146.25	388600.0
2000-06-16 15:30:00	SPY	ETF	146.3125	147.0	145.875	146.875	685400.0
2000-06-16 16:00:00	SPY	ETF	146.875	147.0625	146.5938	146.5938	603400.0
2000-06-16 09:30:00	QQQ	ETF	94.75	94.875	94.0	94.25	2850700.0
2000-06-16 10:00:00	QQQ	ETF	94.25	94.3438	93.0625	93.625	2130800.0
2000-06-16 10:30:00	QQQ	ETF	93.625	94.375	93.5	94.3125	1266400.0
2000-06-16 11:00:00	QQQ	ETF	94.25	94.3125	93.625	93.75	1462000.0
2000-06-16 11:30:00	QQQ	ETF	93.75	94.5	93.75	94.3125	1752400.0
2000-06-16 12:00:00	QQQ	ETF	94.375	95.0	94.375	94.625	1864800.0
2000-06-16 12:30:00	QQQ	ETF	94.6875	94.875	94.25	94.3125	537200.0
2000-06-16 13:00:00	QQQ	ETF	94.3125	94.8125	94.25	94.6875	1171100.0
2000-06-16 13:30:00	QQQ	ETF	94.6875	95.3125	94.4375	95.125	1890700.0
2000-06-16 14:00:00	QQQ	ETF	95.1875	95.3125	94.8125	95.125	1220800.0
2000-06-16 14:30:00	QQQ	ETF	95.0938	95.1875	94.3125	94.5	859700.0
2000-06-16 15:00:00	QQQ	ETF	94.5938	94.8125	93.625	93.8125	1909100.0
2000-06-16 15:30:00	QQQ	ETF	93.75	94.6875	93.5	94.625	1918000.0
2000-06-16 16:00:00	QQQ	ETF	94.625	94.625	94.0	94.125	322600.0
2000-06-16 16:30:00	QQQ	ETF	95.125	95.125	94.125	94.5	1500.0
2000-06-16 17:00:00	QQQ	ETF	94.25	94.25	94.25	94.25	100.0
2000-06-16 17:30:00	QQQ	ETF	94.125	94.125	94.0	94.0	800.0
2000-06-16 18:00:00	QQQ	ETF	94.0	94.25	94.0	94.25	1900.0
2000-06-16 09:30:00	IWM	ETF	51.4688	51.5	51.3438	51.3438	7800.0
2000-06-16 10:00:00	IWM	ETF	51.3125	51.3125	50.9688	51.125	5800.0
2000-06-16 11:30:00	IWM	ETF	51.1875	51.1875	51.1875	51.1875	2000.0
2000-06-16 13:30:00	IWM	ETF	51.3281	51.3281	51.3281	51.3281	1000.0
2000-06-16 14:30:00	IWM	ETF	51.2812	51.3125	51.2812	51.3125	6600.0
2000-06-16 15:00:00	IWM	ETF	50.9688	50.9688	50.9688	50.9688	5000.0
2000-06-16 15:30:00	IWM	ETF	50.9688	50.9688	50.9688	50.9688	2000.0
2000-06-16 09:30:00	DIA	ETF	107.0312	107.1562	106.5938	106.5938	53300.0
2000-06-16 10:00:00	DIA	ETF	106.5938	106.8125	106.0312	106.3438	632300.0
2000-06-16 10:30:00	DIA	ETF	106.5625	106.6562	106.3125	106.5	28900.0
2000-06-16 11:00:00	DIA	ETF	106.5625	106.5625	105.75	105.8125	243800.0
2000-06-16 11:30:00	DIA	ETF	105.8125	106.0625	105.625	105.9688	71700.0
2000-06-16 12:00:00	DIA	ETF	105.6875	106.1562	105.6875	105.875	287500.0
2000-06-16 12:30:00	DIA	ETF	106.0	106.1875	105.625	105.6875	52600.0
2000-06-16 13:00:00	DIA	ETF	105.5625	105.875	105.5	105.875	104000.0
2000-06-16 13:30:00	DIA	ETF	105.8125	106.0625	105.8125	106.0312	87100.0
2000-06-16 14:00:00	DIA	ETF	105.8438	106.0	105.75	106.0	68300.0
2000-06-16 14:30:00	DIA	ETF	105.75	105.875	105.5625	105.7188	271000.0

> showing 50 of 259 rows — these rows as CSV

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