PREVIEW / etf_daily / 2011-12-28

all etf daily files

  file:    by_date/etf_daily/2011/2011-12-28.parquet
  size:    37 KB
  rows:    893

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
2011-12-28	SPY	ETF	126.51	126.53	124.73	124.83	119107100.0
2011-12-28	QQQ	ETF	56.17	56.26	55.44	55.59	38189532.0
2011-12-28	IWM	ETF	74.88	74.9	73.27	73.41	37827500.0
2011-12-28	DIA	ETF	122.66	122.72	121.13	121.25	3871400.0
2011-12-28	GLD	ETF	154.05	154.26	150.66	151.03	16436100.0
2011-12-28	TLT	ETF	118.74	121.05	118.45	120.64	8302300.0
2011-12-28	AAXJ	ETF	49.89	49.91	49.26	49.34	327400.0
2011-12-28	ACTV	ETF	13.0	13.13	12.95	13.01	83601.0
2011-12-28	ACWI	ETF	42.15	42.26	41.63	41.69	1077800.0
2011-12-28	ACWV	ETF	51.02	51.05	51.02	51.05	400.0
2011-12-28	ACWX	ETF	36.7	36.7	35.99	35.99	630089.0
2011-12-28	ADRE	ETF	38.09	38.09	37.5	37.57	34088.0
2011-12-28	AFK	ETF	25.73	25.73	25.4	25.43	23070.0
2011-12-28	AGEM	ETF	20.48	20.5	20.29	20.29	10664.0
2011-12-28	AGG	ETF	109.99	110.23	109.91	110.13	873800.0
2011-12-28	AGQ	ETF	177.56	177.64	158.76	160.64	901350.0
2011-12-28	AGZ	ETF	112.6	112.76	112.492	112.73	15130.0
2011-12-28	AIA	ETF	39.11	39.12	38.681	38.8	17928.0
2011-12-28	AIQ	ETF	5.15	5.8	4.95	5.3	23856.0
2011-12-28	AIS	ETF	1.99	2.28	1.97	2.22	2706841.0
2011-12-28	AIVI	ETF	39.45	39.45	38.68	38.7	98200.0
2011-12-28	AMJ	ETF	38.65	38.68	38.27	38.58	1983954.0
2011-12-28	AMLP	ETF	82.45	82.8	82.05	82.4	196320.0
2011-12-28	AOA	ETF	33.22	33.22	32.75	32.79	7700.0
2011-12-28	AOK	ETF	29.3	29.31	29.27	29.29	14502.0
2011-12-28	AOM	ETF	29.84	29.88	29.7596	29.78	48103.0
2011-12-28	AOR	ETF	31.03	31.04	30.91	30.94	31309.0
2011-12-28	ARB	ETF	35.36	35.39	34.56	34.65	93094.0
2011-12-28	ARGT	ETF	21.28	21.28	21.12	21.12	300.0
2011-12-28	ASEA	ETF	14.46	14.46	14.12	14.2	35100.0
2011-12-28	AWAY	ETF	22.05	23.42	21.69	23.0	328558.0
2011-12-28	BAB	ETF	28.6	28.75	28.53	28.69	93065.0
2011-12-28	BAL	ETF	56.9	56.911	55.67	55.86	35287.0
2011-12-28	BALT	ETF	4.89	4.94	4.59	4.6	113235.0
2011-12-28	BBH	ETF	36.48	36.48	35.9367	36.04	55800.0
2011-12-28	BCM	ETF	43.22	43.22	43.22	43.22	200.0
2011-12-28	BIB	ETF	8.665	8.665	8.4448	8.4448	4000.0
2011-12-28	BICK	ETF	22.77	22.77	22.39	22.43	54517.0
2011-12-28	BIL	ETF	91.66	91.68	91.66	91.66	273600.0
2011-12-28	BIS	ETF	5313.6	5435.2	5313.6	5423.68	29.65
2011-12-28	BITS	ETF	22.56	22.88	22.4	22.796	1125.0
2011-12-28	BIV	ETF	86.32	86.76	86.32	86.7	187100.0
2011-12-28	BJK	ETF	30.31	30.31	29.67	29.68	22500.0
2011-12-28	BKF	ETF	36.53	36.53	35.808	35.99	152046.0
2011-12-28	BKLN	ETF	23.85	23.91	23.75	23.89	226900.0
2011-12-28	BLNG	ETF	45.0	47.61	45.0	47.61	300.0
2011-12-28	BLV	ETF	90.45	91.82	90.45	91.55	31200.0
2011-12-28	BMVP	ETF	13.64	13.64	13.56	13.56	5638.0
2011-12-28	BND	ETF	83.12	83.43	83.02	83.41	1416800.0
2011-12-28	BNO	ETF	37.62	37.655	37.09	37.26	66200.0

> showing 50 of 893 rows — these rows as CSV

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