PREVIEW / etf_daily / 2013-03-28

all etf daily files

  file:    by_date/etf_daily/2013/2013-03-28.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-28	SPY	ETF	156.09	156.85	155.75	156.67	102932800.0
2013-03-28	QQQ	ETF	68.81	69.06	68.64	68.97	23669800.0
2013-03-28	IWM	ETF	94.27	94.66	94.14	94.43	24160700.0
2013-03-28	DIA	ETF	145.01	145.53	144.84	145.32	4346000.0
2013-03-28	GLD	ETF	154.5	154.8	154.22	154.45	6851200.0
2013-03-28	TLT	ETF	118.12	118.45	117.68	117.76	5826400.0
2013-03-28	AAXJ	ETF	58.83	59.12	58.77	59.08	553800.0
2013-03-28	ACTV	ETF	4.08	4.2001	4.08	4.19	680163.0
2013-03-28	ACWI	ETF	50.6	50.8	50.54	50.75	631300.0
2013-03-28	ACWV	ETF	61.75	62.07	61.52	61.99	54300.0
2013-03-28	ACWX	ETF	42.67	42.86	42.6015	42.86	316527.0
2013-03-28	ADRE	ETF	38.64	38.65	38.43	38.6	66919.0
2013-03-28	AFK	ETF	30.26	30.42	30.2	30.37	294922.0
2013-03-28	AGEM	ETF	22.63	22.6499	22.512	22.6499	760.0
2013-03-28	AGG	ETF	110.68	110.78	110.65	110.73	2343300.0
2013-03-28	AGQ	ETF	152.28	153.76	149.36	151.0	279600.0
2013-03-28	AGZ	ETF	113.34	113.43	113.31	113.4024	20730.0
2013-03-28	AIA	ETF	46.26	46.47	46.26	46.44	22343.0
2013-03-28	AIQ	ETF	7.27	7.9947	7.27	7.77	46393.0
2013-03-28	AIVI	ETF	42.18	42.22	42.05	42.1	20800.0
2013-03-28	AMJ	ETF	45.04	45.48	45.02	45.48	1215252.0
2013-03-28	AMLP	ETF	88.2	88.6	88.0	88.6	502660.0
2013-03-28	ANGL	ETF	27.3	27.4	27.18	27.4	500.0
2013-03-28	AOA	ETF	39.69	39.8	39.68	39.78	21800.0
2013-03-28	AOK	ETF	31.13	31.22	31.13	31.19	28371.0
2013-03-28	AOM	ETF	32.74	32.84	32.73	32.83	16238.0
2013-03-28	AOR	ETF	35.65	35.74	35.601	35.73	16483.0
2013-03-28	ARB	ETF	46.85	46.92	46.85	46.87	148204.0
2013-03-28	ARGT	ETF	17.64	17.82	17.58	17.58	4050.0
2013-03-28	ASEA	ETF	17.66	17.73	17.62	17.71	16100.0
2013-03-28	ATMP	ETF	26.0	26.18	25.9	26.14	152100.0
2013-03-28	AVIV	ETF	23.99	24.17	23.82	24.06	514140.0
2013-03-28	AWAY	ETF	33.06	33.086	32.45	32.5	676202.0
2013-03-28	BAB	ETF	30.26	30.33	30.241	30.29	288564.0
2013-03-28	BAL	ETF	57.85	58.29	57.07	57.08	15124.0
2013-03-28	BALT	ETF	4.01	4.1099	4.0045	4.09	99489.0
2013-03-28	BBH	ETF	63.87	65.0	63.8	65.0	150200.0
2013-03-28	BCM	ETF	42.956	42.956	42.956	42.956	200.0
2013-03-28	BIB	ETF	19.0625	19.65	19.0625	19.615	128368.0
2013-03-28	BICK	ETF	24.06	24.112	23.97	24.112	529.0
2013-03-28	BIL	ETF	91.6	91.62	91.6	91.62	97800.0
2013-03-28	BIS	ETF	1966.8	1966.8	1913.996	1918.0	263.5
2013-03-28	BIV	ETF	88.0	88.07	87.94	88.03	180200.0
2013-03-28	BIZD	ETF	20.71	20.71	20.44	20.44	102300.0
2013-03-28	BJK	ETF	39.92	40.07	39.88	40.06	18900.0
2013-03-28	BKF	ETF	38.68	38.87	38.61	38.85	56728.0
2013-03-28	BKLN	ETF	25.06	25.11	25.06	25.1	3965500.0
2013-03-28	BLV	ETF	91.85	91.96	91.6	91.65	38100.0
2013-03-28	BMVP	ETF	18.5967	18.6687	18.5794	18.6687	1663.0
2013-03-28	BND	ETF	83.6	83.66	83.55	83.64	906400.0

> showing 50 of 975 rows — these rows as CSV

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