PREVIEW / etf_daily / 2012-12-13

all etf daily files

  file:    by_date/etf_daily/2012/2012-12-13.parquet
  size:    39 KB
  rows:    964

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-12-13	SPY	ETF	143.42	143.83	142.27	142.63	135715000.0
2012-12-13	QQQ	ETF	65.71	66.16	65.03	65.3111	45467642.0
2012-12-13	IWM	ETF	82.98	83.21	82.11	82.41	33439300.0
2012-12-13	DIA	ETF	132.53	132.72	131.55	131.82	3844500.0
2012-12-13	GLD	ETF	163.87	164.9	163.78	164.37	9332800.0
2012-12-13	TLT	ETF	122.29	123.18	122.13	122.68	6381500.0
2012-12-13	AAXJ	ETF	59.81	59.86	59.43	59.56	257800.0
2012-12-13	ACTV	ETF	5.1	5.14	4.99	5.01	651120.0
2012-12-13	ACWI	ETF	47.9	48.04	47.64	47.75	1478100.0
2012-12-13	ACWV	ETF	56.78	56.96	56.59	56.71	29000.0
2012-12-13	ACWX	ETF	41.47	41.515	41.25	41.37	294572.0
2012-12-13	ADRE	ETF	39.45	39.67	39.278	39.35	34490.0
2012-12-13	AFK	ETF	31.3	31.35	31.042	31.14	11780.0
2012-12-13	AGEM	ETF	22.92	22.92	22.73	22.8207	509.0
2012-12-13	AGG	ETF	111.3	111.34	111.14	111.15	1209700.0
2012-12-13	AGQ	ETF	202.68	205.68	200.12	204.4	551650.0
2012-12-13	AGZ	ETF	113.64	113.73	113.44	113.59	13810.0
2012-12-13	AIA	ETF	47.82	47.98	47.64	47.74	23998.0
2012-12-13	AIQ	ETF	6.2	6.4	6.1	6.25	8250.0
2012-12-13	AIVI	ETF	41.21	41.36	41.09	41.22	81500.0
2012-12-13	AMJ	ETF	38.42	38.42	37.6976	37.93	4698858.0
2012-12-13	AMLP	ETF	79.45	79.45	78.45	78.95	1033160.0
2012-12-13	ANGL	ETF	27.2	27.25	27.11	27.11	5000.0
2012-12-13	AOA	ETF	37.14	37.22	36.96	37.07	15300.0
2012-12-13	AOK	ETF	30.62	30.62	30.53	30.53	38997.0
2012-12-13	AOM	ETF	31.8799	31.8799	31.72	31.77	50826.0
2012-12-13	AOR	ETF	33.98	34.0499	33.8434	33.92	67647.0
2012-12-13	ARB	ETF	37.72	38.03	37.45	37.72	87784.0
2012-12-13	ARGT	ETF	17.26	17.3	17.12	17.12	2050.0
2012-12-13	ASEA	ETF	17.06	17.12	17.04	17.06	13200.0
2012-12-13	AWAY	ETF	20.43	21.0	20.04	20.89	725755.0
2012-12-13	BAB	ETF	30.44	30.44	30.32	30.44	136570.0
2012-12-13	BAL	ETF	48.79	49.0	48.46	48.59	12802.0
2012-12-13	BALT	ETF	2.88	3.0119	2.8796	3.0	163233.0
2012-12-13	BBH	ETF	55.55	55.7	54.85	55.02	11500.0
2012-12-13	BCM	ETF	44.11	44.11	44.11	44.11	1104.0
2012-12-13	BIB	ETF	15.265	15.2925	14.7875	14.875	84656.0
2012-12-13	BICK	ETF	24.69	24.732	24.546	24.62	19635.0
2012-12-13	BIL	ETF	91.62	91.64	91.62	91.62	151700.0
2012-12-13	BIS	ETF	2563.528	2592.8	2563.528	2592.8	7.9
2012-12-13	BIV	ETF	90.05	90.1	89.9	89.99	265900.0
2012-12-13	BJK	ETF	36.48	36.49	36.19	36.33	8500.0
2012-12-13	BKF	ETF	39.69	39.83	39.411	39.59	353602.0
2012-12-13	BKLN	ETF	24.94	24.94	24.91	24.93	815600.0
2012-12-13	BLNG	ETF	51.08	51.08	51.05	51.05	800.0
2012-12-13	BLV	ETF	95.38	95.73	95.3	95.55	41600.0
2012-12-13	BMVP	ETF	16.2733	16.3133	16.1524	16.1533	1477.0
2012-12-13	BND	ETF	84.56	84.63	84.49	84.49	1208700.0
2012-12-13	BNO	ETF	39.59	39.71	39.275	39.385	62400.0
2012-12-13	BOIL	ETF	799400.0	818200.0	779000.0	801400.0	18.6

> showing 50 of 964 rows — these rows as CSV

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