PREVIEW / etf_daily / 2016-04-13

all etf daily files

  file:    by_date/etf_daily/2016/2016-04-13.parquet
  size:    50 KB
  rows:    1,263

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-04-13	SPY	ETF	207.0	208.1	206.84	208.0	96336400.0
2016-04-13	QQQ	ETF	110.32	111.08	110.21	110.91	25356728.0
2016-04-13	IWM	ETF	110.58	112.43	110.51	112.31	40534700.0
2016-04-13	DIA	ETF	178.0	179.02	177.92	178.92	5400200.0
2016-04-13	GLD	ETF	119.37	119.43	118.56	118.77	8841500.0
2016-04-13	TLT	ETF	130.69	131.58	130.52	131.39	5207900.0
2016-04-13	AADR	ETF	39.12	39.12	38.89	38.98	5500.0
2016-04-13	AAXJ	ETF	55.4	55.57	55.28	55.56	724000.0
2016-04-13	ACTX	ETF	7.0801	7.0801	5.31	5.9001	266.0
2016-04-13	ACWF	ETF	23.3746	23.3746	23.3746	23.3746	210.0
2016-04-13	ACWI	ETF	56.67	56.97	56.66	56.91	1669700.0
2016-04-13	ACWV	ETF	74.26	74.34	73.95	74.12	194700.0
2016-04-13	ACWX	ETF	40.27	40.38	40.16	40.33	361254.0
2016-04-13	ADRE	ETF	31.82	31.99	31.79	31.99	7180.0
2016-04-13	AFK	ETF	19.64	19.77	19.56	19.5601	71266.0
2016-04-13	AFTY	ETF	13.09	13.12	13.05	13.07	56400.0
2016-04-13	AGG	ETF	110.74	110.92	110.68	110.83	1769000.0
2016-04-13	AGGY	ETF	50.67	50.77	50.64	50.745	8500.0
2016-04-13	AGQ	ETF	36.46	36.71	35.64	36.09	297400.0
2016-04-13	AGZ	ETF	114.61	114.7	114.47	114.6295	63568.0
2016-04-13	AGZD	ETF	23.825	23.9	23.75	23.785	13000.0
2016-04-13	AIA	ETF	43.95	43.97	43.85	43.923	22138.0
2016-04-13	AIQ	ETF	7.01	7.08	6.9	7.01	8968.0
2016-04-13	AIRR	ETF	17.6	17.9	17.6	17.9	1400.0
2016-04-13	AIVI	ETF	38.85	38.94	38.74	38.87	32900.0
2016-04-13	ALTY	ETF	14.489	14.51	14.405	14.44	1600.0
2016-04-13	AMJ	ETF	27.94	28.066	27.56	27.84	1497762.0
2016-04-13	AMLP	ETF	56.75	57.0	55.9	56.45	2230520.0
2016-04-13	AMZA	ETF	92.9	93.15	91.0	92.6	6920.0
2016-04-13	ANGL	ETF	26.08	26.23	26.01	26.16	45600.0
2016-04-13	AOA	ETF	45.51	45.78	45.51	45.7	58200.0
2016-04-13	AOK	ETF	32.4	32.46	32.3501	32.46	132195.0
2016-04-13	AOM	ETF	34.93	34.95	34.7701	34.95	97523.0
2016-04-13	AOR	ETF	39.56	39.7299	39.5236	39.6835	50045.0
2016-04-13	ARGT	ETF	19.75	20.11	19.65	20.02	68600.0
2016-04-13	ARKG	ETF	18.499	18.63	18.478	18.63	1400.0
2016-04-13	ARKK	ETF	19.81	19.81	19.81	19.81	100.0
2016-04-13	ARKW	ETF	21.0	21.099	21.0	21.099	300.0
2016-04-13	ASEA	ETF	13.48	13.65	13.39	13.54	12400.0
2016-04-13	ASHR	ETF	25.12	25.3	25.1	25.19	4077500.0
2016-04-13	ASHS	ETF	35.98	36.3	35.98	36.18	83900.0
2016-04-13	ASHX	ETF	22.4001	22.4001	22.4001	22.4001	471.0
2016-04-13	ATMP	ETF	18.92	19.01	18.83	18.96	60400.0
2016-04-13	BAB	ETF	30.23	30.3899	30.161	30.36	80448.0
2016-04-13	BAL	ETF	40.81	40.89	40.4932	40.68	13711.0
2016-04-13	BBC	ETF	20.74	21.08	20.65	21.0458	39240.0
2016-04-13	BBH	ETF	109.79	111.1	109.29	110.81	64200.0
2016-04-13	BBP	ETF	26.12	26.62	25.87	26.59	4400.0
2016-04-13	BFOR	ETF	7.5275	7.66	7.5275	7.655	148000.0
2016-04-13	BIB	ETF	46.31	47.5	45.78	47.31	1123243.0

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

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