PREVIEW / etf_daily / 2016-08-03

all etf daily files

  file:    by_date/etf_daily/2016/2016-08-03.parquet
  size:    51 KB
  rows:    1,284

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-08-03	SPY	ETF	215.48	216.25	215.13	216.18	53993600.0
2016-08-03	QQQ	ETF	114.88	115.35	114.8005	115.34	15011273.0
2016-08-03	IWM	ETF	119.37	120.5	119.1	120.45	17830300.0
2016-08-03	DIA	ETF	182.85	183.43	182.71	183.36	3008200.0
2016-08-03	GLD	ETF	129.95	129.96	129.27	129.65	5010700.0
2016-08-03	TLT	ETF	138.6	138.78	137.91	138.41	4930600.0
2016-08-03	AADR	ETF	40.61	40.61	40.58	40.58	600.0
2016-08-03	AAXJ	ETF	56.88	57.36	56.81	57.34	1086300.0
2016-08-03	ACTX	ETF	4.13	4.13	3.54	3.835	1140.0
2016-08-03	ACWF	ETF	23.3301	23.509	23.3301	23.509	981.0
2016-08-03	ACWI	ETF	57.59	57.88	57.53	57.86	1272600.0
2016-08-03	ACWV	ETF	77.48	77.48	77.18	77.33	675400.0
2016-08-03	ACWX	ETF	39.89	40.12	39.81	40.11	695867.0
2016-08-03	ADRE	ETF	32.52	32.75	32.52	32.75	2911.0
2016-08-03	AFK	ETF	20.5	20.9999	20.382	20.87	19155.0
2016-08-03	AGG	ETF	112.31	112.36	112.1	112.34	3777800.0
2016-08-03	AGGY	ETF	51.825	51.93	51.825	51.92	9600.0
2016-08-03	AGQ	ETF	56.29	56.38	55.27	55.48	188500.0
2016-08-03	AGZ	ETF	115.52	115.65	115.501	115.621	36847.0
2016-08-03	AIA	ETF	46.58	46.872	46.49	46.84	11735.0
2016-08-03	AIQ	ETF	5.78	5.84	5.73	5.79	10111.0
2016-08-03	AIRR	ETF	19.03	19.16	19.02	19.1	22400.0
2016-08-03	AIVI	ETF	37.95	38.18	37.92	38.11	19300.0
2016-08-03	ALTY	ETF	15.43	15.49	15.391	15.47	1100.0
2016-08-03	AMJ	ETF	31.08	31.77	31.02	31.76	4085208.0
2016-08-03	AMLP	ETF	63.35	64.25	63.15	64.2	1450880.0
2016-08-03	AMZA	ETF	109.2	113.5	109.2	112.6	15550.0
2016-08-03	ANGL	ETF	27.85	27.97	27.85	27.95	84200.0
2016-08-03	AOA	ETF	46.56	46.69	46.51	46.69	60500.0
2016-08-03	AOK	ETF	33.09	33.11	33.0473	33.11	47609.0
2016-08-03	AOM	ETF	35.63	35.69	35.561	35.69	43701.0
2016-08-03	AOR	ETF	40.37	40.52	40.37	40.5	38392.0
2016-08-03	ARGT	ETF	22.17	22.4	22.17	22.31	12700.0
2016-08-03	ARKG	ETF	18.98	18.98	18.97	18.97	400.0
2016-08-03	ARKK	ETF	20.43	20.43	20.43	20.43	100.0
2016-08-03	ARKQ	ETF	20.59	20.67	20.59	20.64	1000.0
2016-08-03	ARKW	ETF	24.06	24.06	24.025	24.025	1400.0
2016-08-03	ASHR	ETF	24.08	24.17	24.06	24.17	571600.0
2016-08-03	ASHS	ETF	34.01	34.1	34.01	34.06	10400.0
2016-08-03	ATMP	ETF	22.47	22.97	22.2	22.66	116800.0
2016-08-03	BAB	ETF	31.58	31.61	31.5211	31.58	458000.0
2016-08-03	BAL	ETF	49.23	49.63	49.23	49.63	6748.0
2016-08-03	BBC	ETF	20.01	20.6999	19.9499	20.65	5146.0
2016-08-03	BBH	ETF	117.55	118.25	116.96	118.07	84300.0
2016-08-03	BBP	ETF	30.87	31.329	30.87	31.329	6300.0
2016-08-03	BCM	ETF	25.38	25.69	25.38	25.68	45760.0
2016-08-03	BFOR	ETF	7.8875	7.94	7.8875	7.93	71600.0
2016-08-03	BIB	ETF	50.45	51.97	50.08	51.82	758639.0
2016-08-03	BICK	ETF	21.8248	21.8248	21.8248	21.8248	175.0
2016-08-03	BIL	ETF	91.42	91.44	91.42	91.42	658950.0

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

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