PREVIEW / etf_daily / 2012-07-27

all etf daily files

  file:    by_date/etf_daily/2012/2012-07-27.parquet
  size:    39 KB
  rows:    949

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
2012-07-27	SPY	ETF	136.89	139.07	136.14	138.68	236768900.0
2012-07-27	QQQ	ETF	63.83	64.99	63.64	64.87	42623491.0
2012-07-27	IWM	ETF	77.83	79.72	77.39	79.32	67297100.0
2012-07-27	DIA	ETF	129.02	130.89	128.98	130.54	7463900.0
2012-07-27	GLD	ETF	157.64	157.96	156.66	157.54	9772600.0
2012-07-27	TLT	ETF	129.89	130.01	126.96	128.48	14685100.0
2012-07-27	AADR	ETF	28.75	28.87	28.66	28.87	1000.0
2012-07-27	AAXJ	ETF	52.08	53.02	52.01	52.85	387100.0
2012-07-27	ACTV	ETF	14.34	14.7	14.21	14.67	172439.0
2012-07-27	ACWI	ETF	44.0	44.73	43.96	44.55	872800.0
2012-07-27	ACWV	ETF	55.79	55.83	55.3	55.7	23600.0
2012-07-27	ACWX	ETF	37.02	37.63	36.96	37.47	121539.0
2012-07-27	ADRE	ETF	37.65	38.35	37.449	38.35	67982.0
2012-07-27	AFK	ETF	27.892	28.46	27.892	28.34	72439.0
2012-07-27	AGEM	ETF	21.172	21.6279	21.172	21.52	3308.0
2012-07-27	AGG	ETF	112.45	112.46	112.15	112.29	1010200.0
2012-07-27	AGQ	ETF	153.16	154.88	150.0	154.56	219650.0
2012-07-27	AGZ	ETF	113.98	114.01	113.8	113.8201	7970.0
2012-07-27	AIA	ETF	41.34	42.09	41.34	42.04	10931.0
2012-07-27	AIQ	ETF	3.85	4.0	3.65	3.7	15200.0
2012-07-27	AIVI	ETF	37.61	38.26	37.56	38.17	61200.0
2012-07-27	AMJ	ETF	39.44	39.53	39.25	39.5	695470.0
2012-07-27	AMLP	ETF	82.3	82.35	81.9	82.2	271200.0
2012-07-27	ANGL	ETF	25.76	25.76	25.6	25.6	900.0
2012-07-27	AOA	ETF	35.06	35.48	35.06	35.48	10500.0
2012-07-27	AOK	ETF	30.02	30.1	29.991	30.06	21351.0
2012-07-27	AOM	ETF	30.82	31.05	30.82	31.02	56192.0
2012-07-27	AOR	ETF	32.61	32.92	32.61	32.85	28062.0
2012-07-27	ARB	ETF	35.99	37.1	35.32	36.86	86298.0
2012-07-27	ARGT	ETF	16.3	16.34	16.3	16.32	1950.0
2012-07-27	ASEA	ETF	16.0	16.25	16.0	16.25	16400.0
2012-07-27	AWAY	ETF	22.39	24.7	22.3302	24.17	1111090.0
2012-07-27	BAB	ETF	30.62	30.62	30.196	30.41	232455.0
2012-07-27	BAL	ETF	47.3799	48.1094	47.01	47.01	10375.0
2012-07-27	BALT	ETF	3.24	3.3	3.22	3.3	52819.0
2012-07-27	BBH	ETF	50.0	50.85	50.0	50.67	34000.0
2012-07-27	BCM	ETF	43.77	43.81	43.77	43.81	19967.0
2012-07-27	BIB	ETF	14.385	14.786	14.385	14.75	110536.0
2012-07-27	BICK	ETF	21.97	22.4169	21.97	22.39	11430.0
2012-07-27	BIL	ETF	91.64	91.66	91.64	91.66	179400.0
2012-07-27	BIS	ETF	2864.0	3289.6	2756.8	2763.6	133.5
2012-07-27	BIV	ETF	89.98	89.98	89.56	89.79	209700.0
2012-07-27	BJK	ETF	29.85	30.43	29.85	30.43	4200.0
2012-07-27	BKF	ETF	35.41	36.255	35.35	36.16	151084.0
2012-07-27	BKLN	ETF	24.57	24.59	24.52	24.55	254500.0
2012-07-27	BLV	ETF	98.65	98.71	97.18	98.12	123400.0
2012-07-27	BMVP	ETF	15.2	15.4667	15.1833	15.4667	4248.0
2012-07-27	BND	ETF	85.1	85.14	84.86	84.98	957400.0
2012-07-27	BNO	ETF	37.625	37.855	37.54	37.8	77200.0
2012-07-27	BOIL	ETF	1024000.0	1044000.0	992800.0	1026000.0	8.2

> showing 50 of 949 rows — these rows as CSV

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