PREVIEW / etf_daily / 2011-03-09

all etf daily files

  file:    by_date/etf_daily/2011/2011-03-09.parquet
  size:    35 KB
  rows:    826

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
2011-03-09	SPY	ETF	132.32	132.8	131.6	132.39	153806000.0
2011-03-09	QQQ	ETF	57.21	57.27	56.72	57.03	84764136.0
2011-03-09	IWM	ETF	82.25	82.58	81.75	82.08	51216900.0
2011-03-09	DIA	ETF	121.87	122.46	121.45	122.01	7819900.0
2011-03-09	GLD	ETF	139.92	139.95	138.94	139.41	8736400.0
2011-03-09	TLT	ETF	90.09	90.82	89.85	90.55	8904800.0
2011-03-09	AADR	ETF	30.65	30.65	30.48	30.58	900.0
2011-03-09	AAXJ	ETF	62.12	62.29	61.81	62.22	276500.0
2011-03-09	ACWI	ETF	48.61	48.66	48.37	48.58	240300.0
2011-03-09	ACWX	ETF	45.45	45.54	45.32	45.47	310017.0
2011-03-09	ADRE	ETF	47.24	47.45	47.11	47.26	35939.0
2011-03-09	AFK	ETF	32.68	32.6885	32.2108	32.2108	17352.0
2011-03-09	AGG	ETF	105.05	105.37	104.96	105.24	590600.0
2011-03-09	AGQ	ETF	426.64	427.1	409.14	420.66	532100.0
2011-03-09	AGZ	ETF	109.15	109.46	109.01	109.43	18492.0
2011-03-09	AIA	ETF	46.86	46.9101	46.72	46.83	19003.0
2011-03-09	AIQ	ETF	20.6	21.05	20.5	20.9	35549.0
2011-03-09	AIS	ETF	1.67	1.72	1.61	1.62	518739.0
2011-03-09	AIVI	ETF	46.26	46.49	46.24	46.36	2100.0
2011-03-09	AMJ	ETF	37.74	37.77	37.1007	37.23	1061991.0
2011-03-09	AMLP	ETF	81.9	81.9	80.9	81.0	151800.0
2011-03-09	AOA	ETF	35.78	35.8	35.63	35.79	5200.0
2011-03-09	AOK	ETF	29.16	29.18	29.09	29.156	9847.0
2011-03-09	AOM	ETF	30.54	30.56	30.46	30.55	23116.0
2011-03-09	AOR	ETF	32.51	32.52	32.367	32.51	9643.0
2011-03-09	ARB	ETF	39.65	39.93	39.16	39.72	127273.0
2011-03-09	ARGT	ETF	30.54	30.54	30.26	30.28	4950.0
2011-03-09	ASEA	ETF	15.63	15.63	15.54	15.54	600.0
2011-03-09	BAB	ETF	25.12	25.184	25.02	25.13	148551.0
2011-03-09	BAL	ETF	108.79	108.85	104.9001	106.18	77491.0
2011-03-09	BALT	ETF	9.0	9.04	8.7	8.8	231405.0
2011-03-09	BBH	ETF	34.67	34.86	34.6167	34.7933	35400.0
2011-03-09	BIB	ETF	7.9413	7.9475	7.9413	7.9475	17760.0
2011-03-09	BICK	ETF	32.05	32.08	31.81	31.96	62329.0
2011-03-09	BIL	ETF	91.72	91.72	91.7	91.7	159800.0
2011-03-09	BITS	ETF	26.0	26.32	25.8404	25.8404	1575.0
2011-03-09	BIV	ETF	82.07	82.5	82.05	82.38	94200.0
2011-03-09	BJK	ETF	31.62	31.79	31.59	31.64	5200.0
2011-03-09	BKF	ETF	48.78	49.2	48.7	49.08	487654.0
2011-03-09	BKLN	ETF	25.03	25.06	25.0	25.06	263200.0
2011-03-09	BLV	ETF	77.43	78.02	77.38	77.68	26900.0
2011-03-09	BMVP	ETF	15.44	15.5	15.39	15.45	9010.0
2011-03-09	BND	ETF	79.88	80.07	79.79	79.95	712800.0
2011-03-09	BNO	ETF	38.185	38.565	38.1	38.48	229200.0
2011-03-09	BRF	ETF	52.53	53.3	52.35	52.92	324140.0
2011-03-09	BSCE	ETF	20.8923	20.93	20.8923	20.93	8973.0
2011-03-09	BSV	ETF	80.34	80.4	80.3	80.34	525100.0
2011-03-09	BTF	ETF	84.45	85.0	84.35	84.92	2040.2
2011-03-09	BWX	ETF	29.63	29.67	29.549	29.635	175304.0
2011-03-09	BWZ	ETF	37.59	37.86	37.59	37.77	4192.0

> showing 50 of 826 rows — these rows as CSV

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