PREVIEW / etf_30min / 2000-05-31

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-05-31.parquet
  size:    10 KB
  rows:    223

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-05-31 09:30:00	SPY	ETF	142.5625	142.9375	142.0938	142.5	1144100.0
2000-05-31 10:00:00	SPY	ETF	142.4375	143.9688	142.3438	143.4688	872300.0
2000-05-31 10:30:00	SPY	ETF	143.5	143.7188	143.2812	143.4688	395500.0
2000-05-31 11:00:00	SPY	ETF	143.5625	143.5938	142.6562	142.6875	508000.0
2000-05-31 11:30:00	SPY	ETF	142.6875	142.9062	142.375	142.75	139700.0
2000-05-31 12:00:00	SPY	ETF	142.7188	143.3125	142.6875	143.125	128700.0
2000-05-31 12:30:00	SPY	ETF	143.1875	143.6875	143.0938	143.4062	211200.0
2000-05-31 13:00:00	SPY	ETF	143.5	143.5625	143.1875	143.3125	133300.0
2000-05-31 13:30:00	SPY	ETF	143.4688	143.7188	143.0312	143.4375	232300.0
2000-05-31 14:00:00	SPY	ETF	143.5625	144.0	143.5312	143.875	314000.0
2000-05-31 14:30:00	SPY	ETF	143.75	143.75	143.25	143.4375	242700.0
2000-05-31 15:00:00	SPY	ETF	143.4375	143.625	142.7812	143.375	283200.0
2000-05-31 15:30:00	SPY	ETF	143.3438	143.5938	142.25	142.4062	781600.0
2000-05-31 16:00:00	SPY	ETF	142.4062	142.5625	142.25	142.4688	655900.0
2000-05-31 16:30:00	SPY	ETF	142.4688	142.8125	142.4688	142.8125	3600.0
2000-05-31 09:30:00	QQQ	ETF	84.4688	85.6875	83.75	84.5	4939400.0
2000-05-31 10:00:00	QQQ	ETF	84.4375	86.6562	84.375	86.0	4932200.0
2000-05-31 10:30:00	QQQ	ETF	86.0625	86.5	85.5312	85.9375	2210600.0
2000-05-31 11:00:00	QQQ	ETF	85.9375	86.125	84.0	84.0	2201800.0
2000-05-31 11:30:00	QQQ	ETF	84.0	84.5	83.375	83.875	1750300.0
2000-05-31 12:00:00	QQQ	ETF	83.875	85.25	83.8125	84.8438	1148200.0
2000-05-31 12:30:00	QQQ	ETF	84.75	85.5	84.75	85.0625	853800.0
2000-05-31 13:00:00	QQQ	ETF	85.1562	85.25	84.25	85.125	790500.0
2000-05-31 13:30:00	QQQ	ETF	85.0312	85.3125	84.4375	85.1875	1121400.0
2000-05-31 14:00:00	QQQ	ETF	85.1875	86.0625	85.1562	85.5	1038300.0
2000-05-31 14:30:00	QQQ	ETF	85.5	85.625	84.7188	85.25	1461800.0
2000-05-31 15:00:00	QQQ	ETF	85.3125	85.3125	83.875	84.9375	2863900.0
2000-05-31 15:30:00	QQQ	ETF	84.9375	85.2188	82.875	83.0938	2927200.0
2000-05-31 16:00:00	QQQ	ETF	82.75	84.75	82.75	83.0	777500.0
2000-05-31 16:30:00	QQQ	ETF	83.0	83.25	83.0	83.0	3500.0
2000-05-31 17:00:00	QQQ	ETF	83.25	83.25	83.0	83.125	3300.0
2000-05-31 17:30:00	QQQ	ETF	83.125	83.1875	83.125	83.1875	1200.0
2000-05-31 18:00:00	QQQ	ETF	83.0625	85.375	83.0625	85.375	4700.0
2000-05-31 09:30:00	IWM	ETF	47.5625	47.5625	47.5625	47.5625	200.0
2000-05-31 10:00:00	IWM	ETF	48.0625	48.1875	48.0625	48.1875	2200.0
2000-05-31 10:30:00	IWM	ETF	48.1875	48.1875	48.1875	48.1875	10000.0
2000-05-31 11:30:00	IWM	ETF	47.875	47.875	47.875	47.875	5000.0
2000-05-31 12:30:00	IWM	ETF	47.9062	47.9062	47.9062	47.9062	400.0
2000-05-31 13:30:00	IWM	ETF	48.0312	48.0312	48.0312	48.0312	2600.0
2000-05-31 14:30:00	IWM	ETF	48.1719	48.1875	48.1719	48.1875	14400.0
2000-05-31 15:30:00	IWM	ETF	47.5781	47.5781	47.5781	47.5781	1200.0
2000-05-31 09:30:00	DIA	ETF	105.0312	105.5312	105.0	105.125	70400.0
2000-05-31 10:00:00	DIA	ETF	105.25	106.0938	105.25	105.75	118800.0
2000-05-31 10:30:00	DIA	ETF	105.7812	105.8125	105.5	105.7188	41700.0
2000-05-31 11:00:00	DIA	ETF	105.75	105.75	105.375	105.4375	30600.0
2000-05-31 11:30:00	DIA	ETF	105.3125	105.4062	105.0938	105.3438	18200.0
2000-05-31 12:00:00	DIA	ETF	105.1875	105.625	105.1875	105.4062	17200.0
2000-05-31 12:30:00	DIA	ETF	105.3438	105.8438	105.3438	105.5	8300.0
2000-05-31 13:00:00	DIA	ETF	105.5	105.75	105.4375	105.7188	29500.0
2000-05-31 13:30:00	DIA	ETF	105.7188	105.75	105.4062	105.5625	10300.0

> showing 50 of 223 rows — these rows as CSV

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