PREVIEW / etf_daily / 2015-12-29

all etf daily files

  file:    by_date/etf_daily/2015/2015-12-29.parquet
  size:    50 KB
  rows:    1,234

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
2015-12-29	SPY	ETF	206.51	207.79	206.47	207.4	92640700.0
2015-12-29	QQQ	ETF	113.215	114.545	113.13	114.3	27725673.0
2015-12-29	IWM	ETF	114.48	115.29	114.07	115.2	22841500.0
2015-12-29	DIA	ETF	176.19	177.25	176.0	176.98	6145700.0
2015-12-29	GLD	ETF	102.52	102.58	102.11	102.2	2832200.0
2015-12-29	TLT	ETF	121.69	121.74	120.01	120.16	7787500.0
2015-12-29	AADR	ETF	38.96	39.29	38.96	39.08	800.0
2015-12-29	AAXJ	ETF	54.27	54.27	54.03	54.14	697800.0
2015-12-29	ACTX	ETF	7.0801	7.6701	6.9621	7.0801	370.0
2015-12-29	ACWF	ETF	23.62	23.72	23.62	23.63	953.0
2015-12-29	ACWI	ETF	56.69	56.87	56.62	56.79	3612400.0
2015-12-29	ACWV	ETF	70.14	70.29	70.06	70.18	394400.0
2015-12-29	ACWX	ETF	40.32	40.43	40.22	40.37	1573725.0
2015-12-29	ADRE	ETF	29.68	29.83	29.63	29.7	25995.0
2015-12-29	AFK	ETF	17.96	17.996	17.76	17.77	37801.0
2015-12-29	AFTY	ETF	14.44	14.44	14.325	14.355	30400.0
2015-12-29	AGG	ETF	107.92	107.98	107.62	107.74	3094500.0
2015-12-29	AGQ	ETF	27.81	27.94	27.43	27.48	122800.0
2015-12-29	AGZ	ETF	112.861	113.03	112.6101	112.65	11953.0
2015-12-29	AGZD	ETF	23.93	24.075	23.93	24.075	3000.0
2015-12-29	AIA	ETF	42.89	42.93	42.756	42.79	53974.0
2015-12-29	AIQ	ETF	8.97	9.2	8.97	9.12	27904.0
2015-12-29	AIRR	ETF	16.791	16.89	16.74	16.87	76000.0
2015-12-29	AIVI	ETF	38.76	38.91	38.66	38.84	70100.0
2015-12-29	ALTY	ETF	13.812	13.85	13.812	13.85	1300.0
2015-12-29	AMJ	ETF	28.73	29.0	27.87	28.16	4431366.0
2015-12-29	AMLP	ETF	59.35	59.9	57.5	58.0	3960700.0
2015-12-29	AMZA	ETF	108.1	110.0	106.3	107.5	1640.0
2015-12-29	ANGL	ETF	24.24	24.52	24.24	24.4	79900.0
2015-12-29	AOA	ETF	45.45	45.57	45.39	45.48	247200.0
2015-12-29	AOK	ETF	31.8	31.81	31.6501	31.79	87001.0
2015-12-29	AOM	ETF	34.4	34.4	34.24	34.27	452227.0
2015-12-29	AOR	ETF	39.21	39.28	39.17	39.24	917007.0
2015-12-29	ARGT	ETF	18.3	18.3	18.11	18.21	7000.0
2015-12-29	ARKG	ETF	20.97	21.035	20.97	21.02	3000.0
2015-12-29	ARKK	ETF	20.78	20.78	20.78	20.78	300.0
2015-12-29	ARKQ	ETF	19.51	19.56	19.51	19.56	200.0
2015-12-29	ARKW	ETF	23.34	23.55	23.28	23.547	3700.0
2015-12-29	ASEA	ETF	12.18	12.31	12.17	12.29	3400.0
2015-12-29	ASET	ETF	24.62	24.62	24.57	24.57	4480.0
2015-12-29	ASHR	ETF	28.44	28.51	28.33	28.41	1053200.0
2015-12-29	ASHS	ETF	42.6	42.6	41.98	42.23	106900.0
2015-12-29	ASHX	ETF	25.38	25.75	25.38	25.75	1095.0
2015-12-29	ATMP	ETF	18.78	18.95	18.29	18.39	282800.0
2015-12-29	BAB	ETF	29.01	29.01	28.85	28.88	246843.0
2015-12-29	BAL	ETF	42.6	42.67	42.52	42.52	1155.0
2015-12-29	BBC	ETF	28.9	29.5299	28.86	29.5299	17932.0
2015-12-29	BBH	ETF	127.12	128.54	127.1	128.29	132800.0
2015-12-29	BBP	ETF	30.991	31.266	30.99	31.2	8200.0
2015-12-29	BCM	ETF	23.801	23.82	23.79	23.81	1619.0

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

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