PREVIEW / etf_daily / 2012-05-07

all etf daily files

  file:    by_date/etf_daily/2012/2012-05-07.parquet
  size:    38 KB
  rows:    939

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-05-07	SPY	ETF	136.51	137.56	136.46	137.1	127765900.0
2012-05-07	QQQ	ETF	64.31	65.07	64.29	64.76	50266729.0
2012-05-07	IWM	ETF	78.76	79.6	78.62	79.3	47361400.0
2012-05-07	DIA	ETF	129.5	130.25	129.45	129.84	4040500.0
2012-05-07	GLD	ETF	159.31	159.34	158.45	159.08	4927800.0
2012-05-07	TLT	ETF	118.32	118.46	118.02	118.16	3228200.0
2012-05-07	AAXJ	ETF	55.3	55.66	55.3	55.55	296100.0
2012-05-07	ACTV	ETF	15.23	15.33	14.8	14.92	369918.0
2012-05-07	ACWI	ETF	45.32	45.73	45.32	45.65	460200.0
2012-05-07	ACWV	ETF	54.22	54.35	54.02	54.32	15000.0
2012-05-07	ACWX	ETF	39.01	39.279	38.98	39.22	189799.0
2012-05-07	ADRE	ETF	40.11	40.458	40.0	40.41	80337.0
2012-05-07	AFK	ETF	29.74	29.9174	29.72	29.8236	15486.0
2012-05-07	AGEM	ETF	22.0	22.21	22.0	22.21	958.0
2012-05-07	AGG	ETF	110.74	110.77	110.67	110.71	646100.0
2012-05-07	AGQ	ETF	189.44	189.44	182.2	187.08	293700.0
2012-05-07	AGZ	ETF	113.06	113.06	112.98	113.03	8108.0
2012-05-07	AIA	ETF	44.3	44.438	44.246	44.32	6963.0
2012-05-07	AIQ	ETF	7.35	7.5	7.1	7.15	13819.0
2012-05-07	AIS	ETF	2.96	3.16	2.95	3.15	827753.0
2012-05-07	AIVI	ETF	39.7	39.93	39.58	39.88	40000.0
2012-05-07	AMJ	ETF	39.75	39.78	39.164	39.52	1809490.0
2012-05-07	AMLP	ETF	82.6	83.0	81.55	82.0	591640.0
2012-05-07	ANGL	ETF	25.43	25.45	25.4	25.42	12000.0
2012-05-07	AOA	ETF	35.47	35.69	35.45	35.6	9000.0
2012-05-07	AOK	ETF	30.0	30.06	30.0	30.055	2283.0
2012-05-07	AOM	ETF	30.94	31.04	30.94	31.02	25388.0
2012-05-07	AOR	ETF	32.73	32.916	32.73	32.88	9165.0
2012-05-07	ARB	ETF	36.02	36.45	35.86	36.0	241937.0
2012-05-07	ARGT	ETF	17.78	17.78	17.48	17.68	5500.0
2012-05-07	ASEA	ETF	16.11	16.16	16.11	16.14	6600.0
2012-05-07	AWAY	ETF	25.4	25.72	25.34	25.45	221341.0
2012-05-07	BAB	ETF	29.6	29.62	29.55	29.594	104443.0
2012-05-07	BAL	ETF	54.503	54.6	53.47	53.55	34181.0
2012-05-07	BALT	ETF	4.05	4.18	4.05	4.13	82767.0
2012-05-07	BBH	ETF	45.16	46.11	45.16	46.04	11100.0
2012-05-07	BCM	ETF	43.22	43.463	43.13	43.463	87438.0
2012-05-07	BIB	ETF	11.4588	12.2037	11.235	12.1738	28368.0
2012-05-07	BICK	ETF	24.3	24.556	24.3	24.51	12673.0
2012-05-07	BIL	ETF	91.64	91.66	91.64	91.66	257750.0
2012-05-07	BIS	ETF	3603.2	3603.2	3512.0	3512.0	32.45
2012-05-07	BIV	ETF	88.14	88.19	88.08	88.11	203000.0
2012-05-07	BJK	ETF	35.69	35.83	35.62	35.62	6800.0
2012-05-07	BKF	ETF	38.77	38.94	38.64	38.89	115146.0
2012-05-07	BKLN	ETF	24.71	24.8	24.62	24.76	419000.0
2012-05-07	BLNG	ETF	49.24	49.24	49.24	49.24	340.0
2012-05-07	BLV	ETF	92.05	92.1	91.88	91.97	35000.0
2012-05-07	BMVP	ETF	15.1	15.2267	15.1	15.19	1666.0
2012-05-07	BND	ETF	83.97	83.97	83.91	83.91	1049200.0
2012-05-07	BNO	ETF	39.665	39.93	39.445	39.905	142000.0

> showing 50 of 939 rows — these rows as CSV

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