PREVIEW / etf_daily / 2011-04-18

all etf daily files

  file:    by_date/etf_daily/2011/2011-04-18.parquet
  size:    36 KB
  rows:    836

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-04-18	SPY	ETF	130.59	132.03	129.51	130.56	210759300.0
2011-04-18	QQQ	ETF	56.09	56.27	55.32	56.25	69073433.0
2011-04-18	IWM	ETF	82.25	82.26	81.43	82.13	58593400.0
2011-04-18	DIA	ETF	121.83	121.88	120.65	121.74	10033200.0
2011-04-18	GLD	ETF	145.21	146.07	144.63	145.93	17340100.0
2011-04-18	TLT	ETF	91.99	93.1	91.45	92.88	12036700.0
2011-04-18	AADR	ETF	30.25	30.25	30.25	30.25	200.0
2011-04-18	AAXJ	ETF	62.64	62.9	62.29	62.85	603400.0
2011-04-18	ACWI	ETF	48.0	48.03	47.33	47.88	167400.0
2011-04-18	ACWX	ETF	45.05	45.05	44.44	44.98	64867.0
2011-04-18	ADRE	ETF	47.18	47.18	46.59	47.03	78671.0
2011-04-18	AFK	ETF	32.9	32.9	32.38	32.57	32212.0
2011-04-18	AGG	ETF	105.49	105.76	105.43	105.63	720400.0
2011-04-18	AGQ	ETF	585.22	596.14	559.26	593.02	1314350.0
2011-04-18	AGZ	ETF	109.45	109.87	109.45	109.75	10845.0
2011-04-18	AIA	ETF	47.56	47.56	47.19	47.5014	34545.0
2011-04-18	AIQ	ETF	22.65	22.95	22.65	22.7	15205.0
2011-04-18	AIS	ETF	1.69	1.69	1.61	1.67	507762.0
2011-04-18	AIVI	ETF	47.19	47.19	46.47	47.0	10200.0
2011-04-18	AMJ	ETF	37.97	37.97	37.61	37.845	552318.0
2011-04-18	AMLP	ETF	81.85	82.0	81.5	82.0	98420.0
2011-04-18	AOA	ETF	35.58	35.58	35.27	35.44	30900.0
2011-04-18	AOK	ETF	29.21	29.21	29.12	29.2	10645.0
2011-04-18	AOM	ETF	30.49	30.5	30.36	30.474	8741.0
2011-04-18	AOR	ETF	32.24	32.35	32.23	32.3399	39739.0
2011-04-18	ARB	ETF	35.83	35.93	35.38	35.69	148593.0
2011-04-18	ARGT	ETF	29.9	29.9	29.38	29.62	5300.0
2011-04-18	ASEA	ETF	16.06	16.06	15.9	15.9	4000.0
2011-04-18	BAB	ETF	25.42	25.5	25.27	25.4501	142710.0
2011-04-18	BAL	ETF	97.18	99.53	96.472	99.16	117536.0
2011-04-18	BALT	ETF	8.25	8.319	8.051	8.14	255768.0
2011-04-18	BBH	ETF	36.4333	36.4467	36.1333	36.2867	73500.0
2011-04-18	BIB	ETF	9.3575	9.3575	8.9901	9.1461	116360.0
2011-04-18	BICK	ETF	33.94	33.94	33.29	33.668	21538.0
2011-04-18	BIL	ETF	91.7	91.72	91.7	91.7	112300.0
2011-04-18	BIS	ETF	6595.2	6595.2	6595.2	6595.2	9.4
2011-04-18	BITS	ETF	25.0	25.0	25.0	25.0	194.0
2011-04-18	BIV	ETF	82.27	82.65	82.21	82.48	102800.0
2011-04-18	BJK	ETF	33.27	33.7	33.14	33.64	16200.0
2011-04-18	BKF	ETF	49.7	49.77	49.0	49.66	217664.0
2011-04-18	BKLN	ETF	25.16	25.36	25.14	25.22	196800.0
2011-04-18	BLV	ETF	78.24	79.01	78.07	78.96	44400.0
2011-04-18	BMVP	ETF	15.453	15.453	15.32	15.338	11375.0
2011-04-18	BND	ETF	80.25	80.45	80.19	80.36	795500.0
2011-04-18	BNO	ETF	40.565	40.675	40.24	40.49	144600.0
2011-04-18	BRF	ETF	57.89	57.89	56.458	57.05	199218.0
2011-04-18	BSCE	ETF	20.97	21.0	20.9596	21.0	7742.0
2011-04-18	BSV	ETF	80.4	80.48	80.39	80.4	436700.0
2011-04-18	BTF	ETF	81.6	81.8	80.845	81.64949999999999	2321.8
2011-04-18	BWX	ETF	30.2	30.215	30.0095	30.095	109046.0

> showing 50 of 836 rows — these rows as CSV

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