PREVIEW / etf_1hour / 2000-11-02

all etf 1-hour files

  file:    by_date/etf_1hour/2000/2000-11-02.parquet
  size:    10 KB
  rows:    191

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-11-02 09:00:00	SPY	ETF	143.1562	143.875	142.7188	143.625	949300.0
2000-11-02 10:00:00	SPY	ETF	143.5	143.75	142.875	143.0	1055100.0
2000-11-02 11:00:00	SPY	ETF	143.1562	143.2188	142.5	143.1562	379900.0
2000-11-02 12:00:00	SPY	ETF	143.0312	143.4062	142.9375	143.125	399000.0
2000-11-02 13:00:00	SPY	ETF	143.2188	143.25	142.6562	143.0	429400.0
2000-11-02 14:00:00	SPY	ETF	142.9375	143.5	142.9062	143.1562	272300.0
2000-11-02 15:00:00	SPY	ETF	143.1875	143.5	142.75	143.0312	554000.0
2000-11-02 16:00:00	SPY	ETF	143.0938	143.1562	142.625	142.6875	7147800.0
2000-11-02 17:00:00	SPY	ETF	142.8125	142.8125	142.8125	142.8125	100.0
2000-11-02 09:00:00	QQQ	ETF	82.1875	83.0	81.625	82.8438	5185900.0
2000-11-02 10:00:00	QQQ	ETF	82.8438	83.25	82.125	82.125	4022900.0
2000-11-02 11:00:00	QQQ	ETF	82.125	82.4375	81.25	82.0312	5555100.0
2000-11-02 12:00:00	QQQ	ETF	82.1875	82.9375	81.875	82.3125	2108200.0
2000-11-02 13:00:00	QQQ	ETF	82.25	82.375	81.7188	82.375	1783000.0
2000-11-02 14:00:00	QQQ	ETF	82.375	82.75	82.0312	82.3125	2370100.0
2000-11-02 15:00:00	QQQ	ETF	82.4375	82.875	81.875	82.375	3725100.0
2000-11-02 16:00:00	QQQ	ETF	82.4375	82.5625	81.625	82.5	655000.0
2000-11-02 17:00:00	QQQ	ETF	82.5	82.6875	82.1562	82.625	16300.0
2000-11-02 18:00:00	QQQ	ETF	82.5312	82.5312	82.5	82.5312	700.0
2000-11-02 09:00:00	IWM	ETF	49.8906	50.2188	49.875	50.2188	5800.0
2000-11-02 10:00:00	IWM	ETF	50.0312	50.2188	50.0	50.0	24200.0
2000-11-02 11:00:00	IWM	ETF	50.1562	50.1562	49.9688	50.0625	28200.0
2000-11-02 12:00:00	IWM	ETF	50.25	50.5	50.25	50.5	55800.0
2000-11-02 13:00:00	IWM	ETF	50.4844	50.4844	50.4688	50.4688	2800.0
2000-11-02 14:00:00	IWM	ETF	50.4844	50.6875	50.4844	50.5625	33000.0
2000-11-02 15:00:00	IWM	ETF	50.5781	50.8125	50.5	50.8125	48800.0
2000-11-02 16:00:00	IWM	ETF	50.6875	50.7188	50.625	50.7188	12400.0
2000-11-02 09:00:00	DIA	ETF	109.2188	109.625	108.875	109.5625	367300.0
2000-11-02 10:00:00	DIA	ETF	109.4375	109.625	108.9062	109.0312	230000.0
2000-11-02 11:00:00	DIA	ETF	109.0938	109.2188	108.6562	109.125	186600.0
2000-11-02 12:00:00	DIA	ETF	109.0625	109.3438	109.0	109.2188	74000.0
2000-11-02 13:00:00	DIA	ETF	109.0625	109.2188	108.8125	109.0938	116200.0
2000-11-02 14:00:00	DIA	ETF	109.0312	109.3438	108.75	108.9688	270000.0
2000-11-02 15:00:00	DIA	ETF	109.0	109.2188	108.75	108.9688	188400.0
2000-11-02 16:00:00	DIA	ETF	109.0	109.0	108.625	108.625	73500.0

> showing 35 of 191 rows — these rows as CSV

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