PREVIEW / etf_daily / 2012-01-11

all etf daily files

  file:    by_date/etf_daily/2012/2012-01-11.parquet
  size:    37 KB
  rows:    890

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-01-11	SPY	ETF	128.73	129.37	128.52	129.2	111540700.0
2012-01-11	QQQ	ETF	58.02	58.29	57.81	58.16	37144050.0
2012-01-11	IWM	ETF	75.95	76.67	75.87	76.57	33445800.0
2012-01-11	DIA	ETF	124.04	124.45	123.8	124.29	4890300.0
2012-01-11	GLD	ETF	159.34	160.05	158.91	159.67	7968500.0
2012-01-11	TLT	ETF	119.04	120.06	118.98	119.86	8634500.0
2012-01-11	AADR	ETF	28.68	28.68	28.1	28.44	900.0
2012-01-11	AAXJ	ETF	51.49	51.69	51.35	51.56	280000.0
2012-01-11	ACTV	ETF	13.54	14.36	13.52	14.12	1177202.0
2012-01-11	ACWI	ETF	42.94	43.21	42.78	43.15	431600.0
2012-01-11	ACWV	ETF	51.65	51.65	51.65	51.65	100.0
2012-01-11	ACWX	ETF	37.16	37.27	36.98	37.23	205023.0
2012-01-11	ADRE	ETF	39.99	40.304	39.87	40.24	30377.0
2012-01-11	AFK	ETF	26.29	26.69	26.27	26.41	6787.0
2012-01-11	AGEM	ETF	21.65	21.65	21.65	21.65	380.0
2012-01-11	AGG	ETF	110.13	110.39	110.06	110.39	789900.0
2012-01-11	AGQ	ETF	192.0	197.92	190.48	194.6	487550.0
2012-01-11	AGZ	ETF	112.77	113.18	112.757	113.18	7107.0
2012-01-11	AIA	ETF	40.0805	40.2948	40.08	40.29	13121.0
2012-01-11	AIQ	ETF	5.7	5.75	5.55	5.65	7930.0
2012-01-11	AIS	ETF	2.25	2.25	2.18	2.21	571464.0
2012-01-11	AIVI	ETF	39.4	39.6	39.27	39.6	46000.0
2012-01-11	AMJ	ETF	38.81	39.23	38.54	38.68	4859709.0
2012-01-11	AMLP	ETF	82.95	83.1	82.25	82.55	601120.0
2012-01-11	AOA	ETF	33.7	33.89	33.66	33.89	8500.0
2012-01-11	AOK	ETF	29.48	29.52	29.4608	29.48	166907.0
2012-01-11	AOM	ETF	30.04	30.169	30.04	30.16	17838.0
2012-01-11	AOR	ETF	31.5217	31.71	31.52	31.64	182196.0
2012-01-11	ARB	ETF	35.79	36.5	35.73	36.29	131250.0
2012-01-11	ARGT	ETF	22.56	22.56	22.56	22.56	250.0
2012-01-11	ASEA	ETF	14.77	14.77	14.62	14.7	8500.0
2012-01-11	AWAY	ETF	23.44	25.0	23.33	24.91	495027.0
2012-01-11	BAB	ETF	28.74	28.8897	28.7	28.85	255398.0
2012-01-11	BAL	ETF	59.61	60.0359	59.28	59.96	6438.0
2012-01-11	BALT	ETF	4.49	4.51	4.35	4.41	92670.0
2012-01-11	BBH	ETF	39.0633	39.72	39.0633	39.7	21600.0
2012-01-11	BCM	ETF	44.21	44.48	44.21	44.48	600.0
2012-01-11	BIB	ETF	9.7825	9.8949	9.625	9.8949	63488.0
2012-01-11	BICK	ETF	24.01	24.32	24.01	24.2704	6678.0
2012-01-11	BIL	ETF	91.66	91.66	91.64	91.64	402000.0
2012-01-11	BIS	ETF	4648.0	4648.0	4606.4	4608.96	38.05
2012-01-11	BITS	ETF	22.4	22.68	22.08	22.56	1761.0
2012-01-11	BIV	ETF	87.01	87.2	86.83	87.17	260300.0
2012-01-11	BJK	ETF	30.59	30.94	30.58	30.88	3900.0
2012-01-11	BKF	ETF	38.2	38.4788	38.15	38.44	145166.0
2012-01-11	BKLN	ETF	24.19	24.2	24.11	24.2	271600.0
2012-01-11	BLV	ETF	91.41	91.62	91.19	91.38	121600.0
2012-01-11	BMVP	ETF	13.9453	13.9834	13.9367	13.9833	2900.0
2012-01-11	BND	ETF	83.51	83.59	83.45	83.57	853400.0
2012-01-11	BNO	ETF	39.195	39.28	38.95	39.13	113800.0

> showing 50 of 890 rows — these rows as CSV

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