PREVIEW / etf_1hour / 2000-09-05

all etf 1-hour files

  file:    by_date/etf_1hour/2000/2000-09-05.parquet
  size:    9 KB
  rows:    183

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-05 09:00:00	SPY	ETF	151.875	152.1875	151.5938	152.0312	671200.0
2000-09-05 10:00:00	SPY	ETF	152.0312	152.125	151.0	151.2812	804400.0
2000-09-05 11:00:00	SPY	ETF	151.25	151.4062	151.0312	151.1875	194300.0
2000-09-05 12:00:00	SPY	ETF	151.125	151.3438	151.0312	151.125	277600.0
2000-09-05 13:00:00	SPY	ETF	151.25	151.6875	151.125	151.5	246000.0
2000-09-05 14:00:00	SPY	ETF	151.4688	151.5	151.0312	151.0312	183500.0
2000-09-05 15:00:00	SPY	ETF	151.0938	151.3438	150.8125	151.25	694200.0
2000-09-05 16:00:00	SPY	ETF	151.1875	151.4062	151.0625	151.2812	287900.0
2000-09-05 09:00:00	QQQ	ETF	101.625	101.75	101.125	101.5	2357200.0
2000-09-05 10:00:00	QQQ	ETF	101.625	101.6562	100.0312	100.9062	4487800.0
2000-09-05 11:00:00	QQQ	ETF	100.875	100.875	100.1875	100.3125	1310800.0
2000-09-05 12:00:00	QQQ	ETF	100.3438	100.7188	100.125	100.3438	1018600.0
2000-09-05 13:00:00	QQQ	ETF	100.375	100.875	100.1875	100.6562	1676300.0
2000-09-05 14:00:00	QQQ	ETF	100.5938	100.6562	99.875	100.0	1844800.0
2000-09-05 15:00:00	QQQ	ETF	99.9375	100.2812	99.4062	99.5938	3057500.0
2000-09-05 16:00:00	QQQ	ETF	99.625	99.8438	99.5	99.5625	486000.0
2000-09-05 17:00:00	QQQ	ETF	99.875	99.875	99.875	99.875	1700.0
2000-09-05 18:00:00	QQQ	ETF	99.5	99.5	99.5	99.5	300.0
2000-09-05 09:00:00	IWM	ETF	54.1094	54.1094	54.0469	54.0469	2200.0
2000-09-05 10:00:00	IWM	ETF	54.2031	54.2031	53.9531	54.0156	3800.0
2000-09-05 11:00:00	IWM	ETF	54.0469	54.0469	54.0469	54.0469	1000.0
2000-09-05 12:00:00	IWM	ETF	54.0625	54.1562	54.0625	54.1562	31400.0
2000-09-05 13:00:00	IWM	ETF	54.1562	54.2812	54.0938	54.2812	31600.0
2000-09-05 14:00:00	IWM	ETF	54.2344	54.2812	54.125	54.2031	7000.0
2000-09-05 15:00:00	IWM	ETF	54.1562	54.1875	53.9375	54.0469	33000.0
2000-09-05 16:00:00	IWM	ETF	53.8125	53.8125	53.8125	53.8125	400.0
2000-09-05 09:00:00	DIA	ETF	111.9375	112.625	111.9375	112.5	69100.0
2000-09-05 10:00:00	DIA	ETF	112.625	112.6562	111.8125	112.125	138800.0
2000-09-05 11:00:00	DIA	ETF	112.0	112.4375	112.0	112.25	25000.0
2000-09-05 12:00:00	DIA	ETF	112.2812	112.5625	112.25	112.5	59600.0
2000-09-05 13:00:00	DIA	ETF	112.5	113.125	112.4688	113.0	23100.0
2000-09-05 14:00:00	DIA	ETF	112.9375	113.0	112.5625	112.5625	24100.0
2000-09-05 15:00:00	DIA	ETF	112.6875	112.875	112.4062	112.8438	23000.0
2000-09-05 16:00:00	DIA	ETF	112.875	112.875	112.8438	112.8438	9800.0

> showing 34 of 183 rows — these rows as CSV

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