PREVIEW / etf_daily / 2013-04-12

all etf daily files

  file:    by_date/etf_daily/2013/2013-04-12.parquet
  size:    40 KB
  rows:    979

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-04-12	SPY	ETF	158.68	159.04	157.92	158.8	116359900.0
2013-04-12	QQQ	ETF	69.85	69.99	69.41	69.94	32791330.0
2013-04-12	IWM	ETF	93.7	93.94	92.92	93.64	41931800.0
2013-04-12	DIA	ETF	147.99	148.46	147.68	148.42	8710800.0
2013-04-12	GLD	ETF	148.65	148.85	143.43	143.95	55601800.0
2013-04-12	TLT	ETF	121.33	121.94	120.9	121.93	9253000.0
2013-04-12	AAXJ	ETF	57.88	57.88	57.2	57.58	389000.0
2013-04-12	ACTV	ETF	4.46	4.98	4.45	4.93	506470.0
2013-04-12	ACWI	ETF	51.32	51.5	51.13	51.45	387900.0
2013-04-12	ACWV	ETF	62.6	62.66	62.37	62.66	35900.0
2013-04-12	ACWX	ETF	43.24	43.269	42.9711	43.26	172211.0
2013-04-12	ADRE	ETF	38.06	38.3	37.874	38.16	56524.0
2013-04-12	AFK	ETF	30.24	30.24	29.7	29.72	31713.0
2013-04-12	AGEM	ETF	22.44	22.44	22.15	22.21	6439.0
2013-04-12	AGG	ETF	111.02	111.21	110.97	111.2	873700.0
2013-04-12	AGQ	ETF	136.0	136.76	126.84	127.64	1019550.0
2013-04-12	AGZ	ETF	113.53	113.73	113.53	113.64	17618.0
2013-04-12	AIA	ETF	45.03	45.05	44.69	44.9995	20046.0
2013-04-12	AIQ	ETF	9.37	9.5999	9.085	9.59	12544.0
2013-04-12	AIVI	ETF	43.06	43.18	42.93	43.18	25200.0
2013-04-12	AMJ	ETF	45.45	45.7	45.01	45.54	1198590.0
2013-04-12	AMLP	ETF	88.3	88.45	87.85	88.15	716780.0
2013-04-12	AOA	ETF	40.09	40.09	39.89	40.03	83500.0
2013-04-12	AOK	ETF	31.36	31.3699	31.3101	31.369	48776.0
2013-04-12	AOM	ETF	32.97	32.97	32.88	32.9401	105301.0
2013-04-12	AOR	ETF	35.9	35.9	35.7601	35.8798	17606.0
2013-04-12	ARB	ETF	46.71	46.77	46.7	46.72	166373.0
2013-04-12	ARGT	ETF	17.44	17.44	17.04	17.06	4100.0
2013-04-12	ASEA	ETF	17.68	17.73	17.62	17.64	29500.0
2013-04-12	ATMP	ETF	25.91	25.94	25.91	25.94	2200.0
2013-04-12	AVIV	ETF	24.75	24.85	23.38	24.42	853436.0
2013-04-12	AWAY	ETF	32.61	33.14	32.51	33.03	687787.0
2013-04-12	BAB	ETF	30.81	30.9	30.75	30.84	171349.0
2013-04-12	BAL	ETF	54.25	55.58	53.94	55.36	69587.0
2013-04-12	BALT	ETF	3.73	3.73	3.62	3.66	22473.0
2013-04-12	BBH	ETF	67.85	68.76	67.85	68.72	224800.0
2013-04-12	BCM	ETF	41.38	41.43	41.25	41.37	3077.0
2013-04-12	BIB	ETF	21.3225	21.945	21.0625	21.9125	173912.0
2013-04-12	BICK	ETF	23.11	23.2	23.006	23.141	8341.0
2013-04-12	BIL	ETF	91.62	91.62	91.6	91.62	91650.0
2013-04-12	BIS	ETF	1743.2	1743.2	1696.0	1696.0	47.1
2013-04-12	BIV	ETF	88.24	88.38	88.19	88.35	188300.0
2013-04-12	BIZD	ETF	20.0	20.05	19.85	19.88	9100.0
2013-04-12	BJK	ETF	39.9	40.23	39.83	40.23	47400.0
2013-04-12	BKF	ETF	38.28	38.33	37.9	38.24	152686.0
2013-04-12	BKLN	ETF	25.19	25.19	25.16	25.18	1900100.0
2013-04-12	BLNG	ETF	44.04	44.04	43.99	43.99	1500.0
2013-04-12	BLV	ETF	93.71	93.94	93.46	93.92	40100.0
2013-04-12	BMVP	ETF	18.65	18.6573	18.6	18.6573	2287.0
2013-04-12	BND	ETF	83.72	83.89	83.72	83.89	1110300.0

> showing 50 of 979 rows — these rows as CSV

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