PREVIEW / etf_daily / 2011-09-22

all etf daily files

  file:    by_date/etf_daily/2011/2011-09-22.parquet
  size:    37 KB
  rows:    886

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-09-22	SPY	ETF	113.25	114.21	111.3	112.86	513911300.0
2011-09-22	QQQ	ETF	53.93	54.46	52.75	53.58	151885450.0
2011-09-22	IWM	ETF	64.3	65.92	63.49	64.73	159808200.0
2011-09-22	DIA	ETF	107.95	108.4	105.72	107.07	19744500.0
2011-09-22	GLD	ETF	169.3	170.32	167.48	169.05	32476300.0
2011-09-22	TLT	ETF	121.41	123.87	121.23	123.12	25041400.0
2011-09-22	AADR	ETF	26.41	26.41	25.64	25.64	2300.0
2011-09-22	AAXJ	ETF	48.12	48.17	46.38	46.87	2170400.0
2011-09-22	ACTV	ETF	13.92	15.12	13.92	14.62	78201.0
2011-09-22	ACWI	ETF	39.21	39.31	38.37	38.84	1790800.0
2011-09-22	ACWX	ETF	34.75	34.844	34.1	34.49	641537.0
2011-09-22	ADRE	ETF	36.46	36.62	35.33	35.68	84002.0
2011-09-22	AFK	ETF	26.86	26.94	25.62	26.5	28341.0
2011-09-22	AGEM	ETF	19.91	20.1	19.03	19.44	7442.0
2011-09-22	AGG	ETF	110.79	111.03	110.64	110.8	875000.0
2011-09-22	AGQ	ETF	355.82	357.8	322.72	330.2	903250.0
2011-09-22	AGZ	ETF	113.29	113.29	112.75	113.02	13722.0
2011-09-22	AIA	ETF	36.83	37.03	35.6629	35.99	84136.0
2011-09-22	AIQ	ETF	5.9	5.95	5.65	5.85	47241.0
2011-09-22	AIS	ETF	2.18	2.2705	2.18	2.22	976184.0
2011-09-22	AIVI	ETF	37.59	37.71	36.94	37.46	162100.0
2011-09-22	AMJ	ETF	34.52	34.66	34.06	34.36	759613.0
2011-09-22	AMLP	ETF	77.75	77.75	76.0	76.5	188000.0
2011-09-22	AOA	ETF	30.39	30.43	29.98	30.28	24400.0
2011-09-22	AOK	ETF	28.7	28.82	28.68	28.71	19672.0
2011-09-22	AOM	ETF	29.02	29.1065	28.94	29.03	19281.0
2011-09-22	AOR	ETF	29.64	29.72	29.308	29.3101	30709.0
2011-09-22	ARB	ETF	33.34	34.98	33.34	34.13	192453.0
2011-09-22	ARGT	ETF	21.22	21.22	20.16	20.34	15400.0
2011-09-22	ASEA	ETF	13.91	13.91	13.41	13.54	29700.0
2011-09-22	AWAY	ETF	35.86	36.44	31.92	34.08	363643.0
2011-09-22	BAB	ETF	29.0	29.33	28.67	29.17	649946.0
2011-09-22	BAL	ETF	62.53	62.98	61.11	61.38	139394.0
2011-09-22	BALT	ETF	4.61	4.6999	4.48	4.49	192331.0
2011-09-22	BBH	ETF	32.4233	32.4733	31.6933	32.3833	70500.0
2011-09-22	BCM	ETF	43.91	44.2	43.49	43.49	6559.0
2011-09-22	BIB	ETF	7.2625	7.3125	6.975	7.1562	45824.0
2011-09-22	BICK	ETF	22.92	22.92	22.013	22.3899	37926.0
2011-09-22	BIL	ETF	91.68	91.7	91.68	91.68	1011650.0
2011-09-22	BITS	ETF	22.16	23.6	21.4	21.44	6028.0
2011-09-22	BIV	ETF	88.73	88.93	88.38	88.79	211500.0
2011-09-22	BJK	ETF	29.86	30.06	28.92	29.4	34100.0
2011-09-22	BKF	ETF	34.91	35.25	33.82	34.04	320009.0
2011-09-22	BKLN	ETF	23.28	23.38	23.12	23.17	65500.0
2011-09-22	BLV	ETF	93.24	94.25	92.69	93.99	199000.0
2011-09-22	BMVP	ETF	12.37	12.44	12.13	12.34	7182.0
2011-09-22	BND	ETF	84.39	84.58	84.3	84.33	1033100.0
2011-09-22	BNO	ETF	35.755	36.015	35.335	35.475	299000.0
2011-09-22	BRF	ETF	39.69	40.61	38.59	39.2	722308.0
2011-09-22	BSCE	ETF	20.92	20.92	20.82	20.86	20625.0

> showing 50 of 886 rows — these rows as CSV

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