PREVIEW / etf_daily / 2012-12-20

all etf daily files

  file:    by_date/etf_daily/2012/2012-12-20.parquet
  size:    40 KB
  rows:    964

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-12-20	SPY	ETF	144.38	145.14	143.98	145.12	168487000.0
2012-12-20	QQQ	ETF	66.38	66.41	65.93	66.26	40754272.0
2012-12-20	IWM	ETF	84.14	84.61	83.85	84.54	50304600.0
2012-12-20	DIA	ETF	132.57	133.28	132.27	133.19	5530500.0
2012-12-20	GLD	ETF	159.87	160.12	158.39	159.73	25148400.0
2012-12-20	TLT	ETF	121.29	121.64	120.62	120.93	4567900.0
2012-12-20	AADR	ETF	31.3	31.47	31.03	31.47	3700.0
2012-12-20	AAXJ	ETF	59.44	59.66	59.23	59.66	413000.0
2012-12-20	ACTV	ETF	4.99	4.99	4.815	4.88	698782.0
2012-12-20	ACWI	ETF	48.02	48.33	47.99	48.33	2422200.0
2012-12-20	ACWV	ETF	56.24	56.36	56.05	56.3	33500.0
2012-12-20	ACWX	ETF	41.85	41.99	41.741	41.96	219283.0
2012-12-20	ADRE	ETF	40.1	40.4	40.1	40.4	36938.0
2012-12-20	AFK	ETF	31.99	32.19	31.92	32.17	28063.0
2012-12-20	AGEM	ETF	23.49	23.58	23.31	23.58	2453.0
2012-12-20	AGG	ETF	111.1	111.16	110.98	111.02	1122600.0
2012-12-20	AGQ	ETF	175.2	176.48	168.16	172.4	963675.0
2012-12-20	AGZ	ETF	113.41	113.454	113.36	113.43	9732.0
2012-12-20	AIA	ETF	47.39	47.63	47.29	47.59	30084.0
2012-12-20	AIQ	ETF	6.3	6.5	6.2	6.35	13166.0
2012-12-20	AIVI	ETF	42.09	42.3	42.0	42.25	20100.0
2012-12-20	AMJ	ETF	38.73	39.2	38.73	39.14	1998576.0
2012-12-20	AMLP	ETF	80.15	80.7	80.1	80.65	361320.0
2012-12-20	ANGL	ETF	27.24	27.25	27.24	27.25	600.0
2012-12-20	AOA	ETF	37.58	37.66	37.5	37.65	39600.0
2012-12-20	AOK	ETF	30.65	30.72	30.64	30.72	175935.0
2012-12-20	AOM	ETF	31.93	32.0398	31.93	32.029	10298.0
2012-12-20	AOR	ETF	34.24	34.31	34.219	34.29	20939.0
2012-12-20	ARB	ETF	46.6	46.6	46.03	46.24	1332433.0
2012-12-20	ARGT	ETF	17.64	17.68	17.52	17.68	2900.0
2012-12-20	ASEA	ETF	17.21	17.29	17.16	17.26	46400.0
2012-12-20	AWAY	ETF	22.38	23.44	22.06	22.64	1780479.0
2012-12-20	BAB	ETF	30.05	30.1192	29.94	30.1	328504.0
2012-12-20	BAL	ETF	49.13	49.49	48.97	49.34	26933.0
2012-12-20	BALT	ETF	3.11	3.12	3.04	3.1	43216.0
2012-12-20	BBH	ETF	55.06	55.06	54.7	54.82	10500.0
2012-12-20	BCM	ETF	43.56	43.64	43.5	43.56	9075.0
2012-12-20	BIB	ETF	15.0775	15.0775	14.7354	14.9325	55028.0
2012-12-20	BICK	ETF	24.99	25.233	24.99	25.2078	10836.0
2012-12-20	BIL	ETF	91.62	91.64	91.62	91.62	189600.0
2012-12-20	BIS	ETF	2606.0	2606.0	2571.6	2577.2	235.5
2012-12-20	BIV	ETF	89.81	89.89	89.72	89.76	315400.0
2012-12-20	BJK	ETF	37.08	37.25	37.08	37.25	26100.0
2012-12-20	BKF	ETF	40.22	40.48	40.14	40.46	71609.0
2012-12-20	BKLN	ETF	24.92	24.96	24.9	24.94	605000.0
2012-12-20	BLV	ETF	95.05	95.08	94.63	94.83	25300.0
2012-12-20	BMVP	ETF	16.5267	16.5567	16.4667	16.5485	12802.0
2012-12-20	BND	ETF	84.47	84.52	84.4	84.4	1117200.0
2012-12-20	BNO	ETF	40.6	40.825	40.485	40.615	41600.0
2012-12-20	BOIL	ETF	823200.0	857000.0	814600.0	849000.0	11.8

> showing 50 of 964 rows — these rows as CSV

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