PREVIEW / etf_daily / 2011-12-29

all etf daily files

  file:    by_date/etf_daily/2011/2011-12-29.parquet
  size:    37 KB
  rows:    896

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-29	SPY	ETF	125.24	126.25	124.86	126.12	123507200.0
2011-12-29	QQQ	ETF	55.68	56.03	55.5	55.99	28077809.0
2011-12-29	IWM	ETF	73.73	74.44	73.6	74.15	27090500.0
2011-12-29	DIA	ETF	121.52	122.68	121.46	122.52	5133600.0
2011-12-29	GLD	ETF	149.09	150.72	148.27	150.34	19812200.0
2011-12-29	TLT	ETF	120.48	121.09	120.06	120.86	4305000.0
2011-12-29	AADR	ETF	27.89	28.03	27.85	27.89	8900.0
2011-12-29	AAXJ	ETF	49.67	50.07	49.65	50.03	340700.0
2011-12-29	ACTV	ETF	13.23	13.45	13.21	13.34	128398.0
2011-12-29	ACWI	ETF	41.84	42.24	41.72	42.19	929700.0
2011-12-29	ACWV	ETF	51.27	51.47	51.17	51.47	23700.0
2011-12-29	ACWX	ETF	36.14	36.64	36.11	36.62	1341292.0
2011-12-29	ADRE	ETF	37.62	37.94	37.62	37.85	73776.0
2011-12-29	AFK	ETF	25.4	25.72	25.4	25.72	34779.0
2011-12-29	AGEM	ETF	20.39	20.5365	20.34	20.52	14968.0
2011-12-29	AGG	ETF	110.24	110.44	110.08	110.39	985400.0
2011-12-29	AGQ	ETF	153.96	169.28	153.0	168.76	850975.0
2011-12-29	AGZ	ETF	112.67	112.88	112.66	112.879	13161.0
2011-12-29	AIA	ETF	38.96	39.25	38.94	39.25	26731.0
2011-12-29	AIQ	ETF	5.35	5.6	5.1	5.3	12251.0
2011-12-29	AIS	ETF	2.3	2.31	2.14	2.18	1160555.0
2011-12-29	AIVI	ETF	38.86	39.52	38.86	39.5	107400.0
2011-12-29	AMJ	ETF	38.7	38.95	38.55	38.87	2599212.0
2011-12-29	AMLP	ETF	82.65	83.0	81.75	82.95	265520.0
2011-12-29	AOA	ETF	32.88	33.13	32.88	33.13	15900.0
2011-12-29	AOK	ETF	29.33	29.38	29.28	29.38	79318.0
2011-12-29	AOM	ETF	29.84	29.915	29.8	29.8701	12410.0
2011-12-29	AOR	ETF	31.07	31.2	31.032	31.16	5144.0
2011-12-29	ARB	ETF	34.83	35.18	34.79	34.94	101856.0
2011-12-29	ARGT	ETF	20.96	20.98	20.8	20.98	1550.0
2011-12-29	ASEA	ETF	14.31	14.46	14.26	14.34	6100.0
2011-12-29	AWAY	ETF	22.93	23.27	22.203	23.13	190558.0
2011-12-29	BAB	ETF	28.69	28.84	28.66	28.77	198351.0
2011-12-29	BAL	ETF	56.04	56.85	55.38	56.79	21178.0
2011-12-29	BALT	ETF	4.6	4.6	4.4	4.51	256337.0
2011-12-29	BBH	ETF	36.1033	36.4467	36.1033	36.4467	9900.0
2011-12-29	BCM	ETF	42.73	42.73	42.73	42.73	760.0
2011-12-29	BIB	ETF	8.4825	8.6207	8.4787	8.6207	18040.0
2011-12-29	BICK	ETF	22.53	22.67	22.53	22.62	17705.0
2011-12-29	BIL	ETF	91.66	91.68	91.66	91.66	196900.0
2011-12-29	BIS	ETF	6070.4	6070.4	5276.8	5276.8	20.6
2011-12-29	BITS	ETF	22.76	23.0	22.32	22.48	13112.0
2011-12-29	BIV	ETF	86.84	86.98	86.64	86.93	183500.0
2011-12-29	BJK	ETF	29.69	29.97	29.69	29.9	12700.0
2011-12-29	BKF	ETF	36.01	36.2	35.97	36.08	149505.0
2011-12-29	BKLN	ETF	23.88	23.88	23.74	23.74	115900.0
2011-12-29	BLV	ETF	91.61	92.09	91.39	91.95	348000.0
2011-12-29	BMVP	ETF	13.6933	13.7167	13.66	13.71	8942.0
2011-12-29	BND	ETF	83.41	83.55	83.32	83.48	1062300.0
2011-12-29	BNO	ETF	37.235	37.485	37.0	37.465	45200.0

> showing 50 of 896 rows — these rows as CSV

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