PREVIEW / etf_1hour / 2000-10-31

all etf 1-hour files

  file:    by_date/etf_1hour/2000/2000-10-31.parquet
  size:    10 KB
  rows:    194

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-31 09:00:00	SPY	ETF	141.0312	141.4062	140.9062	141.25	1327300.0
2000-10-31 10:00:00	SPY	ETF	141.0312	141.875	140.8438	141.5938	1563000.0
2000-10-31 11:00:00	SPY	ETF	141.625	142.0	141.4688	141.875	684200.0
2000-10-31 12:00:00	SPY	ETF	141.8438	142.6562	141.8125	142.5938	394800.0
2000-10-31 13:00:00	SPY	ETF	142.5	142.7812	142.0938	142.6875	712300.0
2000-10-31 14:00:00	SPY	ETF	142.6875	143.125	142.5312	142.8125	605600.0
2000-10-31 15:00:00	SPY	ETF	142.6875	143.6875	142.6875	142.9688	1352000.0
2000-10-31 16:00:00	SPY	ETF	143.0	143.1875	142.7812	142.9375	224500.0
2000-10-31 09:00:00	QQQ	ETF	78.0	79.5	77.9375	79.25	6027000.0
2000-10-31 10:00:00	QQQ	ETF	79.1875	81.1875	79.0625	80.75	9191600.0
2000-10-31 11:00:00	QQQ	ETF	80.875	81.5	80.625	81.0625	5429600.0
2000-10-31 12:00:00	QQQ	ETF	81.0312	82.0312	81.0	82.0	3243200.0
2000-10-31 13:00:00	QQQ	ETF	82.0	82.125	81.375	81.9688	3559500.0
2000-10-31 14:00:00	QQQ	ETF	81.875	82.5625	80.625	80.9375	6962400.0
2000-10-31 15:00:00	QQQ	ETF	80.75	82.2188	80.75	81.9375	7736800.0
2000-10-31 16:00:00	QQQ	ETF	81.875	81.9688	81.0312	81.75	1113000.0
2000-10-31 17:00:00	QQQ	ETF	81.8125	81.9062	81.6875	81.6875	21000.0
2000-10-31 18:00:00	QQQ	ETF	81.625	82.0	81.5	81.625	1400.0
2000-10-31 09:00:00	IWM	ETF	48.4375	48.8594	48.4375	48.5938	43800.0
2000-10-31 10:00:00	IWM	ETF	48.7188	48.7188	48.5625	48.5625	11000.0
2000-10-31 11:00:00	IWM	ETF	48.9375	48.9375	48.8125	48.9062	129000.0
2000-10-31 12:00:00	IWM	ETF	49.0625	49.0625	49.0625	49.0625	600.0
2000-10-31 13:00:00	IWM	ETF	49.3438	49.375	49.2656	49.375	3800.0
2000-10-31 14:00:00	IWM	ETF	49.4688	49.5625	49.3438	49.5625	3000.0
2000-10-31 15:00:00	IWM	ETF	49.1562	49.6719	49.1562	49.5	39400.0
2000-10-31 16:00:00	IWM	ETF	49.5	49.6562	49.5	49.6562	40600.0
2000-10-31 09:00:00	DIA	ETF	108.9062	108.9062	108.2812	108.5	295100.0
2000-10-31 10:00:00	DIA	ETF	108.4062	108.6875	107.8438	108.3125	1052300.0
2000-10-31 11:00:00	DIA	ETF	108.25	108.8125	108.0625	108.5312	456000.0
2000-10-31 12:00:00	DIA	ETF	108.6562	109.25	108.5	109.25	753400.0
2000-10-31 13:00:00	DIA	ETF	109.1875	109.5312	109.0	109.1875	834800.0
2000-10-31 14:00:00	DIA	ETF	109.25	109.8125	109.25	109.4062	842900.0
2000-10-31 15:00:00	DIA	ETF	109.4688	109.9062	109.4062	109.5	451600.0
2000-10-31 16:00:00	DIA	ETF	109.5	109.6562	109.375	109.4062	86900.0

> showing 34 of 194 rows — these rows as CSV

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