PREVIEW / etf_daily / 2012-03-26

all etf daily files

  file:    by_date/etf_daily/2012/2012-03-26.parquet
  size:    38 KB
  rows:    927

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-26	SPY	ETF	140.65	141.61	140.6	141.61	120164000.0
2012-03-26	QQQ	ETF	67.37	68.11	67.33	68.11	40855239.0
2012-03-26	IWM	ETF	83.74	84.46	83.62	84.4	56454000.0
2012-03-26	DIA	ETF	131.39	132.14	131.34	132.09	4991500.0
2012-03-26	GLD	ETF	163.17	164.54	162.95	164.4	13226700.0
2012-03-26	TLT	ETF	112.83	113.01	111.8	112.63	8118600.0
2012-03-26	AAXJ	ETF	56.74	57.06	56.63	57.03	720800.0
2012-03-26	ACTV	ETF	16.81	17.2	16.81	17.18	177405.0
2012-03-26	ACWI	ETF	47.35	47.56	47.28	47.54	416300.0
2012-03-26	ACWV	ETF	54.2	54.3	54.06	54.23	7400.0
2012-03-26	ACWX	ETF	41.24	41.39	41.1	41.35	381043.0
2012-03-26	ADRE	ETF	42.51	43.07	42.51	43.07	35010.0
2012-03-26	AFK	ETF	29.6	29.67	29.512	29.6	23527.0
2012-03-26	AGEM	ETF	23.56	23.69	23.56	23.69	942.0
2012-03-26	AGG	ETF	109.65	109.68	109.44	109.62	867800.0
2012-03-26	AGQ	ETF	223.36	226.88	222.0	226.32	479850.0
2012-03-26	AGZ	ETF	112.4	112.584	112.325	112.56	25584.0
2012-03-26	AIA	ETF	44.79	45.02	44.7566	45.02	12908.0
2012-03-26	AIQ	ETF	7.75	7.75	7.6	7.65	37560.0
2012-03-26	AIS	ETF	3.4	3.45	3.28	3.32	2568280.0
2012-03-26	AIVI	ETF	42.19	42.42	42.14	42.42	20100.0
2012-03-26	AMJ	ETF	39.71	39.88	39.5572	39.59	1317666.0
2012-03-26	AMLP	ETF	83.85	84.2	83.55	83.9	264840.0
2012-03-26	AOA	ETF	36.6	36.76	36.58	36.75	16400.0
2012-03-26	AOK	ETF	30.17	30.22	30.1408	30.18	12171.0
2012-03-26	AOM	ETF	31.3156	31.4	31.2901	31.4	41694.0
2012-03-26	AOR	ETF	33.44	33.55	33.44	33.5186	9738.0
2012-03-26	ARB	ETF	36.46	37.34	36.46	37.29	163213.0
2012-03-26	ARGT	ETF	21.78	21.78	21.78	21.78	50.0
2012-03-26	ASEA	ETF	16.13	16.13	16.0	16.07	10200.0
2012-03-26	AWAY	ETF	25.03	25.56	24.56	25.52	198948.0
2012-03-26	BAB	ETF	29.02	29.06	28.8818	29.02	138683.0
2012-03-26	BAL	ETF	54.37	55.54	54.34	55.21	110625.0
2012-03-26	BALT	ETF	4.05	4.18	4.0101	4.14	112958.0
2012-03-26	BBH	ETF	43.3	43.97	42.46	43.97	70400.0
2012-03-26	BCM	ETF	46.0	46.15	45.9882	46.15	5215.0
2012-03-26	BIB	ETF	11.9962	12.1212	11.9213	12.07	45528.0
2012-03-26	BICK	ETF	26.62	26.691	26.43	26.619	7679.0
2012-03-26	BIL	ETF	91.66	91.66	91.64	91.66	1261300.0
2012-03-26	BIS	ETF	3740.8	3740.8	3640.0	3640.0	22.85
2012-03-26	BIV	ETF	86.72	86.79	86.54	86.59	271500.0
2012-03-26	BJK	ETF	36.14	36.29	36.07	36.28	6100.0
2012-03-26	BKF	ETF	41.55	41.81	41.42	41.7832	128222.0
2012-03-26	BKLN	ETF	24.52	24.55	24.5	24.54	251700.0
2012-03-26	BLNG	ETF	51.4701	51.5101	51.2999	51.4099	11400.0
2012-03-26	BLV	ETF	89.05	89.18	88.48	88.99	40800.0
2012-03-26	BMVP	ETF	15.58	15.69	15.58	15.68	6285.0
2012-03-26	BND	ETF	83.08	83.19	83.03	83.15	1137700.0
2012-03-26	BNO	ETF	44.05	44.2	43.97	44.125	76600.0
2012-03-26	BOIL	ETF	906000.0	923000.0	891000.0	892000.0	6.8

> showing 50 of 927 rows — these rows as CSV

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