PREVIEW / etf_daily / 2009-06-08

all etf daily files

  file:    by_date/etf_daily/2009/2009-06-08.parquet
  size:    29 KB
  rows:    651

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
2009-06-08	SPY	ETF	93.84	95.1	93.04	94.16	238565100.0
2009-06-08	QQQ	ETF	36.53	36.95	36.12	36.67	89194096.0
2009-06-08	IWM	ETF	52.8	53.28	52.04	52.57	46325400.0
2009-06-08	DIA	ETF	87.22	88.4	86.5	87.74	23538400.0
2009-06-08	GLD	ETF	93.26	93.7	92.58	93.56	11551100.0
2009-06-08	TLT	ETF	90.41	90.73	89.48	89.61	4084000.0
2009-06-08	AAXJ	ETF	44.87	45.37	44.25	44.9	463600.0
2009-06-08	ACWI	ETF	35.38	35.69	34.99	35.5	34600.0
2009-06-08	ACWX	ETF	33.81	34.47	33.73	34.24	65543.0
2009-06-08	ADRE	ETF	35.76	36.248	35.31	35.99	128261.0
2009-06-08	AFK	ETF	27.5	28.0201	27.37	27.6	14634.0
2009-06-08	AGG	ETF	100.05	100.3	99.8	99.8	648800.0
2009-06-08	AGQ	ETF	99.66	100.06	96.4	99.56	188500.0
2009-06-08	AGZ	ETF	106.56	106.56	105.86	105.99	8762.0
2009-06-08	AIA	ETF	32.78	32.88	32.13	32.49	41623.0
2009-06-08	AIQ	ETF	36.65	36.95	35.2	36.55	38969.0
2009-06-08	AIS	ETF	0.77	0.77	0.6101	0.71	341982.0
2009-06-08	AIVI	ETF	35.71	35.85	35.25	35.85	37300.0
2009-06-08	AMJ	ETF	23.42	23.42	22.7716	23.02	97422.0
2009-06-08	AOA	ETF	25.91	25.91	25.42	25.65	9100.0
2009-06-08	AOK	ETF	25.6999	25.7	25.2184	25.661	5907.0
2009-06-08	AOM	ETF	25.75	25.88	25.7232	25.88	3714.0
2009-06-08	AOR	ETF	25.63	25.75	25.6	25.75	4626.0
2009-06-08	ARB	ETF	20.7	20.73	19.89	20.62	300257.0
2009-06-08	BAL	ETF	30.85	31.29	30.65	31.18	23618.0
2009-06-08	BBH	ETF	30.5333	31.0333	30.4967	30.71	429900.0
2009-06-08	BIL	ETF	91.7	91.74	91.66	91.72	132200.0
2009-06-08	BITS	ETF	18.92	19.56	18.92	19.36	830.0
2009-06-08	BIV	ETF	75.65	75.65	74.75	74.75	168700.0
2009-06-08	BJK	ETF	21.57	22.53	21.02	22.0	16300.0
2009-06-08	BKF	ETF	36.53	36.74	35.54	36.58	454516.0
2009-06-08	BLV	ETF	71.58	71.9	71.33	71.44	31500.0
2009-06-08	BMVP	ETF	11.0933	11.1834	11.0	11.1133	15451.0
2009-06-08	BND	ETF	76.34	76.47	76.01	76.08	334100.0
2009-06-08	BNE	ETF	6.68	6.85	6.4003	6.71	134335.0
2009-06-08	BOSS	ETF	15.8	16.41	15.8	15.8	400.0
2009-06-08	BRF	ETF	27.86	27.96	27.2901	27.7101	64532.0
2009-06-08	BSV	ETF	78.32	78.45	78.11	78.17	156700.0
2009-06-08	BTF	ETF	48.49999999999999	48.849999999999994	47.99999999999999	48.849999999999994	7156.6
2009-06-08	BWX	ETF	26.505	26.65	26.4503	26.65	201572.0
2009-06-08	BWZ	ETF	34.64	34.68	34.41	34.445	5689.0
2009-06-08	CBON	ETF	1.69	1.88	1.24	1.59	93669.0
2009-06-08	CEF	ETF	11.8	11.99	11.71	11.99	973900.0
2009-06-08	CEW	ETF	20.54	20.6	20.4425	20.6	42980.0
2009-06-08	CGO	ETF	11.7	11.71	11.38	11.55	23437.0
2009-06-08	CGW	ETF	15.35	15.6	15.19	15.52	53310.0
2009-06-08	CHB	ETF	0.55	0.55	0.48	0.48	628320.0
2009-06-08	CHI	ETF	10.84	10.84	10.55	10.74	172299.0
2009-06-08	CHIC	ETF	11.28	11.6	11.28	11.47	267131.0
2009-06-08	CHW	ETF	7.48	7.51	7.2501	7.44	243589.0

> showing 50 of 651 rows — these rows as CSV

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