PREVIEW / etf_daily / 2013-08-07

all etf daily files

  file:    by_date/etf_daily/2013/2013-08-07.parquet
  size:    41 KB
  rows:    1,009

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-08-07	SPY	ETF	169.19	169.43	168.55	169.18	84854700.0
2013-08-07	QQQ	ETF	76.36	76.568	75.87	76.42	20281126.0
2013-08-07	IWM	ETF	104.12	104.34	103.47	103.72	23362200.0
2013-08-07	DIA	ETF	154.32	154.75	154.01	154.54	4341600.0
2013-08-07	GLD	ETF	124.0	124.6	123.85	124.15	5304700.0
2013-08-07	TLT	ETF	106.17	106.94	106.17	106.8	7183400.0
2013-08-07	AADR	ETF	33.99	33.99	33.92	33.92	200.0
2013-08-07	AAXJ	ETF	55.21	55.32	54.96	54.99	667900.0
2013-08-07	ACTV	ETF	9.95	10.24	9.81	10.01	943746.0
2013-08-07	ACWI	ETF	52.64	52.67	52.47	52.57	903300.0
2013-08-07	ACWV	ETF	62.01	62.01	61.73	61.87	49800.0
2013-08-07	ACWX	ETF	42.83	42.95	42.81	42.85	642821.0
2013-08-07	ADRE	ETF	35.1	35.19	35.04	35.05	29613.0
2013-08-07	AFK	ETF	29.2	29.33	29.07	29.07	32500.0
2013-08-07	AGEM	ETF	21.03	21.1427	21.03	21.1427	474.0
2013-08-07	AGG	ETF	106.92	107.03	106.87	106.93	460600.0
2013-08-07	AGQ	ETF	66.24	67.6	66.08	66.88	299275.0
2013-08-07	AGZ	ETF	111.13	111.13	111.04	111.09	8530.0
2013-08-07	AIA	ETF	43.21	43.38	43.2	43.21	45194.0
2013-08-07	AIQ	ETF	20.86	21.7	20.4	21.55	131078.0
2013-08-07	AIVI	ETF	42.54	42.67	42.53	42.63	25800.0
2013-08-07	ALTL	ETF	29.81	29.81	29.81	29.81	102.0
2013-08-07	AMJ	ETF	46.96	47.33	46.22	47.31	661610.0
2013-08-07	AMLP	ETF	88.45	88.75	87.05	87.65	706440.0
2013-08-07	ANGL	ETF	26.42	26.42	26.42	26.42	300.0
2013-08-07	AOA	ETF	41.49	41.52	41.34	41.44	28400.0
2013-08-07	AOK	ETF	31.2	31.25	31.13	31.25	26938.0
2013-08-07	AOM	ETF	33.01	33.07	32.9801	33.06	44626.0
2013-08-07	AOR	ETF	36.47	36.54	36.421	36.49	41179.0
2013-08-07	ARB	ETF	46.01	46.9	46.0	46.08	190663.0
2013-08-07	ASEA	ETF	16.94	16.94	16.84	16.84	13500.0
2013-08-07	ATMP	ETF	26.44	26.54	26.29	26.52	16700.0
2013-08-07	AVIV	ETF	24.63	24.86	24.57	24.73	170010.0
2013-08-07	AWAY	ETF	30.24	30.37	29.12	29.49	905062.0
2013-08-07	BAB	ETF	27.7	27.77	27.67	27.69	130517.0
2013-08-07	BAL	ETF	55.35	56.67	55.31	56.4999	10876.0
2013-08-07	BALT	ETF	4.0	4.1	3.92	3.93	122544.0
2013-08-07	BBH	ETF	78.4	79.1	77.64	78.93	113900.0
2013-08-07	BCM	ETF	39.081	39.185	39.081	39.1001	1120.0
2013-08-07	BFOR	ETF	6.655	6.655	6.59	6.62	111600.0
2013-08-07	BIB	ETF	28.1325	29.0702	26.8275	28.935	485976.0
2013-08-07	BICK	ETF	21.5	21.5	21.42	21.46	5077.0
2013-08-07	BIL	ETF	91.6	91.6	91.58	91.58	97100.0
2013-08-07	BIS	ETF	1197.6	1211.16	1190.8	1190.8	61.0
2013-08-07	BIV	ETF	83.31	83.46	83.28	83.46	227600.0
2013-08-07	BIZD	ETF	20.22	20.22	19.93	20.09	16300.0
2013-08-07	BJK	ETF	42.42	42.64	42.42	42.58	900.0
2013-08-07	BKF	ETF	34.1	34.27	34.02	34.02	221018.0
2013-08-07	BKLN	ETF	24.89	24.89	24.87	24.88	2050200.0
2013-08-07	BLV	ETF	83.42	83.82	83.25	83.59	25600.0

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

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