PREVIEW / etf_daily / 2012-05-16

all etf daily files

  file:    by_date/etf_daily/2012/2012-05-16.parquet
  size:    39 KB
  rows:    937

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-05-16	SPY	ETF	133.94	134.55	132.8	132.83	207265500.0
2012-05-16	QQQ	ETF	63.62	63.78	62.81	62.94	52825897.0
2012-05-16	IWM	ETF	77.98	78.39	77.1	77.15	52659400.0
2012-05-16	DIA	ETF	126.78	127.37	126.13	126.18	6043200.0
2012-05-16	GLD	ETF	149.48	150.7	148.6	149.46	16750700.0
2012-05-16	TLT	ETF	120.98	122.18	120.72	122.01	6462300.0
2012-05-16	AADR	ETF	28.4	28.46	28.36	28.36	1200.0
2012-05-16	AAXJ	ETF	51.67	51.92	51.23	51.28	9223700.0
2012-05-16	ACTV	ETF	13.83	13.89	12.92	13.02	486164.0
2012-05-16	ACWI	ETF	43.64	43.75	43.13	43.16	931500.0
2012-05-16	ACWV	ETF	52.67	53.16	52.35	53.16	18600.0
2012-05-16	ACWX	ETF	36.88	37.04	36.43	36.43	194919.0
2012-05-16	ADRE	ETF	37.76	37.77	37.1	37.21	15386.0
2012-05-16	AFK	ETF	28.14	28.25	27.96	27.96	10154.0
2012-05-16	AGEM	ETF	20.6	20.7	20.35	20.35	2906.0
2012-05-16	AGG	ETF	110.87	111.09	110.83	110.96	986400.0
2012-05-16	AGQ	ETF	155.28	161.36	147.52	151.8	748600.0
2012-05-16	AGZ	ETF	113.08	113.12	112.981	113.12	10800.0
2012-05-16	AIA	ETF	41.22	41.44	40.8701	41.05	24841.0
2012-05-16	AIQ	ETF	6.15	6.45	5.65	5.75	12896.0
2012-05-16	AIS	ETF	3.06	3.0999	3.01	3.02	613046.0
2012-05-16	AIVI	ETF	38.1	38.22	37.61	37.61	82800.0
2012-05-16	AMJ	ETF	38.42	38.65	38.25	38.26	4887922.0
2012-05-16	AMLP	ETF	80.45	80.7	80.25	80.25	275320.0
2012-05-16	ANGL	ETF	25.4	25.51	25.2	25.21	46600.0
2012-05-16	AOA	ETF	34.72	34.82	34.41	34.41	8600.0
2012-05-16	AOK	ETF	29.72	29.79	29.6801	29.69	20816.0
2012-05-16	AOM	ETF	30.54	30.6397	30.47	30.47	34288.0
2012-05-16	AOR	ETF	32.3	32.38	32.126	32.126	8842.0
2012-05-16	ARB	ETF	36.51	36.71	35.73	35.76	173174.0
2012-05-16	ARGT	ETF	16.38	16.38	15.98	15.98	4300.0
2012-05-16	ASEA	ETF	15.46	15.46	15.26	15.33	40000.0
2012-05-16	AWAY	ETF	25.97	26.87	25.06	26.35	1211700.0
2012-05-16	BAB	ETF	29.64	29.85	29.64	29.8	181619.0
2012-05-16	BAL	ETF	48.18	48.47	47.54	47.63	89896.0
2012-05-16	BALT	ETF	3.92	3.97	3.8	3.8	142837.0
2012-05-16	BBH	ETF	46.69	47.03	46.61	46.62	97500.0
2012-05-16	BCM	ETF	41.66	41.7999	41.632	41.632	3858.0
2012-05-16	BIB	ETF	12.53	12.6105	12.3925	12.3938	110416.0
2012-05-16	BICK	ETF	22.62	22.63	22.2501	22.32	5730.0
2012-05-16	BIL	ETF	91.66	91.66	91.64	91.66	103950.0
2012-05-16	BIS	ETF	3456.0	3459.2	3444.8	3459.2	12.2
2012-05-16	BIV	ETF	88.25	88.46	88.2	88.41	294200.0
2012-05-16	BJK	ETF	32.96	32.96	32.51	32.51	33500.0
2012-05-16	BKF	ETF	36.09	36.2	35.5	35.58	231014.0
2012-05-16	BKLN	ETF	24.6	24.66	24.57	24.57	254500.0
2012-05-16	BLV	ETF	92.95	93.87	92.85	93.77	107400.0
2012-05-16	BMVP	ETF	14.84	14.9	14.75	14.75	5081.0
2012-05-16	BND	ETF	84.0	84.12	83.95	84.07	1371000.0
2012-05-16	BNO	ETF	39.22	39.315	38.555	38.555	78600.0

> showing 50 of 937 rows — these rows as CSV

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