PREVIEW / etf_1hour / 2000-10-04

all etf 1-hour files

  file:    by_date/etf_1hour/2000/2000-10-04.parquet
  size:    9 KB
  rows:    163

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-04 09:00:00	SPY	ETF	142.875	143.1875	142.125	142.7812	563400.0
2000-10-04 10:00:00	SPY	ETF	142.7812	143.4688	141.75	143.4688	1291800.0
2000-10-04 11:00:00	SPY	ETF	143.4375	143.4375	142.0938	142.625	567800.0
2000-10-04 12:00:00	SPY	ETF	142.7188	143.75	142.5625	143.4062	1380300.0
2000-10-04 13:00:00	SPY	ETF	143.4375	143.625	143.0	143.4688	461300.0
2000-10-04 14:00:00	SPY	ETF	143.375	143.8438	142.6875	143.7188	513200.0
2000-10-04 15:00:00	SPY	ETF	143.625	144.25	143.375	143.5625	890900.0
2000-10-04 16:00:00	SPY	ETF	143.5938	143.75	143.375	143.6875	437800.0
2000-10-04 09:00:00	QQQ	ETF	83.5	83.9375	82.5	83.5312	5799800.0
2000-10-04 10:00:00	QQQ	ETF	83.4375	84.75	82.125	84.6875	8128500.0
2000-10-04 11:00:00	QQQ	ETF	84.6875	84.6875	82.875	83.875	4318700.0
2000-10-04 12:00:00	QQQ	ETF	83.7812	85.75	83.75	85.375	4012900.0
2000-10-04 13:00:00	QQQ	ETF	85.4375	85.875	84.75	85.4375	3467900.0
2000-10-04 14:00:00	QQQ	ETF	85.375	85.75	83.875	85.6562	5551900.0
2000-10-04 15:00:00	QQQ	ETF	85.75	86.8438	85.5	86.0	5106700.0
2000-10-04 16:00:00	QQQ	ETF	85.875	86.0312	84.0	84.0	1050400.0
2000-10-04 17:00:00	QQQ	ETF	84.0	85.9375	84.0	84.875	89000.0
2000-10-04 18:00:00	QQQ	ETF	85.0	85.25	84.875	85.25	1400.0
2000-10-04 09:00:00	IWM	ETF	50.4531	50.4531	50.1875	50.1875	22000.0
2000-10-04 10:00:00	IWM	ETF	50.125	50.1875	49.8125	50.125	44800.0
2000-10-04 11:00:00	IWM	ETF	50.1406	50.1875	50.0	50.1875	3800.0
2000-10-04 12:00:00	IWM	ETF	50.125	50.2812	50.125	50.2812	800.0
2000-10-04 13:00:00	IWM	ETF	50.2344	50.2344	50.125	50.125	1200.0
2000-10-04 14:00:00	IWM	ETF	50.1719	50.1719	50.0	50.0	800.0
2000-10-04 15:00:00	IWM	ETF	50.2188	50.5312	50.2188	50.5312	26000.0
2000-10-04 16:00:00	IWM	ETF	50.5781	50.5781	50.5781	50.5781	400.0
2000-10-04 09:00:00	DIA	ETF	107.5625	108.125	107.1562	107.9688	208000.0
2000-10-04 10:00:00	DIA	ETF	107.9688	108.3438	107.4688	108.3438	319900.0
2000-10-04 11:00:00	DIA	ETF	108.375	108.4688	107.6562	108.0312	184700.0
2000-10-04 12:00:00	DIA	ETF	108.0312	108.4688	107.875	108.3125	135400.0
2000-10-04 13:00:00	DIA	ETF	108.2812	108.2812	107.9062	108.0312	137700.0
2000-10-04 14:00:00	DIA	ETF	108.0312	108.4375	107.8125	108.4375	153200.0
2000-10-04 15:00:00	DIA	ETF	108.3125	108.625	107.7812	107.8125	160300.0
2000-10-04 16:00:00	DIA	ETF	107.9375	107.9375	107.875	107.875	12900.0

> showing 34 of 163 rows — these rows as CSV

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