PREVIEW / etf_daily / 2013-03-20

all etf daily files

  file:    by_date/etf_daily/2013/2013-03-20.parquet
  size:    40 KB
  rows:    977

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-20	SPY	ETF	155.52	155.95	155.26	155.69	113759300.0
2013-03-20	QQQ	ETF	68.74	68.86	68.39	68.709	28035338.0
2013-03-20	IWM	ETF	94.36	94.74	94.26	94.7	27958600.0
2013-03-20	DIA	ETF	144.86	145.15	144.59	144.81	5924700.0
2013-03-20	GLD	ETF	155.53	155.83	154.88	155.37	8221500.0
2013-03-20	TLT	ETF	116.71	116.99	116.08	116.12	8543900.0
2013-03-20	AAXJ	ETF	58.39	58.47	58.18	58.35	1442600.0
2013-03-20	ACTV	ETF	4.57	4.5999	4.27	4.32	1418243.0
2013-03-20	ACWI	ETF	50.72	50.81	50.61	50.75	863200.0
2013-03-20	ACWV	ETF	60.72	60.94	60.72	60.91	52100.0
2013-03-20	ACWX	ETF	43.05	43.09	42.93	42.99	118822.0
2013-03-20	ADRE	ETF	38.35	38.5	38.31	38.43	49883.0
2013-03-20	AFK	ETF	30.19	30.41	30.11	30.2426	21617.0
2013-03-20	AGEM	ETF	22.36	22.5299	22.36	22.5299	569.0
2013-03-20	AGG	ETF	110.39	110.48	110.32	110.35	1275100.0
2013-03-20	AGQ	ETF	156.36	156.76	152.08	155.64	201975.0
2013-03-20	AGZ	ETF	113.1555	113.272	113.12	113.248	6657.0
2013-03-20	AIA	ETF	45.67	45.8099	45.6	45.69	28032.0
2013-03-20	AIQ	ETF	7.05	7.19	7.05	7.19	1031.0
2013-03-20	AIVI	ETF	42.77	42.87	42.7	42.75	23500.0
2013-03-20	AMJ	ETF	43.38	43.8	43.24	43.79	1313401.0
2013-03-20	AMLP	ETF	85.55	86.25	85.4	86.25	557120.0
2013-03-20	AOA	ETF	39.67	39.74	39.61	39.71	95700.0
2013-03-20	AOK	ETF	31.1459	31.17	31.13	31.17	22607.0
2013-03-20	AOM	ETF	32.7	32.84	32.7	32.76	15122.0
2013-03-20	AOR	ETF	35.579	35.6108	35.54	35.56	5872.0
2013-03-20	ARB	ETF	46.96	46.99	46.88	46.94	332883.0
2013-03-20	ARGT	ETF	17.86	17.86	17.66	17.76	2950.0
2013-03-20	ASEA	ETF	17.12	17.22	17.12	17.22	10300.0
2013-03-20	ATMP	ETF	24.94	25.2	24.94	25.2	18800.0
2013-03-20	AWAY	ETF	30.21	30.77	30.15	30.55	484519.0
2013-03-20	BAB	ETF	30.19	30.19	30.11	30.13	167608.0
2013-03-20	BAL	ETF	59.15	59.15	57.04	57.7	71786.0
2013-03-20	BALT	ETF	3.95	4.0	3.9	3.99	32072.0
2013-03-20	BBH	ETF	62.43	62.76	62.4	62.59	35400.0
2013-03-20	BCM	ETF	42.806	42.806	42.806	42.806	279.0
2013-03-20	BIB	ETF	18.605	18.7737	18.42	18.6575	34272.0
2013-03-20	BICK	ETF	24.3	24.3599	24.24	24.24	2264.0
2013-03-20	BIL	ETF	91.6	91.62	91.6	91.6	140850.0
2013-03-20	BIS	ETF	2016.8	2016.8	2008.44	2008.44	5.0
2013-03-20	BIV	ETF	87.55	87.62	87.48	87.51	174600.0
2013-03-20	BIZD	ETF	20.56	20.56	20.52	20.52	600.0
2013-03-20	BJK	ETF	39.0	39.27	39.0	39.27	8100.0
2013-03-20	BKF	ETF	39.1	39.17	39.0	39.07	46790.0
2013-03-20	BKLN	ETF	25.06	25.08	25.06	25.07	1803500.0
2013-03-20	BLV	ETF	91.26	91.26	90.72	90.72	65700.0
2013-03-20	BMVP	ETF	18.39	18.5166	18.39	18.5166	2092.0
2013-03-20	BND	ETF	83.4	83.44	83.34	83.34	819100.0
2013-03-20	BNO	ETF	40.97	41.185	40.79	41.11	76000.0
2013-03-20	BOIL	ETF	971200.0	990200.0	963200.0	979200.0	12.2

> showing 50 of 977 rows — these rows as CSV

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