PREVIEW / etf_daily / 2017-03-29

all etf daily files

  file:    by_date/etf_daily/2017/2017-03-29.parquet
  size:    54 KB
  rows:    1,364

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-03-29	SPY	ETF	234.99	235.81	234.73	235.54	61950400.0
2017-03-29	QQQ	ETF	131.73	132.3	131.59	132.25	13709968.0
2017-03-29	IWM	ETF	135.7	136.49	135.3	136.23	22119500.0
2017-03-29	DIA	ETF	206.53	206.56	205.95	206.31	2323900.0
2017-03-29	GLD	ETF	119.22	119.45	119.05	119.33	4911000.0
2017-03-29	TLT	ETF	120.94	121.38	120.88	121.34	6291000.0
2017-03-29	AADR	ETF	46.94	46.94	46.39	46.87	19400.0
2017-03-29	AAXJ	ETF	63.31	63.56	63.31	63.51	662800.0
2017-03-29	ACSI	ETF	27.89	27.92	27.81	27.92	3501.0
2017-03-29	ACTX	ETF	113.576	143.3713	103.2509	137.4712	8623.0
2017-03-29	ACWF	ETF	25.8192	25.8192	25.8192	25.8192	500.0
2017-03-29	ACWI	ETF	63.15	63.47	63.15	63.44	2474400.0
2017-03-29	ACWV	ETF	77.39	77.51	77.29	77.5	312800.0
2017-03-29	ACWX	ETF	43.77	43.92	43.69	43.92	543412.0
2017-03-29	ADRE	ETF	36.73	36.9636	36.65	36.895	5965.0
2017-03-29	AFK	ETF	21.37	21.57	20.83	20.86	8792.0
2017-03-29	AGG	ETF	108.48	108.62	108.46	108.61	1965600.0
2017-03-29	AGGY	ETF	49.76	49.86	49.76	49.851	21500.0
2017-03-29	AGQ	ETF	40.79	41.4	40.71	41.36	90800.0
2017-03-29	AGZ	ETF	113.0056	113.038	112.87	112.92	16019.0
2017-03-29	AGZD	ETF	24.03	24.075	24.02	24.02	8400.0
2017-03-29	AIA	ETF	53.14	53.18	52.97	53.18	32786.0
2017-03-29	AIQ	ETF	10.1258	10.25	10.1	10.25	10206.0
2017-03-29	AIRR	ETF	23.1	23.43	23.1	23.36	41900.0
2017-03-29	AIVI	ETF	39.59	39.75	39.58	39.73	4100.0
2017-03-29	ALTY	ETF	15.46	15.59	15.46	15.574	8400.0
2017-03-29	AMJ	ETF	31.47	32.12	31.47	31.97	1050554.0
2017-03-29	AMLP	ETF	62.85	63.45	62.65	63.2	1154420.0
2017-03-29	AMZA	ETF	109.5	111.1	109.26	110.8	83480.0
2017-03-29	ANGL	ETF	29.26	29.37	29.22	29.36	954100.0
2017-03-29	AOA	ETF	49.92	50.05	49.87	50.03	32800.0
2017-03-29	AOK	ETF	33.29	33.36	33.26	33.36	39885.0
2017-03-29	AOM	ETF	36.33	36.47	36.3105	36.47	74037.0
2017-03-29	AOR	ETF	42.4	42.46	42.3101	42.46	79895.0
2017-03-29	ARGT	ETF	27.95	28.15	27.86	28.08	87200.0
2017-03-29	ARKG	ETF	20.41	20.65	20.41	20.65	600.0
2017-03-29	ARKK	ETF	23.68	23.84	23.59	23.79	9600.0
2017-03-29	ARKQ	ETF	24.27	24.485	24.27	24.466	7800.0
2017-03-29	ARKW	ETF	28.51	28.745	28.51	28.745	1700.0
2017-03-29	ASEA	ETF	14.13	14.15	14.1	14.15	6900.0
2017-03-29	ASET	ETF	26.4	26.46	26.3999	26.4398	2093.0
2017-03-29	ASHR	ETF	25.18	25.23	25.17	25.17	166800.0
2017-03-29	ASHS	ETF	34.22	34.22	34.2	34.2	1000.0
2017-03-29	ATMP	ETF	23.54	23.74	23.34	23.66	57700.0
2017-03-29	BAB	ETF	29.44	29.48	29.416	29.48	76156.0
2017-03-29	BAL	ETF	49.68	49.7469	49.24	49.35	3990.0
2017-03-29	BBC	ETF	23.53	23.81	23.44	23.45	14327.0
2017-03-29	BBH	ETF	118.91	119.87	118.91	119.18	47900.0
2017-03-29	BBP	ETF	38.33	38.678	38.233	38.4	20000.0
2017-03-29	BCM	ETF	26.7901	26.8999	26.7901	26.885	1884.0

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

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