PREVIEW / etf_daily / 2013-02-27

all etf daily files

  file:    by_date/etf_daily/2013/2013-02-27.parquet
  size:    40 KB
  rows:    972

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-02-27	SPY	ETF	149.89	152.33	149.76	151.91	150781900.0
2013-02-27	QQQ	ETF	66.57	67.65	66.47	67.239	36339458.0
2013-02-27	IWM	ETF	89.36	90.85	89.31	90.31	41192300.0
2013-02-27	DIA	ETF	138.74	140.87	138.64	140.6	7404500.0
2013-02-27	GLD	ETF	155.46	155.6	154.08	154.57	9596100.0
2013-02-27	TLT	ETF	119.49	119.54	118.0	118.29	7459600.0
2013-02-27	AAXJ	ETF	59.53	60.34	59.53	60.18	346600.0
2013-02-27	ACTV	ETF	4.78	4.88	4.75	4.82	356020.0
2013-02-27	ACWI	ETF	49.27	50.01	49.26	49.91	1486900.0
2013-02-27	ACWV	ETF	58.86	59.43	58.83	59.39	49100.0
2013-02-27	ACWX	ETF	42.06	42.66	42.02	42.63	208294.0
2013-02-27	ADRE	ETF	38.9	39.32	38.9	39.25	19429.0
2013-02-27	AFK	ETF	30.51	30.7899	30.5	30.7899	12763.0
2013-02-27	AGEM	ETF	22.73	22.8912	22.73	22.8912	865.0
2013-02-27	AGG	ETF	110.83	110.84	110.62	110.73	520300.0
2013-02-27	AGQ	ETF	160.64	161.2	157.12	158.32	201750.0
2013-02-27	AGZ	ETF	113.4599	113.4599	113.23	113.331	18572.0
2013-02-27	AIA	ETF	46.91	47.45	46.91	47.4	9135.0
2013-02-27	AIQ	ETF	6.85	6.99	6.77	6.77	1784.0
2013-02-27	AIVI	ETF	41.43	42.13	41.43	42.05	30200.0
2013-02-27	AMJ	ETF	42.55	43.08	42.5	43.06	751243.0
2013-02-27	AMLP	ETF	84.8	85.3	84.5	85.2	526600.0
2013-02-27	ANGL	ETF	27.09	27.09	27.09	27.09	400.0
2013-02-27	AOA	ETF	38.5	38.9	38.43	38.86	28100.0
2013-02-27	AOK	ETF	30.8799	30.97	30.86	30.96	11207.0
2013-02-27	AOM	ETF	32.33	32.42	32.23	32.39	27263.0
2013-02-27	AOR	ETF	34.88	35.13	34.79	35.13	82862.0
2013-02-27	ARB	ETF	46.75	47.01	46.75	46.96	654200.0
2013-02-27	ARGT	ETF	17.32	17.38	17.32	17.36	6800.0
2013-02-27	ASEA	ETF	17.17	17.28	17.1	17.28	14200.0
2013-02-27	AWAY	ETF	28.18	29.8	28.06	29.44	1808815.0
2013-02-27	BAB	ETF	30.54	30.59	30.42	30.5	215822.0
2013-02-27	BAL	ETF	53.57	54.76	53.5301	54.64	92674.0
2013-02-27	BALT	ETF	3.46	3.55	3.4	3.55	102704.0
2013-02-27	BBH	ETF	58.08	59.21	58.0	58.83	47000.0
2013-02-27	BCM	ETF	43.19	43.19	43.19	43.19	200.0
2013-02-27	BIB	ETF	15.8575	16.6125	15.8575	16.455	40036.0
2013-02-27	BICK	ETF	25.0	25.1714	24.96	25.09	7601.0
2013-02-27	BIL	ETF	91.6	91.62	91.6	91.62	101600.0
2013-02-27	BIS	ETF	2338.4	2338.4	2338.4	2338.4	2.5
2013-02-27	BIV	ETF	88.05	88.05	87.74	87.85	153200.0
2013-02-27	BIZD	ETF	20.27	20.36	20.27	20.28	11000.0
2013-02-27	BJK	ETF	38.07	38.38	38.05	38.38	11400.0
2013-02-27	BKF	ETF	39.56	40.07	39.56	40.02	77290.0
2013-02-27	BKLN	ETF	25.0	25.01	24.99	25.0	1102400.0
2013-02-27	BLV	ETF	93.1	93.1	92.27	92.44	39900.0
2013-02-27	BMVP	ETF	17.6954	17.7929	17.6567	17.7686	2300.0
2013-02-27	BND	ETF	83.8	83.8	83.61	83.69	691400.0
2013-02-27	BNO	ETF	42.28	42.42	41.955	42.03	92000.0
2013-02-27	BOIL	ETF	780000.0	807200.0	747600.0	751400.0	22.0

> showing 50 of 972 rows — these rows as CSV

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