PREVIEW / etf_daily / 2016-10-13

all etf daily files

  file:    by_date/etf_daily/2016/2016-10-13.parquet
  size:    52 KB
  rows:    1,318

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
2016-10-13	SPY	ETF	212.16	213.59	211.21	213.01	101357000.0
2016-10-13	QQQ	ETF	116.635	117.32	115.94	117.0	22821011.0
2016-10-13	IWM	ETF	120.99	121.41	120.11	120.92	26302500.0
2016-10-13	DIA	ETF	180.13	181.22	179.43	180.84	3460100.0
2016-10-13	GLD	ETF	120.0	120.42	119.8	120.03	7184600.0
2016-10-13	TLT	ETF	133.64	133.93	133.37	133.46	7080600.0
2016-10-13	AADR	ETF	39.86	39.99	39.86	39.99	1700.0
2016-10-13	AAXJ	ETF	58.75	59.22	58.41	59.06	654300.0
2016-10-13	ACTX	ETF	10.0301	12.9801	8.8501	12.3901	6209.0
2016-10-13	ACWF	ETF	23.6	23.6299	23.6	23.6299	350.0
2016-10-13	ACWI	ETF	57.7	58.13	57.44	57.97	1647300.0
2016-10-13	ACWV	ETF	73.8	74.4	73.75	74.24	195400.0
2016-10-13	ACWX	ETF	40.27	40.63	40.1	40.55	303614.0
2016-10-13	ADRE	ETF	34.55	35.0	34.54	35.0	3298.0
2016-10-13	AFK	ETF	20.08	20.0988	19.88	19.92	9843.0
2016-10-13	AFTY	ETF	13.4	13.4	13.4	13.4	300.0
2016-10-13	AGG	ETF	111.6	111.68	111.53	111.56	1964600.0
2016-10-13	AGGY	ETF	51.61	51.74	51.61	51.69	27500.0
2016-10-13	AGQ	ETF	39.89	40.03	39.41	39.85	374000.0
2016-10-13	AGZ	ETF	114.98	115.296	114.89	114.97	22292.0
2016-10-13	AIA	ETF	48.75	49.03	48.3967	48.95	120142.0
2016-10-13	AIQ	ETF	7.34	7.59	7.11	7.49	12972.0
2016-10-13	AIRR	ETF	19.95	19.95	19.79	19.85	15200.0
2016-10-13	AIVI	ETF	37.42	37.8	37.34	37.72	11600.0
2016-10-13	ALTY	ETF	15.15	15.25	15.15	15.235	1600.0
2016-10-13	AMJ	ETF	30.87	31.13	30.7	31.03	959887.0
2016-10-13	AMLP	ETF	62.55	62.95	62.3	62.8	952920.0
2016-10-13	AMZA	ETF	107.7	108.0	106.1	107.8	17040.0
2016-10-13	ANGL	ETF	28.96	29.06	28.9	29.03	76800.0
2016-10-13	AOA	ETF	46.38	46.67	46.18	46.57	48500.0
2016-10-13	AOK	ETF	32.86	32.96	32.822	32.9512	31419.0
2016-10-13	AOM	ETF	35.38	35.57	35.3139	35.46	45459.0
2016-10-13	AOR	ETF	40.3	40.4399	40.1301	40.38	114736.0
2016-10-13	ARGT	ETF	23.75	23.93	23.66	23.74	30200.0
2016-10-13	ARKG	ETF	17.86	18.009	17.86	18.009	900.0
2016-10-13	ARKK	ETF	20.589	20.589	20.589	20.589	100.0
2016-10-13	ARKQ	ETF	21.19	21.38	21.19	21.38	700.0
2016-10-13	ARKW	ETF	24.53	24.67	24.33	24.67	1900.0
2016-10-13	ASEA	ETF	13.39	13.39	13.39	13.39	200.0
2016-10-13	ASHR	ETF	24.58	24.63	24.48	24.55	567100.0
2016-10-13	ASHS	ETF	34.97	35.1	34.97	35.09	2500.0
2016-10-13	ATMP	ETF	22.59	22.98	22.59	22.84	12200.0
2016-10-13	BAB	ETF	31.06	31.09	30.955	30.97	140070.0
2016-10-13	BAL	ETF	45.56	46.3	45.56	45.93	2136.0
2016-10-13	BBC	ETF	20.4	20.9431	20.01	20.815	22850.0
2016-10-13	BBH	ETF	106.44	108.34	106.26	107.63	120500.0
2016-10-13	BBP	ETF	30.99	31.695	30.99	31.58	7700.0
2016-10-13	BFIT	ETF	15.263	15.263	15.263	15.263	152.0
2016-10-13	BFOR	ETF	7.9525	7.9525	7.88	7.9175	16400.0
2016-10-13	BIB	ETF	41.38	42.9999	41.34	42.44	854585.0

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

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