PREVIEW / etf_daily / 2012-03-23

all etf daily files

  file:    by_date/etf_daily/2012/2012-03-23.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-23	SPY	ETF	139.32	139.81	138.55	139.65	120521000.0
2012-03-23	QQQ	ETF	67.06	67.08	66.56	66.939	45547682.0
2012-03-23	IWM	ETF	82.0	82.79	81.25	82.68	46464800.0
2012-03-23	DIA	ETF	130.22	130.71	129.71	130.6	4373300.0
2012-03-23	GLD	ETF	160.88	161.88	160.52	161.53	10689000.0
2012-03-23	TLT	ETF	112.69	113.39	112.66	113.21	8465300.0
2012-03-23	AAXJ	ETF	56.3	56.59	56.08	56.54	146900.0
2012-03-23	ACTV	ETF	16.64	16.79	16.48	16.78	210268.0
2012-03-23	ACWI	ETF	46.7	46.95	46.49	46.92	235000.0
2012-03-23	ACWV	ETF	53.82	53.82	53.82	53.82	100.0
2012-03-23	ACWX	ETF	40.59	40.8	40.36	40.8	95383.0
2012-03-23	ADRE	ETF	42.2	42.33	41.96	42.32	28417.0
2012-03-23	AFK	ETF	29.2	29.57	29.128	29.57	3823.0
2012-03-23	AGEM	ETF	23.09	23.26	23.09	23.25	3040.0
2012-03-23	AGG	ETF	109.47	109.7	109.44	109.7	758400.0
2012-03-23	AGQ	ETF	211.44	218.28	209.8	216.52	435300.0
2012-03-23	AGZ	ETF	112.2027	112.5299	112.17	112.44	8614.0
2012-03-23	AIA	ETF	44.279	44.5	44.16	44.45	12358.0
2012-03-23	AIQ	ETF	7.5	7.9	7.5	7.7	27729.0
2012-03-23	AIS	ETF	3.04	3.28	3.03	3.27	2438769.0
2012-03-23	AIVI	ETF	41.9	42.1	41.63	42.07	54400.0
2012-03-23	AMJ	ETF	39.78	39.88	39.581	39.65	1724798.0
2012-03-23	AMLP	ETF	83.9	84.15	83.6	83.85	249400.0
2012-03-23	AOA	ETF	36.13	36.37	36.13	36.35	5300.0
2012-03-23	AOK	ETF	30.01	30.11	29.9901	30.11	19562.0
2012-03-23	AOM	ETF	31.09	31.19	31.09	31.19	9907.0
2012-03-23	AOR	ETF	33.14	33.29	33.07	33.29	7783.0
2012-03-23	ARB	ETF	36.07	36.29	35.78	36.04	198491.0
2012-03-23	ARGT	ETF	21.68	21.7	21.68	21.7	800.0
2012-03-23	ASEA	ETF	16.03	16.08	15.92	16.08	4000.0
2012-03-23	AWAY	ETF	25.16	25.16	24.59	25.0	242568.0
2012-03-23	BAB	ETF	28.95	29.11	28.9455	29.03	140173.0
2012-03-23	BAL	ETF	54.61	54.88	54.2	54.53	103677.0
2012-03-23	BALT	ETF	3.92	4.01	3.915	3.98	95231.0
2012-03-23	BBH	ETF	42.74	43.12	42.73	43.12	9000.0
2012-03-23	BCM	ETF	45.4418	45.89	45.4418	45.79	4791.0
2012-03-23	BIB	ETF	11.5563	11.7	11.4987	11.7	19360.0
2012-03-23	BICK	ETF	26.51	26.51	26.21	26.5	30397.0
2012-03-23	BIL	ETF	91.64	91.66	91.64	91.66	103250.0
2012-03-23	BIS	ETF	3811.2	3811.2	3763.84	3763.84	7.8
2012-03-23	BIV	ETF	86.62	86.81	86.58	86.75	110300.0
2012-03-23	BJK	ETF	35.46	35.62	35.35	35.61	7000.0
2012-03-23	BKF	ETF	41.04	41.2701	40.89	41.26	64694.0
2012-03-23	BKLN	ETF	24.52	24.52	24.5	24.51	149300.0
2012-03-23	BLV	ETF	88.8	89.25	88.8	89.09	44200.0
2012-03-23	BMVP	ETF	15.39	15.47	15.33	15.47	5360.0
2012-03-23	BND	ETF	83.06	83.18	83.01	83.16	1151600.0
2012-03-23	BNO	ETF	43.57	44.5	43.535	43.93	136000.0
2012-03-23	BOIL	ETF	969000.0	981000.0	939000.0	940000.0	4.6
2012-03-23	BOND	ETF	101.24	101.32	101.2108	101.27	31787.0

> showing 50 of 926 rows — these rows as CSV

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