PREVIEW / etf_1hour / 2000-07-14

all etf 1-hour files

  file:    by_date/etf_1hour/2000/2000-07-14.parquet
  size:    9 KB
  rows:    164

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-07-14 09:00:00	SPY	ETF	150.4375	150.7188	150.1875	150.25	925500.0
2000-07-14 10:00:00	SPY	ETF	150.1875	150.3438	149.6562	150.0938	883400.0
2000-07-14 11:00:00	SPY	ETF	150.25	150.8125	150.0312	150.5938	1046200.0
2000-07-14 12:00:00	SPY	ETF	150.5938	150.7188	150.2812	150.5	467500.0
2000-07-14 13:00:00	SPY	ETF	150.4062	150.6875	150.2812	150.625	573800.0
2000-07-14 14:00:00	SPY	ETF	150.5	151.0938	150.5	151.0938	220400.0
2000-07-14 15:00:00	SPY	ETF	151.125	151.25	150.5	150.875	776300.0
2000-07-14 16:00:00	SPY	ETF	150.9375	151.25	150.7812	151.25	236000.0
2000-07-14 09:00:00	QQQ	ETF	100.25	100.375	99.375	99.625	3975600.0
2000-07-14 10:00:00	QQQ	ETF	99.625	99.7812	98.8125	99.5	3494500.0
2000-07-14 11:00:00	QQQ	ETF	99.4375	100.2812	99.375	100.0	2389100.0
2000-07-14 12:00:00	QQQ	ETF	100.0625	100.625	99.75	100.0625	1103300.0
2000-07-14 13:00:00	QQQ	ETF	100.0625	100.3125	99.875	100.0625	1282400.0
2000-07-14 14:00:00	QQQ	ETF	100.125	100.9375	100.0312	100.9375	1595600.0
2000-07-14 15:00:00	QQQ	ETF	100.9062	101.125	100.0	100.8438	2879200.0
2000-07-14 16:00:00	QQQ	ETF	100.8125	100.8438	100.4375	100.5625	463500.0
2000-07-14 17:00:00	QQQ	ETF	100.5625	100.5625	100.1875	100.1875	400.0
2000-07-14 18:00:00	QQQ	ETF	100.625	100.625	100.625	100.625	300.0
2000-07-14 09:00:00	IWM	ETF	54.5469	54.5469	54.4062	54.4062	18200.0
2000-07-14 10:00:00	IWM	ETF	54.0312	54.125	53.875	54.125	16600.0
2000-07-14 11:00:00	IWM	ETF	54.1875	54.2812	54.1875	54.2812	4400.0
2000-07-14 12:00:00	IWM	ETF	54.2031	54.2812	54.2031	54.2812	1600.0
2000-07-14 13:00:00	IWM	ETF	54.2031	54.2031	54.1094	54.1406	2200.0
2000-07-14 14:00:00	IWM	ETF	54.2031	54.2031	54.1719	54.1719	600.0
2000-07-14 15:00:00	IWM	ETF	54.1875	54.3125	54.1875	54.3125	11200.0
2000-07-14 09:00:00	DIA	ETF	108.1875	108.3125	107.7188	107.75	131600.0
2000-07-14 10:00:00	DIA	ETF	107.7812	108.0625	107.625	107.7188	130900.0
2000-07-14 11:00:00	DIA	ETF	107.75	108.2188	107.75	108.0	8900.0
2000-07-14 12:00:00	DIA	ETF	107.8438	108.125	107.75	107.875	32200.0
2000-07-14 13:00:00	DIA	ETF	107.8125	108.0625	107.75	107.875	7800.0
2000-07-14 14:00:00	DIA	ETF	107.75	108.4375	107.75	108.2812	116300.0
2000-07-14 15:00:00	DIA	ETF	108.25	108.4062	107.8125	108.2188	118500.0
2000-07-14 16:00:00	DIA	ETF	108.0625	108.0625	108.0625	108.0625	5000.0
2000-07-14 17:00:00	DIA	ETF	108.25	108.25	108.25	108.25	100.0

> showing 34 of 164 rows — these rows as CSV

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