PREVIEW / etf_1hour / 2000-08-01

all etf 1-hour files

  file:    by_date/etf_1hour/2000/2000-08-01.parquet
  size:    9 KB
  rows:    169

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-08-01 09:00:00	SPY	ETF	143.625	143.9375	143.125	143.5938	675600.0
2000-08-01 10:00:00	SPY	ETF	143.5312	143.9688	143.125	143.9375	451300.0
2000-08-01 11:00:00	SPY	ETF	143.875	144.25	143.7188	143.9062	670700.0
2000-08-01 12:00:00	SPY	ETF	143.8438	144.0625	143.5312	143.9688	298000.0
2000-08-01 13:00:00	SPY	ETF	143.8438	144.1562	143.6875	144.1562	199900.0
2000-08-01 14:00:00	SPY	ETF	144.0938	144.7188	144.0312	144.125	592700.0
2000-08-01 15:00:00	SPY	ETF	144.0625	144.3438	143.625	144.0	813300.0
2000-08-01 16:00:00	SPY	ETF	143.9688	143.9688	143.625	143.875	217300.0
2000-08-01 09:00:00	QQQ	ETF	89.8125	89.9688	88.5	88.9375	2864800.0
2000-08-01 10:00:00	QQQ	ETF	88.9375	89.25	88.25	88.9688	3141100.0
2000-08-01 11:00:00	QQQ	ETF	89.0	89.5	88.5938	88.9375	1923500.0
2000-08-01 12:00:00	QQQ	ETF	88.9375	89.25	88.6562	88.75	922700.0
2000-08-01 13:00:00	QQQ	ETF	88.75	89.0312	88.4375	89.0	1026300.0
2000-08-01 14:00:00	QQQ	ETF	89.0312	89.5625	88.25	88.25	1731300.0
2000-08-01 15:00:00	QQQ	ETF	88.25	88.4375	87.6875	87.9688	3489900.0
2000-08-01 16:00:00	QQQ	ETF	88.0	88.5	87.875	88.4375	577400.0
2000-08-01 17:00:00	QQQ	ETF	87.75	87.75	87.75	87.75	400.0
2000-08-01 18:00:00	QQQ	ETF	88.0	88.25	88.0	88.25	1500.0
2000-08-01 09:00:00	IWM	ETF	49.875	49.9375	49.875	49.9375	65400.0
2000-08-01 10:00:00	IWM	ETF	49.9375	50.0312	49.9375	50.0	82000.0
2000-08-01 11:00:00	IWM	ETF	50.0	50.0625	50.0	50.0625	18200.0
2000-08-01 12:00:00	IWM	ETF	50.0312	50.0312	50.0312	50.0312	19200.0
2000-08-01 13:00:00	IWM	ETF	50.0	50.0	49.875	49.875	20800.0
2000-08-01 14:00:00	IWM	ETF	49.9688	50.0625	49.9688	50.0625	50400.0
2000-08-01 15:00:00	IWM	ETF	49.8906	49.9219	49.6406	49.9219	7400.0
2000-08-01 09:00:00	DIA	ETF	105.5312	105.5938	105.0938	105.5938	70400.0
2000-08-01 10:00:00	DIA	ETF	105.3125	105.8125	105.0312	105.7188	97700.0
2000-08-01 11:00:00	DIA	ETF	105.75	105.75	105.375	105.5938	9900.0
2000-08-01 12:00:00	DIA	ETF	105.3125	105.5938	105.2812	105.5938	10500.0
2000-08-01 13:00:00	DIA	ETF	105.5312	105.875	105.5	105.875	23000.0
2000-08-01 14:00:00	DIA	ETF	105.9375	106.1875	105.875	105.9062	69200.0
2000-08-01 15:00:00	DIA	ETF	105.75	106.3125	105.625	106.0	88900.0
2000-08-01 16:00:00	DIA	ETF	106.0	106.0	105.5312	105.5312	12000.0

> showing 33 of 169 rows — these rows as CSV

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