PREVIEW / etf_1hour / 2000-09-27

all etf 1-hour files

  file:    by_date/etf_1hour/2000/2000-09-27.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-27 09:00:00	SPY	ETF	143.5625	143.7188	143.0938	143.4375	485900.0
2000-09-27 10:00:00	SPY	ETF	143.3125	143.5625	142.75	142.875	695800.0
2000-09-27 11:00:00	SPY	ETF	142.75	143.5	142.5	143.125	1267000.0
2000-09-27 12:00:00	SPY	ETF	143.125	143.9688	143.0312	143.4375	680800.0
2000-09-27 13:00:00	SPY	ETF	143.4375	143.625	142.8438	143.0312	273600.0
2000-09-27 14:00:00	SPY	ETF	143.0625	143.125	142.1562	142.375	728100.0
2000-09-27 15:00:00	SPY	ETF	142.375	142.8438	142.125	142.8125	1167700.0
2000-09-27 16:00:00	SPY	ETF	142.6875	143.1562	142.6562	143.1562	1795400.0
2000-09-27 09:00:00	QQQ	ETF	90.625	91.0	90.0	90.5938	3598200.0
2000-09-27 10:00:00	QQQ	ETF	90.625	90.75	89.5	89.5625	3533700.0
2000-09-27 11:00:00	QQQ	ETF	89.5	90.9375	88.875	90.5625	4814600.0
2000-09-27 12:00:00	QQQ	ETF	90.5625	91.1875	90.375	90.625	2088800.0
2000-09-27 13:00:00	QQQ	ETF	90.6875	90.8125	89.6875	89.9062	1366500.0
2000-09-27 14:00:00	QQQ	ETF	89.8125	90.0625	88.375	88.5625	4059600.0
2000-09-27 15:00:00	QQQ	ETF	88.625	89.3125	88.0625	89.125	8238800.0
2000-09-27 16:00:00	QQQ	ETF	89.1875	89.625	88.625	89.5	581700.0
2000-09-27 17:00:00	QQQ	ETF	89.5	89.75	89.5	89.5625	1800.0
2000-09-27 18:00:00	QQQ	ETF	89.5625	89.5625	89.5625	89.5625	1300.0
2000-09-27 09:00:00	IWM	ETF	51.1562	51.4062	51.1562	51.4062	1200.0
2000-09-27 10:00:00	IWM	ETF	51.25	51.3125	51.2188	51.2188	20600.0
2000-09-27 11:00:00	IWM	ETF	51.125	51.125	51.0	51.0	9000.0
2000-09-27 12:00:00	IWM	ETF	51.0781	51.3438	51.0781	51.3438	2400.0
2000-09-27 13:00:00	IWM	ETF	51.3125	51.3125	51.3125	51.3125	200.0
2000-09-27 14:00:00	IWM	ETF	50.9375	50.9375	50.875	50.875	1000.0
2000-09-27 15:00:00	IWM	ETF	50.9219	50.9219	50.5	50.6875	9200.0
2000-09-27 09:00:00	DIA	ETF	106.875	106.9062	106.5	106.6562	92600.0
2000-09-27 10:00:00	DIA	ETF	106.5312	106.625	106.0	106.0625	123600.0
2000-09-27 11:00:00	DIA	ETF	106.1875	106.4375	106.0	106.25	142200.0
2000-09-27 12:00:00	DIA	ETF	106.3125	106.875	106.25	106.7812	29600.0
2000-09-27 13:00:00	DIA	ETF	106.7812	106.7812	106.25	106.25	30700.0
2000-09-27 14:00:00	DIA	ETF	106.3438	106.4688	105.7812	105.9375	67900.0
2000-09-27 15:00:00	DIA	ETF	106.0	106.4375	105.9062	106.4375	85800.0
2000-09-27 16:00:00	DIA	ETF	106.2812	106.5	106.2812	106.5	40000.0

> showing 33 of 175 rows — these rows as CSV

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