PREVIEW / etf_daily / 2012-06-22

all etf daily files

  file:    by_date/etf_daily/2012/2012-06-22.parquet
  size:    38 KB
  rows:    934

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-06-22	SPY	ETF	133.13	133.71	132.62	133.46	130029200.0
2012-06-22	QQQ	ETF	62.88	63.43	62.731	63.35	29513101.0
2012-06-22	IWM	ETF	77.07	77.74	76.65	77.49	41001200.0
2012-06-22	DIA	ETF	126.13	126.48	125.78	126.23	5295800.0
2012-06-22	GLD	ETF	152.04	152.7	151.21	152.64	6755200.0
2012-06-22	TLT	ETF	125.9	126.22	125.01	125.02	7830400.0
2012-06-22	AAXJ	ETF	51.36	51.36	50.87	51.23	708600.0
2012-06-22	ACTV	ETF	15.95	15.98	15.56	15.7	3438593.0
2012-06-22	ACWI	ETF	42.92	42.92	42.6	42.82	475400.0
2012-06-22	ACWV	ETF	54.74	55.46	53.8	54.02	22000.0
2012-06-22	ACWX	ETF	36.16	36.17	35.83	36.09	204721.0
2012-06-22	ADRE	ETF	36.72	36.72	36.3334	36.53	23796.0
2012-06-22	AFK	ETF	26.8	26.9	26.65	26.83	4192.0
2012-06-22	AGEM	ETF	20.31	20.31	20.2118	20.2118	515.0
2012-06-22	AGG	ETF	111.17	111.2	111.04	111.04	600200.0
2012-06-22	AGQ	ETF	145.4	147.0	143.04	146.88	407825.0
2012-06-22	AGZ	ETF	113.46	113.52	113.35	113.4	15367.0
2012-06-22	AIA	ETF	40.1501	40.3295	40.0	40.27	141358.0
2012-06-22	AIQ	ETF	4.436	4.6	4.25	4.25	552086.0
2012-06-22	AIVI	ETF	37.98	38.04	37.69	37.97	195900.0
2012-06-22	AMJ	ETF	36.38	36.805	36.32	36.42	3799581.0
2012-06-22	AMLP	ETF	78.25	78.4	77.9	78.05	416120.0
2012-06-22	ANGL	ETF	25.4	25.4	25.35	25.35	3800.0
2012-06-22	AOA	ETF	34.45	34.6	34.41	34.6	4000.0
2012-06-22	AOK	ETF	29.71	29.75	29.6801	29.75	8936.0
2012-06-22	AOM	ETF	30.53	30.6	30.53	30.6	8086.0
2012-06-22	AOR	ETF	32.21	32.25	32.1305	32.24	8405.0
2012-06-22	ARB	ETF	34.38	34.62	34.04	34.5	75950.0
2012-06-22	ARGT	ETF	15.68	15.78	15.68	15.78	400.0
2012-06-22	ASEA	ETF	15.12	15.2	15.01	15.18	7100.0
2012-06-22	AWAY	ETF	21.28	21.88	21.0	21.16	2222504.0
2012-06-22	BAB	ETF	29.78	29.8	29.67	29.7	132743.0
2012-06-22	BAL	ETF	45.7	46.05	45.05	45.64	32726.0
2012-06-22	BALT	ETF	3.51	3.7	3.48	3.63	1770694.0
2012-06-22	BBH	ETF	46.0	46.9	46.0	46.84	10000.0
2012-06-22	BCM	ETF	39.85	39.881	39.76	39.8382	8597.0
2012-06-22	BIB	ETF	12.4887	12.82	12.4688	12.8	52872.0
2012-06-22	BICK	ETF	21.86	21.91	21.75	21.91	12074.0
2012-06-22	BIL	ETF	91.64	91.66	91.64	91.64	66950.0
2012-06-22	BIS	ETF	3374.4	3374.4	3273.6	3273.6	48.65
2012-06-22	BIV	ETF	88.56	88.61	88.32	88.34	338400.0
2012-06-22	BJK	ETF	31.99	31.99	31.82	31.93	2100.0
2012-06-22	BKF	ETF	34.75	34.78	34.3301	34.54	139943.0
2012-06-22	BKLN	ETF	24.28	24.32	24.15	24.21	278300.0
2012-06-22	BLV	ETF	95.17	95.4	94.58	94.76	54300.0
2012-06-22	BMVP	ETF	14.83	14.95	14.83	14.94	32888.0
2012-06-22	BND	ETF	84.28	84.29	84.11	84.13	2219900.0
2012-06-22	BNO	ETF	32.055	32.5	32.035	32.47	116600.0
2012-06-22	BOIL	ETF	797400.0	846800.0	795400.0	828600.0	12.8
2012-06-22	BOND	ETF	105.67	105.73	105.615	105.7	1604803.0

> showing 50 of 934 rows — these rows as CSV

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