PREVIEW / etf_1hour / 2003-06-17

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-06-17.parquet
  size:    17 KB
  rows:    438

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-06-17 08:00:00	SPY	ETF	101.86	102.25	101.86	102.17	89100.0
2003-06-17 09:00:00	SPY	ETF	102.2	102.24	101.48	101.63	7246500.0
2003-06-17 10:00:00	SPY	ETF	101.65	102.07	101.23	101.46	6967600.0
2003-06-17 11:00:00	SPY	ETF	101.45	102.0	101.32	101.95	3686600.0
2003-06-17 12:00:00	SPY	ETF	101.94	101.99	101.6	101.85	1809200.0
2003-06-17 13:00:00	SPY	ETF	101.859	102.04	101.62	101.65	2959400.0
2003-06-17 14:00:00	SPY	ETF	101.65	102.13	101.5	102.0	3599100.0
2003-06-17 15:00:00	SPY	ETF	102.0	102.17	101.6	101.75	5580300.0
2003-06-17 16:00:00	SPY	ETF	101.69	101.76	101.62	101.67	1543900.0
2003-06-17 17:00:00	SPY	ETF	101.66	101.71	101.66	101.7	17900.0
2003-06-17 18:00:00	SPY	ETF	101.65	101.71	101.65	101.71	10700.0
2003-06-17 19:00:00	SPY	ETF	101.77	101.84	101.77	101.84	2200.0
2003-06-17 08:00:00	QQQ	ETF	30.93	31.11	30.93	31.08	145400.0
2003-06-17 09:00:00	QQQ	ETF	31.08	31.11	30.62	30.74	15435900.0
2003-06-17 10:00:00	QQQ	ETF	30.73	30.94	30.56	30.7	12757000.0
2003-06-17 11:00:00	QQQ	ETF	30.71	30.89	30.61	30.869	6860300.0
2003-06-17 12:00:00	QQQ	ETF	30.88	30.89	30.72	30.81	3297500.0
2003-06-17 13:00:00	QQQ	ETF	30.81	30.9	30.7	30.72	3679400.0
2003-06-17 14:00:00	QQQ	ETF	30.71	30.97	30.67	30.92	5934300.0
2003-06-17 15:00:00	QQQ	ETF	30.92	30.95	30.72	30.79	7209900.0
2003-06-17 16:00:00	QQQ	ETF	30.79	30.81	30.73	30.78	1008200.0
2003-06-17 17:00:00	QQQ	ETF	30.79	30.81	30.78	30.81	103300.0
2003-06-17 18:00:00	QQQ	ETF	30.81	30.81	30.758	30.8	58700.0
2003-06-17 19:00:00	QQQ	ETF	30.81	30.83	30.8	30.83	2400.0
2003-06-17 09:00:00	IWM	ETF	45.815	45.85	45.325	45.375	603000.0
2003-06-17 10:00:00	IWM	ETF	45.375	45.625	45.32	45.425	1365400.0
2003-06-17 11:00:00	IWM	ETF	45.405	45.585	45.405	45.58	309800.0
2003-06-17 12:00:00	IWM	ETF	45.57	45.6	45.475	45.59	181800.0
2003-06-17 13:00:00	IWM	ETF	45.595	45.71	45.575	45.61	275800.0
2003-06-17 14:00:00	IWM	ETF	45.605	45.745	45.55	45.72	215000.0
2003-06-17 15:00:00	IWM	ETF	45.705	45.77	45.61	45.65	424000.0
2003-06-17 16:00:00	IWM	ETF	45.625	45.67	45.575	45.575	17600.0
2003-06-17 17:00:00	IWM	ETF	45.32	45.32	45.32	45.32	2000.0
2003-06-17 08:00:00	DIA	ETF	93.68	93.95	93.64	93.95	17300.0
2003-06-17 09:00:00	DIA	ETF	93.92	93.96	93.25	93.45	1825400.0
2003-06-17 10:00:00	DIA	ETF	93.46	93.83	93.01	93.246	1352400.0
2003-06-17 11:00:00	DIA	ETF	93.23	93.79	93.1	93.7	857900.0
2003-06-17 12:00:00	DIA	ETF	93.72	93.72	93.35	93.6	403300.0
2003-06-17 13:00:00	DIA	ETF	93.626	93.77	93.36	93.36	486800.0
2003-06-17 14:00:00	DIA	ETF	93.39	93.78	93.21	93.661	742600.0
2003-06-17 15:00:00	DIA	ETF	93.67	93.87	93.41	93.49	983400.0
2003-06-17 16:00:00	DIA	ETF	93.47	93.645	93.42	93.42	362500.0
2003-06-17 17:00:00	DIA	ETF	93.46	93.46	93.46	93.46	500.0
2003-06-17 18:00:00	DIA	ETF	93.46	93.51	93.45	93.51	4900.0
2003-06-17 09:00:00	TLT	ETF	95.97	96.031	95.77	95.77	138200.0
2003-06-17 10:00:00	TLT	ETF	95.77	95.99	95.72	95.88	180000.0
2003-06-17 11:00:00	TLT	ETF	95.91	95.91	95.46	95.6	135400.0
2003-06-17 12:00:00	TLT	ETF	95.57	95.64	95.4	95.6	69400.0
2003-06-17 13:00:00	TLT	ETF	95.63	95.67	95.49	95.59	34800.0
2003-06-17 14:00:00	TLT	ETF	95.56	95.6	95.4	95.44	43000.0

> showing 50 of 438 rows — these rows as CSV

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