PREVIEW / etf_daily / 2014-11-03

all etf daily files

  file:    by_date/etf_daily/2014/2014-11-03.parquet
  size:    46 KB
  rows:    1,133

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-11-03	SPY	ETF	201.92	202.45	201.31	201.77	93600000.0
2014-11-03	QQQ	ETF	101.53	101.9701	101.43	101.7	33480951.0
2014-11-03	IWM	ETF	116.75	117.37	115.9	116.36	39729600.0
2014-11-03	DIA	ETF	173.57	173.78	173.05	173.36	5383200.0
2014-11-03	GLD	ETF	112.39	112.68	112.0	112.15	6589800.0
2014-11-03	TLT	ETF	118.9	119.16	118.21	118.96	9726600.0
2014-11-03	AAXJ	ETF	62.74	62.74	62.38	62.51	683600.0
2014-11-03	ACWI	ETF	59.42	59.5	59.24	59.36	1308300.0
2014-11-03	ACWV	ETF	68.88	69.19	68.88	69.06	271600.0
2014-11-03	ACWX	ETF	45.15	45.15	44.89	45.01	568494.0
2014-11-03	ADRE	ETF	39.5	39.5	39.13	39.25	43304.0
2014-11-03	AFK	ETF	29.46	29.73	29.46	29.64	8172.0
2014-11-03	AGG	ETF	109.83	109.85	109.56	109.68	2282400.0
2014-11-03	AGQ	ETF	40.65	41.5	40.29	41.14	180000.0
2014-11-03	AGZ	ETF	112.89	112.921	112.4201	112.921	12390.0
2014-11-03	AGZD	ETF	24.765	24.8	24.76	24.76	13000.0
2014-11-03	AIA	ETF	47.87	47.886	47.605	47.7	15446.0
2014-11-03	AIQ	ETF	24.32	24.82	24.04	24.64	25303.0
2014-11-03	AIRR	ETF	19.14	19.26	19.03	19.07	31500.0
2014-11-03	AIVI	ETF	45.76	45.81	45.5	45.66	25000.0
2014-11-03	ALTL	ETF	36.2399	36.2399	36.2399	36.2399	330.0
2014-11-03	AMJ	ETF	50.56	51.26	50.41	50.93	1770099.0
2014-11-03	AMLP	ETF	94.7	94.7	92.8	92.8	1041740.0
2014-11-03	AMZA	ETF	244.99	245.0	242.1	243.9	150.0
2014-11-03	ANGL	ETF	27.48	27.48	27.48	27.48	600.0
2014-11-03	AOA	ETF	46.45	46.48	46.31	46.33	63400.0
2014-11-03	AOK	ETF	32.71	32.7599	32.7	32.72	36197.0
2014-11-03	AOM	ETF	35.23	35.31	35.22	35.25	75495.0
2014-11-03	AOR	ETF	40.13	40.13	40.02	40.02	74531.0
2014-11-03	ARGT	ETF	21.11	21.38	21.03	21.27	41100.0
2014-11-03	ARKG	ETF	20.21	20.21	20.06	20.07	4000.0
2014-11-03	ARKK	ETF	20.49	20.49	20.35	20.38	2300.0
2014-11-03	ARKQ	ETF	20.03	20.11	19.98	19.98	4000.0
2014-11-03	ARKW	ETF	20.44	20.53	20.4	20.4	2200.0
2014-11-03	ASEA	ETF	16.82	16.82	16.77	16.79	2000.0
2014-11-03	ASHR	ETF	26.56	26.61	26.43	26.54	808900.0
2014-11-03	ASHS	ETF	34.39	34.4	34.27	34.34	8300.0
2014-11-03	ATMP	ETF	31.55	31.85	31.38	31.5	25200.0
2014-11-03	AVIV	ETF	33.51	34.38	33.51	33.82	1066649.0
2014-11-03	AWAY	ETF	34.99	35.245	34.65	34.86	1341009.0
2014-11-03	BAB	ETF	29.77	29.88	29.68	29.84	226583.0
2014-11-03	BAL	ETF	42.83	43.45	42.8	43.14	32436.0
2014-11-03	BALT	ETF	3.78	4.09	3.77	3.96	1539331.0
2014-11-03	BAR	ETF	2.7	2.707	2.698	2.7	15080.0
2014-11-03	BBH	ETF	116.26	117.14	115.53	116.22	215900.0
2014-11-03	BCM	ETF	35.9	35.934	35.72	35.73	3286.0
2014-11-03	BFOR	ETF	7.875	7.8975	7.825	7.825	71600.0
2014-11-03	BIB	ETF	60.615	61.6345	59.9	60.58	509234.0
2014-11-03	BICK	ETF	25.04	25.04	25.04	25.04	320.0
2014-11-03	BIL	ETF	91.5	91.5	91.48	91.48	9501200.0

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

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