PREVIEW / etf_daily / 2016-07-05

all etf daily files

  file:    by_date/etf_daily/2016/2016-07-05.parquet
  size:    51 KB
  rows:    1,283

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-07-05	SPY	ETF	208.95	209.08	207.71	208.41	109803700.0
2016-07-05	QQQ	ETF	107.58	107.66	106.84	107.42	21167903.0
2016-07-05	IWM	ETF	115.02	115.26	113.07	113.69	29347200.0
2016-07-05	DIA	ETF	178.58	178.68	177.66	178.21	3233100.0
2016-07-05	GLD	ETF	128.8	129.59	128.17	129.47	19026200.0
2016-07-05	TLT	ETF	141.85	142.91	141.7	142.33	8840800.0
2016-07-05	AADR	ETF	39.14	39.14	38.81	38.93	1500.0
2016-07-05	AAXJ	ETF	54.5	54.6	54.25	54.4	1530900.0
2016-07-05	ACTX	ETF	4.72	4.72	3.54	4.012	562.0
2016-07-05	ACWI	ETF	55.88	55.94	55.48	55.65	1358900.0
2016-07-05	ACWV	ETF	76.6	76.8	76.52	76.67	444300.0
2016-07-05	ACWX	ETF	38.63	38.68	38.29	38.38	349688.0
2016-07-05	ADRE	ETF	31.19	31.19	30.85	31.0	8654.0
2016-07-05	AFK	ETF	20.1032	20.3799	20.0	20.0101	3729.0
2016-07-05	AFTY	ETF	12.56	12.56	12.47	12.49	2300.0
2016-07-05	AGG	ETF	113.03	113.12	112.87	112.95	4740000.0
2016-07-05	AGGY	ETF	52.2	52.27	52.11	52.25	9700.0
2016-07-05	AGQ	ETF	52.99	54.12	51.92	53.45	823100.0
2016-07-05	AGZ	ETF	115.9	116.082	115.9	115.9793	37786.0
2016-07-05	AGZD	ETF	23.805	23.805	23.805	23.805	400.0
2016-07-05	AIA	ETF	44.48	44.48	44.22	44.39	19229.0
2016-07-05	AIQ	ETF	6.3	6.58	5.99	6.01	16364.0
2016-07-05	AIRR	ETF	18.22	18.22	18.1	18.18	1900.0
2016-07-05	AIVI	ETF	37.35	37.51	37.01	37.17	14700.0
2016-07-05	ALTY	ETF	15.33	15.33	15.33	15.33	600.0
2016-07-05	AMJ	ETF	31.03	31.39	30.84	31.31	2238765.0
2016-07-05	AMLP	ETF	63.2	63.6	62.5	63.45	981580.0
2016-07-05	AMZA	ETF	109.0	109.0	105.3	108.0	27240.0
2016-07-05	ANGL	ETF	27.63	27.65	27.45	27.6	322900.0
2016-07-05	AOA	ETF	45.97	45.97	45.4	45.64	29400.0
2016-07-05	AOK	ETF	32.8	32.9699	32.717	32.94	16797.0
2016-07-05	AOM	ETF	35.05	35.5	35.05	35.35	108759.0
2016-07-05	AOR	ETF	39.99	40.0	39.76	39.89	66639.0
2016-07-05	ARGT	ETF	22.46	22.48	22.12	22.34	53400.0
2016-07-05	ARKG	ETF	17.3	17.3	17.05	17.08	2500.0
2016-07-05	ARKK	ETF	19.21	19.3	19.21	19.248	700.0
2016-07-05	ARKQ	ETF	19.43	19.43	19.43	19.43	100.0
2016-07-05	ARKW	ETF	22.23	22.23	22.23	22.23	500.0
2016-07-05	ASET	ETF	26.57	26.6	26.57	26.6	300.0
2016-07-05	ASHR	ETF	23.75	23.95	23.75	23.84	1029300.0
2016-07-05	ASHS	ETF	34.12	34.44	34.12	34.3	30100.0
2016-07-05	ASHX	ETF	21.86	21.86	21.86	21.86	346.0
2016-07-05	ATMP	ETF	21.62	21.83	21.5	21.83	132800.0
2016-07-05	BAB	ETF	31.63	31.9099	31.615	31.77	215720.0
2016-07-05	BAL	ETF	43.3368	43.3956	42.6	43.3956	10304.0
2016-07-05	BBC	ETF	18.33	18.5	18.2008	18.5	7848.0
2016-07-05	BBH	ETF	102.84	104.13	102.83	103.58	61400.0
2016-07-05	BBP	ETF	27.37	27.66	27.35	27.647	4300.0
2016-07-05	BCM	ETF	27.1059	27.25	27.07	27.215	43205.0
2016-07-05	BFOR	ETF	7.585	7.585	7.48	7.53	60000.0

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

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