PREVIEW / etf_daily / 2014-10-03

all etf daily files

  file:    by_date/etf_daily/2014/2014-10-03.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-03	SPY	ETF	195.68	196.94	195.08	196.52	121569000.0
2014-10-03	QQQ	ETF	97.76	98.57	97.44	98.17	41627772.0
2014-10-03	IWM	ETF	109.75	110.32	109.08	109.65	44034600.0
2014-10-03	DIA	ETF	168.89	169.97	168.37	169.72	5589100.0
2014-10-03	GLD	ETF	115.17	115.51	114.42	114.61	11301300.0
2014-10-03	TLT	ETF	117.0	117.77	116.83	117.7	8561500.0
2014-10-03	AADR	ETF	37.08	37.08	36.85	37.02	1700.0
2014-10-03	AAXJ	ETF	60.93	61.19	60.69	61.06	733100.0
2014-10-03	ACWI	ETF	58.01	58.35	57.95	58.23	1051900.0
2014-10-03	ACWV	ETF	66.33	66.7	66.32	66.61	34900.0
2014-10-03	ACWX	ETF	44.63	44.66	44.44	44.59	307264.0
2014-10-03	ADRE	ETF	38.46	39.01	38.46	38.97	38176.0
2014-10-03	AFK	ETF	31.03	31.03	30.64	30.73	20602.0
2014-10-03	AGG	ETF	109.31	109.36	109.2	109.3	2928900.0
2014-10-03	AGQ	ETF	45.1	45.81	44.31	44.87	385400.0
2014-10-03	AGZ	ETF	112.32	112.58	112.29	112.4646	8964.0
2014-10-03	AGZD	ETF	24.9	24.9	24.775	24.88	10200.0
2014-10-03	AIA	ETF	46.6	46.6	46.259	46.52	22248.0
2014-10-03	AIQ	ETF	22.34	22.94	22.34	22.81	16496.0
2014-10-03	AIRR	ETF	18.22	18.3	18.11	18.11	17700.0
2014-10-03	AIVI	ETF	45.58	45.69	45.47	45.61	24400.0
2014-10-03	ALTL	ETF	35.3	35.3	35.3	35.3	994.0
2014-10-03	AMJ	ETF	52.65	52.6899	52.3	52.45	441142.0
2014-10-03	AMLP	ETF	95.25	95.5	94.85	95.25	647960.0
2014-10-03	AMZA	ETF	251.2	251.2	250.7	250.7	2590.0
2014-10-03	ANGL	ETF	27.72	27.72	27.67	27.71	1000.0
2014-10-03	AOA	ETF	45.01	45.2	44.96	45.17	28600.0
2014-10-03	AOK	ETF	32.36	32.37	32.31	32.36	16606.0
2014-10-03	AOM	ETF	34.67	34.737	34.62	34.71	34850.0
2014-10-03	AOR	ETF	39.14	39.2299	39.0699	39.21	46711.0
2014-10-03	ARGT	ETF	20.33	20.33	20.03	20.1	47600.0
2014-10-03	ARKQ	ETF	19.81	19.84	19.806	19.84	8500.0
2014-10-03	ARKW	ETF	20.11	20.17	20.084	20.14	8300.0
2014-10-03	ASEA	ETF	16.51	16.58	16.51	16.54	2500.0
2014-10-03	ASHR	ETF	25.74	25.77	25.6	25.69	418000.0
2014-10-03	ASHS	ETF	33.55	33.6	33.53	33.6	1300.0
2014-10-03	ATMP	ETF	32.19	32.19	31.87	31.87	68200.0
2014-10-03	AVIV	ETF	26.7	26.9	26.4	26.87	177845.0
2014-10-03	AWAY	ETF	35.11	36.07	34.98	35.93	1554466.0
2014-10-03	BAB	ETF	29.69	29.86	29.6853	29.84	48714.0
2014-10-03	BAL	ETF	41.3701	41.99	41.3701	41.99	8591.0
2014-10-03	BALT	ETF	3.85	4.0	3.75	3.88	871184.0
2014-10-03	BAR	ETF	2.954	2.954	2.8862	2.8862	13340.0
2014-10-03	BBH	ETF	104.76	106.22	104.27	105.96	166100.0
2014-10-03	BCHP	ETF	18.63	18.63	18.63	18.63	1063.0
2014-10-03	BCM	ETF	36.33	36.3729	36.33	36.3729	267.0
2014-10-03	BFOR	ETF	7.515	7.5675	7.515	7.535	211200.0
2014-10-03	BIB	ETF	51.03	52.835	50.9763	52.575	740644.0
2014-10-03	BICK	ETF	24.48	24.48	24.48	24.48	271.0
2014-10-03	BIL	ETF	91.52	91.52	91.48	91.48	650100.0

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

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