PREVIEW / etf_daily / 2014-10-06

all etf daily files

  file:    by_date/etf_daily/2014/2014-10-06.parquet
  size:    45 KB
  rows:    1,114

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-10-06	SPY	ETF	197.34	197.6	195.58	196.29	104778000.0
2014-10-06	QQQ	ETF	98.47	98.72	97.6587	97.96	36038687.0
2014-10-06	IWM	ETF	109.95	110.07	108.51	108.71	35571200.0
2014-10-06	DIA	ETF	170.44	170.69	168.96	169.57	5315300.0
2014-10-06	GLD	ETF	115.16	116.31	114.94	116.03	7644100.0
2014-10-06	TLT	ETF	117.62	118.19	117.36	117.77	4485500.0
2014-10-06	AADR	ETF	36.89	36.89	36.89	36.89	300.0
2014-10-06	AAXJ	ETF	61.65	61.73	61.36	61.38	496600.0
2014-10-06	ACWI	ETF	58.52	58.7	58.28	58.53	2214500.0
2014-10-06	ACWV	ETF	66.89	66.94	66.58	66.86	96800.0
2014-10-06	ACWX	ETF	44.96	45.05	44.76	44.97	252014.0
2014-10-06	ADRE	ETF	39.93	40.12	39.816	39.816	19158.0
2014-10-06	AFK	ETF	30.89	31.13	30.84	31.11	19387.0
2014-10-06	AGG	ETF	109.4	109.55	109.31	109.4	2145800.0
2014-10-06	AGQ	ETF	46.29	47.77	45.9	47.4	402400.0
2014-10-06	AGZ	ETF	112.37	112.63	112.22	112.5	12077.0
2014-10-06	AGZD	ETF	24.89	24.89	24.83	24.83	8000.0
2014-10-06	AIA	ETF	46.98	47.128	46.85	46.954	38601.0
2014-10-06	AIQ	ETF	23.0	23.0	21.61	22.01	19244.0
2014-10-06	AIRR	ETF	18.2	18.2	17.96	18.01	14200.0
2014-10-06	AIVI	ETF	45.82	46.04	45.66	45.95	18700.0
2014-10-06	ALTL	ETF	35.22	35.22	35.22	35.22	320.0
2014-10-06	AMJ	ETF	52.47	52.64	51.8	52.07	685111.0
2014-10-06	AMLP	ETF	95.35	95.4	94.4	94.7	539240.0
2014-10-06	AMZA	ETF	251.2	280.4	248.2	249.2	2260.0
2014-10-06	ANGL	ETF	27.55	27.7	27.55	27.7	600.0
2014-10-06	AOA	ETF	45.61	45.61	45.13	45.22	18200.0
2014-10-06	AOK	ETF	32.45	32.45	32.35	32.38	19695.0
2014-10-06	AOM	ETF	34.83	34.83	34.6801	34.75	19750.0
2014-10-06	AOR	ETF	39.29	39.364	39.15	39.23	26928.0
2014-10-06	ARGT	ETF	20.26	20.33	20.09	20.2	11000.0
2014-10-06	ARKQ	ETF	19.93	19.93	19.71	19.71	5300.0
2014-10-06	ARKW	ETF	20.23	20.23	19.968	19.968	5000.0
2014-10-06	ASEA	ETF	16.6	16.68	16.6	16.6	3400.0
2014-10-06	ASHR	ETF	26.06	26.09	25.88	25.97	693000.0
2014-10-06	ASHS	ETF	34.07	34.08	33.98	34.08	6500.0
2014-10-06	ATMP	ETF	32.11	32.11	31.7	31.87	20600.0
2014-10-06	AVIV	ETF	26.9	27.35	26.708	27.29	226571.0
2014-10-06	AWAY	ETF	35.92	36.19	35.18	35.4	590678.0
2014-10-06	BAB	ETF	29.91	29.92	29.84	29.9	86213.0
2014-10-06	BAL	ETF	42.1	43.45	42.1	43.1523	11402.0
2014-10-06	BALT	ETF	3.88	4.0	3.55	3.6	1281050.0
2014-10-06	BAR	ETF	2.936	3.022	2.936	3.022	7330.0
2014-10-06	BBH	ETF	106.56	106.82	104.22	104.59	43000.0
2014-10-06	BFOR	ETF	7.5575	7.575	7.4875	7.495	155600.0
2014-10-06	BIB	ETF	53.105	53.39	50.935	51.315	635132.0
2014-10-06	BICK	ETF	25.16	25.16	25.01	25.01	2347.0
2014-10-06	BIL	ETF	91.48	91.5	91.48	91.48	237100.0
2014-10-06	BIS	ETF	467.2	488.988	466.4	485.6	18048.5
2014-10-06	BIV	ETF	84.45	84.65	84.29	84.54	201900.0

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

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