PREVIEW / etf_daily / 2014-10-21

all etf daily files

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

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-21	SPY	ETF	191.68	194.2	191.48	194.07	154949000.0
2014-10-21	QQQ	ETF	95.54	96.87	95.32	96.87	53609758.0
2014-10-21	IWM	ETF	109.33	110.59	109.01	110.53	44748100.0
2014-10-21	DIA	ETF	164.45	165.87	164.12	165.8	8994600.0
2014-10-21	GLD	ETF	120.27	120.5	119.91	120.02	4566100.0
2014-10-21	TLT	ETF	120.84	121.24	120.53	120.54	9754700.0
2014-10-21	AADR	ETF	36.69	36.69	36.19	36.32	500.0
2014-10-21	AAXJ	ETF	61.05	61.5	60.9	61.34	567600.0
2014-10-21	ACWI	ETF	57.05	57.62	56.92	57.55	710900.0
2014-10-21	ACWV	ETF	66.53	66.99	66.39	66.92	146700.0
2014-10-21	ACWX	ETF	43.59	43.9681	43.59	43.96	120624.0
2014-10-21	ADRE	ETF	38.73	38.8754	38.53	38.77	16919.0
2014-10-21	AFK	ETF	29.27	29.66	29.2001	29.58	57837.0
2014-10-21	AGG	ETF	110.55	110.68	110.49	110.55	2625000.0
2014-10-21	AGQ	ETF	48.38	49.0	48.31	48.44	176300.0
2014-10-21	AGZ	ETF	113.06	113.4399	113.06	113.15	12368.0
2014-10-21	AGZD	ETF	24.71	24.8	24.71	24.72	12200.0
2014-10-21	AIA	ETF	46.5092	46.6035	46.4	46.49	13877.0
2014-10-21	AIQ	ETF	23.02	23.29	22.045	22.96	25774.0
2014-10-21	AIRR	ETF	17.8	18.119	17.75	18.09	23700.0
2014-10-21	AIVI	ETF	44.58	45.02	44.58	44.96	22100.0
2014-10-21	AMJ	ETF	50.27	51.38	50.14	50.94	1621611.0
2014-10-21	AMLP	ETF	92.95	93.9	92.5	93.5	1186040.0
2014-10-21	AMZA	ETF	244.5	245.7	241.28	243.8	1600.0
2014-10-21	ANGL	ETF	27.31	27.73	27.31	27.73	19100.0
2014-10-21	AOA	ETF	44.6	45.02	44.6	45.01	30400.0
2014-10-21	AOK	ETF	32.23	32.43	32.23	32.398	55794.0
2014-10-21	AOM	ETF	34.6	34.76	34.599	34.76	32900.0
2014-10-21	AOR	ETF	38.9399	39.19	38.9399	39.19	70513.0
2014-10-21	ARGT	ETF	19.55	19.79	19.5	19.79	4300.0
2014-10-21	ARKQ	ETF	19.34	19.54	19.335	19.53	15100.0
2014-10-21	ARKW	ETF	19.29	19.58	19.28	19.56	10500.0
2014-10-21	ASEA	ETF	16.42	16.58	16.42	16.56	16100.0
2014-10-21	ASHR	ETF	25.8	25.86	25.75	25.79	695700.0
2014-10-21	ASHS	ETF	33.21	33.62	33.21	33.53	2800.0
2014-10-21	ATMP	ETF	30.94	31.68	30.94	31.32	103400.0
2014-10-21	AVIV	ETF	28.87	29.11	28.62	28.88	157945.0
2014-10-21	AWAY	ETF	32.43	33.059	32.32	32.91	1233566.0
2014-10-21	BAB	ETF	30.08	30.12	30.0	30.04	136741.0
2014-10-21	BAL	ETF	41.685	42.42	41.685	42.01	9068.0
2014-10-21	BALT	ETF	3.75	4.19	3.66	4.04	1597516.0
2014-10-21	BAR	ETF	3.348	3.366	3.3251	3.3251	25520.0
2014-10-21	BBH	ETF	105.11	107.25	104.87	107.25	252200.0
2014-10-21	BCHP	ETF	18.19	18.38	18.19	18.38	344.0
2014-10-21	BCM	ETF	36.138	36.138	36.138	36.138	591.0
2014-10-21	BFOR	ETF	7.38	7.5175	7.38	7.5025	798800.0
2014-10-21	BIB	ETF	51.695	53.5	51.255	53.5	892586.0
2014-10-21	BICK	ETF	24.38	24.42	24.36	24.41	1347.0
2014-10-21	BIL	ETF	91.5	91.5	91.48	91.48	2076600.0
2014-10-21	BIS	ETF	480.0	480.0	458.0	458.4	26533.0

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

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