PREVIEW / etf_daily / 2009-06-15

all etf daily files

  file:    by_date/etf_daily/2009/2009-06-15.parquet
  size:    29 KB
  rows:    659

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-15	SPY	ETF	93.96	94.02	92.4	92.9	224190500.0
2009-06-15	QQQ	ETF	36.28	36.33	35.58	35.9	112152898.0
2009-06-15	IWM	ETF	52.03	52.09	50.8	51.36	45942200.0
2009-06-15	DIA	ETF	87.23	87.28	86.0	86.49	14006100.0
2009-06-15	GLD	ETF	91.9	91.9	90.9	91.1	13116700.0
2009-06-15	TLT	ETF	90.54	91.15	90.48	90.78	4518700.0
2009-06-15	AAXJ	ETF	44.76	44.76	43.79	43.96	667900.0
2009-06-15	ACWI	ETF	35.63	35.63	34.8	35.07	838400.0
2009-06-15	ACWX	ETF	34.56	34.56	33.69	33.91	186836.0
2009-06-15	ADRE	ETF	36.08	36.17	35.0	35.42	328622.0
2009-06-15	AFK	ETF	27.7	27.75	27.0	27.35	17760.0
2009-06-15	AGG	ETF	101.1	101.19	100.78	101.19	491000.0
2009-06-15	AGQ	ETF	91.84	91.9	87.08	87.52	193300.0
2009-06-15	AGZ	ETF	106.25	106.74	106.25	106.43	49346.0
2009-06-15	AIA	ETF	32.54	32.54	31.62	31.94	18796.0
2009-06-15	AIQ	ETF	36.05	36.05	34.0	34.4	81347.0
2009-06-15	AIS	ETF	0.7748	0.7748	0.67	0.718	113609.0
2009-06-15	AIVI	ETF	35.81	35.81	35.1	35.38	18200.0
2009-06-15	AMJ	ETF	22.96	22.96	22.17	22.69	84644.0
2009-06-15	AOA	ETF	26.03	26.03	25.25	25.27	4800.0
2009-06-15	AOK	ETF	26.444	26.444	25.64	25.691	1850.0
2009-06-15	AOM	ETF	25.9	26.09	25.6994	26.09	9149.0
2009-06-15	AOR	ETF	25.75	25.75	25.45	25.63	9365.0
2009-06-15	ARB	ETF	19.11	19.36	18.59	18.88	185489.0
2009-06-15	BAL	ETF	30.94	31.19	30.0101	30.0101	10180.0
2009-06-15	BBH	ETF	30.3333	30.3433	29.74	29.8167	949500.0
2009-06-15	BIL	ETF	91.72	91.74	91.68	91.74	116850.0
2009-06-15	BITS	ETF	19.2	19.92	18.68	18.68	1074.0
2009-06-15	BIV	ETF	76.33	76.33	75.3	75.96	92600.0
2009-06-15	BJK	ETF	21.06	21.06	20.62	20.71	7700.0
2009-06-15	BKF	ETF	37.49	37.49	35.59	36.15	243064.0
2009-06-15	BLV	ETF	72.49	72.7	71.71	72.21	10600.0
2009-06-15	BMVP	ETF	11.02	11.03	10.85	10.89	46135.0
2009-06-15	BND	ETF	76.58	76.91	76.58	76.82	348500.0
2009-06-15	BNE	ETF	6.91	7.06	6.46	6.8	144606.0
2009-06-15	BOSS	ETF	16.37	16.37	15.5	16.37	1000.0
2009-06-15	BRF	ETF	28.46	28.46	27.25	27.5487	94983.0
2009-06-15	BSV	ETF	78.75	78.76	78.53	78.72	169000.0
2009-06-15	BTF	ETF	48.3	48.4	47.9	47.9	8516.4
2009-06-15	BWX	ETF	26.725	26.725	26.55	26.655	245456.0
2009-06-15	BWZ	ETF	34.75	34.8	34.6	34.65	4249.0
2009-06-15	CBON	ETF	1.44	1.5	1.4	1.45	18863.0
2009-06-15	CEF	ETF	12.1	12.16	11.85	12.08	1568500.0
2009-06-15	CEW	ETF	20.67	21.04	20.59	20.78	62991.0
2009-06-15	CGO	ETF	11.84	11.84	11.3578	11.42	19851.0
2009-06-15	CGW	ETF	15.66	15.77	15.21	15.42	90931.0
2009-06-15	CHB	ETF	0.48	0.48	0.42	0.44	230445.0
2009-06-15	CHI	ETF	10.58	10.58	10.19	10.31	179830.0
2009-06-15	CHIC	ETF	11.93	11.95	11.6	11.9	224280.0
2009-06-15	CHW	ETF	7.19	7.1923	6.8	6.87	286300.0

> showing 50 of 659 rows — these rows as CSV

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