PREVIEW / etf_1hour / 2000-09-20

all etf 1-hour files

  file:    by_date/etf_1hour/2000/2000-09-20.parquet
  size:    10 KB
  rows:    177

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-20 09:00:00	SPY	ETF	145.6875	146.0312	144.6875	144.875	515200.0
2000-09-20 10:00:00	SPY	ETF	145.0	145.3438	144.25	144.5625	423300.0
2000-09-20 11:00:00	SPY	ETF	144.625	144.8125	144.0	144.4062	571500.0
2000-09-20 12:00:00	SPY	ETF	144.375	144.5	143.6562	144.0312	416600.0
2000-09-20 13:00:00	SPY	ETF	144.0625	144.1875	143.1562	143.875	677800.0
2000-09-20 14:00:00	SPY	ETF	143.9062	145.6875	143.7812	145.4062	1859900.0
2000-09-20 15:00:00	SPY	ETF	145.4062	145.7188	144.8125	145.2188	1828600.0
2000-09-20 16:00:00	SPY	ETF	145.1875	145.25	144.875	144.875	190200.0
2000-09-20 09:00:00	QQQ	ETF	93.375	94.3125	92.375	92.875	3031700.0
2000-09-20 10:00:00	QQQ	ETF	92.75	93.9375	92.4375	93.0938	4430700.0
2000-09-20 11:00:00	QQQ	ETF	93.0938	93.1875	92.0625	92.5625	3560900.0
2000-09-20 12:00:00	QQQ	ETF	92.625	93.1875	91.5	92.25	2797900.0
2000-09-20 13:00:00	QQQ	ETF	92.125	92.4375	91.3125	92.4375	4934400.0
2000-09-20 14:00:00	QQQ	ETF	92.4062	94.9688	92.3125	94.5625	8773900.0
2000-09-20 15:00:00	QQQ	ETF	94.5625	95.2188	93.875	94.5	4966300.0
2000-09-20 16:00:00	QQQ	ETF	94.5938	95.0	94.4375	94.75	395500.0
2000-09-20 17:00:00	QQQ	ETF	94.75	95.0	94.5625	94.5625	7000.0
2000-09-20 18:00:00	QQQ	ETF	94.6875	94.6875	94.625	94.625	1600.0
2000-09-20 09:00:00	IWM	ETF	52.3125	52.3125	52.3125	52.3125	1400.0
2000-09-20 10:00:00	IWM	ETF	52.125	52.2656	51.9688	52.1875	6400.0
2000-09-20 11:00:00	IWM	ETF	52.1562	52.1875	51.9062	52.0625	9600.0
2000-09-20 12:00:00	IWM	ETF	52.0	52.0	51.9375	51.9375	3000.0
2000-09-20 13:00:00	IWM	ETF	51.8125	51.9062	51.625	51.9062	9200.0
2000-09-20 14:00:00	IWM	ETF	52.0312	52.2656	51.9062	52.1562	5600.0
2000-09-20 15:00:00	IWM	ETF	52.125	52.125	52.0625	52.0625	2400.0
2000-09-20 16:00:00	IWM	ETF	51.9062	51.9062	51.9062	51.9062	600.0
2000-09-20 09:00:00	DIA	ETF	108.0	108.375	107.5312	107.6562	503900.0
2000-09-20 10:00:00	DIA	ETF	107.7812	107.7812	106.875	107.1562	397800.0
2000-09-20 11:00:00	DIA	ETF	107.0625	107.3438	106.6875	106.875	381100.0
2000-09-20 12:00:00	DIA	ETF	106.875	106.9688	105.9375	106.25	554400.0
2000-09-20 13:00:00	DIA	ETF	106.3125	106.4375	105.5312	106.0938	757900.0
2000-09-20 14:00:00	DIA	ETF	106.0938	107.3438	106.0312	107.1562	817200.0
2000-09-20 15:00:00	DIA	ETF	107.125	107.3125	106.625	107.0	305500.0
2000-09-20 16:00:00	DIA	ETF	106.9375	106.9688	106.8125	106.9375	8900.0

> showing 34 of 177 rows — these rows as CSV

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