PREVIEW / etf_daily / 2012-11-28

all etf daily files

  file:    by_date/etf_daily/2012/2012-11-28.parquet
  size:    39 KB
  rows:    950

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-28	SPY	ETF	139.76	141.54	139.0	141.46	177086500.0
2012-11-28	QQQ	ETF	64.66	65.57	64.25	65.52	37295780.0
2012-11-28	IWM	ETF	80.32	81.31	79.63	81.31	51316900.0
2012-11-28	DIA	ETF	128.17	129.75	127.47	129.64	7397000.0
2012-11-28	GLD	ETF	165.43	166.84	165.38	166.55	12880100.0
2012-11-28	TLT	ETF	125.97	126.2	125.09	125.11	3569700.0
2012-11-28	AADR	ETF	29.86	30.42	29.74	30.42	5100.0
2012-11-28	AAXJ	ETF	56.9	57.63	56.75	57.6	195400.0
2012-11-28	ACTV	ETF	4.7	4.75	4.67	4.67	582936.0
2012-11-28	ACWI	ETF	46.32	46.92	46.12	46.9	743100.0
2012-11-28	ACWV	ETF	55.61	56.19	55.61	56.19	8600.0
2012-11-28	ACWX	ETF	39.76	40.27	39.65	40.27	209591.0
2012-11-28	ADRE	ETF	37.71	38.1	37.59	38.1	33149.0
2012-11-28	AFK	ETF	30.0	30.199	29.75	30.16	140813.0
2012-11-28	AGEM	ETF	22.47	22.47	21.93	22.1399	2985.0
2012-11-28	AGG	ETF	112.2	112.26	112.16	112.17	458700.0
2012-11-28	AGQ	ETF	210.16	220.48	209.64	219.24	483450.0
2012-11-28	AGZ	ETF	113.82	114.019	113.754	113.78	18190.0
2012-11-28	AIA	ETF	45.33	45.85	45.185	45.85	15575.0
2012-11-28	AIQ	ETF	6.05	6.2	5.85	6.1	2040.0
2012-11-28	AIVI	ETF	39.6	40.21	39.51	40.19	35300.0
2012-11-28	AMJ	ETF	39.34	39.67	39.17	39.65	2244112.0
2012-11-28	AMLP	ETF	80.8	81.4	80.8	81.4	359700.0
2012-11-28	ANGL	ETF	26.89	26.95	26.85	26.85	16900.0
2012-11-28	AOA	ETF	36.25	36.52	36.25	36.52	1700.0
2012-11-28	AOK	ETF	30.42	30.4872	30.35	30.48	20003.0
2012-11-28	AOM	ETF	31.33	31.58	31.33	31.58	52535.0
2012-11-28	AOR	ETF	33.35	33.6	33.26	33.6	32469.0
2012-11-28	ARB	ETF	36.17	36.95	35.59	36.76	186271.0
2012-11-28	ARGT	ETF	15.76	15.76	15.74	15.74	850.0
2012-11-28	ASEA	ETF	16.43	16.7	16.43	16.67	10100.0
2012-11-28	AWAY	ETF	20.99	21.3	20.63	20.75	717075.0
2012-11-28	BAB	ETF	30.53	30.65	30.491	30.62	605277.0
2012-11-28	BAL	ETF	46.93	47.34	46.74	47.18	7904.0
2012-11-28	BALT	ETF	2.97	3.0	2.9	2.97	54018.0
2012-11-28	BBH	ETF	53.76	54.0	52.74	54.0	22000.0
2012-11-28	BCM	ETF	44.53	44.54	44.51	44.51	2510.0
2012-11-28	BIB	ETF	14.3475	14.5825	13.8925	14.5675	39996.0
2012-11-28	BICK	ETF	23.37	23.61	23.37	23.59	1844.0
2012-11-28	BIL	ETF	91.62	91.64	91.62	91.62	63950.0
2012-11-28	BIS	ETF	2728.0	2744.0	2728.0	2744.0	43.75
2012-11-28	BIV	ETF	90.51	90.55	90.41	90.5	209200.0
2012-11-28	BJK	ETF	35.3	35.75	35.3	35.75	5200.0
2012-11-28	BKF	ETF	37.38	37.829	37.28	37.82	46717.0
2012-11-28	BKLN	ETF	24.68	24.68	24.59	24.6	2226200.0
2012-11-28	BLV	ETF	97.55	97.61	97.0	97.0	88200.0
2012-11-28	BMVP	ETF	15.67	15.84	15.65	15.84	3632.0
2012-11-28	BND	ETF	84.93	85.0	84.9	84.95	803400.0
2012-11-28	BNO	ETF	39.755	40.145	39.575	40.135	62000.0
2012-11-28	BOIL	ETF	1031400.0	1037600.0	998200.0	1037400.0	12.0

> showing 50 of 950 rows — these rows as CSV

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