PREVIEW / etf_1hour / 2000-09-07

all etf 1-hour files

  file:    by_date/etf_1hour/2000/2000-09-07.parquet
  size:    9 KB
  rows:    186

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-07 09:00:00	SPY	ETF	150.25	150.25	150.0	150.0312	904900.0
2000-09-07 10:00:00	SPY	ETF	150.0625	150.7812	149.8125	150.5625	959500.0
2000-09-07 11:00:00	SPY	ETF	150.6875	150.875	150.5	150.5625	327200.0
2000-09-07 12:00:00	SPY	ETF	150.5625	150.7188	150.4062	150.5625	310400.0
2000-09-07 13:00:00	SPY	ETF	150.5938	150.8438	150.4375	150.6875	270100.0
2000-09-07 14:00:00	SPY	ETF	150.6562	151.0	150.375	150.75	350300.0
2000-09-07 15:00:00	SPY	ETF	150.7812	151.0625	150.5938	150.75	603700.0
2000-09-07 16:00:00	SPY	ETF	150.75	150.9375	150.6562	150.8438	471000.0
2000-09-07 09:00:00	QQQ	ETF	96.8125	97.3125	96.5625	96.9375	3000800.0
2000-09-07 10:00:00	QQQ	ETF	96.9375	98.5625	96.875	98.25	3645200.0
2000-09-07 11:00:00	QQQ	ETF	98.25	98.7188	98.125	98.2812	2754000.0
2000-09-07 12:00:00	QQQ	ETF	98.25	98.3438	97.875	98.125	1060800.0
2000-09-07 13:00:00	QQQ	ETF	98.0625	98.4688	97.9062	98.1875	917200.0
2000-09-07 14:00:00	QQQ	ETF	98.1875	98.75	97.9375	98.5	1424800.0
2000-09-07 15:00:00	QQQ	ETF	98.5	98.9375	98.25	98.625	2812500.0
2000-09-07 16:00:00	QQQ	ETF	98.5	98.625	98.25	98.5	887900.0
2000-09-07 17:00:00	QQQ	ETF	98.3438	98.3438	98.25	98.25	3700.0
2000-09-07 18:00:00	QQQ	ETF	98.125	98.125	98.125	98.125	100.0
2000-09-07 09:00:00	IWM	ETF	53.8125	53.9688	53.8125	53.9688	60000.0
2000-09-07 10:00:00	IWM	ETF	53.9688	54.0312	53.9688	54.0312	600.0
2000-09-07 11:00:00	IWM	ETF	54.0781	54.0938	54.0781	54.0938	3200.0
2000-09-07 12:00:00	IWM	ETF	54.0312	54.0469	54.0312	54.0469	800.0
2000-09-07 13:00:00	IWM	ETF	53.9062	54.0781	53.9062	54.0781	1000.0
2000-09-07 14:00:00	IWM	ETF	54.0625	54.0625	54.0312	54.0312	7200.0
2000-09-07 15:00:00	IWM	ETF	54.1094	54.4062	54.1094	54.4062	113800.0
2000-09-07 16:00:00	IWM	ETF	54.375	54.375	54.375	54.375	27200.0
2000-09-07 09:00:00	DIA	ETF	112.7812	113.25	112.625	112.7812	174200.0
2000-09-07 10:00:00	DIA	ETF	112.9062	113.0625	112.25	112.9375	144600.0
2000-09-07 11:00:00	DIA	ETF	112.875	113.125	112.7188	112.75	78100.0
2000-09-07 12:00:00	DIA	ETF	112.7812	113.0	112.7812	112.875	73000.0
2000-09-07 13:00:00	DIA	ETF	113.0312	113.125	112.875	112.9062	44500.0
2000-09-07 14:00:00	DIA	ETF	113.0	113.2188	112.8438	113.0	48500.0
2000-09-07 15:00:00	DIA	ETF	113.0	113.1562	112.6875	112.8125	79200.0
2000-09-07 16:00:00	DIA	ETF	112.6875	112.8125	112.6875	112.7812	8500.0

> showing 34 of 186 rows — these rows as CSV

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