PREVIEW / etf_daily / 2012-03-06

all etf daily files

  file:    by_date/etf_daily/2012/2012-03-06.parquet
  size:    38 KB
  rows:    926

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
2012-03-06	SPY	ETF	135.35	135.43	134.36	134.75	202129900.0
2012-03-06	QQQ	ETF	63.59	63.72	63.23	63.57	54638583.0
2012-03-06	IWM	ETF	79.42	79.62	78.41	78.74	80769300.0
2012-03-06	DIA	ETF	127.93	129.46	127.18	127.45	14410100.0
2012-03-06	GLD	ETF	162.15	162.81	161.78	162.7	15533200.0
2012-03-06	TLT	ETF	117.45	118.11	117.44	117.63	6299700.0
2012-03-06	AADR	ETF	29.39	29.39	29.39	29.39	200.0
2012-03-06	AAXJ	ETF	56.03	56.03	55.31	55.52	1492100.0
2012-03-06	ACTV	ETF	15.7	15.81	15.415	15.65	126170.0
2012-03-06	ACWI	ETF	45.64	45.64	45.23	45.27	566800.0
2012-03-06	ACWV	ETF	53.09	53.14	53.01	53.02	19500.0
2012-03-06	ACWX	ETF	39.9	39.924	39.44	39.56	183072.0
2012-03-06	ADRE	ETF	42.24	42.44	41.78	42.03	36903.0
2012-03-06	AFK	ETF	29.83	29.83	29.25	29.4876	27461.0
2012-03-06	AGG	ETF	110.55	110.62	110.45	110.56	1056500.0
2012-03-06	AGQ	ETF	225.48	230.92	221.6	227.96	928850.0
2012-03-06	AGZ	ETF	112.75	112.88	112.75	112.82	24619.0
2012-03-06	AIA	ETF	43.87	43.87	43.3	43.48	24686.0
2012-03-06	AIQ	ETF	6.4	6.55	6.4	6.5	9163.0
2012-03-06	AIS	ETF	2.69	2.71	2.62	2.66	916859.0
2012-03-06	AIVI	ETF	41.0	41.06	40.44	40.57	76000.0
2012-03-06	AMJ	ETF	40.36	40.48	39.92	40.06	1491991.0
2012-03-06	AMLP	ETF	84.9	84.9	84.0	84.35	423440.0
2012-03-06	AOA	ETF	35.46	35.46	35.17	35.22	18700.0
2012-03-06	AOK	ETF	29.94	29.94	29.84	29.84	38591.0
2012-03-06	AOM	ETF	30.84	30.85	30.73	30.8	40454.0
2012-03-06	AOR	ETF	32.66	32.66	32.5	32.53	11704.0
2012-03-06	ARB	ETF	33.22	33.48	32.92	33.11	138163.0
2012-03-06	ARGT	ETF	22.0	22.0	21.48	21.5	1500.0
2012-03-06	ASEA	ETF	15.73	15.73	15.49	15.53	8700.0
2012-03-06	AWAY	ETF	26.95	27.0	25.44	26.05	546163.0
2012-03-06	BAB	ETF	29.58	29.59	29.48	29.52	122042.0
2012-03-06	BAL	ETF	56.0	56.08	55.2	55.39	46257.0
2012-03-06	BALT	ETF	4.02	4.03	3.82	3.93	273890.0
2012-03-06	BBH	ETF	41.71	41.87	41.17	41.35	81900.0
2012-03-06	BCM	ETF	45.5705	45.75	45.558	45.59	15007.0
2012-03-06	BIB	ETF	10.8387	10.9275	10.5862	10.7063	97800.0
2012-03-06	BICK	ETF	26.83	26.83	26.28	26.37	11289.0
2012-03-06	BIL	ETF	91.64	91.64	91.62	91.64	179750.0
2012-03-06	BIS	ETF	4075.2	4159.68	4075.2	4129.6	10.1
2012-03-06	BITS	ETF	20.48	21.0	20.28	20.52	910.0
2012-03-06	BIV	ETF	87.93	88.02	87.87	87.92	159500.0
2012-03-06	BJK	ETF	33.54	33.69	33.26	33.39	5000.0
2012-03-06	BKF	ETF	42.25	42.25	41.5	41.59	427379.0
2012-03-06	BKLN	ETF	24.5	24.51	24.42	24.42	99700.0
2012-03-06	BLV	ETF	91.6	91.82	91.47	91.51	47100.0
2012-03-06	BMVP	ETF	14.96	14.96	14.81	14.85	18929.0
2012-03-06	BND	ETF	83.75	83.8	83.69	83.71	704800.0
2012-03-06	BNO	ETF	42.565	42.95	42.535	42.68	133600.0
2012-03-06	BOIL	ETF	1045000.0	1054000.0	1012000.0	1016000.0	4.6

> showing 50 of 926 rows — these rows as CSV

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