PREVIEW / etf_daily / 2016-06-06

all etf daily files

  file:    by_date/etf_daily/2016/2016-06-06.parquet
  size:    51 KB
  rows:    1,290

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-06-06	SPY	ETF	210.7	211.77	210.51	211.35	64887000.0
2016-06-06	QQQ	ETF	110.25	110.75	110.07	110.46	12502365.0
2016-06-06	IWM	ETF	116.08	117.58	116.01	117.22	26946000.0
2016-06-06	DIA	ETF	178.49	179.46	178.41	179.18	2720300.0
2016-06-06	GLD	ETF	118.89	119.17	118.46	118.92	9887900.0
2016-06-06	TLT	ETF	132.78	132.89	132.1	132.24	7573700.0
2016-06-06	AADR	ETF	38.66	39.57	38.66	39.57	400.0
2016-06-06	AAXJ	ETF	54.3	54.82	54.3	54.7	814200.0
2016-06-06	ACTX	ETF	4.13	4.72	4.13	4.13	902.0
2016-06-06	ACWF	ETF	23.43	23.485	23.43	23.48	1297.0
2016-06-06	ACWI	ETF	57.47	57.8	57.47	57.69	982200.0
2016-06-06	ACWV	ETF	74.92	75.08	74.7	74.95	97500.0
2016-06-06	ACWX	ETF	40.54	40.78	40.54	40.69	341288.0
2016-06-06	ADRE	ETF	30.75	30.9432	30.75	30.914	2287.0
2016-06-06	AFK	ETF	20.7	21.1405	20.6999	20.95	63588.0
2016-06-06	AFTY	ETF	12.64	12.66	12.64	12.66	600.0
2016-06-06	AGG	ETF	111.17	111.23	111.07	111.15	3278900.0
2016-06-06	AGGY	ETF	51.18	51.218	51.02	51.17	3000.0
2016-06-06	AGNG	ETF	16.04	16.04	16.04	16.04	700.0
2016-06-06	AGQ	ETF	36.81	37.01	36.48	36.94	272800.0
2016-06-06	AGZ	ETF	115.01	115.19	114.8299	115.03	21200.0
2016-06-06	AGZD	ETF	23.95	23.95	23.885	23.885	9200.0
2016-06-06	AIA	ETF	44.0	44.2769	44.0	44.19	36585.0
2016-06-06	AIQ	ETF	6.8	6.975	6.78	6.81	18842.0
2016-06-06	AIRR	ETF	18.312	18.5	18.3	18.5	13600.0
2016-06-06	AIVI	ETF	38.89	39.1	38.85	39.06	22800.0
2016-06-06	ALTY	ETF	14.71	14.71	14.71	14.71	1300.0
2016-06-06	AMJ	ETF	31.36	31.76	31.21	31.69	1455460.0
2016-06-06	AMLP	ETF	63.7	64.0	63.1	63.85	1392760.0
2016-06-06	AMZA	ETF	114.7	117.28	113.8	116.7	20290.0
2016-06-06	ANGL	ETF	27.1	27.11	26.93	27.06	141200.0
2016-06-06	AOA	ETF	46.12	46.41	46.12	46.3	35700.0
2016-06-06	AOK	ETF	32.77	32.77	32.64	32.72	44251.0
2016-06-06	AOM	ETF	35.21	35.3399	35.1886	35.3	212332.0
2016-06-06	AOR	ETF	40.03	40.2199	40.0001	40.14	93854.0
2016-06-06	ARGT	ETF	21.41	21.69	21.4	21.57	35200.0
2016-06-06	ARKG	ETF	18.455	18.455	18.38	18.38	900.0
2016-06-06	ARKK	ETF	19.71	19.92	19.71	19.92	2900.0
2016-06-06	ARKQ	ETF	19.65	19.65	19.65	19.65	200.0
2016-06-06	ARKW	ETF	22.2	22.2	22.2	22.2	500.0
2016-06-06	ASEA	ETF	13.2	13.41	13.2	13.41	3100.0
2016-06-06	ASHR	ETF	24.05	24.27	24.05	24.2	1048700.0
2016-06-06	ASHS	ETF	33.94	34.12	33.9	34.06	53300.0
2016-06-06	ATMP	ETF	21.63	21.94	21.6	21.84	21200.0
2016-06-06	BAB	ETF	32.33	32.33	30.83	30.89	117850.0
2016-06-06	BAL	ETF	43.35	43.7476	43.18	43.45	65032.0
2016-06-06	BBC	ETF	21.13	21.64	21.13	21.5001	6248.0
2016-06-06	BBH	ETF	111.18	112.45	109.99	112.12	67300.0
2016-06-06	BBP	ETF	28.45	28.74	28.325	28.658	6100.0
2016-06-06	BCM	ETF	27.28	27.29	27.1951	27.28	9001.0

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

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