PREVIEW / etf_1hour / 2001-08-23

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-08-23.parquet
  size:    11 KB
  rows:    220

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
2001-08-23 09:00:00	SPY	ETF	116.96	117.32	116.72	117.19	1210900.0
2001-08-23 10:00:00	SPY	ETF	117.2	117.52	116.98	117.17	1506000.0
2001-08-23 11:00:00	SPY	ETF	117.18	117.26	116.85	117.03	1112700.0
2001-08-23 12:00:00	SPY	ETF	117.04	117.48	116.94	117.3	736300.0
2001-08-23 13:00:00	SPY	ETF	117.27	117.44	117.01	117.12	477000.0
2001-08-23 14:00:00	SPY	ETF	117.11	117.26	116.52	116.82	1279400.0
2001-08-23 15:00:00	SPY	ETF	116.84	117.11	116.7	116.7	1211800.0
2001-08-23 16:00:00	SPY	ETF	116.7	117.24	116.44	116.9	731200.0
2001-08-23 17:00:00	SPY	ETF	116.85	117.0	116.85	116.93	27800.0
2001-08-23 18:00:00	SPY	ETF	117.0	117.1	117.0	117.1	5500.0
2001-08-23 09:00:00	QQQ	ETF	37.67	38.3	37.55	38.22	8589500.0
2001-08-23 10:00:00	QQQ	ETF	38.2	38.46	38.04	38.08	10764900.0
2001-08-23 11:00:00	QQQ	ETF	38.07	38.23	37.83	37.96	5507000.0
2001-08-23 12:00:00	QQQ	ETF	37.97	38.22	37.88	38.06	3882300.0
2001-08-23 13:00:00	QQQ	ETF	38.05	38.12	37.73	37.85	4117100.0
2001-08-23 14:00:00	QQQ	ETF	37.8	37.95	37.35	37.66	8249600.0
2001-08-23 15:00:00	QQQ	ETF	37.66	37.85	37.31	37.32	7421800.0
2001-08-23 16:00:00	QQQ	ETF	37.32	38.32	37.29	37.74	2202500.0
2001-08-23 17:00:00	QQQ	ETF	37.75	38.0	37.34	37.95	323700.0
2001-08-23 18:00:00	QQQ	ETF	37.95	38.15	37.95	38.04	239100.0
2001-08-23 09:00:00	IWM	ETF	47.6	47.845	47.6	47.845	25800.0
2001-08-23 10:00:00	IWM	ETF	47.935	47.995	47.805	47.9	218400.0
2001-08-23 11:00:00	IWM	ETF	47.725	47.77	47.6	47.6	75000.0
2001-08-23 12:00:00	IWM	ETF	47.7	47.75	47.675	47.75	15800.0
2001-08-23 13:00:00	IWM	ETF	47.8	47.8	47.6	47.64	46800.0
2001-08-23 14:00:00	IWM	ETF	47.645	47.645	47.4	47.4	28800.0
2001-08-23 15:00:00	IWM	ETF	47.525	47.55	47.205	47.205	364600.0
2001-08-23 16:00:00	IWM	ETF	47.155	47.155	47.05	47.05	64800.0
2001-08-23 09:00:00	DIA	ETF	102.65	102.97	102.6	102.74	296100.0
2001-08-23 10:00:00	DIA	ETF	102.73	103.04	102.57	102.74	517200.0
2001-08-23 11:00:00	DIA	ETF	102.72	102.74	102.46	102.6	209800.0
2001-08-23 12:00:00	DIA	ETF	102.59	102.9	102.53	102.79	85200.0
2001-08-23 13:00:00	DIA	ETF	102.73	102.84	102.62	102.74	176800.0
2001-08-23 14:00:00	DIA	ETF	102.75	102.92	102.23	102.54	601600.0
2001-08-23 15:00:00	DIA	ETF	102.58	102.69	102.42	102.48	235200.0
2001-08-23 16:00:00	DIA	ETF	102.47	102.47	102.35	102.45	45900.0
2001-08-23 18:00:00	DIA	ETF	102.65	102.77	102.65	102.77	2000.0

> showing 37 of 220 rows — these rows as CSV

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