PREVIEW / etf_daily / 2016-09-07

all etf daily files

  file:    by_date/etf_daily/2016/2016-09-07.parquet
  size:    52 KB
  rows:    1,303

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-09-07	SPY	ETF	218.84	219.22	218.3	219.01	76554900.0
2016-09-07	QQQ	ETF	117.95	118.12	117.47	117.92	17546872.0
2016-09-07	IWM	ETF	124.55	125.44	124.48	125.41	17830500.0
2016-09-07	DIA	ETF	185.37	185.4	184.78	185.32	1803600.0
2016-09-07	GLD	ETF	128.79	128.86	128.12	128.27	8859800.0
2016-09-07	TLT	ETF	140.37	140.42	139.54	139.54	5421800.0
2016-09-07	AADR	ETF	41.25	41.26	40.8	41.06	2000.0
2016-09-07	AAXJ	ETF	61.08	61.22	60.92	61.12	1400900.0
2016-09-07	ACTX	ETF	2.95	3.54	2.95	3.54	401.0
2016-09-07	ACWI	ETF	59.64	59.71	59.44	59.62	1831600.0
2016-09-07	ACWV	ETF	77.33	77.33	76.97	77.14	89600.0
2016-09-07	ACWX	ETF	42.17	42.21	42.005	42.06	1864456.0
2016-09-07	ADRE	ETF	35.52	35.52	35.3	35.3	4463.0
2016-09-07	AFK	ETF	20.98	21.0999	20.5	20.76	20108.0
2016-09-07	AFTY	ETF	13.79	13.79	13.71	13.71	4800.0
2016-09-07	AGG	ETF	112.76	112.76	112.59	112.61	1839600.0
2016-09-07	AGGY	ETF	52.3	52.44	52.215	52.245	27700.0
2016-09-07	AGQ	ETF	52.48	52.61	50.98	51.54	200300.0
2016-09-07	AGZ	ETF	115.51	115.8199	115.51	115.59	7603.0
2016-09-07	AGZD	ETF	23.915	23.915	23.915	23.915	200.0
2016-09-07	AIA	ETF	50.3	50.41	50.2505	50.37	11944.0
2016-09-07	AIQ	ETF	6.4	6.49	6.22	6.26	34493.0
2016-09-07	AIRR	ETF	20.12	20.138	20.06	20.138	1900.0
2016-09-07	AIVI	ETF	39.7	39.79	39.61	39.67	11200.0
2016-09-07	ALTY	ETF	15.94	15.97	15.886	15.97	4400.0
2016-09-07	AMJ	ETF	31.64	31.82	31.395	31.64	1645197.0
2016-09-07	AMLP	ETF	63.0	63.85	63.0	63.65	1361980.0
2016-09-07	AMZA	ETF	117.0	118.2	116.99	117.6	16000.0
2016-09-07	ANGL	ETF	28.65	28.75	28.64	28.66	118000.0
2016-09-07	AOA	ETF	47.85	47.98	47.8	47.86	42800.0
2016-09-07	AOK	ETF	33.5	33.5699	33.48	33.52	51898.0
2016-09-07	AOM	ETF	36.28	36.3194	36.1542	36.25	375256.0
2016-09-07	AOR	ETF	41.34	41.4599	41.34	41.41	45939.0
2016-09-07	ARGT	ETF	23.34	23.38	23.22	23.37	12700.0
2016-09-07	ARKG	ETF	18.985	18.985	18.97	18.97	500.0
2016-09-07	ARKK	ETF	21.26	21.277	21.26	21.277	200.0
2016-09-07	ARKQ	ETF	21.52	21.52	21.34	21.38	500.0
2016-09-07	ARKW	ETF	24.87	24.87	24.87	24.87	300.0
2016-09-07	ASEA	ETF	14.14	14.2	14.14	14.19	2100.0
2016-09-07	ASHR	ETF	25.36	25.37	25.25	25.25	442300.0
2016-09-07	ASHS	ETF	35.58	35.63	35.55	35.57	5100.0
2016-09-07	ATMP	ETF	23.15	23.45	22.7	23.36	48100.0
2016-09-07	BAB	ETF	31.82	31.82	31.69	31.69	114209.0
2016-09-07	BAL	ETF	45.88	46.109	45.7527	46.109	11070.0
2016-09-07	BBC	ETF	20.8355	20.8899	20.71	20.71	3319.0
2016-09-07	BBH	ETF	115.48	116.15	114.98	115.59	59900.0
2016-09-07	BBP	ETF	31.42	31.49	31.225	31.28	4300.0
2016-09-07	BCM	ETF	25.9	26.089	25.9	26.03	2797.0
2016-09-07	BFOR	ETF	8.1425	8.1775	8.1425	8.1775	42400.0
2016-09-07	BIB	ETF	47.0	47.94	46.88	47.59	554304.0

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

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