PREVIEW / etf_1hour / 2000-09-19

all etf 1-hour files

  file:    by_date/etf_1hour/2000/2000-09-19.parquet
  size:    9 KB
  rows:    167

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-19 09:00:00	SPY	ETF	145.125	145.625	144.6875	145.125	833800.0
2000-09-19 10:00:00	SPY	ETF	145.125	145.5	144.75	144.9375	669300.0
2000-09-19 11:00:00	SPY	ETF	144.9688	145.9375	144.875	145.3438	1005000.0
2000-09-19 12:00:00	SPY	ETF	145.3125	145.5	144.9688	145.125	241000.0
2000-09-19 13:00:00	SPY	ETF	145.2188	145.7188	145.1875	145.4375	518900.0
2000-09-19 14:00:00	SPY	ETF	145.25	145.75	145.25	145.75	751400.0
2000-09-19 15:00:00	SPY	ETF	145.6562	146.3125	145.5938	146.0625	2082500.0
2000-09-19 16:00:00	SPY	ETF	146.2188	146.3125	145.75	146.3125	419500.0
2000-09-19 09:00:00	QQQ	ETF	90.75	92.0625	89.875	91.5312	4949100.0
2000-09-19 10:00:00	QQQ	ETF	91.4688	92.0	90.5	90.9688	5085200.0
2000-09-19 11:00:00	QQQ	ETF	90.875	92.25	90.6875	91.7188	3346500.0
2000-09-19 12:00:00	QQQ	ETF	91.6875	91.9688	91.375	91.625	1430800.0
2000-09-19 13:00:00	QQQ	ETF	91.6562	92.7812	91.625	92.375	3174900.0
2000-09-19 14:00:00	QQQ	ETF	92.375	93.0312	92.1562	93.0	3104600.0
2000-09-19 15:00:00	QQQ	ETF	93.0312	93.7188	92.75	93.5625	5967000.0
2000-09-19 16:00:00	QQQ	ETF	93.5	93.6875	93.2188	93.5	421200.0
2000-09-19 17:00:00	QQQ	ETF	93.3125	93.375	93.1875	93.1875	14600.0
2000-09-19 18:00:00	QQQ	ETF	93.1875	93.1875	93.1875	93.1875	100.0
2000-09-19 09:00:00	IWM	ETF	51.9844	51.9844	51.9375	51.9375	800.0
2000-09-19 10:00:00	IWM	ETF	51.8125	51.875	51.8125	51.875	800.0
2000-09-19 11:00:00	IWM	ETF	51.75	51.8125	51.625	51.6875	13000.0
2000-09-19 12:00:00	IWM	ETF	51.7188	51.7188	51.7188	51.7188	1000.0
2000-09-19 13:00:00	IWM	ETF	51.75	51.7812	51.75	51.7812	3400.0
2000-09-19 14:00:00	IWM	ETF	51.6562	51.7188	51.6562	51.7188	400.0
2000-09-19 15:00:00	IWM	ETF	51.875	52.375	51.875	52.25	29400.0
2000-09-19 16:00:00	IWM	ETF	52.7188	52.7188	52.5	52.5	3800.0
2000-09-19 09:00:00	DIA	ETF	108.4375	108.4375	108.0625	108.0625	65900.0
2000-09-19 10:00:00	DIA	ETF	108.125	108.1875	107.625	107.7188	124900.0
2000-09-19 11:00:00	DIA	ETF	107.75	108.2812	107.6875	107.9062	99600.0
2000-09-19 12:00:00	DIA	ETF	107.9062	108.0625	107.7188	107.8125	37200.0
2000-09-19 13:00:00	DIA	ETF	107.9062	108.2188	107.8125	107.875	40700.0
2000-09-19 14:00:00	DIA	ETF	107.8125	108.0625	107.5938	107.9062	84700.0
2000-09-19 15:00:00	DIA	ETF	107.8438	108.3438	107.8125	107.9375	233400.0
2000-09-19 16:00:00	DIA	ETF	108.0	108.0312	107.875	107.9688	27400.0

> showing 34 of 167 rows — these rows as CSV

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