PREVIEW / etf_daily / 2016-06-30

all etf daily files

  file:    by_date/etf_daily/2016/2016-06-30.parquet
  size:    52 KB
  rows:    1,299

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-30	SPY	ETF	207.21	209.54	206.56	209.48	165021900.0
2016-06-30	QQQ	ETF	106.52	107.61	106.13	107.54	36300819.0
2016-06-30	IWM	ETF	113.12	115.02	112.57	114.98	42973800.0
2016-06-30	DIA	ETF	177.05	179.08	176.86	179.0	5069000.0
2016-06-30	GLD	ETF	125.95	126.52	125.5	126.47	15981600.0
2016-06-30	TLT	ETF	138.81	139.94	138.09	138.9	14698500.0
2016-06-30	AADR	ETF	39.27	39.27	38.98	38.98	1000.0
2016-06-30	AAXJ	ETF	54.41	54.79	54.23	54.68	666700.0
2016-06-30	ACTX	ETF	4.72	4.72	4.602	4.72	7.0
2016-06-30	ACWF	ETF	22.49	22.606	22.49	22.605	15094.0
2016-06-30	ACWI	ETF	55.67	56.24	55.47	56.23	3949600.0
2016-06-30	ACWV	ETF	75.5	76.48	75.4	76.37	368400.0
2016-06-30	ACWX	ETF	38.59	38.99	38.47	38.96	786244.0
2016-06-30	ADRE	ETF	30.97	31.2763	30.97	31.27	3872.0
2016-06-30	AFK	ETF	20.06	20.13	19.8	20.06	22660.0
2016-06-30	AFTY	ETF	12.36	12.36	12.36	12.36	600.0
2016-06-30	AGG	ETF	112.51	112.69	112.4	112.62	4154300.0
2016-06-30	AGGY	ETF	51.836	51.91	51.739	51.839	2700.0
2016-06-30	AGQ	ETF	45.61	47.79	45.52	47.67	344600.0
2016-06-30	AGZ	ETF	115.49	115.88	115.49	115.88	31769.0
2016-06-30	AGZD	ETF	23.79	23.79	23.785	23.785	133400.0
2016-06-30	AIA	ETF	44.42	44.71	44.38	44.66	27596.0
2016-06-30	AIQ	ETF	6.16	6.3	6.025	6.24	20994.0
2016-06-30	AIRR	ETF	18.295	18.295	18.295	18.295	300.0
2016-06-30	AIVI	ETF	37.33	37.84	37.23	37.82	28100.0
2016-06-30	ALTY	ETF	15.08	15.15	15.02	15.02	4800.0
2016-06-30	AMJ	ETF	31.85	31.94	31.27	31.81	2461689.0
2016-06-30	AMLP	ETF	63.95	64.2	62.85	63.6	2788600.0
2016-06-30	AMZA	ETF	115.1	116.5	112.9	115.6	38960.0
2016-06-30	ANGL	ETF	27.62	27.9	27.57	27.85	555400.0
2016-06-30	AOA	ETF	45.5	45.93	45.41	45.87	30900.0
2016-06-30	AOK	ETF	32.71	32.9	32.6655	32.8101	43154.0
2016-06-30	AOM	ETF	35.22	35.38	35.15	35.3	61952.0
2016-06-30	AOR	ETF	39.8	40.0499	39.7507	40.03	97050.0
2016-06-30	ARGT	ETF	22.11	22.31	22.02	22.3	447800.0
2016-06-30	ARKG	ETF	16.71	16.85	16.71	16.85	1600.0
2016-06-30	ARKK	ETF	19.17	19.29	19.17	19.29	500.0
2016-06-30	ARKQ	ETF	19.21	19.21	19.21	19.21	100.0
2016-06-30	ARKW	ETF	22.44	22.44	22.34	22.34	500.0
2016-06-30	ASEA	ETF	13.6	13.69	13.58	13.66	10400.0
2016-06-30	ASHR	ETF	23.7	23.76	23.6	23.76	659300.0
2016-06-30	ASHS	ETF	34.0	34.12	33.81	34.11	17900.0
2016-06-30	ATMP	ETF	21.95	22.21	21.95	22.19	29900.0
2016-06-30	BAB	ETF	31.53	31.56	31.4286	31.49	279188.0
2016-06-30	BAL	ETF	43.8199	43.8248	42.496	42.5152	6961.0
2016-06-30	BBC	ETF	17.9	18.19	17.9	18.0	5132.0
2016-06-30	BBH	ETF	101.64	102.46	100.6	102.34	54500.0
2016-06-30	BBP	ETF	26.87	27.14	26.5	26.969	16900.0
2016-06-30	BCM	ETF	27.53	27.64	27.47	27.6127	10900.0
2016-06-30	BFIT	ETF	15.1499	15.1499	15.1499	15.1499	650.0

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

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