PREVIEW / etf_daily / 2012-12-10

all etf daily files

  file:    by_date/etf_daily/2012/2012-12-10.parquet
  size:    39 KB
  rows:    955

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-10	SPY	ETF	142.21	142.81	142.15	142.47	98840700.0
2012-12-10	QQQ	ETF	64.75	65.455	64.75	65.12	33219547.0
2012-12-10	IWM	ETF	82.37	82.66	82.21	82.54	29173000.0
2012-12-10	DIA	ETF	131.59	132.01	131.57	131.74	3480900.0
2012-12-10	GLD	ETF	166.11	166.16	165.71	165.8	4646600.0
2012-12-10	TLT	ETF	124.96	125.08	124.54	124.98	2134300.0
2012-12-10	AAXJ	ETF	59.0	59.57	58.99	59.43	184100.0
2012-12-10	ACTV	ETF	4.77	4.8603	4.66	4.77	516129.0
2012-12-10	ACWI	ETF	47.57	47.7	47.5	47.67	1984200.0
2012-12-10	ACWV	ETF	56.91	57.11	56.72	56.93	32000.0
2012-12-10	ACWX	ETF	41.0	41.12	40.92	41.08	253106.0
2012-12-10	ADRE	ETF	38.69	39.2	38.69	39.19	25574.0
2012-12-10	AFK	ETF	30.65	30.8	30.6101	30.778	19592.0
2012-12-10	AGEM	ETF	22.8014	22.8901	22.8	22.89	2125.0
2012-12-10	AGG	ETF	111.64	111.71	111.61	111.68	843500.0
2012-12-10	AGQ	ETF	214.6	214.8	212.2	212.48	170950.0
2012-12-10	AGZ	ETF	114.05	114.0599	113.72	113.73	10930.0
2012-12-10	AIA	ETF	47.09	47.46	46.97	47.42	27320.0
2012-12-10	AIQ	ETF	6.25	6.35	6.1	6.25	14499.0
2012-12-10	AIVI	ETF	40.56	40.77	40.56	40.75	15600.0
2012-12-10	AMJ	ETF	38.62	39.089	38.55	38.6	766325.0
2012-12-10	AMLP	ETF	79.95	80.6	79.75	79.75	506440.0
2012-12-10	ANGL	ETF	27.13	27.24	27.11	27.14	2500.0
2012-12-10	AOA	ETF	36.91	37.02	36.91	37.0	27800.0
2012-12-10	AOK	ETF	30.57	30.62	30.57	30.61	12048.0
2012-12-10	AOM	ETF	31.79	31.82	31.7802	31.79	12696.0
2012-12-10	AOR	ETF	33.83	33.9399	33.83	33.92	32079.0
2012-12-10	ARB	ETF	38.04	38.59	37.92	37.96	159949.0
2012-12-10	ARGT	ETF	16.52	16.84	16.5	16.84	6850.0
2012-12-10	ASEA	ETF	16.93	16.98	16.89	16.93	23000.0
2012-12-10	AWAY	ETF	19.99	20.1	19.58	19.98	408431.0
2012-12-10	BAB	ETF	30.61	30.6999	30.5648	30.64	443239.0
2012-12-10	BAL	ETF	48.34	48.4465	47.7601	47.98	4550.0
2012-12-10	BALT	ETF	2.75	2.8	2.72	2.73	120924.0
2012-12-10	BBH	ETF	54.06	55.01	54.06	54.86	15800.0
2012-12-10	BCM	ETF	44.5399	44.5399	44.5399	44.5399	328.0
2012-12-10	BIB	ETF	14.5075	14.9972	14.5075	14.8975	132608.0
2012-12-10	BICK	ETF	24.41	24.578	24.41	24.57	7026.0
2012-12-10	BIL	ETF	91.62	91.64	91.62	91.62	356500.0
2012-12-10	BIS	ETF	2617.6	2624.404	2591.2	2595.6	893.0
2012-12-10	BIV	ETF	90.5	90.51	90.4	90.47	254100.0
2012-12-10	BJK	ETF	35.62	35.86	35.62	35.74	24700.0
2012-12-10	BKF	ETF	39.19	39.749	39.19	39.64	401838.0
2012-12-10	BKLN	ETF	24.93	24.95	24.9	24.94	280700.0
2012-12-10	BLV	ETF	96.91	97.08	96.7	96.8	45100.0
2012-12-10	BMVP	ETF	16.133	16.283	16.133	16.253	7284.0
2012-12-10	BND	ETF	84.86	84.89	84.81	84.86	1378600.0
2012-12-10	BNO	ETF	39.395	39.42	39.18	39.18	14400.0
2012-12-10	BOIL	ETF	849600.0	857400.0	830000.0	847200.0	17.2
2012-12-10	BOND	ETF	110.29	110.336	110.24	110.328	274212.0

> showing 50 of 955 rows — these rows as CSV

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