PREVIEW / etf_daily / 2012-12-07

all etf daily files

  file:    by_date/etf_daily/2012/2012-12-07.parquet
  size:    39 KB
  rows:    954

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-07	SPY	ETF	142.53	142.69	141.67	142.41	108726400.0
2012-12-07	QQQ	ETF	65.65	65.71	64.71	64.93	30092666.0
2012-12-07	IWM	ETF	82.5	82.55	81.83	82.18	24123400.0
2012-12-07	DIA	ETF	131.3	131.61	130.82	131.56	3993200.0
2012-12-07	GLD	ETF	164.88	165.22	164.6	165.16	7289500.0
2012-12-07	TLT	ETF	124.5	124.96	124.34	124.43	4020900.0
2012-12-07	AADR	ETF	30.91	30.91	30.6	30.6	1000.0
2012-12-07	AAXJ	ETF	59.3	59.3	59.01	59.26	492200.0
2012-12-07	ACTV	ETF	4.72	4.86	4.7	4.78	491611.0
2012-12-07	ACWI	ETF	47.59	47.62	47.36	47.57	521000.0
2012-12-07	ACWV	ETF	56.84	56.84	56.51	56.8	32200.0
2012-12-07	ACWX	ETF	41.01	41.01	40.84	40.93	561189.0
2012-12-07	ADRE	ETF	38.87	38.94	38.74	38.92	49636.0
2012-12-07	AFK	ETF	30.52	30.6	30.388	30.5	24409.0
2012-12-07	AGEM	ETF	22.79	22.79	22.72	22.77	910.0
2012-12-07	AGG	ETF	111.61	111.71	111.55	111.66	966200.0
2012-12-07	AGQ	ETF	211.0	213.32	208.64	210.8	240950.0
2012-12-07	AGZ	ETF	113.96	114.0	113.7	113.701	10048.0
2012-12-07	AIA	ETF	47.08	47.129	46.97	47.098	8839.0
2012-12-07	AIQ	ETF	6.2	6.25	6.1	6.1	7276.0
2012-12-07	AIVI	ETF	40.79	40.82	40.52	40.82	24000.0
2012-12-07	AMJ	ETF	38.6	38.72	38.29	38.61	857160.0
2012-12-07	AMLP	ETF	79.8	80.2	79.55	79.85	454140.0
2012-12-07	ANGL	ETF	27.12	27.24	27.11	27.12	3400.0
2012-12-07	AOA	ETF	36.91	36.95	36.83	36.93	9200.0
2012-12-07	AOK	ETF	30.6	30.6	30.57	30.5734	12914.0
2012-12-07	AOM	ETF	31.8	31.8	31.72	31.79	11588.0
2012-12-07	AOR	ETF	33.85	33.87	33.7901	33.86	10127.0
2012-12-07	ARB	ETF	38.58	38.58	37.69	38.09	195917.0
2012-12-07	ARGT	ETF	16.34	16.34	16.34	16.34	300.0
2012-12-07	ASEA	ETF	16.89	16.89	16.77	16.86	14100.0
2012-12-07	AWAY	ETF	20.32	20.39	19.9	19.98	346484.0
2012-12-07	BAB	ETF	30.61	30.64	30.57	30.62	183273.0
2012-12-07	BAL	ETF	48.01	48.23	47.9729	48.23	5452.0
2012-12-07	BALT	ETF	2.8	2.81	2.75	2.79	99349.0
2012-12-07	BBH	ETF	54.44	54.44	53.88	54.05	28500.0
2012-12-07	BCM	ETF	44.45	44.45	44.4192	44.4192	239.0
2012-12-07	BIB	ETF	15.065	15.065	14.39	14.475	379508.0
2012-12-07	BICK	ETF	24.46	24.5	24.371	24.5	501.0
2012-12-07	BIL	ETF	91.62	91.64	91.62	91.62	376400.0
2012-12-07	BIS	ETF	2661.6	2697.2	2661.596	2674.0	325.0
2012-12-07	BIV	ETF	90.41	90.53	90.35	90.43	322300.0
2012-12-07	BJK	ETF	35.8	35.8	35.51	35.57	12100.0
2012-12-07	BKF	ETF	39.12	39.28	39.01	39.26	100805.0
2012-12-07	BKLN	ETF	24.9	24.93	24.87	24.9	1786100.0
2012-12-07	BLV	ETF	96.82	97.1	96.46	96.68	48600.0
2012-12-07	BMVP	ETF	16.13	16.183	16.089	16.169	4890.0
2012-12-07	BND	ETF	84.82	84.9	84.78	84.81	1239200.0
2012-12-07	BNO	ETF	39.335	39.38	39.075	39.22	38400.0
2012-12-07	BOIL	ETF	946000.0	964400.0	892800.0	898000.0	9.2

> showing 50 of 954 rows — these rows as CSV

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