PREVIEW / etf_1hour / 2003-09-22

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-09-22.parquet
  size:    17 KB
  rows:    435

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
2003-09-22 08:00:00	SPY	ETF	102.74	102.98	102.72	102.92	86200.0
2003-09-22 09:00:00	SPY	ETF	102.91	102.96	102.42	102.45	7012500.0
2003-09-22 10:00:00	SPY	ETF	102.45	102.61	102.22	102.45	6732200.0
2003-09-22 11:00:00	SPY	ETF	102.46	102.72	102.34	102.45	3301400.0
2003-09-22 12:00:00	SPY	ETF	102.47	102.54	102.268	102.41	2170200.0
2003-09-22 13:00:00	SPY	ETF	102.43	102.56	102.33	102.41	1465800.0
2003-09-22 14:00:00	SPY	ETF	102.41	102.49	102.03	102.212	5001600.0
2003-09-22 15:00:00	SPY	ETF	102.22	102.58	102.2	102.49	3707800.0
2003-09-22 16:00:00	SPY	ETF	102.46	102.62	102.45	102.55	1173200.0
2003-09-22 17:00:00	SPY	ETF	102.56	102.6	102.52	102.6	23800.0
2003-09-22 18:00:00	SPY	ETF	102.56	102.64	102.56	102.64	9100.0
2003-09-22 19:00:00	SPY	ETF	102.63	102.7	102.63	102.7	3400.0
2003-09-22 08:00:00	QQQ	ETF	34.1	34.16	34.06	34.15	318600.0
2003-09-22 09:00:00	QQQ	ETF	34.14	34.2	33.9	33.93	20153200.0
2003-09-22 10:00:00	QQQ	ETF	33.93	34.097	33.85	34.03	15320700.0
2003-09-22 11:00:00	QQQ	ETF	34.02	34.148	33.95	34.0	10562600.0
2003-09-22 12:00:00	QQQ	ETF	34.0	34.05	33.917	33.99	6393800.0
2003-09-22 13:00:00	QQQ	ETF	33.98	34.05	33.92	33.95	5864900.0
2003-09-22 14:00:00	QQQ	ETF	33.94	33.98	33.77	33.82	13855800.0
2003-09-22 15:00:00	QQQ	ETF	33.819	33.98	33.8	33.95	11662700.0
2003-09-22 16:00:00	QQQ	ETF	33.941	33.96	33.87	33.96	1591000.0
2003-09-22 17:00:00	QQQ	ETF	33.95	33.96	33.92	33.93	22100.0
2003-09-22 18:00:00	QQQ	ETF	33.93	33.94	33.93	33.93	7800.0
2003-09-22 19:00:00	QQQ	ETF	33.94	33.96	33.94	33.96	6700.0
2003-09-22 09:00:00	IWM	ETF	51.1	51.135	50.925	50.95	951400.0
2003-09-22 10:00:00	IWM	ETF	50.935	51.14	50.87	51.03	571600.0
2003-09-22 11:00:00	IWM	ETF	51.025	51.245	50.975	51.1	318600.0
2003-09-22 12:00:00	IWM	ETF	51.14	51.2	51.12	51.185	63200.0
2003-09-22 13:00:00	IWM	ETF	51.18	51.44	51.165	51.335	444000.0
2003-09-22 14:00:00	IWM	ETF	51.335	51.335	50.975	51.07	1058800.0
2003-09-22 15:00:00	IWM	ETF	51.065	51.225	51.065	51.075	415000.0
2003-09-22 16:00:00	IWM	ETF	51.1	51.1	50.95	51.09	102600.0
2003-09-22 08:00:00	DIA	ETF	95.74	95.84	95.71	95.84	11100.0
2003-09-22 09:00:00	DIA	ETF	95.84	95.85	95.45	95.46	1330700.0
2003-09-22 10:00:00	DIA	ETF	95.451	95.77	95.26	95.62	1315000.0
2003-09-22 11:00:00	DIA	ETF	95.62	95.79	95.51	95.62	614900.0
2003-09-22 12:00:00	DIA	ETF	95.58	95.63	95.46	95.48	507800.0
2003-09-22 13:00:00	DIA	ETF	95.5	95.62	95.45	95.49	311300.0
2003-09-22 14:00:00	DIA	ETF	95.54	95.54	95.14	95.27	611900.0
2003-09-22 15:00:00	DIA	ETF	95.29	95.57	95.27	95.48	921400.0
2003-09-22 16:00:00	DIA	ETF	95.46	95.6	95.42	95.53	78900.0
2003-09-22 17:00:00	DIA	ETF	95.6	95.6	95.54	95.55	1300.0
2003-09-22 18:00:00	DIA	ETF	95.55	95.55	95.55	95.55	600.0
2003-09-22 19:00:00	DIA	ETF	95.64	95.64	95.64	95.64	100.0
2003-09-22 09:00:00	TLT	ETF	85.0	85.18	84.76	84.76	233900.0
2003-09-22 10:00:00	TLT	ETF	84.77	84.82	84.41	84.54	227700.0
2003-09-22 11:00:00	TLT	ETF	84.45	84.45	84.23	84.45	198000.0
2003-09-22 12:00:00	TLT	ETF	84.45	84.68	84.37	84.6	52700.0
2003-09-22 13:00:00	TLT	ETF	84.56	84.75	84.42	84.723	40500.0
2003-09-22 14:00:00	TLT	ETF	84.71	85.05	84.71	84.91	138600.0

> showing 50 of 435 rows — these rows as CSV

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