PREVIEW / etf_daily / 2011-03-04

all etf daily files

  file:    by_date/etf_daily/2011/2011-03-04.parquet
  size:    35 KB
  rows:    829

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-03-04	SPY	ETF	133.37	133.63	131.6	132.47	277202300.0
2011-03-04	QQQ	ETF	58.25	58.26	57.59	57.9675	62328324.0
2011-03-04	IWM	ETF	82.79	82.84	81.65	82.44	60907100.0
2011-03-04	DIA	ETF	122.43	122.53	120.6	121.47	10366700.0
2011-03-04	GLD	ETF	138.63	139.75	138.61	139.35	17454600.0
2011-03-04	TLT	ETF	90.1	90.85	90.0	90.81	9316200.0
2011-03-04	AADR	ETF	30.56	30.6	30.56	30.6	900.0
2011-03-04	AAXJ	ETF	61.82	61.89	61.24	61.69	349800.0
2011-03-04	ACWI	ETF	49.09	49.09	48.45	48.71	392600.0
2011-03-04	ACWX	ETF	46.01	46.01	45.47	45.76	100001.0
2011-03-04	ADRE	ETF	47.74	47.8	47.26	47.58	62088.0
2011-03-04	AFK	ETF	33.45	33.5	32.86	32.91	21822.0
2011-03-04	AGG	ETF	104.89	105.11	104.85	105.02	761700.0
2011-03-04	AGQ	ETF	389.58	409.18	389.42	408.38	794200.0
2011-03-04	AGZ	ETF	109.05	109.25	108.95	108.96	20801.0
2011-03-04	AIA	ETF	46.7	46.81	46.34	46.511	20310.0
2011-03-04	AIQ	ETF	20.3	20.5	20.2	20.3	11300.0
2011-03-04	AIS	ETF	1.58	1.6	1.56	1.58	197808.0
2011-03-04	AIVI	ETF	46.44	46.44	46.12	46.38	4300.0
2011-03-04	AMJ	ETF	38.2	38.2	37.95	38.03	810245.0
2011-03-04	AMLP	ETF	82.6	82.6	82.15	82.25	95640.0
2011-03-04	AOA	ETF	36.05	36.05	35.64	35.67	17400.0
2011-03-04	AOK	ETF	29.18	29.18	29.0965	29.12	19155.0
2011-03-04	AOM	ETF	30.56	30.5699	30.46	30.52	21037.0
2011-03-04	AOR	ETF	32.64	32.64	32.3901	32.53	22656.0
2011-03-04	ARB	ETF	39.79	40.03	38.95	39.49	166207.0
2011-03-04	ARGT	ETF	30.46	30.5	30.16	30.28	28900.0
2011-03-04	ASEA	ETF	15.28	15.33	15.16	15.29	5800.0
2011-03-04	BAB	ETF	25.02	25.16	24.95	25.06	365473.0
2011-03-04	BAL	ETF	110.96	112.0	109.44	110.81	106683.0
2011-03-04	BALT	ETF	9.26	9.26	9.0	9.19	114483.0
2011-03-04	BBH	ETF	34.32	34.5667	34.2967	34.4667	45900.0
2011-03-04	BICK	ETF	32.05	32.05	31.756	31.8738	19024.0
2011-03-04	BIL	ETF	91.7	91.72	91.7	91.72	132300.0
2011-03-04	BITS	ETF	26.56	26.56	25.84	25.88	761.0
2011-03-04	BIV	ETF	81.83	82.3	81.83	82.28	88500.0
2011-03-04	BJK	ETF	32.14	32.19	31.78	32.03	8300.0
2011-03-04	BKF	ETF	49.1	49.1	48.35	48.67	569004.0
2011-03-04	BKLN	ETF	25.13	25.13	25.01	25.08	189100.0
2011-03-04	BLV	ETF	77.35	77.94	77.35	77.82	19100.0
2011-03-04	BMVP	ETF	15.57	15.61	15.47	15.57	10017.0
2011-03-04	BND	ETF	79.74	79.92	79.72	79.89	960000.0
2011-03-04	BNO	ETF	38.435	38.69	38.365	38.53	125200.0
2011-03-04	BRF	ETF	53.75	53.9485	52.89	53.1	173498.0
2011-03-04	BSCE	ETF	20.81	20.8888	20.81	20.88	22364.0
2011-03-04	BSV	ETF	80.19	80.36	80.19	80.36	564100.0
2011-03-04	BTF	ETF	85.19999999999999	85.19999999999999	84.19999999999999	84.375	3185.2000000000003
2011-03-04	BWX	ETF	29.59	29.85	29.59	29.795	225292.0
2011-03-04	BWZ	ETF	37.7	37.9399	37.7	37.9399	16278.0
2011-03-04	BZQ	ETF	2462.4	2497.6	2435.2	2454.4	734.0

> showing 50 of 829 rows — these rows as CSV

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