PREVIEW / etf_daily / 2017-09-01

all etf daily files

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

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-09-01	SPY	ETF	247.92	248.33	247.67	247.84	62007000.0
2017-09-01	QQQ	ETF	146.36	146.585	145.61	146.0	22293553.0
2017-09-01	IWM	ETF	139.98	140.63	139.73	140.52	17412500.0
2017-09-01	DIA	ETF	220.13	220.41	219.83	219.92	2150200.0
2017-09-01	GLD	ETF	126.01	126.17	125.12	126.06	11567400.0
2017-09-01	TLT	ETF	127.31	127.34	126.43	126.75	14128600.0
2017-09-01	AADR	ETF	52.69	53.36	52.68	53.23	21900.0
2017-09-01	AAXJ	ETF	72.3	72.46	72.14	72.43	960100.0
2017-09-01	ACSI	ETF	28.8702	28.8825	28.8702	28.8825	1198.0
2017-09-01	ACTX	ETF	73.1607	74.3407	70.8006	73.7507	334.0
2017-09-01	ACWF	ETF	28.26	28.37	28.26	28.3417	3868.0
2017-09-01	ACWI	ETF	67.73	67.8	67.64	67.71	1675700.0
2017-09-01	ACWV	ETF	81.42	81.42	81.15	81.22	75700.0
2017-09-01	ACWX	ETF	47.58	47.6199	47.49	47.56	627163.0
2017-09-01	ADRE	ETF	42.77	42.91	42.684	42.87	22427.0
2017-09-01	AFK	ETF	23.95	24.0	23.7125	24.0	5476.0
2017-09-01	AFTY	ETF	17.11	17.22	17.11	17.22	6100.0
2017-09-01	AGG	ETF	110.19	110.22	109.91	109.97	2824200.0
2017-09-01	AGGY	ETF	50.98	50.98	50.86	50.9	14400.0
2017-09-01	AGNG	ETF	19.34	19.419	19.34	19.414	18500.0
2017-09-01	AGQ	ETF	37.6	37.87	36.92	37.71	128300.0
2017-09-01	AGZ	ETF	114.177	114.177	114.06	114.07	7595.0
2017-09-01	AGZD	ETF	23.91	23.91	23.91	23.91	1600.0
2017-09-01	AIA	ETF	61.15	61.2199	61.04	61.13	45927.0
2017-09-01	AIRR	ETF	23.8	23.864	23.72	23.85	10900.0
2017-09-01	AIVI	ETF	42.19	42.19	42.08	42.08	9000.0
2017-09-01	ALTY	ETF	15.59	15.66	15.567	15.66	4100.0
2017-09-01	AMJ	ETF	28.17	28.33	28.01	28.21	2016774.0
2017-09-01	AMLP	ETF	56.0	56.4	55.75	56.25	2152000.0
2017-09-01	AMZA	ETF	93.0	93.3	92.0	93.3	59990.0
2017-09-01	ANGL	ETF	29.9	29.9	29.82	29.89	350300.0
2017-09-01	AOA	ETF	52.85	52.85	52.74	52.82	38200.0
2017-09-01	AOK	ETF	34.44	34.44	34.33	34.4	65626.0
2017-09-01	AOM	ETF	37.78	37.78	37.69	37.75	96574.0
2017-09-01	AOR	ETF	44.39	44.406	44.2985	44.35	39343.0
2017-09-01	ARCM	ETF	100.3	100.3	100.25	100.3	80.0
2017-09-01	ARGT	ETF	29.91	30.04	29.69	29.9	57700.0
2017-09-01	ARKG	ETF	25.4	25.429	25.05	25.36	87500.0
2017-09-01	ARKK	ETF	34.37	34.37	33.34	33.64	216400.0
2017-09-01	ARKQ	ETF	30.5	30.5	30.195	30.34	44600.0
2017-09-01	ARKW	ETF	41.37	41.37	40.11	40.43	171300.0
2017-09-01	ASEA	ETF	15.51	15.61	15.5	15.59	1200.0
2017-09-01	ASET	ETF	28.2466	28.2466	28.22	28.24	2514.0
2017-09-01	ASHR	ETF	29.63	29.79	29.61	29.77	2224300.0
2017-09-01	ASHS	ETF	36.0	36.5	36.0	36.5	18300.0
2017-09-01	ASHX	ETF	21.7899	21.7899	21.7899	21.7899	335.0
2017-09-01	ATMP	ETF	21.42	21.45	21.29	21.45	105800.0
2017-09-01	BAB	ETF	30.64	30.64	30.52	30.56	53606.0
2017-09-01	BAL	ETF	47.1499	47.49	47.1499	47.43	8832.0
2017-09-01	BAR	ETF	13.2	13.27	13.2	13.27	22300.0

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

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