PREVIEW / etf_30min / 2000-07-05

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-07-05.parquet
  size:    11 KB
  rows:    269

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-07-05 09:30:00	SPY	ETF	146.375	146.625	145.9375	146.3125	418400.0
2000-07-05 10:00:00	SPY	ETF	146.25	146.6562	146.0312	146.125	204600.0
2000-07-05 10:30:00	SPY	ETF	146.2188	146.2812	145.8125	146.125	241300.0
2000-07-05 11:00:00	SPY	ETF	146.125	146.1875	145.7188	146.125	154600.0
2000-07-05 11:30:00	SPY	ETF	146.1875	146.5	145.8438	146.5	144200.0
2000-07-05 12:00:00	SPY	ETF	146.375	146.5	146.1562	146.25	135900.0
2000-07-05 12:30:00	SPY	ETF	146.1562	146.25	146.0312	146.0938	63900.0
2000-07-05 13:00:00	SPY	ETF	146.2188	146.2188	145.75	145.8125	100400.0
2000-07-05 13:30:00	SPY	ETF	145.8125	146.2812	145.75	146.2812	89500.0
2000-07-05 14:00:00	SPY	ETF	146.25	146.25	145.6562	145.6875	85400.0
2000-07-05 14:30:00	SPY	ETF	145.625	145.8125	145.2812	145.5938	165300.0
2000-07-05 15:00:00	SPY	ETF	145.375	145.375	144.5625	144.9688	336900.0
2000-07-05 15:30:00	SPY	ETF	144.875	145.2812	144.375	145.0938	301300.0
2000-07-05 16:00:00	SPY	ETF	145.0	145.0312	144.375	144.625	296000.0
2000-07-05 16:30:00	SPY	ETF	144.625	144.625	144.625	144.625	7600.0
2000-07-05 17:00:00	SPY	ETF	144.625	144.625	144.625	144.625	400.0
2000-07-05 09:30:00	QQQ	ETF	93.625	93.75	92.875	93.4375	3172400.0
2000-07-05 10:00:00	QQQ	ETF	93.5	93.9688	93.0	93.2188	2435000.0
2000-07-05 10:30:00	QQQ	ETF	93.25	93.25	92.5625	93.0	1085600.0
2000-07-05 11:00:00	QQQ	ETF	93.0	93.0	92.5	92.9375	723600.0
2000-07-05 11:30:00	QQQ	ETF	93.0	93.3438	92.75	93.3438	626800.0
2000-07-05 12:00:00	QQQ	ETF	93.3125	93.3438	92.8125	92.875	341100.0
2000-07-05 12:30:00	QQQ	ETF	92.8125	93.125	92.75	92.875	426500.0
2000-07-05 13:00:00	QQQ	ETF	92.9688	93.0	92.5	92.5625	586500.0
2000-07-05 13:30:00	QQQ	ETF	92.625	93.0	92.4375	92.9375	503200.0
2000-07-05 14:00:00	QQQ	ETF	92.9062	92.9375	91.9375	91.9375	769900.0
2000-07-05 14:30:00	QQQ	ETF	92.0	92.3125	91.75	91.9375	1064000.0
2000-07-05 15:00:00	QQQ	ETF	92.0	92.0	91.125	91.625	1825700.0
2000-07-05 15:30:00	QQQ	ETF	91.625	91.9375	90.875	91.25	2024800.0
2000-07-05 16:00:00	QQQ	ETF	91.25	91.5625	91.125	91.5	745600.0
2000-07-05 16:30:00	QQQ	ETF	91.4375	91.4375	91.3125	91.375	2200.0
2000-07-05 17:00:00	QQQ	ETF	91.375	91.375	91.25	91.25	300.0
2000-07-05 17:30:00	QQQ	ETF	91.375	91.375	91.375	91.375	100.0
2000-07-05 18:00:00	QQQ	ETF	91.75	91.75	91.5625	91.5625	200.0
2000-07-05 09:30:00	IWM	ETF	52.1094	52.1094	51.875	52.0	31400.0
2000-07-05 10:00:00	IWM	ETF	52.125	52.125	52.1094	52.1094	4600.0
2000-07-05 10:30:00	IWM	ETF	51.8906	52.0312	51.8906	52.0156	2800.0
2000-07-05 11:00:00	IWM	ETF	51.7344	51.7344	51.7344	51.7344	200.0
2000-07-05 11:30:00	IWM	ETF	51.8125	51.9219	51.8125	51.9219	22200.0
2000-07-05 12:00:00	IWM	ETF	52.0312	52.0312	52.0	52.0	800.0
2000-07-05 12:30:00	IWM	ETF	52.1094	52.1094	52.0	52.0	2200.0
2000-07-05 13:00:00	IWM	ETF	52.0	52.0	52.0	52.0	58000.0
2000-07-05 13:30:00	IWM	ETF	52.0	52.0	52.0	52.0	1600.0
2000-07-05 14:00:00	IWM	ETF	51.9062	51.9062	51.75	51.75	12000.0
2000-07-05 14:30:00	IWM	ETF	51.8438	51.8438	51.7656	51.7656	800.0
2000-07-05 15:00:00	IWM	ETF	51.8125	51.8125	51.8125	51.8125	400.0
2000-07-05 15:30:00	IWM	ETF	51.625	51.625	51.625	51.625	1200.0
2000-07-05 16:00:00	IWM	ETF	51.8125	51.8125	51.8125	51.8125	600.0
2000-07-05 09:30:00	DIA	ETF	105.3438	105.625	105.0312	105.5	150700.0
2000-07-05 10:00:00	DIA	ETF	105.625	105.7188	105.3125	105.3125	40800.0

> showing 50 of 269 rows — these rows as CSV

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