PREVIEW / etf_1hour / 2003-11-17

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-11-17.parquet
  size:    20 KB
  rows:    505

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-11-17 08:00:00	SPY	ETF	104.9	104.96	104.77	104.8	265200.0
2003-11-17 09:00:00	SPY	ETF	104.82	105.14	104.8	104.82	4468800.0
2003-11-17 10:00:00	SPY	ETF	104.85	104.87	104.48	104.66	8818100.0
2003-11-17 11:00:00	SPY	ETF	104.65	104.69	104.211	104.55	5724600.0
2003-11-17 12:00:00	SPY	ETF	104.55	104.59	104.34	104.48	2470000.0
2003-11-17 13:00:00	SPY	ETF	104.47	104.48	104.04	104.27	4889100.0
2003-11-17 14:00:00	SPY	ETF	104.3	104.5	104.18	104.48	4468600.0
2003-11-17 15:00:00	SPY	ETF	104.48	105.04	104.23	104.86	6224700.0
2003-11-17 16:00:00	SPY	ETF	104.86	105.0	104.81	105.0	1493400.0
2003-11-17 17:00:00	SPY	ETF	104.99	105.03	104.93	104.95	63500.0
2003-11-17 18:00:00	SPY	ETF	104.99	105.05	104.96	104.96	25000.0
2003-11-17 19:00:00	SPY	ETF	104.94	104.95	104.92	104.95	2000.0
2003-11-17 08:00:00	QQQ	ETF	34.81	34.82	34.71	34.75	346000.0
2003-11-17 09:00:00	QQQ	ETF	34.76	34.91	34.73	34.744	12558300.0
2003-11-17 10:00:00	QQQ	ETF	34.75	34.79	34.53	34.68	18050700.0
2003-11-17 11:00:00	QQQ	ETF	34.68	34.69	34.41	34.57	14022000.0
2003-11-17 12:00:00	QQQ	ETF	34.572	34.6	34.46	34.5	6790000.0
2003-11-17 13:00:00	QQQ	ETF	34.51	34.52	34.26	34.344	10996700.0
2003-11-17 14:00:00	QQQ	ETF	34.35	34.47	34.297	34.46	13087900.0
2003-11-17 15:00:00	QQQ	ETF	34.45	34.67	34.31	34.62	18843400.0
2003-11-17 16:00:00	QQQ	ETF	34.62	34.731	34.46	34.68	3545800.0
2003-11-17 17:00:00	QQQ	ETF	34.68	34.72	34.66	34.68	49600.0
2003-11-17 18:00:00	QQQ	ETF	34.66	34.72	34.5046	34.67	390800.0
2003-11-17 19:00:00	QQQ	ETF	34.67	34.67	34.61	34.66	9300.0
2003-11-17 09:00:00	IWM	ETF	52.73	52.737	52.34	52.35	958200.0
2003-11-17 10:00:00	IWM	ETF	52.3	52.305	51.945	52.135	1556000.0
2003-11-17 11:00:00	IWM	ETF	52.135	52.165	51.945	52.015	1002000.0
2003-11-17 12:00:00	IWM	ETF	52.02	52.257	51.98	52.19	680000.0
2003-11-17 13:00:00	IWM	ETF	52.19	52.215	51.995	52.155	396600.0
2003-11-17 14:00:00	IWM	ETF	52.155	52.375	52.125	52.365	689800.0
2003-11-17 15:00:00	IWM	ETF	52.375	52.75	52.22	52.525	2355800.0
2003-11-17 16:00:00	IWM	ETF	52.49	52.525	52.27	52.493	396600.0
2003-11-17 17:00:00	IWM	ETF	52.45	52.45	52.45	52.45	200.0
2003-11-17 18:00:00	IWM	ETF	52.4535	52.4535	52.4535	52.4535	60000.0
2003-11-17 08:00:00	DIA	ETF	97.51	97.51	97.34	97.45	7300.0
2003-11-17 09:00:00	DIA	ETF	97.42	97.71	97.4	97.45	524200.0
2003-11-17 10:00:00	DIA	ETF	97.45	97.49	97.19	97.3	946900.0
2003-11-17 11:00:00	DIA	ETF	97.31	97.33	96.86	97.159	1024400.0
2003-11-17 12:00:00	DIA	ETF	97.16	97.19	96.93	97.06	390400.0
2003-11-17 13:00:00	DIA	ETF	97.05	97.05	96.63	96.85	468100.0
2003-11-17 14:00:00	DIA	ETF	96.89	97.06	96.76	97.05	572700.0
2003-11-17 15:00:00	DIA	ETF	97.07	97.67	96.862	97.43	1349900.0
2003-11-17 16:00:00	DIA	ETF	97.42	97.54	97.41	97.49	55700.0
2003-11-17 17:00:00	DIA	ETF	97.52	97.53	97.52	97.53	200.0
2003-11-17 18:00:00	DIA	ETF	97.55	97.55	97.55	97.55	100.0
2003-11-17 09:00:00	TLT	ETF	86.14	86.21	86.06	86.13	78200.0
2003-11-17 10:00:00	TLT	ETF	86.16	86.46	86.16	86.38	68800.0
2003-11-17 11:00:00	TLT	ETF	86.35	86.59	86.15	86.15	142600.0
2003-11-17 12:00:00	TLT	ETF	86.1	86.12	85.95	86.1	110500.0
2003-11-17 13:00:00	TLT	ETF	86.15	86.33	86.08	86.14	108600.0

> showing 50 of 505 rows — these rows as CSV

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