PREVIEW / etf_daily / 2005-07-07

all etf daily files

  file:    by_date/etf_daily/2005/2005-07-07.parquet
  size:    15 KB
  rows:    270

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-07-07	SPY	ETF	118.29	119.95	118.26	119.95	103268800.0
2005-07-07	QQQ	ETF	36.58	37.09	36.5498	37.06	120216319.0
2005-07-07	IWM	ETF	63.69	64.69	63.47	64.58	32447900.0
2005-07-07	DIA	ETF	101.75	103.2	101.73	103.14	13370400.0
2005-07-07	GLD	ETF	42.47	42.56	42.05	42.36	4345200.0
2005-07-07	TLT	ETF	95.43	95.55	94.96	95.02	1678000.0
2005-07-07	AAA	ETF	50.38	50.4	50.1	50.21	14100.0
2005-07-07	ADRE	ETF	90.45	91.53	90.28	91.39	5428.0
2005-07-07	AFK	ETF	25.9	26.03	25.9	25.97	5600.0
2005-07-07	AGG	ETF	102.69	102.82	102.5	102.59	166100.0
2005-07-07	AIQ	ETF	52.5	54.1	52.0	53.75	17760.0
2005-07-07	AIS	ETF	1.14	1.19	1.1	1.17	280900.0
2005-07-07	ARB	ETF	42.75	43.18	42.45	42.9	132000.0
2005-07-07	BAB	ETF	45.16	46.4	45.16	46.32	131700.0
2005-07-07	BBH	ETF	56.7667	58.17	56.7467	58.1067	2021400.0
2005-07-07	BCM	ETF	61.34	62.08	61.34	61.8	4800.0
2005-07-07	BITS	ETF	15.04	15.04	14.512	14.6	1625.0
2005-07-07	BKF	ETF	37.15	37.48	37.01	37.38	9600.0
2005-07-07	BNE	ETF	14.25	14.35	14.03	14.3	232400.0
2005-07-07	BRF	ETF	15.55	15.55	15.42	15.45	18900.0
2005-07-07	BTF	ETF	85.5	86.14999999999999	85.5	86.14999999999999	5500.0
2005-07-07	CBON	ETF	30.91	31.75	30.89	31.3	32881.0
2005-07-07	CDC	ETF	6.8	6.8	6.3	6.65	12700.0
2005-07-07	CDL	ETF	11.69	11.98	11.67	11.75	1106900.0
2005-07-07	CEF	ETF	5.24	5.25	5.21	5.24	258300.0
2005-07-07	CEW	ETF	26.75	26.75	26.6	26.6	5100.0
2005-07-07	CHB	ETF	9.65	10.27	9.58	10.11	409600.0
2005-07-07	CHI	ETF	19.89	20.0	19.85	19.99	80000.0
2005-07-07	CHIC	ETF	12.65	12.98	12.65	12.94	88946.0
2005-07-07	CHIR	ETF	35.0199	35.2101	34.53	35.1201	1026339.0
2005-07-07	CHY	ETF	16.67	16.74	16.66	16.72	120300.0
2005-07-07	CIL	ETF	25.65	25.65	25.65	25.65	200.0
2005-07-07	CN	ETF	28.75	28.86	28.5	28.66	21600.0
2005-07-07	CNXT	ETF	1.63	1.67	1.58	1.64	3059382.0
2005-07-07	CPST	ETF	1.5	1.62	1.42	1.57	1163167.0
2005-07-07	CSB	ETF	28.5	28.68	28.4	28.63	9000.0
2005-07-07	CSQ	ETF	13.95	14.04	13.93	14.04	412100.0
2005-07-07	CTEC	ETF	56.39999999999999	56.39999999999999	55.0	55.8	3790.0
2005-07-07	CURE	ETF	0.305	0.3125	0.2895	0.305	252360.0
2005-07-07	CYA	ETF	128.0	134.0	128.0	134.0	405.0
2005-07-07	CYB	ETF	3.0	3.05	2.96	3.05	17700.0
2005-07-07	DGT	ETF	62.66	62.79	62.64	62.79	4100.0
2005-07-07	DIV	ETF	13.83	13.94	13.78	13.8	13200.0
2005-07-07	DRIV	ETF	31.95	33.21	31.66	33.05	912036.0
2005-07-07	DUSA	ETF	9.22	9.4	9.05	9.36	50230.0
2005-07-07	DVY	ETF	61.6	62.1	61.4	62.1	494000.0
2005-07-07	EDEN	ETF	0.95	1.03	0.92	0.99	129355.0
2005-07-07	EDV	ETF	26.08	26.08	26.0	26.01	8600.0
2005-07-07	EEM	ETF	23.6667	24.0167	23.6667	24.0133	2380200.0
2005-07-07	EFA	ETF	51.28	52.1	51.24	51.95	4927400.0

> showing 50 of 270 rows — these rows as CSV

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