PREVIEW / etf_daily / 2011-08-17

all etf daily files

  file:    by_date/etf_daily/2011/2011-08-17.parquet
  size:    36 KB
  rows:    868

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-08-17	SPY	ETF	120.25	121.2	118.72	119.67	238201100.0
2011-08-17	QQQ	ETF	53.98	54.42	53.02	53.58	84416524.0
2011-08-17	IWM	ETF	70.97	71.52	69.76	70.46	66789100.0
2011-08-17	DIA	ETF	114.7	115.46	113.38	114.26	9350200.0
2011-08-17	GLD	ETF	173.87	174.68	173.25	174.42	16482000.0
2011-08-17	TLT	ETF	106.32	108.1	105.77	108.09	15906600.0
2011-08-17	AADR	ETF	29.18	29.18	28.96	29.0	1700.0
2011-08-17	AAXJ	ETF	56.19	56.73	55.76	55.97	1158000.0
2011-08-17	ACTV	ETF	16.38	16.89	16.35	16.81	143249.0
2011-08-17	ACWI	ETF	43.49	43.74	42.95	43.31	761300.0
2011-08-17	ACWX	ETF	40.14	40.33	39.67	39.851	82920.0
2011-08-17	ADRE	ETF	41.57	41.78	41.1715	41.62	150142.0
2011-08-17	AFK	ETF	29.5935	29.76	29.35	29.47	7115.0
2011-08-17	AGEM	ETF	23.3	23.345	23.0	23.0	5177.0
2011-08-17	AGG	ETF	109.73	109.97	109.5	109.82	1119500.0
2011-08-17	AGQ	ETF	427.8	435.86	420.0	431.24	469500.0
2011-08-17	AGZ	ETF	112.52	112.62	112.33	112.62	20751.0
2011-08-17	AIA	ETF	41.44	41.72	41.12	41.2729	21714.0
2011-08-17	AIQ	ETF	7.75	7.9	7.4	7.4	31633.0
2011-08-17	AIS	ETF	2.2	2.29	2.19	2.27	878882.0
2011-08-17	AIVI	ETF	42.28	42.61	41.87	42.08	17700.0
2011-08-17	AMJ	ETF	36.34	36.4	35.89	35.89	1406249.0
2011-08-17	AMLP	ETF	78.2	78.45	77.75	77.9	220820.0
2011-08-17	AOA	ETF	32.73	32.83	32.31	32.48	5400.0
2011-08-17	AOK	ETF	29.14	29.14	29.05	29.11	46280.0
2011-08-17	AOM	ETF	29.83	29.94	29.7502	29.81	36026.0
2011-08-17	AOR	ETF	30.94	30.95	30.721	30.7875	3519.0
2011-08-17	ARB	ETF	34.73	35.01	33.9	34.18	72081.0
2011-08-17	ARGT	ETF	26.02	26.02	26.02	26.02	50.0
2011-08-17	ASEA	ETF	16.29	16.44	16.17	16.22	3400.0
2011-08-17	AWAY	ETF	36.5	37.49	35.0	37.41	100597.0
2011-08-17	BAB	ETF	27.44	27.55	27.37	27.54	359296.0
2011-08-17	BAL	ETF	65.86	67.696	65.829	67.31	125830.0
2011-08-17	BALT	ETF	4.48	4.79	4.23	4.43	322389.0
2011-08-17	BBH	ETF	31.5	31.83	31.44	31.5433	24900.0
2011-08-17	BCM	ETF	47.33	47.35	47.33	47.35	4130.0
2011-08-17	BIB	ETF	7.0825	7.32	6.8937	7.0431	97368.0
2011-08-17	BICK	ETF	27.62	27.7	27.22	27.519	74647.0
2011-08-17	BIL	ETF	91.72	91.72	91.7	91.72	331200.0
2011-08-17	BIS	ETF	7278.4	7479.68	7278.4	7356.8	12.2
2011-08-17	BITS	ETF	21.56	22.16	21.5	21.68	2900.0
2011-08-17	BIV	ETF	87.96	88.19	87.65	88.18	101600.0
2011-08-17	BJK	ETF	33.91	34.12	33.48	33.69	46400.0
2011-08-17	BKF	ETF	41.75	42.05	41.34	41.69	115774.0
2011-08-17	BKLN	ETF	23.45	23.55	23.35	23.5	221200.0
2011-08-17	BLV	ETF	86.94	87.8	86.46	87.8	43600.0
2011-08-17	BMVP	ETF	13.5367	13.6223	13.3433	13.43	4945.0
2011-08-17	BND	ETF	83.6	83.79	83.46	83.73	958800.0
2011-08-17	BNO	ETF	37.255	37.315	36.9	37.005	168800.0
2011-08-17	BRF	ETF	48.89	49.31	48.44	49.21	141232.0

> showing 50 of 868 rows — these rows as CSV

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