PREVIEW / etf_1hour / 2000-09-14

all etf 1-hour files

  file:    by_date/etf_1hour/2000/2000-09-14.parquet
  size:    9 KB
  rows:    177

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-14 09:00:00	SPY	ETF	149.875	149.9375	149.4375	149.5938	547800.0
2000-09-14 10:00:00	SPY	ETF	149.5938	149.7188	149.3125	149.625	277200.0
2000-09-14 11:00:00	SPY	ETF	149.5938	149.75	149.1875	149.4688	447800.0
2000-09-14 12:00:00	SPY	ETF	149.4688	149.5	149.0625	149.3125	190100.0
2000-09-14 13:00:00	SPY	ETF	149.375	149.375	148.625	148.8125	313400.0
2000-09-14 14:00:00	SPY	ETF	148.8125	149.0	148.4688	148.9062	270100.0
2000-09-14 15:00:00	SPY	ETF	148.9375	148.9375	148.1562	148.5312	1037700.0
2000-09-14 16:00:00	SPY	ETF	148.5625	149.625	148.4375	149.625	126600.0
2000-09-14 09:00:00	QQQ	ETF	95.25	95.625	94.75	95.375	5875000.0
2000-09-14 10:00:00	QQQ	ETF	95.4062	95.5625	94.875	95.4688	2930600.0
2000-09-14 11:00:00	QQQ	ETF	95.4375	95.7188	95.125	95.4375	1914200.0
2000-09-14 12:00:00	QQQ	ETF	95.4688	95.5938	94.8125	95.0938	3045300.0
2000-09-14 13:00:00	QQQ	ETF	95.0625	95.125	93.375	94.0	3361500.0
2000-09-14 14:00:00	QQQ	ETF	94.0	94.625	93.5	94.1875	3326000.0
2000-09-14 15:00:00	QQQ	ETF	94.375	94.5	92.625	93.2188	4220000.0
2000-09-14 16:00:00	QQQ	ETF	93.2188	93.625	93.0	93.1875	1577200.0
2000-09-14 17:00:00	QQQ	ETF	93.0	93.1875	92.8125	93.0	17300.0
2000-09-14 18:00:00	QQQ	ETF	93.0	93.0	92.75	93.0	1900.0
2000-09-14 09:00:00	IWM	ETF	53.8281	53.8281	53.5781	53.5781	2800.0
2000-09-14 10:00:00	IWM	ETF	53.7656	53.9688	53.7656	53.9219	56200.0
2000-09-14 11:00:00	IWM	ETF	54.0312	54.0781	54.0	54.0	5000.0
2000-09-14 12:00:00	IWM	ETF	54.0312	54.0625	54.0312	54.0312	8800.0
2000-09-14 13:00:00	IWM	ETF	54.0312	54.0625	53.9375	53.9375	7200.0
2000-09-14 14:00:00	IWM	ETF	53.9062	54.0	53.8125	53.9062	11200.0
2000-09-14 15:00:00	IWM	ETF	54.0312	54.1094	53.875	54.0312	15000.0
2000-09-14 16:00:00	IWM	ETF	53.9062	53.9062	53.9062	53.9062	400.0
2000-09-14 09:00:00	DIA	ETF	112.1875	112.4688	111.9375	112.0	180800.0
2000-09-14 10:00:00	DIA	ETF	112.0	112.0312	111.5	111.75	37500.0
2000-09-14 11:00:00	DIA	ETF	111.6875	111.75	111.1562	111.375	27900.0
2000-09-14 12:00:00	DIA	ETF	111.375	111.5	111.125	111.375	88500.0
2000-09-14 13:00:00	DIA	ETF	111.375	111.4375	111.0312	111.0625	160200.0
2000-09-14 14:00:00	DIA	ETF	111.0625	111.2188	110.8438	111.125	30400.0
2000-09-14 15:00:00	DIA	ETF	111.1562	111.2188	110.7188	110.9062	115900.0
2000-09-14 16:00:00	DIA	ETF	110.9062	111.0312	110.9062	111.0312	14400.0

> showing 34 of 177 rows — these rows as CSV

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