PREVIEW / etf_1hour / 2003-09-15

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-09-15.parquet
  size:    17 KB
  rows:    413

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-15 08:00:00	SPY	ETF	102.63	102.63	102.5	102.55	64100.0
2003-09-15 09:00:00	SPY	ETF	102.55	102.6	102.23	102.42	4364500.0
2003-09-15 10:00:00	SPY	ETF	102.41	102.63	102.28	102.38	2690400.0
2003-09-15 11:00:00	SPY	ETF	102.35	102.41	102.05	102.19	2940000.0
2003-09-15 12:00:00	SPY	ETF	102.19	102.26	101.95	102.18	1716900.0
2003-09-15 13:00:00	SPY	ETF	102.188	102.38	102.09	102.16	1297300.0
2003-09-15 14:00:00	SPY	ETF	102.17	102.38	102.1	102.18	1857200.0
2003-09-15 15:00:00	SPY	ETF	102.17	102.38	102.01	102.12	3018400.0
2003-09-15 16:00:00	SPY	ETF	102.12	102.18	102.0	102.08	1413500.0
2003-09-15 17:00:00	SPY	ETF	102.08	102.1	102.05	102.05	10900.0
2003-09-15 18:00:00	SPY	ETF	102.06	102.06	102.02	102.02	1800.0
2003-09-15 08:00:00	QQQ	ETF	33.89	33.89	33.84	33.86	67100.0
2003-09-15 09:00:00	QQQ	ETF	33.85	33.91	33.664	33.75	9510800.0
2003-09-15 10:00:00	QQQ	ETF	33.75	33.86	33.63	33.65	9538200.0
2003-09-15 11:00:00	QQQ	ETF	33.66	33.68	33.53	33.61	7022000.0
2003-09-15 12:00:00	QQQ	ETF	33.61	33.69	33.52	33.63	4099700.0
2003-09-15 13:00:00	QQQ	ETF	33.63	33.7	33.56	33.6	4204000.0
2003-09-15 14:00:00	QQQ	ETF	33.61	33.63	33.47	33.51	5405100.0
2003-09-15 15:00:00	QQQ	ETF	33.5	33.63	33.444	33.481	7279400.0
2003-09-15 16:00:00	QQQ	ETF	33.49	33.7576	33.46	33.527	3508200.0
2003-09-15 17:00:00	QQQ	ETF	33.53	33.54	33.51	33.52	38900.0
2003-09-15 18:00:00	QQQ	ETF	33.511	33.539	33.499	33.51	29000.0
2003-09-15 19:00:00	QQQ	ETF	33.51	33.54	33.5	33.54	8100.0
2003-09-15 09:00:00	IWM	ETF	50.75	51.15	50.75	51.0	483000.0
2003-09-15 10:00:00	IWM	ETF	51.0	51.1	50.925	50.985	697400.0
2003-09-15 11:00:00	IWM	ETF	50.985	50.985	50.8	50.955	526800.0
2003-09-15 12:00:00	IWM	ETF	51.0	51.0	50.835	50.88	312000.0
2003-09-15 13:00:00	IWM	ETF	50.88	50.89	50.7	50.725	843800.0
2003-09-15 14:00:00	IWM	ETF	50.71	50.77	50.59	50.59	645200.0
2003-09-15 15:00:00	IWM	ETF	50.59	50.685	50.525	50.56	764600.0
2003-09-15 16:00:00	IWM	ETF	50.575	50.59	50.545	50.58	78000.0
2003-09-15 08:00:00	DIA	ETF	95.15	95.19	95.13	95.13	500.0
2003-09-15 09:00:00	DIA	ETF	95.13	95.21	94.81	95.0	618100.0
2003-09-15 10:00:00	DIA	ETF	94.99	95.16	94.91	94.99	756100.0
2003-09-15 11:00:00	DIA	ETF	95.01	95.03	94.744	94.84	433600.0
2003-09-15 12:00:00	DIA	ETF	94.86	94.98	94.69	94.88	270200.0
2003-09-15 13:00:00	DIA	ETF	94.89	95.06	94.8	94.88	265700.0
2003-09-15 14:00:00	DIA	ETF	94.87	95.09	94.79	94.92	598000.0
2003-09-15 15:00:00	DIA	ETF	94.92	95.13	94.81	94.88	383900.0
2003-09-15 16:00:00	DIA	ETF	94.926	94.93	94.76	94.77	41600.0
2003-09-15 09:00:00	TLT	ETF	84.5	84.54	84.28	84.29	50400.0
2003-09-15 10:00:00	TLT	ETF	84.36	84.36	84.11	84.21	110800.0
2003-09-15 11:00:00	TLT	ETF	84.21	84.52	84.21	84.5	79300.0
2003-09-15 12:00:00	TLT	ETF	84.48	84.63	84.46	84.53	13700.0
2003-09-15 13:00:00	TLT	ETF	84.54	84.79	84.45	84.75	25000.0
2003-09-15 14:00:00	TLT	ETF	84.71	84.89	84.66	84.7	45500.0
2003-09-15 15:00:00	TLT	ETF	84.64	84.64	84.36	84.56	23500.0
2003-09-15 16:00:00	TLT	ETF	84.56	84.58	84.55	84.55	6400.0

> showing 48 of 413 rows — these rows as CSV

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