PREVIEW / etf_daily / 2011-02-14

all etf daily files

  file:    by_date/etf_daily/2011/2011-02-14.parquet
  size:    35 KB
  rows:    828

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-02-14	SPY	ETF	133.03	133.54	132.88	133.43	101690700.0
2011-02-14	QQQ	ETF	58.43	58.66	58.38	58.58	48506026.0
2011-02-14	IWM	ETF	82.11	82.61	82.05	82.49	36730500.0
2011-02-14	DIA	ETF	122.49	122.71	122.3	122.61	4093900.0
2011-02-14	GLD	ETF	132.95	133.38	132.7	132.95	8694200.0
2011-02-14	TLT	ETF	89.31	89.93	89.31	89.52	8033500.0
2011-02-14	AADR	ETF	30.23	30.24	30.23	30.24	300.0
2011-02-14	AAXJ	ETF	60.66	60.91	60.64	60.64	1028400.0
2011-02-14	ACWI	ETF	48.45	48.57	48.39	48.48	486400.0
2011-02-14	ACWX	ETF	45.02	45.22	44.99	45.14	221051.0
2011-02-14	ADRE	ETF	46.14	46.692	46.14	46.53	75192.0
2011-02-14	AFK	ETF	33.91	34.08	33.39	33.58	32370.0
2011-02-14	AGG	ETF	104.21	104.45	104.21	104.35	1024900.0
2011-02-14	AGQ	ETF	300.18	308.24	299.9	306.82	397600.0
2011-02-14	AGZ	ETF	108.61	108.9383	108.61	108.89	24657.0
2011-02-14	AIA	ETF	46.27	46.27	46.06	46.11	33998.0
2011-02-14	AIQ	ETF	21.3	21.3	20.55	20.55	13754.0
2011-02-14	AIS	ETF	1.86	1.87	1.7	1.72	1913310.0
2011-02-14	AIVI	ETF	45.72	46.07	45.68	46.0	14900.0
2011-02-14	AMJ	ETF	37.57	37.92	37.53	37.92	934950.0
2011-02-14	AMLP	ETF	80.4	81.1	80.4	81.1	125100.0
2011-02-14	AOA	ETF	35.78	35.89	35.72	35.88	26100.0
2011-02-14	AOK	ETF	28.95	28.98	28.95	28.95	8617.0
2011-02-14	AOM	ETF	30.36	30.4	30.35	30.3601	6764.0
2011-02-14	AOR	ETF	32.38	32.44	32.35	32.43	17613.0
2011-02-14	ARB	ETF	44.0	44.38	43.89	44.14	291997.0
2011-02-14	BAB	ETF	24.77	24.83	24.71	24.7699	255150.0
2011-02-14	BAL	ETF	95.99	96.565	93.95	94.25	84196.0
2011-02-14	BALT	ETF	8.88	9.14	8.8	8.85	220900.0
2011-02-14	BBH	ETF	33.5133	33.76	33.5	33.76	15900.0
2011-02-14	BIB	ETF	7.64	7.67	7.64	7.67	10560.0
2011-02-14	BICK	ETF	31.11	31.359	31.11	31.26	42455.0
2011-02-14	BIL	ETF	91.72	91.72	91.7	91.7	74450.0
2011-02-14	BIS	ETF	7913.6	7913.6	7913.6	7913.6	31.25
2011-02-14	BITS	ETF	27.2	27.36	25.84	27.0	4494.0
2011-02-14	BIV	ETF	81.28	81.6	81.27	81.46	108100.0
2011-02-14	BJK	ETF	32.3	32.5	32.24	32.41	15400.0
2011-02-14	BKF	ETF	46.98	47.46	46.95	47.4	269090.0
2011-02-14	BLV	ETF	76.6	77.07	76.56	76.89	29700.0
2011-02-14	BMVP	ETF	15.4633	15.5706	15.4633	15.55	6263.0
2011-02-14	BND	ETF	79.28	79.55	79.24	79.39	559300.0
2011-02-14	BNO	ETF	33.98	34.595	33.98	34.28	39200.0
2011-02-14	BRF	ETF	51.38	52.486	51.37	52.41	163858.0
2011-02-14	BSCE	ETF	20.77	20.77	20.7	20.76	13258.0
2011-02-14	BSV	ETF	79.96	80.01	79.94	79.95	513300.0
2011-02-14	BTF	ETF	84.60000000000001	86.44999999999999	84.60000000000001	85.39999999999999	16042.2
2011-02-14	BWX	ETF	28.795	28.85	28.645	28.84	1174586.0
2011-02-14	BWZ	ETF	37.3	38.1	37.055	38.0	28376.0
2011-02-14	BZQ	ETF	2768.0	2768.0	2667.2	2692.8	352.0
2011-02-14	CEF	ETF	19.97	20.2	19.94	20.2	1142300.0

> showing 50 of 828 rows — these rows as CSV

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