PREVIEW / etf_daily / 2016-06-29

all etf daily files

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

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-29	SPY	ETF	204.84	206.93	204.72	206.66	137328600.0
2016-06-29	QQQ	ETF	105.26	106.53	105.231	106.31	31356723.0
2016-06-29	IWM	ETF	111.7	113.05	111.53	112.88	34031600.0
2016-06-29	DIA	ETF	175.16	176.82	175.0	176.64	5578200.0
2016-06-29	GLD	ETF	125.91	126.81	125.7	125.84	12218400.0
2016-06-29	TLT	ETF	139.68	140.13	138.26	138.39	12999800.0
2016-06-29	AADR	ETF	38.34	38.34	38.25	38.25	1700.0
2016-06-29	AAXJ	ETF	53.89	54.17	53.89	54.06	674200.0
2016-06-29	ACTX	ETF	4.13	4.72	4.13	4.72	182.0
2016-06-29	ACWF	ETF	22.383	22.52	22.383	22.52	1172.0
2016-06-29	ACWI	ETF	55.08	55.57	55.04	55.48	1732500.0
2016-06-29	ACWV	ETF	74.91	75.44	74.88	75.41	472700.0
2016-06-29	ACWX	ETF	38.24	38.56	38.24	38.49	704373.0
2016-06-29	ADRE	ETF	30.58	30.9499	30.58	30.87	10438.0
2016-06-29	AFK	ETF	19.44	19.98	19.2101	19.71	36313.0
2016-06-29	AFTY	ETF	12.417	12.419	12.417	12.419	700.0
2016-06-29	AGG	ETF	112.53	112.6	112.34	112.39	2745800.0
2016-06-29	AGGY	ETF	51.8	51.8	51.63	51.65	3200.0
2016-06-29	AGQ	ETF	44.91	45.82	44.57	45.06	401400.0
2016-06-29	AGZ	ETF	116.08	116.08	115.49	115.84	21097.0
2016-06-29	AGZD	ETF	23.835	23.845	23.77	23.805	8400.0
2016-06-29	AIA	ETF	43.85	44.0963	43.85	44.03	19711.0
2016-06-29	AIQ	ETF	6.5	6.51	6.1	6.11	45760.0
2016-06-29	AIRR	ETF	17.772	17.87	17.772	17.84	1900.0
2016-06-29	AIVI	ETF	36.84	37.17	36.8	37.0	28000.0
2016-06-29	ALTY	ETF	15.07	15.07	15.07	15.07	1600.0
2016-06-29	AMJ	ETF	31.4	31.89	31.4	31.71	2139004.0
2016-06-29	AMLP	ETF	63.65	64.15	63.35	63.7	2154760.0
2016-06-29	AMZA	ETF	115.7	116.03	114.1	115.1	25950.0
2016-06-29	ANGL	ETF	27.47	27.71	27.35	27.58	412000.0
2016-06-29	AOA	ETF	45.3	45.49	45.19	45.3	45500.0
2016-06-29	AOK	ETF	32.69	32.7799	32.63	32.64	41723.0
2016-06-29	AOM	ETF	35.18	35.21	34.9201	35.11	64371.0
2016-06-29	AOR	ETF	39.66	39.8	39.53	39.69	110572.0
2016-06-29	ARGT	ETF	21.81	22.2	21.74	22.05	44300.0
2016-06-29	ARKG	ETF	16.79	16.79	16.79	16.79	100.0
2016-06-29	ARKK	ETF	19.161	19.161	19.161	19.161	100.0
2016-06-29	ARKQ	ETF	18.858	18.996	18.858	18.996	1500.0
2016-06-29	ARKW	ETF	22.231	22.24	22.225	22.24	1000.0
2016-06-29	ASEA	ETF	13.53	13.59	13.53	13.59	1800.0
2016-06-29	ASHR	ETF	23.59	23.78	23.56	23.76	1068900.0
2016-06-29	ASHS	ETF	34.02	34.19	33.93	34.14	20000.0
2016-06-29	ATMP	ETF	21.69	22.18	21.69	22.1	10900.0
2016-06-29	BAB	ETF	31.52	31.5892	31.36	31.41	165568.0
2016-06-29	BAL	ETF	43.7	43.79	43.56	43.69	10477.0
2016-06-29	BBC	ETF	17.8	18.69	17.6783	18.1162	8151.0
2016-06-29	BBH	ETF	101.25	101.8	100.0	101.43	78300.0
2016-06-29	BBP	ETF	26.43	28.372	26.05	26.909	2900.0
2016-06-29	BCM	ETF	27.675	27.76	27.66	27.66	4463.0
2016-06-29	BFOR	ETF	7.3525	7.4875	7.3525	7.48	30800.0

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

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