PREVIEW / etf_daily / 2012-07-16

all etf daily files

  file:    by_date/etf_daily/2012/2012-07-16.parquet
  size:    38 KB
  rows:    929

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-07-16	SPY	ETF	135.44	135.83	134.9	135.43	97525200.0
2012-07-16	QQQ	ETF	63.24	63.52	62.95	63.2	27623184.0
2012-07-16	IWM	ETF	79.62	79.88	79.11	79.45	31922600.0
2012-07-16	DIA	ETF	127.25	127.51	126.75	127.12	1991700.0
2012-07-16	GLD	ETF	154.43	154.75	153.98	154.21	5710900.0
2012-07-16	TLT	ETF	130.3	130.61	129.61	129.77	5283500.0
2012-07-16	AADR	ETF	27.81	27.81	27.8	27.8	500.0
2012-07-16	AAXJ	ETF	51.52	51.79	51.34	51.59	292600.0
2012-07-16	ACTV	ETF	15.0	15.0	14.7	14.75	73402.0
2012-07-16	ACWI	ETF	43.63	43.65	43.3	43.54	600400.0
2012-07-16	ACWV	ETF	54.93	55.19	54.89	54.98	7100.0
2012-07-16	ACWX	ETF	36.59	36.76	36.41	36.69	156851.0
2012-07-16	ADRE	ETF	36.94	37.014	36.781	36.952	43555.0
2012-07-16	AFK	ETF	27.63	27.88	27.56	27.87	26733.0
2012-07-16	AGG	ETF	112.21	112.32	112.16	112.17	480800.0
2012-07-16	AGQ	ETF	150.36	151.0	148.08	149.76	208175.0
2012-07-16	AGZ	ETF	113.91	113.98	113.81	113.82	15675.0
2012-07-16	AIA	ETF	40.25	40.37	40.09	40.24	4075.0
2012-07-16	AIQ	ETF	4.4	4.745	4.3505	4.68	5566.0
2012-07-16	AIVI	ETF	37.39	37.65	37.21	37.57	17000.0
2012-07-16	AMJ	ETF	39.29	39.75	39.29	39.61	491999.0
2012-07-16	AMLP	ETF	81.85	82.15	81.55	82.05	492200.0
2012-07-16	ANGL	ETF	25.41	25.6	25.41	25.57	4700.0
2012-07-16	AOA	ETF	34.89	34.9	34.71	34.89	11700.0
2012-07-16	AOK	ETF	29.94	29.95	29.9018	29.9132	4855.0
2012-07-16	AOM	ETF	30.74	30.7799	30.6784	30.7132	28179.0
2012-07-16	AOR	ETF	32.54	32.54	32.4111	32.4111	14407.0
2012-07-16	ARB	ETF	34.37	34.64	34.24	34.36	90139.0
2012-07-16	ASEA	ETF	15.9	16.02	15.84	15.98	12700.0
2012-07-16	AWAY	ETF	21.05	21.59	20.8	21.35	157663.0
2012-07-16	BAB	ETF	30.35	30.35	30.2236	30.3	187763.0
2012-07-16	BAL	ETF	47.86	48.4	47.77	48.23	44478.0
2012-07-16	BALT	ETF	3.7	3.705	3.5	3.52	62390.0
2012-07-16	BBH	ETF	48.26	48.5	48.12	48.4	43900.0
2012-07-16	BCM	ETF	43.58	43.58	43.5782	43.5782	200.0
2012-07-16	BIB	ETF	13.5	13.7937	13.245	13.6875	67208.0
2012-07-16	BICK	ETF	21.82	21.9082	21.7725	21.8	4380.0
2012-07-16	BIL	ETF	91.62	91.64	91.62	91.62	98000.0
2012-07-16	BIS	ETF	3011.216	3064.0	3001.6	3029.44	164.5
2012-07-16	BIV	ETF	89.95	89.95	89.75	89.78	286700.0
2012-07-16	BJK	ETF	30.76	30.94	30.76	30.9	6900.0
2012-07-16	BKF	ETF	35.16	35.24	34.9	35.15	130125.0
2012-07-16	BKLN	ETF	24.43	24.52	24.43	24.46	181200.0
2012-07-16	BLV	ETF	98.05	98.22	97.61	97.79	151400.0
2012-07-16	BMVP	ETF	15.3767	15.44	15.37	15.41	23933.0
2012-07-16	BND	ETF	85.0	85.07	84.9	84.91	1885600.0
2012-07-16	BNO	ETF	36.41	36.78	36.21	36.755	104800.0
2012-07-16	BOIL	ETF	920200.0	925600.0	867400.0	880200.0	9.0
2012-07-16	BOND	ETF	106.94	106.99	106.851	106.94	564676.0
2012-07-16	BRF	ETF	35.08	35.13	34.58	34.89	122749.0

> showing 50 of 929 rows — these rows as CSV

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