PREVIEW / etf_1hour / 2000-09-18

all etf 1-hour files

  file:    by_date/etf_1hour/2000/2000-09-18.parquet
  size:    9 KB
  rows:    175

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-09-18 09:00:00	SPY	ETF	146.375	146.8125	146.2812	146.6875	512400.0
2000-09-18 10:00:00	SPY	ETF	146.5625	146.9688	146.375	146.5	373900.0
2000-09-18 11:00:00	SPY	ETF	146.5	146.5	145.4688	145.6875	568200.0
2000-09-18 12:00:00	SPY	ETF	145.6875	145.75	145.25	145.25	500300.0
2000-09-18 13:00:00	SPY	ETF	145.25	145.4062	144.5	145.2188	961100.0
2000-09-18 14:00:00	SPY	ETF	145.25	145.5625	144.6875	145.5	862100.0
2000-09-18 15:00:00	SPY	ETF	145.375	145.625	144.1875	144.6875	756500.0
2000-09-18 16:00:00	SPY	ETF	144.8125	144.9375	144.5625	144.6562	201200.0
2000-09-18 09:00:00	QQQ	ETF	91.8125	93.0	91.25	92.0625	3179600.0
2000-09-18 10:00:00	QQQ	ETF	92.0312	92.9375	91.75	92.125	2742900.0
2000-09-18 11:00:00	QQQ	ETF	92.125	92.2188	90.375	90.625	4548100.0
2000-09-18 12:00:00	QQQ	ETF	90.6875	91.125	89.25	89.25	5048200.0
2000-09-18 13:00:00	QQQ	ETF	89.375	89.75	88.5	89.6875	4284200.0
2000-09-18 14:00:00	QQQ	ETF	89.8438	90.6875	89.0	90.6875	3153100.0
2000-09-18 15:00:00	QQQ	ETF	90.6562	90.8125	88.8125	89.5	5382600.0
2000-09-18 16:00:00	QQQ	ETF	89.5	90.125	89.375	89.875	635700.0
2000-09-18 17:00:00	QQQ	ETF	89.875	90.125	89.875	89.875	2800.0
2000-09-18 18:00:00	QQQ	ETF	89.875	89.875	89.875	89.875	500.0
2000-09-18 09:00:00	IWM	ETF	53.1406	53.1406	52.9062	52.9062	2600.0
2000-09-18 10:00:00	IWM	ETF	52.8438	53.0	52.8438	52.9062	24400.0
2000-09-18 11:00:00	IWM	ETF	52.5	52.5	52.25	52.375	5000.0
2000-09-18 12:00:00	IWM	ETF	52.1562	52.1562	51.8438	52.0312	35000.0
2000-09-18 13:00:00	IWM	ETF	51.9531	51.9688	51.8125	51.875	5000.0
2000-09-18 14:00:00	IWM	ETF	51.875	51.9375	51.6875	51.9375	5800.0
2000-09-18 15:00:00	IWM	ETF	52.0781	52.0938	51.5156	51.6562	6200.0
2000-09-18 16:00:00	IWM	ETF	51.8125	51.8125	51.6562	51.6562	117400.0
2000-09-18 09:00:00	DIA	ETF	109.4375	109.4688	108.875	109.0312	144700.0
2000-09-18 10:00:00	DIA	ETF	108.9062	109.0938	108.7812	108.7812	53900.0
2000-09-18 11:00:00	DIA	ETF	108.75	108.75	108.2812	108.5312	197200.0
2000-09-18 12:00:00	DIA	ETF	108.5312	108.6875	108.3438	108.4375	95900.0
2000-09-18 13:00:00	DIA	ETF	108.5	108.6875	108.125	108.6562	277600.0
2000-09-18 14:00:00	DIA	ETF	108.6875	108.75	108.1875	108.7188	50300.0
2000-09-18 15:00:00	DIA	ETF	108.7188	108.7188	107.8438	108.0	203800.0
2000-09-18 16:00:00	DIA	ETF	108.0	108.25	108.0	108.25	10200.0

> showing 34 of 175 rows — these rows as CSV

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