PREVIEW / etf_daily / 2005-06-27

all etf daily files

  file:    by_date/etf_daily/2005/2005-06-27.parquet
  size:    15 KB
  rows:    275

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2005-06-27	SPY	ETF	118.97	119.41	118.75	119.15	48183800.0
2005-06-27	QQQ	ETF	36.95	37.06	36.7	36.8	72888203.0
2005-06-27	IWM	ETF	62.28	62.59	62.1	62.37	19839000.0
2005-06-27	DIA	ETF	102.84	103.26	102.44	102.95	9047400.0
2005-06-27	GLD	ETF	43.9	43.93	43.73	43.91	1016600.0
2005-06-27	TLT	ETF	96.49	96.81	96.35	96.65	1203600.0
2005-06-27	AAA	ETF	57.67	57.67	57.39	57.39	600.0
2005-06-27	ADRE	ETF	87.69	91.088	87.69	91.01	7408.0
2005-06-27	AFK	ETF	26.0	26.34	26.0	26.1	6800.0
2005-06-27	AGG	ETF	103.39	103.47	103.28	103.4	198400.0
2005-06-27	AIQ	ETF	51.15	52.35	50.95	52.0	25300.0
2005-06-27	AIS	ETF	1.09	1.09	1.01	1.04	69900.0
2005-06-27	ARB	ETF	42.03	42.26	41.84	42.05	131400.0
2005-06-27	BAB	ETF	48.51	48.53	47.56	47.61	44100.0
2005-06-27	BBH	ETF	55.83	55.97	55.4467	55.5167	811800.0
2005-06-27	BCM	ETF	62.23	62.54	61.88	62.48	7900.0
2005-06-27	BIS	ETF	600.0	612.8	600.0	609.6	29.4
2005-06-27	BITS	ETF	12.0	12.36	12.0	12.276	1986.0
2005-06-27	BKF	ETF	38.1	38.58	37.85	37.89	11200.0
2005-06-27	BNE	ETF	14.17	14.17	14.02	14.04	86600.0
2005-06-27	BOSS	ETF	27.0	27.0	26.7	26.7	100.0
2005-06-27	BRF	ETF	15.46	15.5	15.4	15.46	15400.0
2005-06-27	BTF	ETF	85.05	85.39999999999999	85.05	85.39999999999999	1840.0
2005-06-27	CBON	ETF	29.46	30.98	29.13	30.89	27566.0
2005-06-27	CDC	ETF	6.72	6.72	6.51	6.54	15100.0
2005-06-27	CDL	ETF	12.04	12.15	11.93	12.01	333900.0
2005-06-27	CEF	ETF	5.42	5.42	5.36	5.38	162400.0
2005-06-27	CEW	ETF	26.5	26.65	26.5	26.65	1800.0
2005-06-27	CHB	ETF	9.67	9.96	9.56	9.74	243300.0
2005-06-27	CHI	ETF	19.41	19.46	19.3	19.37	100500.0
2005-06-27	CHIC	ETF	12.08	12.39	12.08	12.36	117936.0
2005-06-27	CHIR	ETF	35.2401	35.46	34.7799	34.89	849682.0
2005-06-27	CHY	ETF	16.4	16.41	16.23	16.35	118900.0
2005-06-27	CIL	ETF	25.63	25.63	25.63	25.63	800.0
2005-06-27	CIZ	ETF	22.6	22.6	22.35	22.35	1000.0
2005-06-27	CN	ETF	29.09	29.19	29.03	29.11	13500.0
2005-06-27	CNXT	ETF	1.61	1.61	1.46	1.48	7875627.0
2005-06-27	CPI	ETF	23.71	23.71	23.68	23.68	200.0
2005-06-27	CPST	ETF	1.22	1.37	1.21	1.25	836994.0
2005-06-27	CSB	ETF	29.1	29.29	28.98	29.05	18700.0
2005-06-27	CSQ	ETF	13.69	13.69	13.56	13.66	393500.0
2005-06-27	CTEC	ETF	52.300000000000004	53.699999999999996	52.300000000000004	52.8	4938.0
2005-06-27	CURE	ETF	0.2362	0.3175	0.2275	0.3063	9351888.0
2005-06-27	CYA	ETF	141.0	141.0	137.0	137.0	125.0
2005-06-27	CYB	ETF	3.28	3.34	3.25	3.3	10000.0
2005-06-27	DGT	ETF	63.35	63.5	63.15	63.29	110100.0
2005-06-27	DIV	ETF	13.8	13.83	13.61	13.61	31900.0
2005-06-27	DRIV	ETF	30.62	31.14	30.51	30.85	455772.0
2005-06-27	DSI	ETF	5.72	5.72	5.72	5.72	400.0
2005-06-27	DUSA	ETF	8.9	10.3	8.9	8.94	305469.0

> showing 50 of 275 rows — these rows as CSV

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