PREVIEW / etf_daily / 2011-09-29

all etf daily files

  file:    by_date/etf_daily/2011/2011-09-29.parquet
  size:    37 KB
  rows:    877

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-29	SPY	ETF	117.05	117.63	113.93	116.05	298108900.0
2011-09-29	QQQ	ETF	55.36	55.43	52.97	53.88	116900117.0
2011-09-29	IWM	ETF	66.73	67.02	64.37	66.33	73927200.0
2011-09-29	DIA	ETF	111.87	112.5	109.43	111.38	13212200.0
2011-09-29	GLD	ETF	158.12	158.2	156.14	157.7	17340800.0
2011-09-29	TLT	ETF	117.61	118.82	117.09	117.84	12341800.0
2011-09-29	AAXJ	ETF	49.45	49.65	48.26	48.82	417200.0
2011-09-29	ACTV	ETF	15.23	15.7	14.59	15.13	66838.0
2011-09-29	ACWI	ETF	40.94	41.01	39.84	40.52	281000.0
2011-09-29	ACWX	ETF	36.68	36.78	35.79	36.27	82025.0
2011-09-29	ADRE	ETF	37.51	37.68	36.7363	37.1	46032.0
2011-09-29	AFK	ETF	26.36	26.64	25.881	26.17	57070.0
2011-09-29	AGEM	ETF	20.85	20.85	20.413	20.413	540.0
2011-09-29	AGG	ETF	109.64	109.87	109.56	109.7	825000.0
2011-09-29	AGQ	ETF	223.5	226.78	210.04	222.86	936500.0
2011-09-29	AGZ	ETF	112.58	112.743	112.36	112.57	7924.0
2011-09-29	AIA	ETF	38.12	38.25	37.4055	37.76	54564.0
2011-09-29	AIQ	ETF	5.7	5.85	5.3	5.85	42987.0
2011-09-29	AIS	ETF	2.28	2.33	2.19	2.23	489352.0
2011-09-29	AIVI	ETF	39.63	39.69	38.71	39.27	66800.0
2011-09-29	AMJ	ETF	34.5	34.8	34.0628	34.26	538794.0
2011-09-29	AMLP	ETF	77.6	78.75	76.3	76.45	107380.0
2011-09-29	AOA	ETF	31.08	31.08	30.56	30.88	7400.0
2011-09-29	AOK	ETF	28.83	28.86	28.65	28.74	20476.0
2011-09-29	AOM	ETF	29.22	29.24	28.9464	29.11	24416.0
2011-09-29	AOR	ETF	29.96	29.96	29.5536	29.76	10624.0
2011-09-29	ARB	ETF	35.9	35.9	33.0	34.2	204978.0
2011-09-29	ARGT	ETF	20.42	20.42	19.9	19.98	4750.0
2011-09-29	ASEA	ETF	14.19	14.26	13.97	14.05	4000.0
2011-09-29	AWAY	ETF	34.35	35.53	31.7	33.82	473923.0
2011-09-29	BAB	ETF	28.44	28.64	28.37	28.51	179234.0
2011-09-29	BAL	ETF	62.06	63.77	61.03	63.63	92112.0
2011-09-29	BALT	ETF	4.88	4.9374	4.74	4.8	135141.0
2011-09-29	BBH	ETF	33.3533	33.4167	32.3733	32.8467	19500.0
2011-09-29	BCM	ETF	42.59	42.65	42.32	42.33	3395.0
2011-09-29	BIB	ETF	7.42	7.42	6.84	7.1562	63480.0
2011-09-29	BICK	ETF	23.34	23.34	22.75	22.91	10404.0
2011-09-29	BIL	ETF	91.7	91.7	91.68	91.7	451650.0
2011-09-29	BIS	ETF	6894.4	6894.4	6894.4	6894.4	4.69
2011-09-29	BITS	ETF	22.256	22.4	21.52	22.36	1014.0
2011-09-29	BIV	ETF	87.4	87.64	87.22	87.41	168000.0
2011-09-29	BJK	ETF	30.4	30.41	29.06	29.41	156500.0
2011-09-29	BKF	ETF	36.02	36.14	35.22	35.66	210594.0
2011-09-29	BKLN	ETF	23.3	23.3	23.08	23.09	95900.0
2011-09-29	BLNG	ETF	49.06	49.06	49.06	49.06	200.0
2011-09-29	BLV	ETF	90.45	90.94	90.13	90.32	132000.0
2011-09-29	BMVP	ETF	12.79	12.79	12.26	12.49	5979.0
2011-09-29	BND	ETF	83.36	83.55	83.34	83.43	1204300.0
2011-09-29	BNO	ETF	35.36	35.635	34.935	35.145	379400.0
2011-09-29	BRF	ETF	41.27	41.458	40.01	40.65	154891.0

> showing 50 of 877 rows — these rows as CSV

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