PREVIEW / etf_daily / 2012-03-08

all etf daily files

  file:    by_date/etf_daily/2012/2012-03-08.parquet
  size:    38 KB
  rows:    916

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-03-08	SPY	ETF	136.52	137.32	136.24	137.04	116968900.0
2012-03-08	QQQ	ETF	64.42	64.94	64.3	64.75	43711013.0
2012-03-08	IWM	ETF	80.0	80.69	79.35	80.51	43803100.0
2012-03-08	DIA	ETF	128.82	129.27	128.55	128.92	4417000.0
2012-03-08	GLD	ETF	164.74	165.55	164.05	165.28	8858200.0
2012-03-08	TLT	ETF	116.32	116.57	115.64	115.74	7982100.0
2012-03-08	AADR	ETF	30.29	30.51	30.29	30.51	700.0
2012-03-08	AAXJ	ETF	57.11	57.32	56.93	57.25	807200.0
2012-03-08	ACTV	ETF	16.0	16.46	15.64	16.39	865333.0
2012-03-08	ACWI	ETF	46.25	46.67	46.24	46.53	345700.0
2012-03-08	ACWX	ETF	40.63	41.0	40.509	40.86	127964.0
2012-03-08	ADRE	ETF	42.92	43.0134	42.68	42.968	148972.0
2012-03-08	AFK	ETF	29.99	30.37	29.951	30.3	48387.0
2012-03-08	AGEM	ETF	23.6	23.76	23.5712	23.76	6765.0
2012-03-08	AGG	ETF	110.45	110.48	110.18	110.21	971300.0
2012-03-08	AGQ	ETF	238.8	242.08	233.6	240.28	441675.0
2012-03-08	AGZ	ETF	112.88	113.01	112.76	112.85	20572.0
2012-03-08	AIA	ETF	44.68	44.76	44.49	44.73	16519.0
2012-03-08	AIQ	ETF	6.65	6.65	6.45	6.55	4435.0
2012-03-08	AIS	ETF	2.83	2.97	2.81	2.97	2034759.0
2012-03-08	AIVI	ETF	41.53	41.96	41.45	41.85	44300.0
2012-03-08	AMJ	ETF	40.5	40.74	40.3	40.34	568886.0
2012-03-08	AMLP	ETF	84.4	85.4	84.4	84.55	314440.0
2012-03-08	AOA	ETF	35.78	35.97	35.67	35.89	6000.0
2012-03-08	AOK	ETF	30.0496	30.06	30.02	30.0599	2006.0
2012-03-08	AOM	ETF	31.03	31.09	31.022	31.09	14764.0
2012-03-08	AOR	ETF	32.9196	33.0	32.9196	33.0	11096.0
2012-03-08	ARB	ETF	33.37	33.98	33.22	33.88	176459.0
2012-03-08	ARGT	ETF	22.38	22.48	22.38	22.48	500.0
2012-03-08	ASEA	ETF	15.92	15.97	15.89	15.93	11900.0
2012-03-08	AWAY	ETF	24.99	25.61	24.62	25.56	506860.0
2012-03-08	BAB	ETF	29.53	29.53	29.36	29.4	132866.0
2012-03-08	BAL	ETF	55.13	55.28	54.11	54.16	19565.0
2012-03-08	BALT	ETF	3.95	4.05	3.88	3.99	113364.0
2012-03-08	BBH	ETF	41.8	42.39	41.8	42.28	64500.0
2012-03-08	BCM	ETF	45.98	46.17	45.98	46.1	5147.0
2012-03-08	BIB	ETF	11.0938	11.2438	11.005	11.185	67144.0
2012-03-08	BICK	ETF	27.13	27.3525	27.02	27.3525	6598.0
2012-03-08	BIL	ETF	91.64	91.66	91.64	91.66	711300.0
2012-03-08	BIS	ETF	4027.2	4027.2	3923.2	3934.4	23.9
2012-03-08	BITS	ETF	19.56	21.0	19.56	20.04	4225.0
2012-03-08	BIV	ETF	87.84	87.87	87.65	87.71	188300.0
2012-03-08	BJK	ETF	34.66	34.92	34.5	34.86	7400.0
2012-03-08	BKF	ETF	42.68	42.91	42.44	42.78	140594.0
2012-03-08	BKLN	ETF	24.51	24.53	24.47	24.49	116400.0
2012-03-08	BLNG	ETF	52.43	52.43	52.43	52.43	1000.0
2012-03-08	BLV	ETF	90.94	91.05	90.54	90.63	45000.0
2012-03-08	BMVP	ETF	15.083	15.178	15.073	15.178	10866.0
2012-03-08	BND	ETF	83.71	83.73	83.56	83.6	847000.0
2012-03-08	BNO	ETF	43.765	44.16	43.705	43.85	74600.0

> showing 50 of 916 rows — these rows as CSV

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