PREVIEW / etf_daily / 2013-07-18

all etf daily files

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

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-07-18	SPY	ETF	168.31	169.27	168.2	168.87	103620100.0
2013-07-18	QQQ	ETF	75.54	75.74	75.25	75.37	36278798.0
2013-07-18	IWM	ETF	103.73	104.59	103.66	104.15	32034100.0
2013-07-18	DIA	ETF	154.98	155.74	154.56	155.34	6823000.0
2013-07-18	GLD	ETF	124.11	124.52	123.78	124.01	6150900.0
2013-07-18	TLT	ETF	108.61	108.67	107.48	107.5	9066400.0
2013-07-18	AADR	ETF	33.91	33.91	33.69	33.74	4200.0
2013-07-18	AAXJ	ETF	56.35	56.35	55.94	56.0	275500.0
2013-07-18	ACTV	ETF	8.84	9.0	8.79	8.91	575589.0
2013-07-18	ACWI	ETF	52.33	52.65	52.33	52.54	1262700.0
2013-07-18	ACWV	ETF	62.14	62.27	62.07	62.13	47400.0
2013-07-18	ACWX	ETF	42.82	42.97	42.79	42.93	619881.0
2013-07-18	ADRE	ETF	35.21	35.39	35.1516	35.18	17586.0
2013-07-18	AFK	ETF	28.99	29.0	28.87	28.8901	24788.0
2013-07-18	AGEM	ETF	21.331	21.331	21.289	21.2896	866.0
2013-07-18	AGG	ETF	107.37	107.44	107.18	107.24	576900.0
2013-07-18	AGQ	ETF	66.76	67.44	65.44	66.24	347575.0
2013-07-18	AGZ	ETF	111.261	111.4	111.13	111.13	7860.0
2013-07-18	AIA	ETF	43.69	43.69	43.442	43.5	30420.0
2013-07-18	AIQ	ETF	17.31	18.46	17.28	18.39	87338.0
2013-07-18	AIVI	ETF	41.95	42.16	41.94	42.11	17400.0
2013-07-18	AMJ	ETF	48.34	49.0	48.05	48.26	700026.0
2013-07-18	AMLP	ETF	90.55	90.85	89.95	90.1	438340.0
2013-07-18	ANGL	ETF	26.81	26.85	26.8	26.8	1400.0
2013-07-18	AOA	ETF	41.33	41.45	41.33	41.4	42600.0
2013-07-18	AOK	ETF	31.2	31.25	31.1901	31.21	18899.0
2013-07-18	AOM	ETF	33.04	33.0899	33.0	33.08	9829.0
2013-07-18	AOR	ETF	36.38	36.519	36.37	36.46	39141.0
2013-07-18	ARB	ETF	46.35	46.46	46.32	46.39	452143.0
2013-07-18	ARGT	ETF	17.16	17.16	17.11	17.16	1500.0
2013-07-18	ASEA	ETF	17.19	17.23	17.14	17.17	38800.0
2013-07-18	ATMP	ETF	26.81	26.86	26.55	26.55	82400.0
2013-07-18	AVIV	ETF	26.2	26.37	26.06	26.29	112949.0
2013-07-18	AWAY	ETF	31.79	32.1	31.21	31.39	674162.0
2013-07-18	BAB	ETF	28.17	28.17	27.94	27.98	147449.0
2013-07-18	BAL	ETF	53.89	54.78	53.89	54.2491	9104.0
2013-07-18	BALT	ETF	3.77	3.84	3.77	3.81	120370.0
2013-07-18	BBH	ETF	76.83	77.18	76.5	76.81	51000.0
2013-07-18	BCM	ETF	40.1	40.1	39.99	39.99	699.0
2013-07-18	BFOR	ETF	6.515	6.57	6.515	6.555	250800.0
2013-07-18	BIB	ETF	27.8675	27.9962	27.5	27.6827	106460.0
2013-07-18	BICK	ETF	21.78	21.793	21.7696	21.779	1402.0
2013-07-18	BIL	ETF	91.6	91.6	91.58	91.6	168700.0
2013-07-18	BIS	ETF	1242.0	1242.0	1240.0	1242.0	27.5
2013-07-18	BIV	ETF	83.98	84.0	83.71	83.74	452400.0
2013-07-18	BIZD	ETF	20.44	20.52	20.44	20.51	108400.0
2013-07-18	BJK	ETF	41.81	42.1	41.8	41.98	26100.0
2013-07-18	BKF	ETF	35.11	35.301	35.0201	35.08	83109.0
2013-07-18	BKLN	ETF	24.9	24.95	24.85	24.94	3369400.0
2013-07-18	BLV	ETF	85.1	85.1	84.48	84.5	116000.0

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

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