PREVIEW / etf_daily / 2011-05-04

all etf daily files

  file:    by_date/etf_daily/2011/2011-05-04.parquet
  size:    36 KB
  rows:    852

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-05-04	SPY	ETF	135.67	135.73	134.23	134.83	182678500.0
2011-05-04	QQQ	ETF	58.72	58.87	58.11	58.6	53105014.0
2011-05-04	IWM	ETF	84.42	84.46	82.73	83.21	64754600.0
2011-05-04	DIA	ETF	127.67	127.76	126.51	126.97	8253900.0
2011-05-04	GLD	ETF	149.86	150.34	146.76	147.73	35107000.0
2011-05-04	TLT	ETF	94.31	94.72	94.27	94.59	7406300.0
2011-05-04	AADR	ETF	31.37	31.59	31.37	31.41	2400.0
2011-05-04	AAXJ	ETF	63.82	63.83	62.88	63.33	680700.0
2011-05-04	ACWI	ETF	50.23	50.23	49.58	49.78	418000.0
2011-05-04	ACWX	ETF	47.01	47.02	46.47	46.63	120570.0
2011-05-04	ADRE	ETF	47.41	47.41	46.5	46.6899	89452.0
2011-05-04	AFK	ETF	33.67	33.7	33.171	33.59	4938.0
2011-05-04	AGG	ETF	106.22	106.44	106.22	106.43	659200.0
2011-05-04	AGQ	ETF	520.08	523.64	462.2	468.4	2809700.0
2011-05-04	AGZ	ETF	109.94	110.0	109.8468	109.95	14549.0
2011-05-04	AIA	ETF	48.56	48.56	47.8996	48.09	13986.0
2011-05-04	AIQ	ETF	20.95	21.05	20.375	20.7	40417.0
2011-05-04	AIS	ETF	1.76	1.78	1.69	1.7	631937.0
2011-05-04	AIVI	ETF	50.15	50.15	49.43	49.45	38000.0
2011-05-04	AMJ	ETF	38.03	38.03	36.88	37.46	1320986.0
2011-05-04	AMLP	ETF	82.05	82.15	80.35	81.25	240280.0
2011-05-04	AOA	ETF	36.87	36.87	36.45	36.55	20000.0
2011-05-04	AOK	ETF	29.55	29.55	29.44	29.47	14165.0
2011-05-04	AOM	ETF	31.09	31.09	30.97	31.008	22919.0
2011-05-04	AOR	ETF	33.24	33.24	32.9925	33.05	17715.0
2011-05-04	ARB	ETF	39.01	39.11	37.83	38.65	113636.0
2011-05-04	ARGT	ETF	29.9	29.9	29.44	29.56	1900.0
2011-05-04	ASEA	ETF	16.31	16.31	16.06	16.29	4800.0
2011-05-04	BAB	ETF	25.98	26.14	25.98	26.07	131050.0
2011-05-04	BAL	ETF	83.94	84.2099	82.41	83.15	144520.0
2011-05-04	BALT	ETF	7.67	7.93	6.95	7.3	524916.0
2011-05-04	BBH	ETF	34.8833	35.08	34.54	34.86	33000.0
2011-05-04	BCM	ETF	49.3	49.3	48.96	48.96	3100.0
2011-05-04	BIB	ETF	9.7963	9.9	9.4763	9.6125	50592.0
2011-05-04	BICK	ETF	33.55	33.6	33.1	33.2	12687.0
2011-05-04	BIL	ETF	91.74	91.74	91.7	91.74	449750.0
2011-05-04	BIS	ETF	6080.0	6166.4	6068.8	6113.6	78.5
2011-05-04	BITS	ETF	23.32	23.32	22.96	22.96	450.0
2011-05-04	BIV	ETF	83.3	83.48	83.25	83.37	148000.0
2011-05-04	BJK	ETF	34.69	34.72	34.16	34.27	12000.0
2011-05-04	BKF	ETF	48.59	48.66	47.81	47.86	294476.0
2011-05-04	BKLN	ETF	25.28	25.28	25.25	25.27	58000.0
2011-05-04	BLV	ETF	80.09	80.5	80.09	80.5	28000.0
2011-05-04	BMVP	ETF	15.93	15.93	15.69	15.77	24578.0
2011-05-04	BND	ETF	80.86	81.0	80.83	80.95	821600.0
2011-05-04	BNO	ETF	40.575	40.63	40.125	40.135	72000.0
2011-05-04	BRF	ETF	57.56	57.56	55.5	55.5	199796.0
2011-05-04	BSCE	ETF	21.08	21.1	21.07	21.08	11645.0
2011-05-04	BSV	ETF	80.61	80.71	80.6	80.67	291000.0
2011-05-04	BTF	ETF	83.1	83.6	82.79999999999998	83.25049999999999	2193.0

> showing 50 of 852 rows — these rows as CSV

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