PREVIEW / etf_1hour / 2000-07-31

all etf 1-hour files

  file:    by_date/etf_1hour/2000/2000-07-31.parquet
  size:    9 KB
  rows:    177

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:00:00	SPY	ETF	142.9375	143.2188	142.4062	142.625	573900.0
2000-07-31 10:00:00	SPY	ETF	142.7188	144.125	142.0625	143.8125	1228100.0
2000-07-31 11:00:00	SPY	ETF	143.9062	144.0	143.4062	143.6562	181700.0
2000-07-31 12:00:00	SPY	ETF	143.75	144.0938	143.625	143.875	373300.0
2000-07-31 13:00:00	SPY	ETF	143.8125	144.125	143.5938	143.625	365000.0
2000-07-31 14:00:00	SPY	ETF	143.6875	144.0938	143.375	143.6562	821900.0
2000-07-31 15:00:00	SPY	ETF	143.625	143.9688	142.9062	143.4375	1284200.0
2000-07-31 16:00:00	SPY	ETF	143.3438	143.3438	142.75	142.9062	433000.0
2000-07-31 17:00:00	SPY	ETF	143.0	143.0	143.0	143.0	100.0
2000-07-31 09:00:00	QQQ	ETF	87.625	88.125	86.8125	86.875	4978100.0
2000-07-31 10:00:00	QQQ	ETF	86.9688	88.875	85.7188	88.7188	7163000.0
2000-07-31 11:00:00	QQQ	ETF	88.5625	89.375	88.375	88.9062	3584100.0
2000-07-31 12:00:00	QQQ	ETF	88.7812	89.875	88.75	89.375	2280500.0
2000-07-31 13:00:00	QQQ	ETF	89.375	89.75	89.0	89.25	1481400.0
2000-07-31 14:00:00	QQQ	ETF	89.25	90.125	88.875	89.625	2581700.0
2000-07-31 15:00:00	QQQ	ETF	89.5625	90.125	89.125	90.125	4405700.0
2000-07-31 16:00:00	QQQ	ETF	90.0312	90.0938	89.4375	89.5	1038900.0
2000-07-31 17:00: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:00:00	IWM	ETF	49.25	49.25	49.0469	49.0469	800.0
2000-07-31 10:00:00	IWM	ETF	48.6875	49.0938	48.6875	49.0625	18200.0
2000-07-31 11:00:00	IWM	ETF	49.1875	49.4219	49.1875	49.3438	5000.0
2000-07-31 13:00:00	IWM	ETF	49.5625	49.5781	49.5156	49.5156	5400.0
2000-07-31 14:00:00	IWM	ETF	49.4375	49.4844	49.375	49.3906	6000.0
2000-07-31 15:00:00	IWM	ETF	49.625	50.0938	49.6094	50.0938	130600.0
2000-07-31 16:00:00	IWM	ETF	50.25	50.25	50.25	50.25	400.0
2000-07-31 09:00:00	DIA	ETF	105.4375	105.5625	104.875	105.125	62800.0
2000-07-31 10:00:00	DIA	ETF	105.25	105.9688	104.9375	105.8125	96800.0
2000-07-31 11:00:00	DIA	ETF	105.625	105.9375	105.5625	105.7188	21400.0
2000-07-31 12:00:00	DIA	ETF	105.7812	106.0	105.625	105.9375	13700.0
2000-07-31 13:00:00	DIA	ETF	105.9688	106.0	105.7812	105.875	11500.0
2000-07-31 14:00:00	DIA	ETF	105.9688	105.9688	105.5938	105.75	9100.0
2000-07-31 15:00:00	DIA	ETF	105.8125	105.9375	105.125	105.125	111800.0
2000-07-31 16:00:00	DIA	ETF	105.0625	105.125	104.875	105.0	25200.0

> showing 34 of 177 rows — these rows as CSV

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