PREVIEW / etf_daily / 2012-11-26

all etf daily files

  file:    by_date/etf_daily/2012/2012-11-26.parquet
  size:    39 KB
  rows:    953

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-11-26	SPY	ETF	140.65	141.36	140.19	141.05	100124400.0
2012-11-26	QQQ	ETF	64.77	65.22	64.54	65.181	26430885.0
2012-11-26	IWM	ETF	80.35	80.79	80.07	80.73	31180700.0
2012-11-26	DIA	ETF	129.12	129.52	128.79	129.52	4621000.0
2012-11-26	GLD	ETF	169.56	169.73	169.25	169.43	5377700.0
2012-11-26	TLT	ETF	125.16	125.52	124.75	124.8	2799000.0
2012-11-26	AADR	ETF	29.78	29.98	29.78	29.98	1300.0
2012-11-26	AAXJ	ETF	57.37	57.45	57.09	57.45	176200.0
2012-11-26	ACTV	ETF	4.865	4.94	4.74	4.79	681274.0
2012-11-26	ACWI	ETF	46.73	46.84	46.55	46.84	585500.0
2012-11-26	ACWV	ETF	56.21	56.26	55.95	56.07	28200.0
2012-11-26	ACWX	ETF	40.02	40.18	39.99	40.15	104500.0
2012-11-26	ADRE	ETF	38.34	38.38	38.16	38.37	17232.0
2012-11-26	AFK	ETF	30.44	30.65	30.44	30.57	27831.0
2012-11-26	AGEM	ETF	22.1	22.32	22.1	22.32	7307.0
2012-11-26	AGG	ETF	112.02	112.09	111.95	112.0	629500.0
2012-11-26	AGQ	ETF	224.4	225.76	222.6	224.76	271600.0
2012-11-26	AGZ	ETF	113.75	113.85	113.7301	113.85	12567.0
2012-11-26	AIA	ETF	45.61	45.76	45.38	45.74	84199.0
2012-11-26	AIQ	ETF	6.0	6.25	5.9	6.2	10397.0
2012-11-26	AIVI	ETF	40.0	40.12	39.96	40.12	19700.0
2012-11-26	AMJ	ETF	39.88	40.01	39.5901	39.62	693461.0
2012-11-26	AMLP	ETF	80.95	81.2	80.7	80.8	554520.0
2012-11-26	ANGL	ETF	26.6	26.79	26.6	26.75	38300.0
2012-11-26	AOA	ETF	36.41	36.51	36.32	36.51	9500.0
2012-11-26	AOK	ETF	30.39	30.45	30.39	30.45	9130.0
2012-11-26	AOM	ETF	31.5	31.53	31.4645	31.53	5790.0
2012-11-26	AOR	ETF	33.51	33.54	33.4401	33.54	64368.0
2012-11-26	ARB	ETF	35.9	36.37	35.53	36.35	139514.0
2012-11-26	ARGT	ETF	15.96	15.96	15.9	15.9	200.0
2012-11-26	ASEA	ETF	16.68	16.71	16.61	16.7	7700.0
2012-11-26	AWAY	ETF	20.92	21.0	20.49	20.71	248957.0
2012-11-26	BAB	ETF	30.43	30.474	30.35	30.39	191201.0
2012-11-26	BAL	ETF	47.06	47.57	47.03	47.35	5406.0
2012-11-26	BALT	ETF	3.02	3.08	2.96	2.97	77278.0
2012-11-26	BBH	ETF	54.5	54.5	53.77	54.18	75300.0
2012-11-26	BCM	ETF	44.8	44.8	44.8	44.8	1392.0
2012-11-26	BIB	ETF	14.73	14.73	14.2965	14.6	137132.0
2012-11-26	BICK	ETF	23.52	23.669	23.5009	23.669	2515.0
2012-11-26	BIL	ETF	91.62	91.64	91.62	91.62	594700.0
2012-11-26	BIS	ETF	2681.6	2686.4	2681.6	2686.4	17.5
2012-11-26	BIV	ETF	90.25	90.32	90.12	90.12	261900.0
2012-11-26	BJK	ETF	35.06	35.06	35.06	35.06	100.0
2012-11-26	BKF	ETF	37.95	38.12	37.87	38.12	23266.0
2012-11-26	BKLN	ETF	24.67	24.67	24.62	24.64	267400.0
2012-11-26	BLV	ETF	97.0	97.22	96.66	96.75	82700.0
2012-11-26	BMVP	ETF	15.837	15.847	15.732	15.847	6928.0
2012-11-26	BND	ETF	84.86	84.87	84.73	84.73	951100.0
2012-11-26	BNO	ETF	40.535	40.62	40.475	40.535	42200.0
2012-11-26	BOIL	ETF	1077400.0	1088800.0	1053800.0	1080600.0	8.2

> showing 50 of 953 rows — these rows as CSV

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