PREVIEW / etf_daily / 2014-10-31

all etf daily files

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

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-31	SPY	ETF	201.78	201.82	200.77	201.66	146903000.0
2014-10-31	QQQ	ETF	101.67	101.75	101.07	101.4	54254141.0
2014-10-31	IWM	ETF	116.91	116.96	115.88	116.56	53133300.0
2014-10-31	DIA	ETF	173.34	173.63	172.79	173.45	7563500.0
2014-10-31	GLD	ETF	111.83	112.88	111.66	112.66	18208200.0
2014-10-31	TLT	ETF	119.34	119.71	118.83	119.25	6664200.0
2014-10-31	AADR	ETF	37.37	37.37	37.36	37.37	800.0
2014-10-31	AAXJ	ETF	62.92	63.2	62.82	62.89	959900.0
2014-10-31	ACWI	ETF	59.46	59.67	59.31	59.61	1484200.0
2014-10-31	ACWV	ETF	69.26	69.35	68.92	69.15	92800.0
2014-10-31	ACWX	ETF	45.22	45.38	45.12	45.38	200998.0
2014-10-31	ADRE	ETF	39.5	39.6945	39.4601	39.69	7367.0
2014-10-31	AFK	ETF	29.61	29.61	29.2801	29.55	83814.0
2014-10-31	AGG	ETF	109.93	110.08	109.9	110.08	3145100.0
2014-10-31	AGQ	ETF	39.64	41.15	39.55	41.06	401600.0
2014-10-31	AGZ	ETF	113.24	113.4599	112.78	112.95	11299.0
2014-10-31	AGZD	ETF	24.89	24.89	24.76	24.825	15600.0
2014-10-31	AIA	ETF	48.25	48.35	48.06	48.19	30042.0
2014-10-31	AIQ	ETF	25.55	25.55	23.92	24.13	46450.0
2014-10-31	AIRR	ETF	19.03	19.3	19.03	19.25	83800.0
2014-10-31	AIVI	ETF	46.03	46.27	45.88	46.25	27600.0
2014-10-31	ALTL	ETF	35.96	35.9694	35.96	35.9694	856.0
2014-10-31	AMJ	ETF	50.62	50.99	50.1	50.66	863691.0
2014-10-31	AMLP	ETF	93.35	93.5	92.35	92.9	1005040.0
2014-10-31	AMZA	ETF	243.3	243.3	240.6	242.2	790.0
2014-10-31	ANGL	ETF	27.53	27.74	27.53	27.61	600.0
2014-10-31	AOA	ETF	46.35	46.46	46.26	46.46	44400.0
2014-10-31	AOK	ETF	32.68	32.77	32.68	32.74	33103.0
2014-10-31	AOM	ETF	35.42	35.42	35.238	35.28	81352.0
2014-10-31	AOR	ETF	40.25	40.25	39.9601	40.12	43756.0
2014-10-31	ARGT	ETF	20.59	21.21	20.59	21.12	12700.0
2014-10-31	ARKG	ETF	20.33	20.35	20.1	20.1	5861.0
2014-10-31	ARKK	ETF	20.42	20.42	20.38	20.38	2662.0
2014-10-31	ARKQ	ETF	19.976	20.06	19.976	20.06	600.0
2014-10-31	ARKW	ETF	20.31	20.34	20.31	20.33	1300.0
2014-10-31	ASEA	ETF	16.84	16.84	16.75	16.77	6700.0
2014-10-31	ASHR	ETF	26.5	26.65	26.5	26.57	349300.0
2014-10-31	ASHS	ETF	34.21	34.28	34.15	34.2	9200.0
2014-10-31	ATMP	ETF	31.33	31.48	31.21	31.43	17000.0
2014-10-31	AVIV	ETF	33.76	34.71	30.1	33.73	5108649.0
2014-10-31	AWAY	ETF	34.33	34.94	34.225	34.9	1189837.0
2014-10-31	BAB	ETF	29.84	29.88	29.7	29.74	171840.0
2014-10-31	BAL	ETF	42.93	43.12	42.307	43.12	18164.0
2014-10-31	BALT	ETF	3.95	3.97	3.71	3.75	646562.0
2014-10-31	BAR	ETF	2.675	2.742	2.668	2.74	159330.0
2014-10-31	BBH	ETF	117.88	118.27	115.19	115.77	124700.0
2014-10-31	BCHP	ETF	18.4001	18.4001	18.4001	18.4001	169.0
2014-10-31	BCM	ETF	35.798	35.798	35.798	35.798	546.0
2014-10-31	BFOR	ETF	7.81	7.855	7.7975	7.855	107600.0
2014-10-31	BIB	ETF	62.115	63.27	60.1	60.665	896962.0

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

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