PREVIEW / etf_daily / 2013-06-05

all etf daily files

  file:    by_date/etf_daily/2013/2013-06-05.parquet
  size:    41 KB
  rows:    1,007

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
2013-06-05	SPY	ETF	163.09	163.42	161.13	161.27	211737800.0
2013-06-05	QQQ	ETF	72.77	73.04	71.99	72.05	48654171.0
2013-06-05	IWM	ETF	97.56	97.71	96.15	96.43	58967500.0
2013-06-05	DIA	ETF	151.22	151.43	149.29	149.31	9426900.0
2013-06-05	GLD	ETF	135.47	136.37	135.01	135.52	7444900.0
2013-06-05	TLT	ETF	114.29	115.32	114.13	115.29	8056100.0
2013-06-05	AADR	ETF	33.45	33.48	33.3	33.43	800.0
2013-06-05	AAXJ	ETF	58.1	58.25	57.48	57.51	497800.0
2013-06-05	ACTV	ETF	6.88	7.26	6.818	7.25	640623.0
2013-06-05	ACWI	ETF	51.75	51.78	51.14	51.19	2240500.0
2013-06-05	ACWV	ETF	60.65	60.65	60.09	60.27	130300.0
2013-06-05	ACWX	ETF	42.78	42.8201	42.37	42.37	469809.0
2013-06-05	ADRE	ETF	37.4	37.4	36.61	36.61	42631.0
2013-06-05	AFK	ETF	30.03	30.03	29.71	29.75	12390.0
2013-06-05	AGEM	ETF	21.68	21.68	21.27	21.27	1987.0
2013-06-05	AGG	ETF	108.85	108.9	108.67	108.67	1160600.0
2013-06-05	AGQ	ETF	91.24	93.08	90.64	91.16	303600.0
2013-06-05	AGZ	ETF	112.47	112.77	112.47	112.595	6056.0
2013-06-05	AIA	ETF	45.39	45.46	44.91	44.92	41535.0
2013-06-05	AIQ	ETF	15.98	16.81	15.7501	16.1	36663.0
2013-06-05	AIVI	ETF	42.53	42.59	42.19	42.19	20800.0
2013-06-05	ALTL	ETF	28.18	28.22	28.17	28.21	30600.0
2013-06-05	AMJ	ETF	45.02	45.09	43.96	44.09	812174.0
2013-06-05	AMLP	ETF	86.65	86.65	85.55	85.9	1325820.0
2013-06-05	ANGL	ETF	27.03	27.21	27.03	27.2	700.0
2013-06-05	AOA	ETF	40.43	40.43	40.0	40.05	63100.0
2013-06-05	AOK	ETF	31.1599	31.1599	30.99	30.99	46021.0
2013-06-05	AOM	ETF	32.83	32.87	32.7	32.7019	11423.0
2013-06-05	AOR	ETF	35.98	36.0	35.7	35.72	50633.0
2013-06-05	ARB	ETF	46.9	46.9	46.76	46.76	442619.0
2013-06-05	ARGT	ETF	17.63	17.63	17.63	17.63	900.0
2013-06-05	ASEA	ETF	17.49	17.52	17.23	17.28	26100.0
2013-06-05	ATMP	ETF	25.0	25.0	24.74	24.84	30800.0
2013-06-05	AVIV	ETF	26.69	26.86	25.5	25.66	334290.0
2013-06-05	AWAY	ETF	29.05	29.6	28.94	29.13	601747.0
2013-06-05	BAB	ETF	29.94	30.06	29.92	30.06	248875.0
2013-06-05	BAL	ETF	52.6	53.06	52.31	52.31	33097.0
2013-06-05	BALT	ETF	3.61	3.61	3.5	3.55	328456.0
2013-06-05	BBH	ETF	68.92	69.99	67.07	67.4	230100.0
2013-06-05	BCM	ETF	40.79	40.87	40.59	40.6	1700.0
2013-06-05	BFOR	ETF	6.2675	6.2675	6.14	6.15	77600.0
2013-06-05	BIB	ETF	22.3775	23.47	21.5752	21.8675	464144.0
2013-06-05	BICK	ETF	23.05	23.05	22.94	23.0099	1169.0
2013-06-05	BIL	ETF	91.6	91.62	91.6	91.62	123150.0
2013-06-05	BIS	ETF	1555.6	1642.36	1519.6	1622.88	865.0
2013-06-05	BIV	ETF	85.75	85.96	85.72	85.82	319000.0
2013-06-05	BIZD	ETF	19.8	19.8	19.42	19.47	36900.0
2013-06-05	BJK	ETF	41.92	41.92	41.44	41.57	26500.0
2013-06-05	BKF	ETF	37.61	37.61	36.98	37.0	238201.0
2013-06-05	BKLN	ETF	25.02	25.03	24.96	24.98	5735200.0

> showing 50 of 1,007 rows — these rows as CSV

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