PREVIEW / etf_daily / 2013-01-16

all etf daily files

  file:    by_date/etf_daily/2013/2013-01-16.parquet
  size:    39 KB
  rows:    956

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
2013-01-16	SPY	ETF	146.77	147.28	146.61	147.05	104849500.0
2013-01-16	QQQ	ETF	66.75	67.13	66.6	66.9	33828119.0
2013-01-16	IWM	ETF	87.57	87.75	87.3	87.51	20881400.0
2013-01-16	DIA	ETF	134.62	135.05	134.54	134.89	3197800.0
2013-01-16	GLD	ETF	162.42	163.03	162.15	162.65	9214700.0
2013-01-16	TLT	ETF	120.63	120.68	120.01	120.32	4286100.0
2013-01-16	AADR	ETF	32.1	32.2	32.1	32.2	1600.0
2013-01-16	AAXJ	ETF	60.52	60.8	60.42	60.69	324200.0
2013-01-16	ACTV	ETF	5.87	6.0	5.74	5.78	405998.0
2013-01-16	ACWI	ETF	49.1	49.23	49.0	49.18	841300.0
2013-01-16	ACWV	ETF	56.78	57.08	56.78	57.02	13400.0
2013-01-16	ACWX	ETF	42.45	42.58	42.31	42.53	308639.0
2013-01-16	ADRE	ETF	40.77	40.9582	40.75	40.92	13630.0
2013-01-16	AFK	ETF	31.17	31.28	31.1	31.19	18072.0
2013-01-16	AGEM	ETF	23.64	23.64	23.54	23.54	70399.0
2013-01-16	AGG	ETF	111.02	111.1	110.92	111.04	1232000.0
2013-01-16	AGQ	ETF	185.96	189.6	184.84	188.72	217550.0
2013-01-16	AGZ	ETF	113.36	113.4899	113.36	113.47	15024.0
2013-01-16	AIA	ETF	47.82	47.91	47.68	47.87	46633.0
2013-01-16	AIQ	ETF	6.651	6.737	6.651	6.7	7307.0
2013-01-16	AIVI	ETF	42.54	42.68	42.5	42.63	32400.0
2013-01-16	AMJ	ETF	41.39	41.53	41.16	41.38	1378515.0
2013-01-16	AMLP	ETF	83.75	83.9	83.55	83.65	654260.0
2013-01-16	ANGL	ETF	27.27	27.27	27.06	27.21	2800.0
2013-01-16	AOA	ETF	38.19	38.19	37.97	38.08	17500.0
2013-01-16	AOK	ETF	30.84	30.84	30.78	30.81	10720.0
2013-01-16	AOM	ETF	32.08	32.1	32.0421	32.09	20684.0
2013-01-16	AOR	ETF	34.59	34.59	34.4901	34.51	16307.0
2013-01-16	ARB	ETF	46.76	46.81	46.62	46.79	206987.0
2013-01-16	ARGT	ETF	17.98	18.14	17.98	18.06	6850.0
2013-01-16	ASEA	ETF	16.98	17.09	16.97	17.05	12200.0
2013-01-16	AWAY	ETF	22.99	23.19	22.28	22.72	273070.0
2013-01-16	BAB	ETF	30.14	30.29	30.12	30.14	253978.0
2013-01-16	BAL	ETF	50.25	50.75	50.21	50.39	23985.0
2013-01-16	BALT	ETF	3.27	3.43	3.16	3.33	62792.0
2013-01-16	BBH	ETF	56.8	56.8	56.22	56.22	45500.0
2013-01-16	BCM	ETF	44.18	44.18	44.18	44.18	300.0
2013-01-16	BIB	ETF	16.4775	16.625	16.075	16.1172	238348.0
2013-01-16	BICK	ETF	25.66	25.72	25.65	25.72	5925.0
2013-01-16	BIL	ETF	91.6	91.62	91.6	91.6	417550.0
2013-01-16	BIS	ETF	2372.0	2382.8	2372.0	2382.8	21.1
2013-01-16	BIV	ETF	88.23	88.23	88.1	88.15	226200.0
2013-01-16	BJK	ETF	37.78	37.78	37.58	37.65	4000.0
2013-01-16	BKF	ETF	41.26	41.5699	41.26	41.5383	76294.0
2013-01-16	BKLN	ETF	25.12	25.13	25.04	25.11	1116700.0
2013-01-16	BLV	ETF	93.81	93.81	93.33	93.42	52000.0
2013-01-16	BMVP	ETF	16.9667	17.09	16.9667	17.0534	9952.0
2013-01-16	BND	ETF	83.99	84.02	83.88	83.93	1136500.0
2013-01-16	BNO	ETF	40.83	41.1	40.76	40.905	76800.0
2013-01-16	BOIL	ETF	806400.0	815000.0	775000.0	806800.0	11.8

> showing 50 of 956 rows — these rows as CSV

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