PREVIEW / etf_1hour / 2000-06-23

all etf 1-hour files

  file:    by_date/etf_1hour/2000/2000-06-23.parquet
  size:    9 KB
  rows:    149

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-06-23 09:00:00	SPY	ETF	145.8125	146.125	145.3438	145.375	492800.0
2000-06-23 10:00:00	SPY	ETF	145.3125	145.7188	144.8438	145.6562	580600.0
2000-06-23 11:00:00	SPY	ETF	145.75	146.0	145.4375	145.5938	1068500.0
2000-06-23 12:00:00	SPY	ETF	145.4375	145.75	144.875	145.25	138800.0
2000-06-23 13:00:00	SPY	ETF	145.25	145.5938	144.75	144.9688	251100.0
2000-06-23 14:00:00	SPY	ETF	144.9375	145.4062	144.0312	144.1875	449600.0
2000-06-23 15:00:00	SPY	ETF	144.125	144.6875	143.875	144.375	1006700.0
2000-06-23 16:00:00	SPY	ETF	144.3125	144.4688	144.1875	144.3125	709100.0
2000-06-23 09:00:00	QQQ	ETF	95.0	95.5	93.7188	93.8125	4419400.0
2000-06-23 10:00:00	QQQ	ETF	93.7188	94.4375	93.0	94.0	5049100.0
2000-06-23 11:00:00	QQQ	ETF	93.9062	94.8125	93.7812	94.1875	2710700.0
2000-06-23 12:00:00	QQQ	ETF	94.1875	94.3438	93.25	93.8125	1255900.0
2000-06-23 13:00:00	QQQ	ETF	93.625	94.125	93.0938	93.3125	1268700.0
2000-06-23 14:00:00	QQQ	ETF	93.3125	93.9375	92.3125	92.5	4003600.0
2000-06-23 15:00:00	QQQ	ETF	92.5	92.875	91.4375	91.8125	4929400.0
2000-06-23 16:00:00	QQQ	ETF	91.875	92.0	91.375	91.6875	1111600.0
2000-06-23 17:00:00	QQQ	ETF	91.6875	92.0	91.625	92.0	1300.0
2000-06-23 18:00:00	QQQ	ETF	91.6875	91.6875	91.5	91.5	200.0
2000-06-23 09:00:00	IWM	ETF	51.75	51.75	51.5	51.5	53400.0
2000-06-23 10:00:00	IWM	ETF	51.0	51.1094	50.8438	51.1094	45400.0
2000-06-23 11:00:00	IWM	ETF	51.375	51.5	51.3125	51.4844	5000.0
2000-06-23 12:00:00	IWM	ETF	51.3438	51.3438	51.3438	51.3438	400.0
2000-06-23 13:00:00	IWM	ETF	51.3125	51.4219	51.1875	51.1875	23800.0
2000-06-23 14:00:00	IWM	ETF	51.125	51.125	50.875	50.875	66200.0
2000-06-23 15:00:00	IWM	ETF	50.875	50.9062	50.5	50.6562	10800.0
2000-06-23 16:00:00	IWM	ETF	50.7812	50.9062	50.7812	50.9062	30800.0
2000-06-23 09:00:00	DIA	ETF	104.2188	104.5	104.0312	104.0312	110100.0
2000-06-23 10:00:00	DIA	ETF	104.0312	104.625	103.7812	104.625	63200.0
2000-06-23 11:00:00	DIA	ETF	104.5625	104.9688	104.4375	104.5938	170800.0
2000-06-23 12:00:00	DIA	ETF	104.5625	104.8125	104.4375	104.7812	46400.0
2000-06-23 13:00:00	DIA	ETF	104.7188	104.9688	104.375	104.375	27600.0
2000-06-23 14:00:00	DIA	ETF	104.375	104.8125	103.9375	104.0312	186900.0
2000-06-23 15:00:00	DIA	ETF	104.0312	104.5	104.0	104.1562	108000.0
2000-06-23 16:00:00	DIA	ETF	104.3438	104.4688	104.1562	104.4375	12400.0

> showing 34 of 149 rows — these rows as CSV

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