PREVIEW / etf_daily / 2015-07-16

all etf daily files

  file:    by_date/etf_daily/2015/2015-07-16.parquet
  size:    48 KB
  rows:    1,187

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-07-16	SPY	ETF	211.87	212.3	211.58	212.3	106683300.0
2015-07-16	QQQ	ETF	111.29	111.96	111.07	111.94	29838948.0
2015-07-16	IWM	ETF	126.11	126.74	125.97	126.31	33568400.0
2015-07-16	DIA	ETF	181.2	181.25	180.5	181.07	2495100.0
2015-07-16	GLD	ETF	109.67	110.01	109.6	109.76	4629700.0
2015-07-16	TLT	ETF	116.89	118.16	116.87	118.11	7306500.0
2015-07-16	AADR	ETF	39.55	39.85	39.52	39.85	2800.0
2015-07-16	AAXJ	ETF	61.2	61.6	61.16	61.53	966800.0
2015-07-16	ACTX	ETF	1.475	1.475	1.18	1.18	194.0
2015-07-16	ACWI	ETF	60.78	60.87	60.75	60.83	1050400.0
2015-07-16	ACWV	ETF	71.28	71.43	71.2	71.42	104900.0
2015-07-16	ACWX	ETF	44.86	44.95	44.81	44.84	223811.0
2015-07-16	ADRE	ETF	34.19	34.3799	34.16	34.3799	4627.0
2015-07-16	AFK	ETF	23.3299	23.5199	23.2601	23.38	6566.0
2015-07-16	AFTY	ETF	19.98	20.42	19.98	20.41	151600.0
2015-07-16	AGG	ETF	108.54	108.79	108.5	108.78	1294800.0
2015-07-16	AGQ	ETF	33.16	33.85	33.08	33.21	161200.0
2015-07-16	AGZ	ETF	113.06	113.41	113.06	113.33	8689.0
2015-07-16	AGZD	ETF	24.46	24.475	24.35	24.35	28200.0
2015-07-16	AIA	ETF	48.48	48.73	48.48	48.72	66651.0
2015-07-16	AIQ	ETF	17.3	17.45	16.88	16.93	15598.0
2015-07-16	AIRR	ETF	17.988	18.115	17.956	17.98	6600.0
2015-07-16	AIVI	ETF	43.72	43.82	43.66	43.71	46400.0
2015-07-16	ALTY	ETF	15.22	15.29	15.17	15.29	1700.0
2015-07-16	AMJ	ETF	39.99	39.99	39.29	39.39	3267426.0
2015-07-16	AMLP	ETF	78.85	78.85	77.95	78.0	1196220.0
2015-07-16	AMZA	ETF	195.8	195.8	190.5	190.6	2680.0
2015-07-16	ANGL	ETF	27.12	27.12	26.97	27.11	14000.0
2015-07-16	AOA	ETF	47.76	47.86	47.73	47.83	41200.0
2015-07-16	AOK	ETF	32.48	32.5899	32.4501	32.54	30271.0
2015-07-16	AOM	ETF	35.4	35.4	35.18	35.23	214106.0
2015-07-16	AOR	ETF	40.8	40.8215	40.69	40.81	40771.0
2015-07-16	ARGT	ETF	19.96	20.26	19.96	20.26	800.0
2015-07-16	ARKG	ETF	23.745	23.86	23.745	23.86	600.0
2015-07-16	ARKK	ETF	21.868	21.868	21.848	21.848	900.0
2015-07-16	ARKQ	ETF	19.902	19.95	19.902	19.95	400.0
2015-07-16	ARKW	ETF	23.49	23.7	23.49	23.7	6800.0
2015-07-16	ASEA	ETF	14.99	15.0	14.99	15.0	2800.0
2015-07-16	ASHR	ETF	41.23	42.19	41.17	42.11	5069400.0
2015-07-16	ASHS	ETF	46.37	49.04	46.37	48.7	194600.0
2015-07-16	ATMP	ETF	27.13	27.14	26.88	26.94	61000.0
2015-07-16	AWAY	ETF	31.59	31.9	31.49	31.62	971471.0
2015-07-16	BAB	ETF	28.59	28.7799	28.59	28.74	44850.0
2015-07-16	BAL	ETF	43.56	43.71	43.38	43.577	19774.0
2015-07-16	BALT	ETF	1.52	1.57	1.51	1.56	106892.0
2015-07-16	BBC	ETF	39.03	39.32	38.6	39.25	30800.0
2015-07-16	BBH	ETF	143.16	144.41	142.68	144.05	86700.0
2015-07-16	BBP	ETF	37.36	37.36	36.73	37.25	75400.0
2015-07-16	BCM	ETF	29.988	29.9899	29.815	29.815	1250.0
2015-07-16	BFOR	ETF	8.39	8.41	8.3825	8.3875	74400.0

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

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