PREVIEW / etf_daily / 2014-10-29

all etf daily files

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

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-29	SPY	ETF	198.55	199.12	196.8	198.11	142557000.0
2014-10-29	QQQ	ETF	99.84	100.12	99.1	99.81	40552803.0
2014-10-29	IWM	ETF	114.36	114.89	112.98	113.9	67133500.0
2014-10-29	DIA	ETF	170.01	170.34	168.61	169.4	7584000.0
2014-10-29	GLD	ETF	117.65	117.91	116.14	116.41	7900800.0
2014-10-29	TLT	ETF	118.96	119.82	118.42	119.46	9105100.0
2014-10-29	AADR	ETF	38.11	38.11	37.14	37.37	1100.0
2014-10-29	AAXJ	ETF	62.55	62.76	62.02	62.26	299300.0
2014-10-29	ACWI	ETF	58.75	58.93	58.15	58.39	3362300.0
2014-10-29	ACWV	ETF	68.33	68.44	67.6	68.05	105000.0
2014-10-29	ACWX	ETF	44.87	44.89	44.24	44.4	300727.0
2014-10-29	ADRE	ETF	39.15	39.15	38.53	38.65	4260.0
2014-10-29	AFK	ETF	29.72	29.88	29.5	29.64	53913.0
2014-10-29	AGG	ETF	110.03	110.16	109.85	109.9	1591000.0
2014-10-29	AGQ	ETF	46.73	47.31	45.7	45.87	177000.0
2014-10-29	AGZ	ETF	113.24	113.26	112.87	113.1287	3913.0
2014-10-29	AGZD	ETF	24.78	24.805	24.725	24.725	175200.0
2014-10-29	AIA	ETF	47.69	47.83	47.411	47.47	29744.0
2014-10-29	AIQ	ETF	25.3	25.35	24.89	25.02	12523.0
2014-10-29	AIRR	ETF	19.038	19.038	18.66	18.78	23800.0
2014-10-29	AIVI	ETF	45.66	45.87	45.18	45.39	17300.0
2014-10-29	AMJ	ETF	51.18	51.41	50.5001	51.12	786369.0
2014-10-29	AMLP	ETF	93.9	94.1	92.95	93.85	782760.0
2014-10-29	AMZA	ETF	244.9	244.9	242.9	242.9	180.0
2014-10-29	ANGL	ETF	27.86	27.86	27.68	27.73	4200.0
2014-10-29	AOA	ETF	45.85	45.91	45.51	45.72	26700.0
2014-10-29	AOK	ETF	32.54	32.6	32.46	32.5007	16367.0
2014-10-29	AOM	ETF	35.02	35.1	34.8801	34.97	66430.0
2014-10-29	AOR	ETF	39.76	39.78	39.5	39.6	75395.0
2014-10-29	ARGT	ETF	20.16	20.16	19.74	19.74	4100.0
2014-10-29	ARKQ	ETF	20.19	20.19	19.54	19.66	12300.0
2014-10-29	ARKW	ETF	19.91	19.91	19.73	19.8	5000.0
2014-10-29	ASEA	ETF	16.66	16.76	16.59	16.73	215000.0
2014-10-29	ASHR	ETF	25.84	26.01	25.8	25.85	214600.0
2014-10-29	ASHS	ETF	34.27	34.31	34.01	34.06	20400.0
2014-10-29	ATMP	ETF	31.57	31.74	31.37	31.62	20600.0
2014-10-29	AVIV	ETF	29.84	29.94	29.57	29.86	384877.0
2014-10-29	AWAY	ETF	34.91	34.942	34.19	34.43	770561.0
2014-10-29	BAB	ETF	29.92	29.92	29.78	29.86	109425.0
2014-10-29	BAL	ETF	43.86	44.176	43.598	43.73	6654.0
2014-10-29	BALT	ETF	3.88	4.1	3.76	3.96	1104064.0
2014-10-29	BAR	ETF	2.89	3.178	2.89	3.0124	27120.0
2014-10-29	BBH	ETF	114.38	114.52	112.21	113.38	149000.0
2014-10-29	BCM	ETF	36.58	37.8	36.54	36.612	9993.0
2014-10-29	BFOR	ETF	7.7175	7.755	7.6625	7.695	132400.0
2014-10-29	BIB	ETF	59.42	59.56	57.14	58.325	594160.0
2014-10-29	BICK	ETF	24.99	24.99	24.77	24.77	3344.0
2014-10-29	BIL	ETF	91.5	91.5	91.48	91.5	725950.0
2014-10-29	BIS	ETF	414.8	425.2	409.2	417.6	13767.0
2014-10-29	BIV	ETF	85.19	85.2	84.8	84.94	292400.0

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

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