PREVIEW / etf_daily / 2017-04-05

all etf daily files

  file:    by_date/etf_daily/2017/2017-04-05.parquet
  size:    54 KB
  rows:    1,377

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-04-05	SPY	ETF	236.26	237.39	234.54	234.78	108800600.0
2017-04-05	QQQ	ETF	132.68	133.48	131.72	131.97	32011155.0
2017-04-05	IWM	ETF	136.83	137.43	134.08	134.33	44968800.0
2017-04-05	DIA	ETF	207.59	208.65	206.16	206.26	4110400.0
2017-04-05	GLD	ETF	118.62	119.63	118.4	119.62	8106000.0
2017-04-05	TLT	ETF	120.56	121.52	120.36	121.38	8555200.0
2017-04-05	AADR	ETF	47.2	47.2	46.62	46.62	105400.0
2017-04-05	AAXJ	ETF	63.49	63.68	63.22	63.28	1305700.0
2017-04-05	ACSI	ETF	28.0399	28.0399	27.76	27.76	751.0
2017-04-05	ACTX	ETF	109.151	112.101	102.2479	107.971	1295.0
2017-04-05	ACWI	ETF	63.43	63.66	63.03	63.1	2895800.0
2017-04-05	ACWV	ETF	77.48	77.72	77.3	77.36	158600.0
2017-04-05	ACWX	ETF	43.7	43.8044	43.46	43.47	614531.0
2017-04-05	ADRE	ETF	37.045	37.0719	36.64	36.64	6789.0
2017-04-05	AFK	ETF	20.98	20.98	20.64	20.65	19341.0
2017-04-05	AFTY	ETF	13.95	13.95	13.88	13.88	5900.0
2017-04-05	AGG	ETF	108.48	108.74	108.45	108.69	2304100.0
2017-04-05	AGGY	ETF	49.92	49.96	49.85	49.88	14500.0
2017-04-05	AGQ	ETF	41.15	41.74	40.89	41.66	156100.0
2017-04-05	AGZ	ETF	113.05	113.2	112.22	113.195	11642.0
2017-04-05	AGZD	ETF	24.015	24.045	23.975	24.03	14800.0
2017-04-05	AIA	ETF	53.13	53.29	52.97	53.02	92038.0
2017-04-05	AIQ	ETF	9.15	10.2	9.1182	10.0	8249.0
2017-04-05	AIRR	ETF	23.66	23.873	23.365	23.458	23100.0
2017-04-05	AIVI	ETF	39.59	39.72	39.45	39.45	22800.0
2017-04-05	ALTY	ETF	15.55	15.56	15.179	15.422	18800.0
2017-04-05	AMJ	ETF	32.66	32.84	32.17	32.17	1745579.0
2017-04-05	AMLP	ETF	64.25	64.45	63.55	63.55	1815440.0
2017-04-05	AMZA	ETF	107.2	108.0	106.19	106.29	82630.0
2017-04-05	ANGL	ETF	29.56	29.59	29.44	29.45	321600.0
2017-04-05	AOA	ETF	49.89	50.0	49.64	49.68	38100.0
2017-04-05	AOK	ETF	33.41	33.41	33.26	33.28	65275.0
2017-04-05	AOM	ETF	36.3	36.3799	36.26	36.26	51080.0
2017-04-05	AOR	ETF	42.32	42.3799	42.12	42.12	76025.0
2017-04-05	ARCM	ETF	100.05	100.05	100.05	100.05	2000.0
2017-04-05	ARGT	ETF	28.97	29.04	28.52	28.54	66500.0
2017-04-05	ARKG	ETF	20.262	20.31	20.0	20.0	4200.0
2017-04-05	ARKK	ETF	23.96	24.02	23.655	23.655	5500.0
2017-04-05	ARKQ	ETF	24.66	24.78	24.4	24.4	3100.0
2017-04-05	ARKW	ETF	29.072	29.3	29.039	29.039	3300.0
2017-04-05	ASEA	ETF	14.3	14.3	14.2	14.25	2400.0
2017-04-05	ASET	ETF	26.62	26.65	26.62	26.65	1363.0
2017-04-05	ASHR	ETF	25.55	25.59	25.47	25.5	527800.0
2017-04-05	ASHS	ETF	34.41	34.58	34.41	34.46	3500.0
2017-04-05	ATMP	ETF	24.0	24.18	23.85	23.85	9100.0
2017-04-05	BAB	ETF	29.33	29.42	29.3014	29.39	107676.0
2017-04-05	BAL	ETF	48.63	48.63	48.49	48.5	1961.0
2017-04-05	BBC	ETF	22.68	22.7	21.741	21.85	9655.0
2017-04-05	BBH	ETF	118.59	119.36	117.31	117.41	70300.0
2017-04-05	BBP	ETF	37.19	37.354	36.49	36.554	11200.0

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

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