PREVIEW / etf_daily / 2012-08-01

all etf daily files

  file:    by_date/etf_daily/2012/2012-08-01.parquet
  size:    38 KB
  rows:    933

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-08-01	SPY	ETF	138.7	138.73	137.4	137.59	138293800.0
2012-08-01	QQQ	ETF	65.25	65.2799	64.35	64.61	30919778.0
2012-08-01	IWM	ETF	78.91	79.0	77.04	77.06	63601100.0
2012-08-01	DIA	ETF	130.47	130.5	129.18	129.45	5770000.0
2012-08-01	GLD	ETF	155.18	155.79	154.41	155.14	12714500.0
2012-08-01	TLT	ETF	128.53	129.74	128.15	128.78	7972000.0
2012-08-01	AADR	ETF	28.97	28.97	28.78	28.78	300.0
2012-08-01	AAXJ	ETF	53.64	53.64	53.03	53.12	167300.0
2012-08-01	ACTV	ETF	14.23	14.35	14.01	14.03	259359.0
2012-08-01	ACWI	ETF	44.49	44.57	44.18	44.18	767600.0
2012-08-01	ACWV	ETF	56.39	56.39	55.52	55.52	10700.0
2012-08-01	ACWX	ETF	37.56	37.61	37.25	37.25	330440.0
2012-08-01	ADRE	ETF	37.99	38.16	37.77	37.96	129688.0
2012-08-01	AFK	ETF	28.24	28.43	28.15	28.26	18258.0
2012-08-01	AGEM	ETF	21.58	21.58	21.3234	21.525	3515.0
2012-08-01	AGG	ETF	112.25	112.39	111.99	112.24	2480600.0
2012-08-01	AGQ	ETF	148.72	152.68	147.36	149.52	396225.0
2012-08-01	AGZ	ETF	113.77	113.85	113.66	113.68	9479.0
2012-08-01	AIA	ETF	42.82	42.82	42.48	42.48	9039.0
2012-08-01	AIQ	ETF	4.05	4.6	3.9	4.45	71537.0
2012-08-01	AIVI	ETF	38.15	38.31	37.98	38.0	27800.0
2012-08-01	AMJ	ETF	39.58	39.9	39.51	39.71	622844.0
2012-08-01	AMLP	ETF	82.55	82.9	82.35	82.75	311880.0
2012-08-01	ANGL	ETF	25.9	25.9	25.79	25.79	9300.0
2012-08-01	AOA	ETF	35.37	35.37	35.18	35.28	2000.0
2012-08-01	AOK	ETF	30.14	30.14	30.06	30.064	22953.0
2012-08-01	AOM	ETF	31.03	31.04	30.86	30.978	28358.0
2012-08-01	AOR	ETF	32.8999	32.8999	32.67	32.73	14199.0
2012-08-01	ARB	ETF	35.12	35.29	34.28	34.33	114293.0
2012-08-01	ARGT	ETF	15.8	15.8	15.8	15.8	50.0
2012-08-01	ASEA	ETF	16.32	16.4	16.24	16.31	2600.0
2012-08-01	AWAY	ETF	22.94	22.94	22.5	22.92	274661.0
2012-08-01	BAB	ETF	30.56	30.5992	30.37	30.45	210926.0
2012-08-01	BAL	ETF	46.93	46.93	46.54	46.5842	3312.0
2012-08-01	BALT	ETF	3.19	3.25	3.1	3.1	32384.0
2012-08-01	BBH	ETF	49.86	49.86	49.03	49.04	38500.0
2012-08-01	BCM	ETF	43.56	43.72	43.56	43.669	950.0
2012-08-01	BIB	ETF	13.9138	14.2062	13.5	13.5	54088.0
2012-08-01	BICK	ETF	22.63	22.6399	22.488	22.5	5880.0
2012-08-01	BIL	ETF	91.66	91.66	91.64	91.64	699750.0
2012-08-01	BIS	ETF	2876.8	3019.2	2876.8	3011.2	20.8
2012-08-01	BIV	ETF	89.84	89.96	89.64	89.77	390400.0
2012-08-01	BJK	ETF	30.24	30.25	30.04	30.17	2000.0
2012-08-01	BKF	ETF	36.02	36.09	35.69	35.84	61204.0
2012-08-01	BKLN	ETF	24.66	24.7	24.52	24.56	339800.0
2012-08-01	BLV	ETF	98.04	98.61	97.83	98.18	104600.0
2012-08-01	BMVP	ETF	15.3667	15.3911	15.3667	15.3911	1200.0
2012-08-01	BND	ETF	85.01	85.07	84.91	84.94	1587100.0
2012-08-01	BNO	ETF	37.575	37.935	37.415	37.495	114600.0
2012-08-01	BOIL	ETF	1103200.0	1166600.0	1085600.0	1113800.0	10.6

> showing 50 of 933 rows — these rows as CSV

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