PREVIEW / etf_daily / 2012-08-20

all etf daily files

  file:    by_date/etf_daily/2012/2012-08-20.parquet
  size:    39 KB
  rows:    939

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-08-20	SPY	ETF	141.98	142.22	141.59	142.19	78255700.0
2012-08-20	QQQ	ETF	68.27	68.43	68.0	68.42	26923940.0
2012-08-20	IWM	ETF	81.59	81.66	80.98	81.53	32657000.0
2012-08-20	DIA	ETF	132.19	132.47	131.99	132.38	2266700.0
2012-08-20	GLD	ETF	156.52	157.4	156.47	157.26	7846200.0
2012-08-20	TLT	ETF	121.55	122.19	121.5	121.85	4427100.0
2012-08-20	AAXJ	ETF	54.1	54.37	54.0	54.33	149800.0
2012-08-20	ACTV	ETF	11.46	11.67	11.24	11.25	356575.0
2012-08-20	ACWI	ETF	45.89	45.99	45.7	45.97	470600.0
2012-08-20	ACWV	ETF	55.67	56.04	55.6	56.03	7300.0
2012-08-20	ACWX	ETF	38.68	38.8	38.54	38.73	147378.0
2012-08-20	ADRE	ETF	39.0	39.046	38.75	39.022	17368.0
2012-08-20	AFK	ETF	29.33	29.5	29.12	29.2701	16431.0
2012-08-20	AGEM	ETF	22.09	22.09	21.7935	21.825	7123.0
2012-08-20	AGG	ETF	111.15	111.27	111.14	111.19	419000.0
2012-08-20	AGQ	ETF	157.8	165.96	157.52	165.68	355975.0
2012-08-20	AGZ	ETF	113.27	113.41	113.24	113.4	14615.0
2012-08-20	AIA	ETF	42.88	43.06	42.79	43.04	2748.0
2012-08-20	AIQ	ETF	6.9	7.3	6.15	6.45	16529.0
2012-08-20	AIVI	ETF	39.66	39.89	39.55	39.86	20400.0
2012-08-20	AMJ	ETF	40.21	40.25	40.04	40.1	459600.0
2012-08-20	AMLP	ETF	81.95	82.0	81.75	81.75	327680.0
2012-08-20	ANGL	ETF	26.2	26.2	26.2	26.2	1000.0
2012-08-20	AOA	ETF	36.08	36.21	36.08	36.21	4300.0
2012-08-20	AOK	ETF	30.16	30.17	30.14	30.15	55285.0
2012-08-20	AOM	ETF	31.19	31.259	31.19	31.23	78331.0
2012-08-20	AOR	ETF	33.29	33.3181	33.19	33.266	53371.0
2012-08-20	ARB	ETF	37.05	37.35	36.28	36.58	58380.0
2012-08-20	ARGT	ETF	17.0	17.24	17.0	17.24	1150.0
2012-08-20	ASEA	ETF	16.45	16.48	16.36	16.48	1400.0
2012-08-20	AWAY	ETF	24.75	24.78	23.67	24.64	570744.0
2012-08-20	BAB	ETF	29.56	29.77	29.56	29.73	154984.0
2012-08-20	BAL	ETF	48.7	49.62	48.6	49.53	4839.0
2012-08-20	BALT	ETF	3.0	3.11	2.9835	3.06	42332.0
2012-08-20	BBH	ETF	49.52	49.72	49.39	49.71	25400.0
2012-08-20	BCM	ETF	44.79	45.0299	44.79	45.0299	2071.0
2012-08-20	BIB	ETF	13.7363	13.7363	13.49	13.5638	168296.0
2012-08-20	BICK	ETF	23.12	23.45	23.11	23.44	14608.0
2012-08-20	BIL	ETF	91.62	91.64	91.62	91.62	116400.0
2012-08-20	BIS	ETF	2976.0	2977.6	2976.0	2976.32	8.45
2012-08-20	BIV	ETF	88.71	88.82	88.64	88.79	582500.0
2012-08-20	BJK	ETF	32.16	32.24	32.15	32.24	1300.0
2012-08-20	BKF	ETF	36.7	36.98	36.61	36.94	80664.0
2012-08-20	BKLN	ETF	24.68	24.68	24.45	24.68	190400.0
2012-08-20	BLV	ETF	94.24	94.5	94.17	94.22	47100.0
2012-08-20	BMVP	ETF	16.0	16.09	16.0	16.09	1754.0
2012-08-20	BND	ETF	84.21	84.29	84.17	84.19	741100.0
2012-08-20	BNO	ETF	41.12	41.12	40.675	40.91	81200.0
2012-08-20	BOIL	ETF	828600.0	850000.0	811800.0	849400.0	8.0
2012-08-20	BOND	ETF	106.59	106.72	106.52	106.7	297014.0

> showing 50 of 939 rows — these rows as CSV

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