PREVIEW / etf_daily / 2011-09-23

all etf daily files

  file:    by_date/etf_daily/2011/2011-09-23.parquet
  size:    37 KB
  rows:    871

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-23	SPY	ETF	112.11	114.16	112.02	113.54	307242500.0
2011-09-23	QQQ	ETF	53.14	54.38	53.091	54.15	85940566.0
2011-09-23	IWM	ETF	64.25	65.53	64.1	65.14	84086000.0
2011-09-23	DIA	ETF	106.44	107.87	106.13	107.45	12056800.0
2011-09-23	GLD	ETF	164.51	165.72	158.55	159.8	52981400.0
2011-09-23	TLT	ETF	123.12	123.36	120.83	120.83	15173800.0
2011-09-23	AADR	ETF	26.0	26.0	25.86	25.94	8100.0
2011-09-23	AAXJ	ETF	47.36	48.13	47.2	47.97	682300.0
2011-09-23	ACTV	ETF	14.62	14.63	14.17	14.44	62311.0
2011-09-23	ACWI	ETF	38.72	39.3	38.54	39.21	711000.0
2011-09-23	ACWX	ETF	34.26	34.91	34.18	34.89	389254.0
2011-09-23	ADRE	ETF	35.62	36.3	35.55	36.23	61929.0
2011-09-23	AFK	ETF	26.28	26.39	26.08	26.38	16775.0
2011-09-23	AGEM	ETF	19.46	19.907	19.46	19.823	90260.0
2011-09-23	AGG	ETF	110.93	110.93	110.21	110.23	1113400.0
2011-09-23	AGQ	ETF	268.2	280.66	221.82	237.28	2196400.0
2011-09-23	AGZ	ETF	112.79	113.069	112.59	112.59	5654.0
2011-09-23	AIA	ETF	36.42	37.03	36.36	36.85	42506.0
2011-09-23	AIQ	ETF	5.85	6.1	5.7	6.1	15609.0
2011-09-23	AIS	ETF	2.22	2.29	2.16	2.23	790748.0
2011-09-23	AIVI	ETF	37.27	37.85	37.06	37.78	119200.0
2011-09-23	AMJ	ETF	34.12	34.416	34.0	34.13	648089.0
2011-09-23	AMLP	ETF	76.45	77.0	75.75	75.85	136440.0
2011-09-23	AOA	ETF	30.15	30.55	30.1	30.49	7300.0
2011-09-23	AOK	ETF	28.7	28.74	28.65	28.71	24037.0
2011-09-23	AOM	ETF	28.92	29.0552	28.92	29.02	13994.0
2011-09-23	AOR	ETF	29.39	29.64	29.39	29.59	3870.0
2011-09-23	ARB	ETF	34.08	35.1	34.08	34.76	115978.0
2011-09-23	ARGT	ETF	19.98	20.42	19.86	20.14	10600.0
2011-09-23	ASEA	ETF	13.81	13.93	13.77	13.8	11000.0
2011-09-23	AWAY	ETF	33.51	34.66	33.51	33.97	107690.0
2011-09-23	BAB	ETF	28.96	29.04	28.75	28.8032	402485.0
2011-09-23	BAL	ETF	61.78	63.09	61.77	62.64	53158.0
2011-09-23	BALT	ETF	4.49	4.77	4.42	4.74	194445.0
2011-09-23	BBH	ETF	32.32	32.4967	31.89	32.4067	13500.0
2011-09-23	BCM	ETF	43.1	43.1	42.9	42.9	3600.0
2011-09-23	BIB	ETF	6.9962	7.3325	6.9962	7.27	25360.0
2011-09-23	BICK	ETF	22.23	22.6	22.21	22.52	114452.0
2011-09-23	BIL	ETF	91.7	91.7	91.68	91.7	604150.0
2011-09-23	BIS	ETF	6814.4	6836.8	6796.8	6796.8	8.1
2011-09-23	BITS	ETF	21.68	23.16	21.36	21.56	2784.0
2011-09-23	BIV	ETF	88.66	88.66	87.82	87.9	204600.0
2011-09-23	BJK	ETF	29.37	29.8	29.33	29.55	12100.0
2011-09-23	BKF	ETF	34.21	35.04	34.04	34.92	255861.0
2011-09-23	BKLN	ETF	23.15	23.37	23.13	23.21	85400.0
2011-09-23	BLNG	ETF	51.73	51.73	49.69	50.26	3165.0
2011-09-23	BLV	ETF	93.29	93.69	91.81	91.98	115700.0
2011-09-23	BMVP	ETF	12.2833	12.4233	12.2633	12.4163	14532.0
2011-09-23	BND	ETF	84.39	84.39	83.99	84.05	803000.0
2011-09-23	BNO	ETF	35.215	35.66	34.97	35.055	351200.0

> showing 50 of 871 rows — these rows as CSV

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