PREVIEW / etf_daily / 2013-03-26

all etf daily files

  file:    by_date/etf_daily/2013/2013-03-26.parquet
  size:    40 KB
  rows:    975

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-26	SPY	ETF	155.59	156.23	155.42	156.19	86856600.0
2013-03-26	QQQ	ETF	68.6	68.73	68.45	68.71	19734745.0
2013-03-26	IWM	ETF	94.34	94.49	93.75	94.25	26348000.0
2013-03-26	DIA	ETF	144.67	145.29	144.63	145.28	4877900.0
2013-03-26	GLD	ETF	154.47	154.91	154.28	154.72	7388700.0
2013-03-26	TLT	ETF	116.87	117.91	116.78	117.36	5093200.0
2013-03-26	AADR	ETF	32.71	32.72	32.65	32.65	4400.0
2013-03-26	AAXJ	ETF	58.6	59.0	58.6	58.98	448000.0
2013-03-26	ACTV	ETF	4.16	4.16	4.0	4.04	678816.0
2013-03-26	ACWI	ETF	50.47	50.66	50.4	50.64	2136800.0
2013-03-26	ACWV	ETF	61.4	61.64	61.39	61.61	45100.0
2013-03-26	ACWX	ETF	42.69	42.8	42.62	42.8	86200.0
2013-03-26	ADRE	ETF	38.22	38.4539	38.22	38.39	24716.0
2013-03-26	AFK	ETF	30.11	30.19	30.05	30.19	15727.0
2013-03-26	AGEM	ETF	22.58	22.61	22.58	22.5825	3042.0
2013-03-26	AGG	ETF	110.31	110.52	110.31	110.5	964700.0
2013-03-26	AGQ	ETF	155.48	155.92	154.04	154.8	176150.0
2013-03-26	AGZ	ETF	113.22	113.3	113.159	113.3	24507.0
2013-03-26	AIA	ETF	46.34	46.48	46.29	46.48	12451.0
2013-03-26	AIQ	ETF	7.04	7.19	7.01	7.15	12243.0
2013-03-26	AIVI	ETF	42.32	42.43	42.21	42.35	15100.0
2013-03-26	AMJ	ETF	44.93	45.18	44.65	45.17	1491009.0
2013-03-26	AMLP	ETF	87.9	88.35	87.7	88.25	562060.0
2013-03-26	ANGL	ETF	27.44	27.44	27.44	27.44	100.0
2013-03-26	AOA	ETF	39.6	39.69	39.54	39.69	22300.0
2013-03-26	AOK	ETF	31.08	31.159	31.08	31.159	5229.0
2013-03-26	AOM	ETF	32.81	32.81	32.67	32.73	18093.0
2013-03-26	AOR	ETF	35.55	35.61	35.506	35.58	26018.0
2013-03-26	ARB	ETF	46.89	46.95	46.84	46.87	176559.0
2013-03-26	ARGT	ETF	17.9	17.9	17.58	17.6	600.0
2013-03-26	ASEA	ETF	17.35	17.49	17.33	17.49	22600.0
2013-03-26	ATMP	ETF	25.8	25.98	25.75	25.98	53200.0
2013-03-26	AVIV	ETF	22.99	23.28	22.99	23.15	637262.0
2013-03-26	AWAY	ETF	33.53	33.55	32.6	33.18	485288.0
2013-03-26	BAB	ETF	30.23	30.236	30.111	30.23	137677.0
2013-03-26	BAL	ETF	57.19	57.32	56.75	56.84	18323.0
2013-03-26	BALT	ETF	4.24	4.2497	4.04	4.07	31677.0
2013-03-26	BBH	ETF	62.63	62.88	62.36	62.74	18200.0
2013-03-26	BCM	ETF	43.0717	43.203	43.0717	43.203	764.0
2013-03-26	BIB	ETF	18.665	18.665	18.3775	18.5025	31992.0
2013-03-26	BICK	ETF	24.02	24.08	23.99	24.03	3005.0
2013-03-26	BIL	ETF	91.62	91.62	91.6	91.62	119100.0
2013-03-26	BIV	ETF	87.67	87.84	87.62	87.81	185300.0
2013-03-26	BIZD	ETF	20.57	20.57	20.41	20.45	10300.0
2013-03-26	BJK	ETF	39.65	40.08	39.65	40.07	13700.0
2013-03-26	BKF	ETF	38.63	38.846	38.63	38.7	66122.0
2013-03-26	BKLN	ETF	25.11	25.11	25.08	25.11	2052000.0
2013-03-26	BLV	ETF	91.1	91.54	90.97	91.35	24900.0
2013-03-26	BMVP	ETF	18.46	18.5	18.44	18.5	4092.0
2013-03-26	BND	ETF	83.4	83.48	83.35	83.46	655500.0

> showing 50 of 975 rows — these rows as CSV

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