PREVIEW / etf_daily / 2012-10-09

all etf daily files

  file:    by_date/etf_daily/2012/2012-10-09.parquet
  size:    39 KB
  rows:    943

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
2012-10-09	SPY	ETF	145.53	145.65	144.15	144.2	148872900.0
2012-10-09	QQQ	ETF	68.17	68.3395	67.1	67.2592	67973910.0
2012-10-09	IWM	ETF	83.62	83.7	82.44	82.6	45221200.0
2012-10-09	DIA	ETF	135.42	135.74	134.55	134.59	6034700.0
2012-10-09	GLD	ETF	171.86	172.17	170.56	170.99	7750700.0
2012-10-09	TLT	ETF	121.47	122.18	121.38	121.95	4752700.0
2012-10-09	AADR	ETF	29.58	29.59	29.57	29.59	400.0
2012-10-09	AAXJ	ETF	56.54	56.69	56.06	56.17	182700.0
2012-10-09	ACTV	ETF	10.95	10.95	10.6	10.64	669678.0
2012-10-09	ACWI	ETF	47.12	47.17	46.68	46.68	1347000.0
2012-10-09	ACWV	ETF	57.55	57.55	56.72	56.72	8200.0
2012-10-09	ACWX	ETF	39.56	39.65	39.28	39.33	293827.0
2012-10-09	ADRE	ETF	39.34	39.37	38.94	38.95	57222.0
2012-10-09	AFK	ETF	31.11	31.1799	30.93	30.93	3800.0
2012-10-09	AGG	ETF	111.94	112.07	111.86	111.91	2316400.0
2012-10-09	AGQ	ETF	224.76	226.76	219.64	224.16	275200.0
2012-10-09	AGZ	ETF	113.85	113.86	113.69	113.82	45530.0
2012-10-09	AIA	ETF	44.7	44.72	44.4	44.41	4276.0
2012-10-09	AIQ	ETF	6.6	7.0	6.55	7.0	5013.0
2012-10-09	AIVI	ETF	40.19	40.26	39.83	39.88	27500.0
2012-10-09	AMJ	ETF	41.31	41.41	41.074	41.15	555211.0
2012-10-09	AMLP	ETF	84.0	84.15	83.75	83.85	352460.0
2012-10-09	ANGL	ETF	26.32	26.43	26.06	26.32	6900.0
2012-10-09	AOA	ETF	36.91	36.91	36.63	36.64	9500.0
2012-10-09	AOK	ETF	30.55	30.55	30.485	30.49	8726.0
2012-10-09	AOM	ETF	31.69	31.69	31.53	31.53	17706.0
2012-10-09	AOR	ETF	33.86	33.86	33.7199	33.724	17224.0
2012-10-09	ARB	ETF	38.5	38.5	37.55	37.68	61746.0
2012-10-09	ARGT	ETF	17.84	17.84	17.8	17.8	750.0
2012-10-09	ASEA	ETF	16.82	16.82	16.67	16.73	10500.0
2012-10-09	AWAY	ETF	26.34	26.97	26.025	26.97	912978.0
2012-10-09	BAB	ETF	29.99	29.99	29.82	29.82	284649.0
2012-10-09	BAL	ETF	47.69	47.72	47.23	47.2901	5704.0
2012-10-09	BALT	ETF	3.07	3.12	3.03	3.12	126694.0
2012-10-09	BBH	ETF	55.52	55.52	54.66	54.68	43900.0
2012-10-09	BCM	ETF	45.96	46.07	45.96	45.96	4526.0
2012-10-09	BIB	ETF	16.475	16.6	15.85	15.875	104508.0
2012-10-09	BICK	ETF	23.84	23.84	23.63	23.6699	2984.0
2012-10-09	BIL	ETF	91.62	91.64	91.62	91.62	287450.0
2012-10-09	BIS	ETF	2459.2	2517.888	2459.2	2517.888	26.5
2012-10-09	BIV	ETF	90.01	90.13	89.94	90.07	272500.0
2012-10-09	BJK	ETF	33.7	33.77	33.36	33.48	2000.0
2012-10-09	BKF	ETF	38.13	38.22	37.7808	37.88	90405.0
2012-10-09	BKLN	ETF	24.99	25.0	24.98	25.0	614000.0
2012-10-09	BLV	ETF	95.61	96.05	95.61	95.92	37400.0
2012-10-09	BMVP	ETF	16.2833	16.2833	16.1033	16.1133	4041.0
2012-10-09	BND	ETF	84.75	84.84	84.74	84.74	1113600.0
2012-10-09	BNO	ETF	40.775	41.3	40.775	41.165	77200.0
2012-10-09	BOIL	ETF	1050000.0	1131600.0	1040600.0	1114200.0	11.6
2012-10-09	BOND	ETF	109.08	109.1699	109.07	109.09	385402.0

> showing 50 of 943 rows — these rows as CSV

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