PREVIEW / etf_1hour / 2000-09-28

all etf 1-hour files

  file:    by_date/etf_1hour/2000/2000-09-28.parquet
  size:    10 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-09-28 09:00:00	SPY	ETF	143.1875	143.4375	142.9062	143.0	631800.0
2000-09-28 10:00:00	SPY	ETF	143.0	144.8125	142.875	144.7812	1469600.0
2000-09-28 11:00:00	SPY	ETF	144.75	145.3438	144.375	145.3125	1237800.0
2000-09-28 12:00:00	SPY	ETF	145.25	145.5625	145.0938	145.25	406700.0
2000-09-28 13:00:00	SPY	ETF	145.125	145.7188	145.0	145.5625	371500.0
2000-09-28 14:00:00	SPY	ETF	145.5625	146.25	145.4375	146.0625	812100.0
2000-09-28 15:00:00	SPY	ETF	146.0938	146.3125	145.8438	146.1875	1528600.0
2000-09-28 16:00:00	SPY	ETF	146.2188	146.2188	145.0312	145.0312	475000.0
2000-09-28 17:00:00	SPY	ETF	145.125	145.125	145.0	145.0	2500.0
2000-09-28 09:00:00	QQQ	ETF	88.7188	89.9375	88.7188	89.0	3755500.0
2000-09-28 10:00:00	QQQ	ETF	88.875	90.75	88.75	90.625	5336000.0
2000-09-28 11:00:00	QQQ	ETF	90.6875	91.75	90.1875	91.6875	3970300.0
2000-09-28 12:00:00	QQQ	ETF	91.6875	92.3438	91.4375	91.625	3612700.0
2000-09-28 13:00:00	QQQ	ETF	91.5625	92.2812	91.375	92.0938	2443000.0
2000-09-28 14:00:00	QQQ	ETF	92.125	92.625	91.5938	92.5	2878100.0
2000-09-28 15:00:00	QQQ	ETF	92.4688	93.0	92.1875	92.75	4432500.0
2000-09-28 16:00:00	QQQ	ETF	92.8125	93.0	91.0	91.5625	660600.0
2000-09-28 17:00:00	QQQ	ETF	91.3125	91.8125	90.875	91.0	68100.0
2000-09-28 18:00:00	QQQ	ETF	91.375	91.875	91.0625	91.5625	8100.0
2000-09-28 09:00:00	IWM	ETF	50.8125	51.0312	50.8125	50.8125	26400.0
2000-09-28 10:00:00	IWM	ETF	50.7812	51.0312	50.7812	50.9062	11800.0
2000-09-28 11:00:00	IWM	ETF	51.1875	51.4688	51.1562	51.4688	44400.0
2000-09-28 12:00:00	IWM	ETF	51.5625	51.6719	51.4531	51.6719	22400.0
2000-09-28 13:00:00	IWM	ETF	51.5156	51.8438	51.5156	51.8438	4400.0
2000-09-28 14:00:00	IWM	ETF	51.8281	51.8438	51.8281	51.8438	2200.0
2000-09-28 15:00:00	IWM	ETF	52.0	52.1562	52.0	52.1406	2800.0
2000-09-28 16:00:00	IWM	ETF	52.0625	52.0625	52.0625	52.0625	1000.0
2000-09-28 09:00:00	DIA	ETF	106.375	106.6562	106.3125	106.375	102900.0
2000-09-28 10:00:00	DIA	ETF	106.375	107.5625	106.3438	107.5	336600.0
2000-09-28 11:00:00	DIA	ETF	107.5	108.2188	107.25	108.0625	109600.0
2000-09-28 12:00:00	DIA	ETF	108.0625	108.4688	107.9375	108.125	74000.0
2000-09-28 13:00:00	DIA	ETF	108.125	108.5	108.0312	108.375	66900.0
2000-09-28 14:00:00	DIA	ETF	108.4375	108.625	108.25	108.5	121400.0
2000-09-28 15:00:00	DIA	ETF	108.5	108.5938	108.2812	108.4688	196000.0
2000-09-28 16:00:00	DIA	ETF	108.3438	108.4062	108.25	108.3438	34400.0

> showing 35 of 177 rows — these rows as CSV

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