PREVIEW / etf_1hour / 2000-08-23

all etf 1-hour files

  file:    by_date/etf_1hour/2000/2000-08-23.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-08-23 09:00:00	SPY	ETF	149.8125	150.1562	149.6875	149.75	683600.0
2000-08-23 10:00:00	SPY	ETF	149.7812	150.3125	149.2812	150.0312	1143700.0
2000-08-23 11:00:00	SPY	ETF	150.0625	150.9688	150.0312	150.5625	778600.0
2000-08-23 12:00:00	SPY	ETF	150.625	150.6562	150.25	150.4375	692500.0
2000-08-23 13:00:00	SPY	ETF	150.4375	150.9688	150.4375	150.6875	383700.0
2000-08-23 14:00:00	SPY	ETF	150.6875	151.0	150.5	150.6562	536200.0
2000-08-23 15:00:00	SPY	ETF	150.875	151.2812	150.625	150.9062	960000.0
2000-08-23 16:00:00	SPY	ETF	150.9375	151.0625	150.8438	150.8438	222700.0
2000-08-23 09:00:00	QQQ	ETF	94.6875	95.25	93.8125	94.5938	2868200.0
2000-08-23 10:00:00	QQQ	ETF	94.6875	95.0625	93.8125	94.9375	5329100.0
2000-08-23 11:00:00	QQQ	ETF	94.875	96.3438	94.875	95.9375	4418800.0
2000-08-23 12:00:00	QQQ	ETF	95.9375	96.4375	95.5625	95.9688	1494400.0
2000-08-23 13:00:00	QQQ	ETF	95.9062	96.7188	95.9062	96.5	1579900.0
2000-08-23 14:00:00	QQQ	ETF	96.5625	96.9688	96.3125	96.8125	2054800.0
2000-08-23 15:00:00	QQQ	ETF	96.6875	97.4375	96.375	97.2812	3081900.0
2000-08-23 16:00:00	QQQ	ETF	97.2188	97.3125	96.875	97.0	395100.0
2000-08-23 17:00:00	QQQ	ETF	97.0	97.1875	97.0	97.0	3000.0
2000-08-23 18:00:00	QQQ	ETF	97.125	97.125	97.0	97.0625	1200.0
2000-08-23 09:00:00	IWM	ETF	51.5938	51.5938	51.375	51.375	51200.0
2000-08-23 10:00:00	IWM	ETF	51.5312	51.6562	51.375	51.6562	17200.0
2000-08-23 11:00:00	IWM	ETF	51.625	51.7188	51.5625	51.6562	16600.0
2000-08-23 12:00:00	IWM	ETF	51.6562	51.7188	51.5625	51.7188	5600.0
2000-08-23 13:00:00	IWM	ETF	51.75	51.75	51.75	51.75	35200.0
2000-08-23 14:00:00	IWM	ETF	51.75	51.75	51.6875	51.6875	2600.0
2000-08-23 15:00:00	IWM	ETF	51.7188	51.7344	51.625	51.7344	5200.0
2000-08-23 16:00:00	IWM	ETF	51.5781	51.5781	51.5781	51.5781	19400.0
2000-08-23 09:00:00	DIA	ETF	111.1875	111.25	110.6875	110.6875	168500.0
2000-08-23 10:00:00	DIA	ETF	110.7188	111.2812	110.6562	111.1875	120600.0
2000-08-23 11:00:00	DIA	ETF	111.125	111.625	111.125	111.3438	69400.0
2000-08-23 12:00:00	DIA	ETF	111.25	111.375	111.0625	111.25	19300.0
2000-08-23 13:00:00	DIA	ETF	111.25	111.625	111.1875	111.3438	52600.0
2000-08-23 14:00:00	DIA	ETF	111.375	111.5	111.1562	111.3438	22700.0
2000-08-23 15:00:00	DIA	ETF	111.375	111.875	111.3125	111.5625	123800.0
2000-08-23 16:00:00	DIA	ETF	111.4688	111.5938	111.4688	111.5	25900.0

> showing 34 of 163 rows — these rows as CSV

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