PREVIEW / etf_daily / 2012-07-31

all etf daily files

  file:    by_date/etf_daily/2012/2012-07-31.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-31	SPY	ETF	138.49	138.87	137.71	137.71	120575900.0
2012-07-31	QQQ	ETF	64.91	65.18	64.74	64.8	34595377.0
2012-07-31	IWM	ETF	78.73	79.47	78.35	78.35	48933500.0
2012-07-31	DIA	ETF	130.25	130.53	129.69	129.69	4783400.0
2012-07-31	GLD	ETF	157.6	157.72	156.26	156.49	10919700.0
2012-07-31	TLT	ETF	129.81	129.88	128.58	129.7	7448600.0
2012-07-31	AAXJ	ETF	53.15	53.4	52.98	52.98	298300.0
2012-07-31	ACTV	ETF	14.64	14.75	14.16	14.19	179544.0
2012-07-31	ACWI	ETF	44.52	44.66	44.22	44.23	1299900.0
2012-07-31	ACWV	ETF	56.7	56.7	55.5	55.52	25400.0
2012-07-31	ACWX	ETF	37.47	37.5909	37.285	37.29	183930.0
2012-07-31	ADRE	ETF	38.28	38.4	37.88	37.88	44223.0
2012-07-31	AFK	ETF	28.2	28.2	27.97	27.97	27989.0
2012-07-31	AGEM	ETF	21.36	21.36	21.21	21.21	910.0
2012-07-31	AGG	ETF	112.58	112.65	112.43	112.59	983600.0
2012-07-31	AGQ	ETF	159.08	159.72	155.88	156.4	249350.0
2012-07-31	AGZ	ETF	113.94	114.0	113.87	113.959	12316.0
2012-07-31	AIA	ETF	42.694	42.708	42.48	42.48	7465.0
2012-07-31	AIQ	ETF	4.0	4.25	3.9	4.05	10351.0
2012-07-31	AIVI	ETF	38.07	38.25	37.96	38.03	29600.0
2012-07-31	AMJ	ETF	39.4	39.7	39.4	39.51	1317449.0
2012-07-31	AMLP	ETF	82.3	82.6	82.15	82.25	388840.0
2012-07-31	ANGL	ETF	25.75	25.75	25.75	25.75	700.0
2012-07-31	AOA	ETF	35.2	35.45	35.2	35.26	8700.0
2012-07-31	AOK	ETF	30.19	30.19	30.07	30.1	33698.0
2012-07-31	AOM	ETF	31.0	31.06	30.9722	30.9762	17808.0
2012-07-31	AOR	ETF	32.9	32.9	32.77	32.79	21911.0
2012-07-31	ARB	ETF	35.85	35.85	34.95	35.07	100003.0
2012-07-31	ASEA	ETF	16.29	16.32	16.23	16.28	16000.0
2012-07-31	AWAY	ETF	23.47	23.71	22.7	22.96	592415.0
2012-07-31	BAB	ETF	30.94	30.94	30.4307	30.61	276033.0
2012-07-31	BAL	ETF	47.32	47.38	46.8049	47.0301	27970.0
2012-07-31	BALT	ETF	3.27	3.3	3.18	3.18	31041.0
2012-07-31	BBH	ETF	50.28	50.45	49.62	49.62	20400.0
2012-07-31	BCM	ETF	43.8824	43.95	43.83	43.83	16950.0
2012-07-31	BIB	ETF	14.3325	14.3325	13.8975	13.8975	39760.0
2012-07-31	BICK	ETF	22.57	22.6525	22.38	22.38	3772.0
2012-07-31	BIL	ETF	91.62	91.64	91.62	91.62	150900.0
2012-07-31	BIS	ETF	2844.8	2899.2	2832.0	2899.2	21.2
2012-07-31	BIV	ETF	90.16	90.2	89.94	90.18	242800.0
2012-07-31	BJK	ETF	30.1	30.1	30.09	30.09	400.0
2012-07-31	BKF	ETF	36.06	36.19	35.75	35.75	59699.0
2012-07-31	BKLN	ETF	24.6	24.61	24.57	24.57	318400.0
2012-07-31	BLV	ETF	98.82	98.82	98.18	98.72	28100.0
2012-07-31	BMVP	ETF	15.427	15.517	15.424	15.429	7463.0
2012-07-31	BND	ETF	85.25	85.28	85.12	85.23	754800.0
2012-07-31	BNO	ETF	37.63	37.63	37.0	37.015	97200.0
2012-07-31	BOIL	ETF	1140000.0	1194400.0	1108000.0	1155200.0	12.0
2012-07-31	BOND	ETF	107.3	107.3	107.15	107.29	542718.0
2012-07-31	BRF	ETF	36.12	36.3	35.8632	35.87	123360.0

> showing 50 of 929 rows — these rows as CSV

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