PREVIEW / etf_30min / 2000-07-31

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-07-31.parquet
  size:    11 KB
  rows:    281

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-31 09:30:00	SPY	ETF	142.9375	143.2188	142.4062	142.625	573900.0
2000-07-31 10:00:00	SPY	ETF	142.7188	143.2188	142.0625	142.9062	500900.0
2000-07-31 10:30:00	SPY	ETF	142.9375	144.125	142.8125	143.8125	727200.0
2000-07-31 11:00:00	SPY	ETF	143.9062	144.0	143.5625	143.8438	117100.0
2000-07-31 11:30:00	SPY	ETF	143.875	144.0	143.4062	143.6562	64600.0
2000-07-31 12:00:00	SPY	ETF	143.75	144.0938	143.625	143.9688	152800.0
2000-07-31 12:30:00	SPY	ETF	143.875	144.0938	143.8125	143.875	220500.0
2000-07-31 13:00:00	SPY	ETF	143.8125	144.0625	143.6875	144.0	89400.0
2000-07-31 13:30:00	SPY	ETF	144.0	144.125	143.5938	143.625	275600.0
2000-07-31 14:00:00	SPY	ETF	143.6875	143.8438	143.375	143.8125	469000.0
2000-07-31 14:30:00	SPY	ETF	143.6875	144.0938	143.5312	143.6562	352900.0
2000-07-31 15:00:00	SPY	ETF	143.625	143.9688	143.5312	143.7188	621600.0
2000-07-31 15:30:00	SPY	ETF	143.8125	143.9375	142.9062	143.4375	662600.0
2000-07-31 16:00:00	SPY	ETF	143.3438	143.3438	142.75	142.9062	432500.0
2000-07-31 16:30:00	SPY	ETF	143.0	143.0	142.9062	142.9062	500.0
2000-07-31 17:30:00	SPY	ETF	143.0	143.0	143.0	143.0	100.0
2000-07-31 09:30:00	QQQ	ETF	87.625	88.125	86.8125	86.875	4978100.0
2000-07-31 10:00:00	QQQ	ETF	86.9688	87.25	85.7188	87.0938	4061000.0
2000-07-31 10:30:00	QQQ	ETF	87.125	88.875	86.9062	88.7188	3102000.0
2000-07-31 11:00:00	QQQ	ETF	88.5625	89.375	88.375	88.75	2223400.0
2000-07-31 11:30:00	QQQ	ETF	88.8125	89.25	88.5312	88.9062	1360700.0
2000-07-31 12:00:00	QQQ	ETF	88.7812	89.3438	88.75	89.3125	893200.0
2000-07-31 12:30:00	QQQ	ETF	89.25	89.875	89.1875	89.375	1387300.0
2000-07-31 13:00:00	QQQ	ETF	89.375	89.75	89.2812	89.625	646400.0
2000-07-31 13:30:00	QQQ	ETF	89.5938	89.75	89.0	89.25	835000.0
2000-07-31 14:00:00	QQQ	ETF	89.25	89.4688	88.875	89.4375	998500.0
2000-07-31 14:30:00	QQQ	ETF	89.4688	90.125	89.125	89.625	1583200.0
2000-07-31 15:00:00	QQQ	ETF	89.5625	89.9062	89.125	89.3438	1279800.0
2000-07-31 15:30:00	QQQ	ETF	89.375	90.125	89.2812	90.125	3125900.0
2000-07-31 16:00:00	QQQ	ETF	90.0312	90.0938	89.4375	89.4375	1038800.0
2000-07-31 16:30:00	QQQ	ETF	89.5	89.5	89.5	89.5	100.0
2000-07-31 17:30:00	QQQ	ETF	89.4375	89.4375	89.4375	89.4375	100.0
2000-07-31 18:00:00	QQQ	ETF	89.5	89.5	89.4375	89.4375	300.0
2000-07-31 09:30:00	IWM	ETF	49.25	49.25	49.0469	49.0469	800.0
2000-07-31 10:00:00	IWM	ETF	48.6875	48.6875	48.6875	48.6875	200.0
2000-07-31 10:30:00	IWM	ETF	48.8594	49.0938	48.7812	49.0625	18000.0
2000-07-31 11:00:00	IWM	ETF	49.1875	49.2031	49.1875	49.2031	3000.0
2000-07-31 11:30:00	IWM	ETF	49.3906	49.4219	49.3438	49.3438	2000.0
2000-07-31 13:00:00	IWM	ETF	49.5625	49.5781	49.5625	49.5781	4400.0
2000-07-31 13:30:00	IWM	ETF	49.5156	49.5156	49.5156	49.5156	1000.0
2000-07-31 14:00:00	IWM	ETF	49.4375	49.4375	49.4375	49.4375	400.0
2000-07-31 14:30:00	IWM	ETF	49.4844	49.4844	49.375	49.3906	5600.0
2000-07-31 15:00:00	IWM	ETF	49.625	49.625	49.625	49.625	2000.0
2000-07-31 15:30:00	IWM	ETF	49.6094	50.0938	49.6094	50.0938	128600.0
2000-07-31 16:00:00	IWM	ETF	50.25	50.25	50.25	50.25	400.0
2000-07-31 09:30:00	DIA	ETF	105.4375	105.5625	104.875	105.125	62800.0
2000-07-31 10:00:00	DIA	ETF	105.25	105.5625	104.9375	105.5625	50900.0
2000-07-31 10:30:00	DIA	ETF	105.375	105.9688	105.3125	105.8125	45900.0
2000-07-31 11:00:00	DIA	ETF	105.625	105.9375	105.625	105.6875	11200.0
2000-07-31 11:30:00	DIA	ETF	105.75	105.875	105.5625	105.7188	10200.0

> showing 50 of 281 rows — these rows as CSV

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