PREVIEW / etf_daily / 2014-10-14

all etf daily files

  file:    by_date/etf_daily/2014/2014-10-14.parquet
  size:    46 KB
  rows:    1,128

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-14	SPY	ETF	188.42	189.82	187.04	187.7	215847000.0
2014-10-14	QQQ	ETF	93.6	94.1699	92.71	92.97	71814456.0
2014-10-14	IWM	ETF	105.23	106.99	104.86	105.54	70034800.0
2014-10-14	DIA	ETF	163.67	164.41	162.5	163.03	13626400.0
2014-10-14	GLD	ETF	118.58	118.82	118.35	118.59	5174800.0
2014-10-14	TLT	ETF	121.31	121.78	120.68	121.57	11285400.0
2014-10-14	AADR	ETF	35.2	35.29	35.2	35.29	400.0
2014-10-14	AAXJ	ETF	60.38	60.77	60.2	60.44	1014500.0
2014-10-14	ACWI	ETF	56.25	56.64	55.93	56.09	1734500.0
2014-10-14	ACWV	ETF	65.84	66.18	65.56	65.71	195900.0
2014-10-14	ACWX	ETF	43.42	43.61	43.1452	43.27	794237.0
2014-10-14	ADRE	ETF	39.32	39.75	39.08	39.53	15297.0
2014-10-14	AFK	ETF	29.5	29.699	29.231	29.44	77318.0
2014-10-14	AGG	ETF	110.5	110.58	110.28	110.56	3518500.0
2014-10-14	AGQ	ETF	48.19	48.37	47.44	47.9	159600.0
2014-10-14	AGZ	ETF	113.13	113.52	113.015	113.29	16080.0
2014-10-14	AGZD	ETF	24.835	24.84	24.8	24.8	4600.0
2014-10-14	AIA	ETF	46.23	46.3999	45.94	46.18	16998.0
2014-10-14	AIQ	ETF	21.89	22.97	21.35	22.5	23061.0
2014-10-14	AIRR	ETF	18.04	18.04	17.149	17.22	72500.0
2014-10-14	AIVI	ETF	44.32	44.45	44.12	44.16	51900.0
2014-10-14	ALTL	ETF	33.72	33.86	33.68	33.8	12736.0
2014-10-14	AMJ	ETF	46.31	46.94	43.45	45.72	5988992.0
2014-10-14	AMLP	ETF	87.75	88.25	83.15	86.65	2983500.0
2014-10-14	AMZA	ETF	222.5	223.15	213.9	217.5	980.0
2014-10-14	ANGL	ETF	27.62	27.62	27.46	27.48	1900.0
2014-10-14	AOA	ETF	43.93	44.17	43.72	43.81	38500.0
2014-10-14	AOK	ETF	32.03	32.11	31.99	32.02	32870.0
2014-10-14	AOM	ETF	34.28	34.37	34.1993	34.22	48338.0
2014-10-14	AOR	ETF	38.37	38.6273	38.31	38.41	67622.0
2014-10-14	ARGT	ETF	19.0	19.27	18.98	19.11	9700.0
2014-10-14	ARKQ	ETF	18.65	18.67	18.65	18.664	9100.0
2014-10-14	ARKW	ETF	18.82	18.82	18.69	18.76	5200.0
2014-10-14	ASEA	ETF	16.24	16.34	16.24	16.28	1400.0
2014-10-14	ASHR	ETF	25.67	25.75	25.54	25.64	1120800.0
2014-10-14	ASHS	ETF	33.49	33.93	33.49	33.83	1300.0
2014-10-14	ATMP	ETF	28.42	28.77	26.9	27.98	58700.0
2014-10-14	AVIV	ETF	27.92	28.51	27.92	28.49	232978.0
2014-10-14	AWAY	ETF	33.95	34.1	31.12	31.77	2572116.0
2014-10-14	BAB	ETF	30.2	30.25	30.07	30.22	163561.0
2014-10-14	BAL	ETF	43.764	43.95	42.85	42.88	27037.0
2014-10-14	BALT	ETF	3.0	3.97	2.95	3.35	2964312.0
2014-10-14	BAR	ETF	3.218	3.22	3.1891	3.22	13630.0
2014-10-14	BBH	ETF	99.82	100.35	96.34	97.57	217500.0
2014-10-14	BCHP	ETF	17.8399	17.8399	17.8399	17.8399	109.0
2014-10-14	BCM	ETF	36.22	36.22	36.22	36.22	107.0
2014-10-14	BFOR	ETF	7.0925	7.195	7.0375	7.125	200400.0
2014-10-14	BIB	ETF	46.56	47.125	43.805	45.115	816442.0
2014-10-14	BICK	ETF	24.7529	24.77	24.7529	24.77	400.0
2014-10-14	BIL	ETF	91.48	91.5	91.48	91.48	424150.0

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

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