PREVIEW / etf_daily / 2015-10-20

all etf daily files

  file:    by_date/etf_daily/2015/2015-10-20.parquet
  size:    48 KB
  rows:    1,207

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-10-20	SPY	ETF	202.85	203.84	202.55	203.11	78448500.0
2015-10-20	QQQ	ETF	108.545	108.78	107.81	108.18	23404691.0
2015-10-20	IWM	ETF	115.58	116.3	115.03	115.48	20531400.0
2015-10-20	DIA	ETF	171.59	172.39	171.24	172.01	4140900.0
2015-10-20	GLD	ETF	112.38	113.09	112.38	112.73	4903200.0
2015-10-20	TLT	ETF	122.8	122.97	122.55	122.83	6431300.0
2015-10-20	AADR	ETF	38.06	38.06	38.0	38.0	1000.0
2015-10-20	AAXJ	ETF	57.66	57.77	57.53	57.71	451400.0
2015-10-20	ACTX	ETF	10.6201	10.6201	8.2601	10.0301	1922.0
2015-10-20	ACWI	ETF	57.36	57.6	57.29	57.39	1246900.0
2015-10-20	ACWV	ETF	70.26	70.47	69.98	70.2	559800.0
2015-10-20	ACWX	ETF	41.77	41.84	41.66	41.75	853066.0
2015-10-20	ADRE	ETF	30.41	30.524	30.333	30.41	2899.0
2015-10-20	AFK	ETF	20.9	21.02	20.82	20.94	27385.0
2015-10-20	AFTY	ETF	16.097	16.12	16.061	16.12	7500.0
2015-10-20	AGG	ETF	109.78	109.78	109.55	109.66	1805400.0
2015-10-20	AGGY	ETF	49.925	49.925	49.925	49.925	100.0
2015-10-20	AGQ	ETF	36.05	36.57	35.59	36.34	122000.0
2015-10-20	AGZ	ETF	113.88	114.11	113.88	114.02	11029.0
2015-10-20	AGZD	ETF	23.995	23.995	23.995	23.995	1600.0
2015-10-20	AIA	ETF	46.09	46.1644	46.03	46.11	8232.0
2015-10-20	AIQ	ETF	10.4658	10.4658	9.93	10.11	20850.0
2015-10-20	AIRR	ETF	16.157	16.34	16.157	16.244	15000.0
2015-10-20	AIVI	ETF	40.7	40.89	40.67	40.79	38900.0
2015-10-20	ALTY	ETF	14.68	14.68	14.68	14.68	200.0
2015-10-20	AMJ	ETF	33.84	34.1	33.63	33.9	1797009.0
2015-10-20	AMLP	ETF	69.25	69.85	68.6	69.25	1508380.0
2015-10-20	AMZA	ETF	149.32	150.3	148.3	148.5	780.0
2015-10-20	ANGL	ETF	26.0	26.08	25.98	26.08	17200.0
2015-10-20	AOA	ETF	45.61	45.79	45.54	45.69	45600.0
2015-10-20	AOK	ETF	32.11	32.13	32.065	32.07	29594.0
2015-10-20	AOM	ETF	34.65	34.65	34.51	34.61	49885.0
2015-10-20	AOR	ETF	39.44	39.53	39.38	39.47	251241.0
2015-10-20	ARGT	ETF	17.57	17.57	17.42	17.42	500.0
2015-10-20	ARKG	ETF	19.053	19.053	19.053	19.053	400.0
2015-10-20	ARKK	ETF	19.496	19.496	19.496	19.496	100.0
2015-10-20	ARKQ	ETF	18.385	18.435	18.385	18.435	400.0
2015-10-20	ARKW	ETF	22.37	22.37	22.164	22.164	400.0
2015-10-20	ASEA	ETF	13.35	13.35	13.33	13.33	2500.0
2015-10-20	ASHR	ETF	36.14	36.31	35.99	36.26	1709200.0
2015-10-20	ASHS	ETF	43.1	43.87	43.1	43.59	33400.0
2015-10-20	ASHX	ETF	25.53	25.54	25.47	25.48	2200.0
2015-10-20	ATMP	ETF	23.32	23.32	22.65	22.65	28500.0
2015-10-20	AWAY	ETF	28.9	29.39	28.72	29.26	712528.0
2015-10-20	BAB	ETF	29.2	29.22	29.1386	29.2	49472.0
2015-10-20	BAL	ETF	42.38	42.586	42.29	42.39	12616.0
2015-10-20	BBC	ETF	27.76	27.79	26.493	26.93	10438.0
2015-10-20	BBH	ETF	119.13	119.46	116.05	116.32	237000.0
2015-10-20	BBP	ETF	29.8	29.8	28.74	28.8	4100.0
2015-10-20	BCM	ETF	26.952	27.013	26.95	27.013	10164.0

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

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