PREVIEW / etf_daily / 2012-03-19

all etf daily files

  file:    by_date/etf_daily/2012/2012-03-19.parquet
  size:    39 KB
  rows:    933

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-19	SPY	ETF	140.21	141.28	140.11	140.85	125291100.0
2012-03-19	QQQ	ETF	66.62	67.15	66.45	66.99	60966105.0
2012-03-19	IWM	ETF	82.89	84.39	82.75	83.7	66822800.0
2012-03-19	DIA	ETF	131.91	132.4	131.78	132.07	4424000.0
2012-03-19	GLD	ETF	160.85	162.3	160.72	161.59	9920800.0
2012-03-19	TLT	ETF	111.36	111.48	109.69	110.1	14011400.0
2012-03-19	AAXJ	ETF	57.23	57.84	57.23	57.63	7241400.0
2012-03-19	ACTV	ETF	16.86	17.04	16.69	16.8	177797.0
2012-03-19	ACWI	ETF	47.5	47.81	47.34	47.68	525100.0
2012-03-19	ACWV	ETF	53.85	54.03	53.74	54.03	5800.0
2012-03-19	ACWX	ETF	41.4	41.73	41.35	41.62	301951.0
2012-03-19	ADRE	ETF	42.91	43.3	42.91	43.09	19879.0
2012-03-19	AFK	ETF	29.75	30.0	29.75	29.95	35748.0
2012-03-19	AGEM	ETF	23.7399	23.99	23.7399	23.76	10990.0
2012-03-19	AGG	ETF	109.3	109.3	108.89	108.93	1146800.0
2012-03-19	AGQ	ETF	221.6	229.2	220.64	226.96	482350.0
2012-03-19	AGZ	ETF	112.13	112.3275	111.897	112.1	12657.0
2012-03-19	AIA	ETF	45.05	45.3208	45.03	45.18	5855.0
2012-03-19	AIQ	ETF	7.8	8.545	7.75	8.45	37790.0
2012-03-19	AIS	ETF	2.86	2.97	2.82	2.97	1339977.0
2012-03-19	AIVI	ETF	42.31	42.69	42.26	42.59	189600.0
2012-03-19	AMJ	ETF	39.48	40.2	39.48	40.13	832604.0
2012-03-19	AMLP	ETF	83.3	84.45	83.3	84.4	381100.0
2012-03-19	AOA	ETF	36.54	36.79	36.54	36.7	7900.0
2012-03-19	AOK	ETF	30.08	30.16	30.08	30.1463	26150.0
2012-03-19	AOM	ETF	31.23	31.3589	31.23	31.32	18507.0
2012-03-19	AOR	ETF	33.39	33.535	33.38	33.4536	24777.0
2012-03-19	ARB	ETF	35.93	36.44	35.14	35.89	193053.0
2012-03-19	ARGT	ETF	22.04	22.28	22.04	22.26	2500.0
2012-03-19	ASEA	ETF	15.97	16.15	15.97	16.08	1800.0
2012-03-19	AWAY	ETF	26.03	26.34	25.59	25.61	256285.0
2012-03-19	BAB	ETF	28.72	28.72	28.4	28.47	262639.0
2012-03-19	BAL	ETF	53.6	54.37	53.59	53.78	18216.0
2012-03-19	BALT	ETF	4.1	4.2325	4.09	4.13	122630.0
2012-03-19	BBH	ETF	42.97	43.44	42.97	43.25	19800.0
2012-03-19	BCM	ETF	46.35	46.44	46.35	46.358	2760.0
2012-03-19	BIB	ETF	11.48	11.735	11.4787	11.64	29384.0
2012-03-19	BICK	ETF	27.23	27.2725	27.166	27.2224	4724.0
2012-03-19	BIL	ETF	91.66	91.66	91.64	91.66	105150.0
2012-03-19	BIS	ETF	3854.4	3854.4	3824.0	3824.0	14.4
2012-03-19	BITS	ETF	17.2	17.96	17.2	17.28	6132.0
2012-03-19	BIV	ETF	86.45	86.45	86.04	86.13	159900.0
2012-03-19	BJK	ETF	35.91	36.45	35.82	36.34	18000.0
2012-03-19	BKF	ETF	42.49	42.816	42.301	42.55	73764.0
2012-03-19	BKLN	ETF	24.48	24.56	24.41	24.5	348400.0
2012-03-19	BLNG	ETF	51.1201	51.1201	50.8799	50.88	700.0
2012-03-19	BLV	ETF	88.29	88.32	87.25	87.5	65300.0
2012-03-19	BMVP	ETF	15.443	15.534	15.443	15.5	2865.0
2012-03-19	BND	ETF	82.84	82.87	82.59	82.63	945800.0
2012-03-19	BNO	ETF	44.205	44.205	43.945	44.075	49200.0

> showing 50 of 933 rows — these rows as CSV

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