PREVIEW / etf_daily / 2017-01-12

all etf daily files

  file:    by_date/etf_daily/2017/2017-01-12.parquet
  size:    54 KB
  rows:    1,356

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
2017-01-12	SPY	ETF	226.5	226.75	224.96	226.53	72113200.0
2017-01-12	QQQ	ETF	122.49	122.819	121.6	122.74	19622511.0
2017-01-12	IWM	ETF	136.16	136.22	133.59	135.28	41844200.0
2017-01-12	DIA	ETF	198.88	198.91	197.53	198.75	3865200.0
2017-01-12	GLD	ETF	114.52	114.93	113.81	113.91	8457300.0
2017-01-12	TLT	ETF	122.8	123.14	121.83	121.89	9977600.0
2017-01-12	AADR	ETF	43.33	43.39	43.27	43.37	5500.0
2017-01-12	AAXJ	ETF	57.72	57.77	57.49	57.74	1652500.0
2017-01-12	ACSI	ETF	27.1456	27.21	27.0499	27.21	4250.0
2017-01-12	ACTX	ETF	29.5003	35.4003	28.9103	35.4003	2225.0
2017-01-12	ACWF	ETF	24.88	24.88	24.88	24.88	181.0
2017-01-12	ACWI	ETF	60.34	60.58	60.2	60.54	1481400.0
2017-01-12	ACWV	ETF	73.45	73.59	73.28	73.59	240600.0
2017-01-12	ACWX	ETF	41.52	41.55	41.35	41.48	556204.0
2017-01-12	ADRE	ETF	34.27	34.34	34.0595	34.25	4248.0
2017-01-12	AFK	ETF	20.99	21.27	20.7722	21.23	8555.0
2017-01-12	AFTY	ETF	13.33	13.36	13.31	13.335	9200.0
2017-01-12	AGG	ETF	108.78	108.9	108.61	108.61	3036600.0
2017-01-12	AGGY	ETF	49.952	50.007	49.84	49.882	3700.0
2017-01-12	AGQ	ETF	35.87	36.3	35.39	35.57	115100.0
2017-01-12	AGZ	ETF	112.97	113.283	112.92	112.92	12940.0
2017-01-12	AGZD	ETF	23.995	24.115	23.99	24.115	17600.0
2017-01-12	AIA	ETF	48.67	48.74	48.54	48.73	40089.0
2017-01-12	AIQ	ETF	9.75	9.75	9.7	9.75	9159.0
2017-01-12	AIRR	ETF	23.81	23.81	23.131	23.45	87800.0
2017-01-12	AIVI	ETF	38.42	38.42	38.28	38.36	70500.0
2017-01-12	ALTY	ETF	15.17	15.17	15.17	15.17	100.0
2017-01-12	AMJ	ETF	32.17	32.18	31.69	31.75	2120948.0
2017-01-12	AMLP	ETF	64.0	64.2	63.4	63.5	1214980.0
2017-01-12	AMZA	ETF	109.8	109.9	108.1	108.7	34760.0
2017-01-12	ANGL	ETF	29.23	29.23	29.15	29.18	401200.0
2017-01-12	AOA	ETF	48.06	48.06	47.84	48.01	71200.0
2017-01-12	AOK	ETF	32.83	32.89	32.76	32.7752	112488.0
2017-01-12	AOM	ETF	35.61	35.66	35.5	35.55	236360.0
2017-01-12	AOR	ETF	41.13	41.1643	40.93	41.05	358056.0
2017-01-12	ARGT	ETF	25.17	25.17	24.85	24.9	53600.0
2017-01-12	ARKG	ETF	18.32	18.32	18.32	18.32	100.0
2017-01-12	ARKK	ETF	21.55	21.83	21.46	21.83	1700.0
2017-01-12	ARKQ	ETF	22.826	22.901	22.826	22.901	300.0
2017-01-12	ARKW	ETF	27.0	27.0	26.6	26.93	4500.0
2017-01-12	ASEA	ETF	13.2	13.34	13.2	13.34	2100.0
2017-01-12	ASET	ETF	25.9	25.9	25.9	25.9	400.0
2017-01-12	ASHR	ETF	24.1	24.18	24.08	24.16	1002300.0
2017-01-12	ASHS	ETF	33.01	33.1	33.01	33.1	4000.0
2017-01-12	ATMP	ETF	23.7	23.76	23.5	23.6	158200.0
2017-01-12	BAB	ETF	29.45	29.5108	29.36	29.39	225261.0
2017-01-12	BAL	ETF	48.4284	48.48	47.63	47.6322	4625.0
2017-01-12	BBC	ETF	19.42	19.887	19.2195	19.7366	6217.0
2017-01-12	BBH	ETF	112.43	113.8	111.84	113.55	42500.0
2017-01-12	BBP	ETF	34.97	35.65	34.866	35.49	14600.0

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

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