PREVIEW / etf_daily / 2017-09-25

all etf daily files

  file:    by_date/etf_daily/2017/2017-09-25.parquet
  size:    57 KB
  rows:    1,463

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-25	SPY	ETF	249.15	249.55	248.08	248.93	57064400.0
2017-09-25	QQQ	ETF	143.75	143.8299	142.1	142.8	54947712.0
2017-09-25	IWM	ETF	144.27	144.94	143.69	144.5	30012800.0
2017-09-25	DIA	ETF	223.11	223.43	221.99	222.82	2844300.0
2017-09-25	GLD	ETF	122.78	124.66	122.71	124.53	10257200.0
2017-09-25	TLT	ETF	126.32	127.27	126.2	126.99	9679000.0
2017-09-25	AADR	ETF	55.29	55.29	53.88	54.17	37900.0
2017-09-25	AAXJ	ETF	72.28	72.28	71.32	71.59	984600.0
2017-09-25	ACSI	ETF	28.861	28.8899	28.8	28.8899	2958.0
2017-09-25	ACTX	ETF	72.5707	73.1607	67.8506	70.2106	522.0
2017-09-25	ACWF	ETF	28.77	28.8075	28.6856	28.7094	3335.0
2017-09-25	ACWI	ETF	68.51	68.6	68.14	68.4	4745400.0
2017-09-25	ACWV	ETF	81.06	81.17	80.93	81.16	44700.0
2017-09-25	ACWX	ETF	48.2	48.28	47.96	48.08	348333.0
2017-09-25	ADRE	ETF	42.05	42.35	40.79	41.7	15172.0
2017-09-25	AFK	ETF	23.51	23.51	23.3863	23.4	6003.0
2017-09-25	AFTY	ETF	16.98	16.98	16.79	16.795	17100.0
2017-09-25	AGG	ETF	109.85	110.04	109.82	110.03	3937600.0
2017-09-25	AGGY	ETF	50.88	50.98	50.88	50.97	15500.0
2017-09-25	AGNG	ETF	19.35	19.38	19.326	19.326	3100.0
2017-09-25	AGQ	ETF	34.03	35.37	33.95	35.2	180500.0
2017-09-25	AGZ	ETF	113.76	113.97	113.76	113.94	90118.0
2017-09-25	AGZD	ETF	24.02	24.035	24.02	24.035	800.0
2017-09-25	AIA	ETF	61.42	61.43	60.83	61.04	30977.0
2017-09-25	AIRR	ETF	25.16	25.3	25.079	25.25	12100.0
2017-09-25	AIVI	ETF	42.97	43.08	42.87	42.99	6600.0
2017-09-25	ALTY	ETF	15.59	15.69	15.59	15.67	1900.0
2017-09-25	AMJ	ETF	28.01	28.59	27.925	28.49	1785068.0
2017-09-25	AMLP	ETF	55.75	57.05	55.75	56.75	3725640.0
2017-09-25	AMZA	ETF	92.0	94.4	91.98	94.3	147920.0
2017-09-25	ANGL	ETF	30.21	30.23	30.17	30.22	224400.0
2017-09-25	AOA	ETF	53.28	53.36	53.1	53.24	30200.0
2017-09-25	AOK	ETF	34.41	34.44	34.4	34.44	44150.0
2017-09-25	AOM	ETF	37.89	37.9255	37.81	37.91	89305.0
2017-09-25	AOR	ETF	44.66	44.68	44.5298	44.64	95934.0
2017-09-25	ARGT	ETF	31.62	31.69	31.02	31.12	47800.0
2017-09-25	ARKG	ETF	25.8	25.8	25.41	25.58	21500.0
2017-09-25	ARKK	ETF	33.96	34.08	33.352	33.38	95000.0
2017-09-25	ARKQ	ETF	31.37	31.37	30.78	30.84	26100.0
2017-09-25	ARKW	ETF	40.59	40.67	39.56	39.64	84400.0
2017-09-25	ASEA	ETF	15.71	15.71	15.6	15.71	1900.0
2017-09-25	ASET	ETF	28.095	28.12	28.095	28.12	462.0
2017-09-25	ASHR	ETF	29.24	29.24	28.95	28.96	1518200.0
2017-09-25	ASHS	ETF	36.0	36.01	35.7	35.7	12900.0
2017-09-25	ASHX	ETF	21.42	21.42	21.42	21.42	110.0
2017-09-25	ATMP	ETF	21.4	21.65	21.36	21.6	24500.0
2017-09-25	BAB	ETF	30.49	30.6235	30.49	30.62	75062.0
2017-09-25	BAL	ETF	45.32	45.9634	45.21	45.86	3576.0
2017-09-25	BAR	ETF	12.928	13.1	12.928	13.0916	32390.0
2017-09-25	BBC	ETF	27.89	28.69	27.89	28.35	10728.0

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

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