PREVIEW / etf_daily / 2012-07-12

all etf daily files

  file:    by_date/etf_daily/2012/2012-07-12.parquet
  size:    38 KB
  rows:    924

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-12	SPY	ETF	133.38	134.23	132.6	133.51	143583200.0
2012-07-12	QQQ	ETF	62.55	62.69	61.86	62.43	57680387.0
2012-07-12	IWM	ETF	78.44	79.1	77.59	78.79	55502600.0
2012-07-12	DIA	ETF	125.21	126.16	124.77	125.57	4412400.0
2012-07-12	GLD	ETF	151.26	153.07	150.85	152.59	11394800.0
2012-07-12	TLT	ETF	129.05	129.56	128.9	129.51	6421000.0
2012-07-12	AADR	ETF	27.89	27.89	27.89	27.89	200.0
2012-07-12	AAXJ	ETF	50.99	51.28	50.74	51.09	286900.0
2012-07-12	ACTV	ETF	14.7	14.75	14.37	14.59	220501.0
2012-07-12	ACWI	ETF	42.95	43.13	42.62	42.97	860000.0
2012-07-12	ACWV	ETF	54.25	54.55	54.25	54.55	900.0
2012-07-12	ACWX	ETF	36.13	36.26	35.86	36.2	218784.0
2012-07-12	ADRE	ETF	36.07	36.63	36.031	36.46	78172.0
2012-07-12	AFK	ETF	27.59	27.59	27.24	27.5	12012.0
2012-07-12	AGG	ETF	112.0	112.04	111.93	112.04	382700.0
2012-07-12	AGQ	ETF	142.32	150.72	141.52	148.6	376575.0
2012-07-12	AGZ	ETF	113.8	113.87	113.7	113.87	25918.0
2012-07-12	AIA	ETF	39.67	39.71	39.43	39.62	15305.0
2012-07-12	AIQ	ETF	4.5	4.5	4.315	4.5	3357.0
2012-07-12	AIVI	ETF	36.66	36.96	36.55	36.92	41500.0
2012-07-12	AMJ	ETF	38.93	39.22	38.84	39.05	686648.0
2012-07-12	AMLP	ETF	81.2	81.35	80.5	81.15	468680.0
2012-07-12	AOA	ETF	34.3	34.53	34.24	34.53	8100.0
2012-07-12	AOK	ETF	29.8	29.81	29.742	29.78	120191.0
2012-07-12	AOM	ETF	30.53	30.57	30.42	30.56	15996.0
2012-07-12	AOR	ETF	32.16	32.21	32.02	32.18	17792.0
2012-07-12	ARB	ETF	34.23	34.45	33.83	34.1	107398.0
2012-07-12	ARGT	ETF	15.8	15.8	15.58	15.72	2950.0
2012-07-12	ASEA	ETF	15.68	15.71	15.62	15.65	2100.0
2012-07-12	AWAY	ETF	20.85	20.88	20.5	20.81	314368.0
2012-07-12	BAB	ETF	30.34	30.369	30.2001	30.35	146310.0
2012-07-12	BAL	ETF	46.201	46.42	45.9201	46.17	23535.0
2012-07-12	BALT	ETF	3.51	3.71	3.46	3.67	66180.0
2012-07-12	BBH	ETF	46.88	47.72	46.6	47.59	9600.0
2012-07-12	BCM	ETF	42.11	42.11	42.11	42.11	100.0
2012-07-12	BIB	ETF	12.8	13.3358	12.6564	13.3358	51088.0
2012-07-12	BICK	ETF	21.53	21.7069	21.4279	21.67	5291.0
2012-07-12	BIL	ETF	91.62	91.64	91.62	91.62	260700.0
2012-07-12	BIS	ETF	3262.4	3262.4	3085.088	3111.04	25.6
2012-07-12	BIV	ETF	89.56	89.66	89.53	89.64	196800.0
2012-07-12	BJK	ETF	30.86	30.86	30.5	30.57	8800.0
2012-07-12	BKF	ETF	34.51	34.8708	34.406	34.74	116018.0
2012-07-12	BKLN	ETF	24.48	24.58	24.45	24.49	208000.0
2012-07-12	BLV	ETF	97.28	97.62	97.14	97.57	32800.0
2012-07-12	BMVP	ETF	15.09	15.21	14.98	15.21	26451.0
2012-07-12	BND	ETF	84.83	84.85	84.76	84.85	2024300.0
2012-07-12	BNO	ETF	35.1	35.735	34.925	35.56	142400.0
2012-07-12	BOIL	ETF	890000.0	951000.0	826000.0	925200.0	16.4
2012-07-12	BOND	ETF	106.56	106.65	106.56	106.63	667042.0
2012-07-12	BRF	ETF	34.58	34.82	34.328	34.68	86837.0

> showing 50 of 924 rows — these rows as CSV

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