PREVIEW / etf_1hour / 2000-08-31

all etf 1-hour files

  file:    by_date/etf_1hour/2000/2000-08-31.parquet
  size:    9 KB
  rows:    170

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-08-31 09:00:00	SPY	ETF	151.0625	151.4688	150.9062	151.1875	808500.0
2000-08-31 10:00:00	SPY	ETF	151.2812	152.4688	151.2812	152.3438	945400.0
2000-08-31 11:00:00	SPY	ETF	152.3125	152.5	152.125	152.25	632800.0
2000-08-31 12:00:00	SPY	ETF	152.2188	152.5625	152.1562	152.3438	566500.0
2000-08-31 13:00:00	SPY	ETF	152.25	152.75	152.1875	152.6875	295400.0
2000-08-31 14:00:00	SPY	ETF	152.6875	152.9688	152.625	152.8438	363500.0
2000-08-31 15:00:00	SPY	ETF	152.7812	153.0938	152.25	152.25	772700.0
2000-08-31 16:00:00	SPY	ETF	152.1562	152.5	152.125	152.2812	378000.0
2000-08-31 09:00:00	QQQ	ETF	99.625	100.0	99.5625	99.9375	2674600.0
2000-08-31 10:00:00	QQQ	ETF	99.9375	100.875	99.875	100.7188	3781300.0
2000-08-31 11:00:00	QQQ	ETF	100.6875	100.875	100.5	100.625	1199900.0
2000-08-31 12:00:00	QQQ	ETF	100.625	101.0	100.625	100.8125	1211000.0
2000-08-31 13:00:00	QQQ	ETF	100.8125	101.1875	100.625	101.0	1275700.0
2000-08-31 14:00:00	QQQ	ETF	101.1875	101.4688	101.0	101.4375	1611200.0
2000-08-31 15:00:00	QQQ	ETF	101.375	101.8125	101.1875	101.6875	3115500.0
2000-08-31 16:00:00	QQQ	ETF	101.8125	101.875	101.5625	101.6875	583000.0
2000-08-31 17:00:00	QQQ	ETF	101.8125	102.0	101.625	102.0	3700.0
2000-08-31 18:00:00	QQQ	ETF	101.5	101.625	101.5	101.625	3000.0
2000-08-31 09:00:00	IWM	ETF	53.4062	53.6562	53.4062	53.6562	7000.0
2000-08-31 10:00:00	IWM	ETF	53.8438	53.875	53.8438	53.8594	3000.0
2000-08-31 11:00:00	IWM	ETF	53.875	53.9844	53.875	53.9844	15600.0
2000-08-31 12:00:00	IWM	ETF	53.9531	54.0	53.7969	54.0	37800.0
2000-08-31 13:00:00	IWM	ETF	53.8125	53.9688	53.8125	53.9688	1800.0
2000-08-31 14:00:00	IWM	ETF	53.9688	54.0	53.8125	53.8125	2800.0
2000-08-31 15:00:00	IWM	ETF	54.0469	54.1562	53.7812	53.9219	63000.0
2000-08-31 16:00:00	IWM	ETF	53.7812	53.7812	53.75	53.75	20200.0
2000-08-31 09:00:00	DIA	ETF	111.5	111.8438	111.4375	111.5625	137900.0
2000-08-31 10:00:00	DIA	ETF	111.625	112.7812	111.625	112.7188	184700.0
2000-08-31 11:00:00	DIA	ETF	112.7188	113.0	112.5938	113.0	227600.0
2000-08-31 12:00:00	DIA	ETF	112.9688	113.1562	112.7188	112.9062	85700.0
2000-08-31 13:00:00	DIA	ETF	112.7812	113.0625	112.75	113.0625	42300.0
2000-08-31 14:00:00	DIA	ETF	113.0938	113.2188	112.9062	113.0	61500.0
2000-08-31 15:00:00	DIA	ETF	112.9688	113.1562	112.4375	112.5	106300.0
2000-08-31 16:00:00	DIA	ETF	112.5312	112.5625	112.375	112.4688	43400.0

> showing 34 of 170 rows — these rows as CSV

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