PREVIEW / etf_daily / 2012-03-14

all etf daily files

  file:    by_date/etf_daily/2012/2012-03-14.parquet
  size:    38 KB
  rows:    930

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-14	SPY	ETF	140.1	140.45	139.48	139.91	145163600.0
2012-03-14	QQQ	ETF	66.31	66.74	66.08	66.49	59926891.0
2012-03-14	IWM	ETF	82.96	83.23	82.01	82.38	46707700.0
2012-03-14	DIA	ETF	131.79	132.17	131.62	131.88	5124600.0
2012-03-14	GLD	ETF	159.61	160.58	158.8	159.57	28822100.0
2012-03-14	TLT	ETF	112.7	112.75	110.95	111.04	24515300.0
2012-03-14	AADR	ETF	30.54	30.54	30.54	30.54	500.0
2012-03-14	AAXJ	ETF	58.02	58.25	57.43	57.51	271700.0
2012-03-14	ACTV	ETF	17.7	17.7	17.12	17.34	242822.0
2012-03-14	ACWI	ETF	47.26	47.3	46.93	47.07	1709500.0
2012-03-14	ACWX	ETF	41.26	41.29	40.81	40.96	150982.0
2012-03-14	ADRE	ETF	43.27	43.55	42.93	43.11	40366.0
2012-03-14	AFK	ETF	29.73	29.82	29.41	29.422	12476.0
2012-03-14	AGEM	ETF	24.04	24.21	23.83	23.9401	7062.0
2012-03-14	AGG	ETF	109.76	109.84	109.25	109.32	1119800.0
2012-03-14	AGQ	ETF	224.08	229.88	209.56	217.12	1074900.0
2012-03-14	AGZ	ETF	112.21	112.3986	112.06	112.09	29400.0
2012-03-14	AIA	ETF	45.51	45.6201	45.14	45.1401	5643.0
2012-03-14	AIQ	ETF	7.05	7.05	6.6	6.9	13071.0
2012-03-14	AIS	ETF	2.95	2.9501	2.79	2.8	959467.0
2012-03-14	AIVI	ETF	41.94	41.97	41.57	41.67	86700.0
2012-03-14	AMJ	ETF	40.31	40.31	39.68	39.75	1116393.0
2012-03-14	AMLP	ETF	84.6	84.75	83.65	83.65	352160.0
2012-03-14	AOA	ETF	36.46	36.49	36.26	36.28	4400.0
2012-03-14	AOK	ETF	30.18	30.18	30.039	30.06	18925.0
2012-03-14	AOM	ETF	31.29	31.29	31.132	31.17	77760.0
2012-03-14	AOR	ETF	33.37	33.37	33.19	33.22	20036.0
2012-03-14	ARB	ETF	35.22	35.46	34.91	35.09	187860.0
2012-03-14	ARGT	ETF	21.92	21.92	21.76	21.76	12400.0
2012-03-14	ASEA	ETF	16.07	16.07	15.9	15.92	13400.0
2012-03-14	AWAY	ETF	26.74	26.74	25.73	25.91	623240.0
2012-03-14	BAB	ETF	29.04	29.0999	28.801	28.81	423079.0
2012-03-14	BAL	ETF	53.32	53.43	52.82	52.87	7913.0
2012-03-14	BALT	ETF	3.99	3.99	3.83	3.86	151833.0
2012-03-14	BBH	ETF	42.93	42.93	42.55	42.56	30700.0
2012-03-14	BCM	ETF	46.02	46.02	45.725	45.725	510.0
2012-03-14	BIB	ETF	11.4812	11.4812	11.2726	11.3325	25040.0
2012-03-14	BICK	ETF	27.61	27.62	27.292	27.3518	6439.0
2012-03-14	BIL	ETF	91.64	91.66	91.64	91.64	127050.0
2012-03-14	BITS	ETF	22.0	22.92	20.8	21.92	2404.0
2012-03-14	BIV	ETF	87.05	87.05	86.46	86.53	234600.0
2012-03-14	BJK	ETF	35.37	35.6	35.08	35.16	51800.0
2012-03-14	BKF	ETF	43.23	43.4899	42.7901	42.98	120805.0
2012-03-14	BKLN	ETF	24.57	24.61	24.52	24.57	191300.0
2012-03-14	BLV	ETF	89.0	89.16	87.98	88.03	124500.0
2012-03-14	BMVP	ETF	15.4167	15.45	15.3565	15.3867	9876.0
2012-03-14	BND	ETF	83.26	83.26	82.82	82.84	1069500.0
2012-03-14	BNO	ETF	44.09	44.52	43.705	43.745	159600.0
2012-03-14	BOIL	ETF	984000.0	1017000.0	961000.0	973000.0	5.8
2012-03-14	BOND	ETF	101.03	101.03	100.4775	100.55	175367.0

> showing 50 of 930 rows — these rows as CSV

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