PREVIEW / etf_30min / 2000-06-27

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-06-27.parquet
  size:    10 KB
  rows:    241

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-27 09:30:00	SPY	ETF	145.9688	146.4375	145.7812	146.3438	784800.0
2000-06-27 10:00:00	SPY	ETF	146.25	146.7188	146.125	146.125	200300.0
2000-06-27 10:30:00	SPY	ETF	146.1875	146.5	146.0312	146.4062	168900.0
2000-06-27 11:00:00	SPY	ETF	146.2812	146.4375	145.7812	145.9062	96700.0
2000-06-27 11:30:00	SPY	ETF	145.9062	146.0938	145.8125	146.0625	190300.0
2000-06-27 12:00:00	SPY	ETF	146.0625	146.1875	145.7812	146.0625	82600.0
2000-06-27 12:30:00	SPY	ETF	146.1562	146.2812	145.75	145.75	150500.0
2000-06-27 13:00:00	SPY	ETF	145.875	146.0938	145.5938	145.625	76200.0
2000-06-27 13:30:00	SPY	ETF	145.625	146.0	145.5	145.875	383000.0
2000-06-27 14:00:00	SPY	ETF	145.8125	146.125	145.7812	146.0	209400.0
2000-06-27 14:30:00	SPY	ETF	145.875	145.9062	145.5	145.8438	152900.0
2000-06-27 15:00:00	SPY	ETF	145.875	146.1875	145.6562	146.0	433000.0
2000-06-27 15:30:00	SPY	ETF	146.0	146.125	145.3125	145.5625	446700.0
2000-06-27 16:00:00	SPY	ETF	145.6875	145.7188	145.0312	145.1562	634100.0
2000-06-27 09:30:00	QQQ	ETF	93.75	95.0625	93.6875	94.875	2766400.0
2000-06-27 10:00:00	QQQ	ETF	95.0	95.0	94.125	94.125	1506200.0
2000-06-27 10:30:00	QQQ	ETF	94.1875	94.5625	93.9375	94.2188	1182600.0
2000-06-27 11:00:00	QQQ	ETF	94.25	94.25	93.3438	93.375	878400.0
2000-06-27 11:30:00	QQQ	ETF	93.4062	93.9062	93.375	93.8125	920200.0
2000-06-27 12:00:00	QQQ	ETF	93.8125	94.125	93.5	94.0	624200.0
2000-06-27 12:30:00	QQQ	ETF	94.0312	94.0625	93.1875	93.25	373500.0
2000-06-27 13:00:00	QQQ	ETF	93.25	93.625	93.0312	93.0312	540700.0
2000-06-27 13:30:00	QQQ	ETF	93.0	93.3438	92.75	93.3438	1178900.0
2000-06-27 14:00:00	QQQ	ETF	93.1875	93.375	92.9375	93.3125	493600.0
2000-06-27 14:30:00	QQQ	ETF	93.3125	93.4375	92.625	92.9375	950600.0
2000-06-27 15:00:00	QQQ	ETF	92.875	93.625	92.625	93.375	900800.0
2000-06-27 15:30:00	QQQ	ETF	93.4375	93.5625	92.375	92.6562	1935700.0
2000-06-27 16:00:00	QQQ	ETF	92.6562	92.75	92.5	92.75	492900.0
2000-06-27 16:30:00	QQQ	ETF	92.6875	92.75	92.5	92.5	1200.0
2000-06-27 17:00:00	QQQ	ETF	92.6875	92.6875	92.375	92.375	4400.0
2000-06-27 17:30:00	QQQ	ETF	92.5	92.5	92.5	92.5	200.0
2000-06-27 18:00:00	QQQ	ETF	92.75	92.875	92.75	92.875	700.0
2000-06-27 09:30:00	IWM	ETF	51.6094	52.0625	51.6094	51.8125	8200.0
2000-06-27 10:00:00	IWM	ETF	51.7812	51.7812	51.5938	51.5938	9200.0
2000-06-27 10:30:00	IWM	ETF	51.3594	51.4688	51.3594	51.4688	2000.0
2000-06-27 11:00:00	IWM	ETF	51.3125	51.3125	51.3125	51.3125	4800.0
2000-06-27 11:30:00	IWM	ETF	51.4375	51.4375	51.375	51.375	7200.0
2000-06-27 12:00:00	IWM	ETF	51.4375	51.4375	51.4375	51.4375	8800.0
2000-06-27 12:30:00	IWM	ETF	51.4531	51.4531	51.4375	51.4375	6000.0
2000-06-27 13:00:00	IWM	ETF	51.0	51.0	51.0	51.0	600.0
2000-06-27 13:30:00	IWM	ETF	51.0	51.0	50.9375	50.9375	400.0
2000-06-27 14:00:00	IWM	ETF	51.0938	51.125	51.0938	51.125	600.0
2000-06-27 14:30:00	IWM	ETF	50.9219	50.9375	50.9219	50.9375	31000.0
2000-06-27 15:00:00	IWM	ETF	50.9375	51.0	50.9375	51.0	30000.0
2000-06-27 15:30:00	IWM	ETF	50.8125	50.8125	50.7188	50.7188	4000.0
2000-06-27 09:30:00	DIA	ETF	105.6562	105.9062	105.5	105.9062	23800.0
2000-06-27 10:00:00	DIA	ETF	105.9062	106.2188	105.6875	105.8438	121600.0
2000-06-27 10:30:00	DIA	ETF	105.8438	106.2188	105.75	106.1562	75400.0
2000-06-27 11:00:00	DIA	ETF	106.0625	106.25	105.875	105.875	53900.0
2000-06-27 11:30:00	DIA	ETF	106.0938	106.0938	105.8125	106.0	13400.0

> showing 50 of 241 rows — these rows as CSV

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