PREVIEW / etf_daily / 2013-03-25

all etf daily files

  file:    by_date/etf_daily/2013/2013-03-25.parquet
  size:    41 KB
  rows:    986

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-03-25	SPY	ETF	156.01	156.27	154.35	154.95	151322300.0
2013-03-25	QQQ	ETF	68.81	68.96	68.01	68.34	24909753.0
2013-03-25	IWM	ETF	94.12	94.72	93.28	93.95	36680500.0
2013-03-25	DIA	ETF	145.09	145.32	143.6	144.21	9603200.0
2013-03-25	GLD	ETF	154.71	155.57	154.36	155.24	6819100.0
2013-03-25	TLT	ETF	116.77	117.78	116.67	117.22	5839800.0
2013-03-25	AADR	ETF	32.55	32.55	32.55	32.55	500.0
2013-03-25	AAXJ	ETF	58.36	58.56	57.88	58.09	620600.0
2013-03-25	ACTV	ETF	4.28	4.3099	3.975	4.11	1332820.0
2013-03-25	ACWI	ETF	50.81	50.81	50.09	50.31	783600.0
2013-03-25	ACWV	ETF	61.39	61.42	60.9	61.12	77100.0
2013-03-25	ACWX	ETF	43.0	43.0	42.34	42.51	244916.0
2013-03-25	ADRE	ETF	38.26	38.35	37.93	38.04	40849.0
2013-03-25	AFK	ETF	30.13	30.34	29.9	29.93	41195.0
2013-03-25	AGEM	ETF	22.36	22.36	22.21	22.3167	5460.0
2013-03-25	AGG	ETF	110.4	110.52	110.36	110.37	981100.0
2013-03-25	AGQ	ETF	155.36	157.04	154.28	155.92	225275.0
2013-03-25	AGZ	ETF	113.04	113.28	113.04	113.21	9997.0
2013-03-25	AIA	ETF	45.99	46.08	45.63	45.68	14515.0
2013-03-25	AIQ	ETF	7.14	7.17	7.11	7.16	4309.0
2013-03-25	AIVI	ETF	42.82	42.86	42.11	42.25	37700.0
2013-03-25	ALTL	ETF	28.9255	28.9255	28.83	28.83	4135.0
2013-03-25	AMJ	ETF	44.88	45.24	44.73	44.85	1907222.0
2013-03-25	AMLP	ETF	87.65	88.25	87.6	87.7	629860.0
2013-03-25	ANGL	ETF	27.14	27.3	27.14	27.21	2100.0
2013-03-25	AOA	ETF	39.72	39.78	39.36	39.52	46800.0
2013-03-25	AOK	ETF	31.18	31.1881	31.05	31.1	13924.0
2013-03-25	AOM	ETF	32.77	32.7899	32.61	32.61	45199.0
2013-03-25	AOR	ETF	35.65	35.65	35.39	35.48	64550.0
2013-03-25	ARB	ETF	46.89	46.98	46.85	46.85	135987.0
2013-03-25	ARGT	ETF	17.86	17.9	17.86	17.88	2500.0
2013-03-25	ASEA	ETF	17.23	17.28	17.09	17.13	25700.0
2013-03-25	ATMP	ETF	25.87	25.95	25.7	25.7	20300.0
2013-03-25	AVIV	ETF	23.4	23.41	22.81	23.0	837667.0
2013-03-25	AWAY	ETF	33.44	34.09	32.91	33.29	1326898.0
2013-03-25	BAB	ETF	30.16	30.25	30.11	30.18	163565.0
2013-03-25	BAL	ETF	55.86	56.246	55.66	55.88	39540.0
2013-03-25	BALT	ETF	4.29	4.31	4.211	4.25	170780.0
2013-03-25	BBH	ETF	63.09	63.09	62.0	62.39	45500.0
2013-03-25	BCM	ETF	42.996	42.996	42.996	42.996	165.0
2013-03-25	BIB	ETF	18.8475	18.87	18.21	18.5125	78840.0
2013-03-25	BICK	ETF	23.95	23.9516	23.788	23.9	3872.0
2013-03-25	BIL	ETF	91.6	91.62	91.6	91.6	338550.0
2013-03-25	BIS	ETF	2000.0	2031.2	2000.0	2030.0	187.0
2013-03-25	BIV	ETF	87.67	87.82	87.56	87.79	210100.0
2013-03-25	BIZD	ETF	20.7	20.7	20.49	20.56	12300.0
2013-03-25	BJK	ETF	39.32	39.33	39.17	39.17	8200.0
2013-03-25	BKF	ETF	38.81	38.825	38.28	38.44	113281.0
2013-03-25	BKLN	ETF	25.11	25.11	25.06	25.07	1944900.0
2013-03-25	BLV	ETF	91.14	91.45	91.03	91.12	39300.0

> showing 50 of 986 rows — these rows as CSV

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