PREVIEW / etf_1hour / 2000-09-06

all etf 1-hour files

  file:    by_date/etf_1hour/2000/2000-09-06.parquet
  size:    9 KB
  rows:    183

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-06 09:00:00	SPY	ETF	151.1875	151.7812	151.125	151.625	674800.0
2000-09-06 10:00:00	SPY	ETF	151.5625	151.7188	151.0	151.125	550500.0
2000-09-06 11:00:00	SPY	ETF	151.125	151.125	150.625	151.0625	371000.0
2000-09-06 12:00:00	SPY	ETF	151.0938	151.3125	150.875	151.1875	149000.0
2000-09-06 13:00:00	SPY	ETF	151.1875	151.25	150.25	150.25	323900.0
2000-09-06 14:00:00	SPY	ETF	150.3125	150.75	150.0	150.2188	510900.0
2000-09-06 15:00:00	SPY	ETF	150.2188	150.2188	149.6875	149.6875	1176300.0
2000-09-06 16:00:00	SPY	ETF	149.5938	149.7812	149.5312	149.5625	441300.0
2000-09-06 09:00:00	QQQ	ETF	99.25	99.4688	98.5312	99.25	3079000.0
2000-09-06 10:00:00	QQQ	ETF	99.2812	99.4688	98.0625	98.1562	3432800.0
2000-09-06 11:00:00	QQQ	ETF	98.1875	98.25	97.75	98.0	2390500.0
2000-09-06 12:00:00	QQQ	ETF	98.0625	98.75	97.8125	98.4375	1465700.0
2000-09-06 13:00:00	QQQ	ETF	98.4375	98.4688	97.0	97.0312	2689200.0
2000-09-06 14:00:00	QQQ	ETF	97.0625	97.625	96.6875	96.9375	2203500.0
2000-09-06 15:00:00	QQQ	ETF	96.875	96.9375	95.75	95.875	4701600.0
2000-09-06 16:00:00	QQQ	ETF	95.9062	96.4375	95.75	95.75	787700.0
2000-09-06 17:00:00	QQQ	ETF	95.9375	96.0	95.5	96.0	10500.0
2000-09-06 18:00:00	QQQ	ETF	96.0	96.0	96.0	96.0	400.0
2000-09-06 09:00:00	IWM	ETF	54.0625	54.0625	53.8438	53.8438	1800.0
2000-09-06 10:00:00	IWM	ETF	53.9375	53.9844	53.5938	53.7656	203200.0
2000-09-06 11:00:00	IWM	ETF	53.625	53.6562	53.5	53.5	3000.0
2000-09-06 12:00:00	IWM	ETF	53.625	53.8125	53.625	53.8125	2600.0
2000-09-06 13:00:00	IWM	ETF	53.625	53.625	53.625	53.625	400.0
2000-09-06 14:00:00	IWM	ETF	53.625	53.7656	53.5938	53.5938	600.0
2000-09-06 15:00:00	IWM	ETF	53.7812	53.7812	53.5469	53.5781	5600.0
2000-09-06 16:00:00	IWM	ETF	53.7656	53.7656	53.5781	53.5781	600.0
2000-09-06 09:00:00	DIA	ETF	113.0312	113.9062	113.0312	113.6875	53800.0
2000-09-06 10:00:00	DIA	ETF	113.75	113.875	113.3125	113.5938	202300.0
2000-09-06 11:00:00	DIA	ETF	113.5938	113.6875	113.375	113.5	56500.0
2000-09-06 12:00:00	DIA	ETF	113.5938	114.0938	113.5625	114.0625	113400.0
2000-09-06 13:00:00	DIA	ETF	114.0	114.0938	113.375	113.375	139600.0
2000-09-06 14:00:00	DIA	ETF	113.4375	113.6875	113.1875	113.375	48000.0
2000-09-06 15:00:00	DIA	ETF	113.3125	113.5938	113.0625	113.1562	75600.0
2000-09-06 16:00:00	DIA	ETF	113.125	113.25	113.0938	113.1875	25900.0

> showing 34 of 183 rows — these rows as CSV

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