PREVIEW / etf_1hour / 2000-10-19

all etf 1-hour files

  file:    by_date/etf_1hour/2000/2000-10-19.parquet
  size:    10 KB
  rows:    181

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-10-19 09:00:00	SPY	ETF	136.8438	137.125	136.4375	136.9688	1619800.0
2000-10-19 10:00:00	SPY	ETF	136.9375	137.7812	136.625	137.2188	1131700.0
2000-10-19 11:00:00	SPY	ETF	137.1562	138.0938	137.0312	137.5	1174100.0
2000-10-19 12:00:00	SPY	ETF	137.5	138.375	137.4688	138.0938	1085300.0
2000-10-19 13:00:00	SPY	ETF	138.125	138.4688	137.875	138.0	566600.0
2000-10-19 14:00:00	SPY	ETF	137.875	139.125	137.875	138.9062	621100.0
2000-10-19 15:00:00	SPY	ETF	139.0625	139.4375	138.625	139.0312	1632700.0
2000-10-19 16:00:00	SPY	ETF	139.1562	139.3125	138.875	139.125	480400.0
2000-10-19 09:00:00	QQQ	ETF	82.375	83.0	81.4375	82.125	10784700.0
2000-10-19 10:00:00	QQQ	ETF	82.0625	83.125	81.625	82.5625	6515800.0
2000-10-19 11:00:00	QQQ	ETF	82.5625	83.875	82.375	82.875	4993600.0
2000-10-19 12:00:00	QQQ	ETF	82.875	83.75	82.8125	83.6875	2577300.0
2000-10-19 13:00:00	QQQ	ETF	83.6875	84.3125	82.875	82.875	3951000.0
2000-10-19 14:00:00	QQQ	ETF	83.0	84.6875	82.875	84.625	5139500.0
2000-10-19 15:00:00	QQQ	ETF	84.625	85.0	83.7188	84.8125	6628400.0
2000-10-19 16:00:00	QQQ	ETF	84.875	85.5	83.8125	85.0625	762500.0
2000-10-19 17:00:00	QQQ	ETF	84.9375	85.5	84.9375	85.5	22100.0
2000-10-19 18:00:00	QQQ	ETF	85.5	85.5	85.25	85.5	6100.0
2000-10-19 09:00:00	IWM	ETF	47.2812	47.5781	47.2812	47.5781	10000.0
2000-10-19 10:00:00	IWM	ETF	47.375	47.7188	47.375	47.7188	23200.0
2000-10-19 11:00:00	IWM	ETF	47.7812	47.7812	47.6875	47.75	3800.0
2000-10-19 12:00:00	IWM	ETF	47.75	47.75	47.75	47.75	3400.0
2000-10-19 13:00:00	IWM	ETF	47.8125	47.9688	47.7188	47.7188	97600.0
2000-10-19 14:00:00	IWM	ETF	47.625	48.0	47.625	48.0	1400.0
2000-10-19 15:00:00	IWM	ETF	47.875	48.0938	47.875	47.9688	9600.0
2000-10-19 09:00:00	DIA	ETF	101.25	101.5	100.875	101.1562	239700.0
2000-10-19 10:00:00	DIA	ETF	101.1562	101.2812	100.75	100.875	229100.0
2000-10-19 11:00:00	DIA	ETF	100.75	101.375	100.6562	100.9375	88300.0
2000-10-19 12:00:00	DIA	ETF	100.9375	101.2188	100.875	101.0312	42900.0
2000-10-19 13:00:00	DIA	ETF	101.0	101.1562	100.5	100.6875	105200.0
2000-10-19 14:00:00	DIA	ETF	100.625	101.6562	100.625	101.3125	391100.0
2000-10-19 15:00:00	DIA	ETF	101.375	101.6875	101.125	101.375	353300.0
2000-10-19 16:00:00	DIA	ETF	101.3438	102.0	101.3438	101.75	77200.0

> showing 33 of 181 rows — these rows as CSV

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