PREVIEW / etf_daily / 2017-08-01

all etf daily files

  file:    by_date/etf_daily/2017/2017-08-01.parquet
  size:    56 KB
  rows:    1,443

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-08-01	SPY	ETF	247.46	247.5	246.72	247.32	55050400.0
2017-08-01	QQQ	ETF	143.7	143.76	143.12	143.56	20149421.0
2017-08-01	IWM	ETF	142.17	142.2	140.97	141.78	19835900.0
2017-08-01	DIA	ETF	219.74	219.8	219.15	219.37	2307100.0
2017-08-01	GLD	ETF	120.44	121.14	120.44	120.65	7365100.0
2017-08-01	TLT	ETF	123.18	124.71	123.16	124.64	9676800.0
2017-08-01	AADR	ETF	49.88	49.88	49.65	49.8	19300.0
2017-08-01	AAXJ	ETF	71.43	71.43	71.16	71.25	1613500.0
2017-08-01	ACSI	ETF	29.0699	29.1	29.0699	29.1	21107.0
2017-08-01	ACTX	ETF	70.8006	73.7507	68.4406	71.9806	335.0
2017-08-01	ACWF	ETF	28.12	28.12	28.0803	28.0803	551.0
2017-08-01	ACWI	ETF	67.54	67.6	67.4	67.5	2403400.0
2017-08-01	ACWV	ETF	80.8	80.87	80.7	80.81	155500.0
2017-08-01	ACWX	ETF	47.53	47.55	47.41	47.42	246567.0
2017-08-01	ADRE	ETF	42.0	42.0	41.5	41.6735	10927.0
2017-08-01	AFK	ETF	23.09	23.1389	23.04	23.1389	4694.0
2017-08-01	AFTY	ETF	16.397	16.43	16.39	16.39	10400.0
2017-08-01	AGG	ETF	109.38	109.72	109.36	109.72	2338900.0
2017-08-01	AGGY	ETF	50.65	50.82	50.65	50.792	17900.0
2017-08-01	AGNG	ETF	18.76	18.76	18.58	18.75	3800.0
2017-08-01	AGQ	ETF	33.95	34.44	33.85	33.93	102900.0
2017-08-01	AGZ	ETF	113.64	113.8729	113.64	113.87	8318.0
2017-08-01	AGZD	ETF	23.985	24.01	23.97	23.99	3400.0
2017-08-01	AIA	ETF	60.86	60.86	60.67	60.7	68070.0
2017-08-01	AIQ	ETF	13.2	13.2001	13.15	13.2	31876.0
2017-08-01	AIRR	ETF	23.93	24.1	23.92	24.09	23100.0
2017-08-01	AIVI	ETF	42.14	42.22	42.11	42.11	6500.0
2017-08-01	ALTY	ETF	15.63	15.705	15.613	15.65	2800.0
2017-08-01	AMJ	ETF	30.05	30.305	30.05	30.12	1340403.0
2017-08-01	AMLP	ETF	60.05	60.3	59.9	60.0	1715260.0
2017-08-01	AMZA	ETF	97.5	98.0	97.3	97.5	79270.0
2017-08-01	ANGL	ETF	29.83	29.9	29.77	29.77	908800.0
2017-08-01	AOA	ETF	52.66	52.72	52.63	52.63	35300.0
2017-08-01	AOK	ETF	34.25	34.31	34.19	34.3	44852.0
2017-08-01	AOM	ETF	37.57	37.62	37.4919	37.62	88193.0
2017-08-01	AOR	ETF	44.23	44.247	44.1726	44.24	144583.0
2017-08-01	ARCM	ETF	99.975	99.975	99.975	99.975	20.0
2017-08-01	ARGT	ETF	29.77	29.8	29.63	29.74	101700.0
2017-08-01	ARKG	ETF	22.52	22.52	21.95	22.154	11200.0
2017-08-01	ARKK	ETF	29.83	29.83	29.51	29.7	28600.0
2017-08-01	ARKQ	ETF	29.94	29.94	29.55	29.59	27600.0
2017-08-01	ARKW	ETF	37.08	37.214	36.89	37.19	40300.0
2017-08-01	ASEA	ETF	15.36	15.41	15.34	15.37	6600.0
2017-08-01	ASET	ETF	28.094	28.15	28.094	28.12	4560.0
2017-08-01	ASHR	ETF	28.45	28.45	28.37	28.44	1187200.0
2017-08-01	ASHS	ETF	34.12	34.23	34.12	34.15	5700.0
2017-08-01	ATMP	ETF	22.81	22.97	22.79	22.86	85500.0
2017-08-01	BAB	ETF	30.11	30.24	30.08	30.23	72785.0
2017-08-01	BAL	ETF	45.39	45.84	45.39	45.84	732.0
2017-08-01	BBC	ETF	24.18	24.18	23.61	23.89	63125.0

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

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