PREVIEW / etf_30min / 2000-11-03

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-11-03.parquet
  size:    11 KB
  rows:    287

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-11-03 09:30:00	SPY	ETF	143.4688	143.4688	142.375	142.7188	1035800.0
2000-11-03 10:00:00	SPY	ETF	142.7188	143.375	142.5	143.0312	522100.0
2000-11-03 10:30:00	SPY	ETF	143.0625	143.6875	143.0312	143.5938	367700.0
2000-11-03 11:00:00	SPY	ETF	143.7188	143.75	143.0938	143.0938	116800.0
2000-11-03 11:30:00	SPY	ETF	143.125	143.2812	142.7812	143.2812	552500.0
2000-11-03 12:00:00	SPY	ETF	143.2188	143.3125	142.8125	142.9375	217900.0
2000-11-03 12:30:00	SPY	ETF	142.9375	142.9688	142.5	142.75	387900.0
2000-11-03 13:00:00	SPY	ETF	142.7812	142.9375	142.5625	142.875	138900.0
2000-11-03 13:30:00	SPY	ETF	142.8125	143.0	142.5312	142.75	146000.0
2000-11-03 14:00:00	SPY	ETF	142.75	142.9688	142.5	142.5	120200.0
2000-11-03 14:30:00	SPY	ETF	142.6562	142.9688	142.5	142.9375	411700.0
2000-11-03 15:00:00	SPY	ETF	142.8438	143.125	142.4375	143.125	103700.0
2000-11-03 15:30:00	SPY	ETF	143.0938	143.2188	142.875	143.0938	450800.0
2000-11-03 16:00:00	SPY	ETF	143.0	143.375	142.7812	142.7812	327100.0
2000-11-03 16:30:00	SPY	ETF	142.7812	142.7812	142.7812	142.7812	700.0
2000-11-03 17:00:00	SPY	ETF	142.8125	142.8125	142.0	142.0	3000.0
2000-11-03 09:30:00	QQQ	ETF	82.875	82.9375	81.625	81.9375	7726900.0
2000-11-03 10:00:00	QQQ	ETF	82.0	83.0625	81.6875	82.75	5796300.0
2000-11-03 10:30:00	QQQ	ETF	82.6875	83.7188	82.5625	83.6875	2984800.0
2000-11-03 11:00:00	QQQ	ETF	83.6875	83.875	83.1875	83.3125	2424000.0
2000-11-03 11:30:00	QQQ	ETF	83.3125	83.3438	82.75	83.1875	1400200.0
2000-11-03 12:00:00	QQQ	ETF	83.1875	83.375	82.75	82.75	851600.0
2000-11-03 12:30:00	QQQ	ETF	82.75	82.875	82.375	82.6875	1324800.0
2000-11-03 13:00:00	QQQ	ETF	82.625	83.0938	82.5	83.0	1138700.0
2000-11-03 13:30:00	QQQ	ETF	83.0	83.25	82.75	83.1562	691200.0
2000-11-03 14:00:00	QQQ	ETF	83.125	83.4375	82.75	82.7812	1025200.0
2000-11-03 14:30:00	QQQ	ETF	82.7812	83.25	82.75	83.0938	928000.0
2000-11-03 15:00:00	QQQ	ETF	83.0938	83.1562	82.625	82.9375	928600.0
2000-11-03 15:30:00	QQQ	ETF	83.0	83.25	82.8125	83.0	1009000.0
2000-11-03 16:00:00	QQQ	ETF	83.0	83.125	82.4375	83.0	624300.0
2000-11-03 16:30:00	QQQ	ETF	82.9375	83.0	82.875	82.875	5400.0
2000-11-03 17:00:00	QQQ	ETF	82.875	83.0	82.875	83.0	1000.0
2000-11-03 18:00:00	QQQ	ETF	83.0	83.0	82.9375	82.9375	700.0
2000-11-03 09:30:00	IWM	ETF	50.7969	50.7969	50.4375	50.6562	23400.0
2000-11-03 10:00:00	IWM	ETF	50.3906	50.6562	50.3906	50.5312	138600.0
2000-11-03 10:30:00	IWM	ETF	50.6875	50.7188	50.625	50.7188	15400.0
2000-11-03 11:00:00	IWM	ETF	50.7188	50.8125	50.7188	50.8125	1400.0
2000-11-03 11:30:00	IWM	ETF	50.6562	50.6562	50.6562	50.6562	3200.0
2000-11-03 12:00:00	IWM	ETF	50.7188	50.7188	50.7188	50.7188	400.0
2000-11-03 12:30:00	IWM	ETF	50.625	50.6562	50.5	50.5	2200.0
2000-11-03 13:00:00	IWM	ETF	50.4375	50.5625	50.4062	50.5312	3200.0
2000-11-03 14:00:00	IWM	ETF	50.5312	50.5312	50.375	50.375	1400.0
2000-11-03 14:30:00	IWM	ETF	50.5938	50.6094	50.5938	50.6094	1400.0
2000-11-03 15:00:00	IWM	ETF	50.6562	50.6562	50.6562	50.6562	2400.0
2000-11-03 15:30:00	IWM	ETF	50.6562	50.75	50.6562	50.75	5400.0
2000-11-03 16:00:00	IWM	ETF	50.75	50.75	50.6562	50.6562	10200.0
2000-11-03 09:30:00	DIA	ETF	109.0	109.0	108.0	108.25	410700.0
2000-11-03 10:00:00	DIA	ETF	108.25	108.625	108.25	108.4062	91300.0
2000-11-03 10:30:00	DIA	ETF	108.5625	108.6875	108.4375	108.6562	48100.0
2000-11-03 11:00:00	DIA	ETF	108.5312	108.6875	108.0625	108.125	105100.0

> showing 50 of 287 rows — these rows as CSV

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