PREVIEW / etf_daily / 2014-04-15

all etf daily files

  file:    by_date/etf_daily/2014/2014-04-15.parquet
  size:    44 KB
  rows:    1,082

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
2014-04-15	SPY	ETF	183.32	184.33	181.51	184.2	157093000.0
2014-04-15	QQQ	ETF	85.06	85.54	83.28	85.0501	84631517.0
2014-04-15	IWM	ETF	111.03	111.72	108.66	111.15	76968000.0
2014-04-15	DIA	ETF	161.67	162.47	160.38	162.36	8489000.0
2014-04-15	GLD	ETF	124.79	125.7	124.6	125.49	9967600.0
2014-04-15	TLT	ETF	110.61	111.51	110.35	111.13	7752000.0
2014-04-15	AADR	ETF	37.22	37.39	37.22	37.39	600.0
2014-04-15	AAXJ	ETF	60.48	60.51	59.58	60.25	376000.0
2014-04-15	ACWI	ETF	57.33	57.55	56.71	57.42	772100.0
2014-04-15	ACWV	ETF	64.04	64.14	63.53	64.12	16300.0
2014-04-15	ACWX	ETF	46.33	46.41	45.78	46.26	155084.0
2014-04-15	ADRE	ETF	37.42	37.42	36.55	37.04	15239.0
2014-04-15	AFK	ETF	31.84	31.85	31.37	31.73	93293.0
2014-04-15	AGG	ETF	108.44	108.62	108.39	108.48	1442100.0
2014-04-15	AGQ	ETF	61.75	62.95	61.52	62.8	543900.0
2014-04-15	AGZ	ETF	112.24	112.36	112.11	112.11	42441.0
2014-04-15	AIA	ETF	47.16	47.24	46.78	47.14	19028.0
2014-04-15	AIQ	ETF	29.06	30.085	28.1	29.5	62114.0
2014-04-15	AIRR	ETF	19.05	19.09	18.57	18.93	51000.0
2014-04-15	AIVI	ETF	48.9	48.99	48.22	48.66	24300.0
2014-04-15	ALTL	ETF	32.885	32.885	32.885	32.885	155.0
2014-04-15	AMJ	ETF	47.84	47.9	47.47	47.65	226948.0
2014-04-15	AMLP	ETF	89.75	89.9	89.3	89.55	788260.0
2014-04-15	ANGL	ETF	27.5	27.7	27.49	27.65	4700.0
2014-04-15	AOA	ETF	44.61	44.68	44.11	44.6	42800.0
2014-04-15	AOK	ETF	32.2	32.24	32.11	32.24	32325.0
2014-04-15	AOM	ETF	34.46	34.56	34.32	34.54	28217.0
2014-04-15	AOR	ETF	38.59	38.72	38.35	38.7	33293.0
2014-04-15	ARGT	ETF	19.57	19.59	19.25	19.26	5700.0
2014-04-15	ASEA	ETF	16.12	16.14	16.08	16.1	18400.0
2014-04-15	ASHR	ETF	22.66	22.68	22.56	22.63	112600.0
2014-04-15	ATMP	ETF	27.32	28.49	27.32	28.15	26100.0
2014-04-15	AVIV	ETF	24.81	25.71	24.66	25.64	374664.0
2014-04-15	AWAY	ETF	33.41	33.71	32.02	33.43	2579309.0
2014-04-15	BAB	ETF	28.9	28.99	28.83	28.95	114371.0
2014-04-15	BAL	ETF	56.9001	57.03	55.9799	56.66	6676.0
2014-04-15	BALT	ETF	6.03	6.195	5.93	6.13	906254.0
2014-04-15	BBH	ETF	83.35	84.58	80.05	83.84	368700.0
2014-04-15	BCM	ETF	41.32	41.47	41.32	41.46	2259.0
2014-04-15	BFOR	ETF	7.35	7.375	7.2325	7.3575	233600.0
2014-04-15	BIB	ETF	33.075	34.33	30.4457	33.455	1978156.0
2014-04-15	BICK	ETF	24.84	24.84	24.22	24.48	2243.0
2014-04-15	BIL	ETF	91.54	91.56	91.54	91.54	226800.0
2014-04-15	BIS	ETF	821.2	900.0	800.0	820.0	40564.0
2014-04-15	BIV	ETF	83.79	84.0	83.71	83.88	164500.0
2014-04-15	BIZD	ETF	19.91	19.91	19.72	19.88	8500.0
2014-04-15	BJK	ETF	50.4	50.4	49.22	49.95	38800.0
2014-04-15	BKF	ETF	36.48	36.48	35.6	35.91	88320.0
2014-04-15	BKLN	ETF	24.7	24.71	24.63	24.63	3775800.0
2014-04-15	BLV	ETF	87.65	88.2	87.65	88.06	56400.0

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

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