PREVIEW / etf_daily / 2017-08-21

all etf daily files

  file:    by_date/etf_daily/2017/2017-08-21.parquet
  size:    55 KB
  rows:    1,415

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-21	SPY	ETF	242.64	243.2	241.83	242.9	65469700.0
2017-08-21	QQQ	ETF	141.23	141.53	140.18	141.05	37111487.0
2017-08-21	IWM	ETF	134.69	135.02	134.14	134.83	21504100.0
2017-08-21	DIA	ETF	216.46	216.92	215.73	216.74	3467200.0
2017-08-21	GLD	ETF	122.54	122.98	122.5	122.76	5549700.0
2017-08-21	TLT	ETF	126.77	127.02	126.5	126.93	7669800.0
2017-08-21	AADR	ETF	51.3	51.3	50.98	51.25	5800.0
2017-08-21	AAXJ	ETF	70.45	70.51	70.18	70.44	378100.0
2017-08-21	ACSI	ETF	28.56	28.5642	28.56	28.5642	12201.0
2017-08-21	ACTX	ETF	76.7007	82.6007	75.5207	77.2907	264.0
2017-08-21	ACWF	ETF	27.61	27.685	27.52	27.64	7993.0
2017-08-21	ACWI	ETF	66.32	66.46	66.16	66.4	1029300.0
2017-08-21	ACWV	ETF	80.4	80.67	80.28	80.63	62800.0
2017-08-21	ACWX	ETF	46.72	46.77	46.58	46.71	199352.0
2017-08-21	ADRE	ETF	41.565	41.77	41.565	41.68	4882.0
2017-08-21	AFK	ETF	22.97	23.2	22.8509	23.2	8655.0
2017-08-21	AFTY	ETF	16.28	16.28	16.22	16.25	4000.0
2017-08-21	AGG	ETF	110.01	110.09	109.97	110.03	1717600.0
2017-08-21	AGGY	ETF	50.74	50.754	50.7	50.75	11100.0
2017-08-21	AGNG	ETF	18.38	18.4	18.33	18.4	1300.0
2017-08-21	AGQ	ETF	35.14	35.4	34.77	34.89	91000.0
2017-08-21	AGZ	ETF	114.12	114.18	114.11	114.15	9872.0
2017-08-21	AIA	ETF	59.79	59.8	59.55	59.7	36978.0
2017-08-21	AIRR	ETF	22.44	22.494	22.403	22.48	14000.0
2017-08-21	AIVI	ETF	41.45	41.57	41.43	41.52	6000.0
2017-08-21	ALTY	ETF	15.56	15.56	15.444	15.444	1000.0
2017-08-21	AMJ	ETF	27.38	27.41	26.99	27.11	3073714.0
2017-08-21	AMLP	ETF	53.5	53.65	52.55	52.7	2981780.0
2017-08-21	AMUB	ETF	17.08	17.08	17.0572	17.0572	481.0
2017-08-21	AMZA	ETF	87.1	87.4	85.15	85.6	209850.0
2017-08-21	ANGL	ETF	29.7	29.73	29.59	29.6	423200.0
2017-08-21	AOA	ETF	51.95	52.0	51.84	51.96	41300.0
2017-08-21	AOK	ETF	34.12	34.13	34.0512	34.12	19893.0
2017-08-21	AOM	ETF	37.37	37.4	37.32	37.4	64681.0
2017-08-21	AOR	ETF	43.8	43.8	43.6801	43.8	64114.0
2017-08-21	ARGT	ETF	29.06	29.14	28.92	28.96	43500.0
2017-08-21	ARKG	ETF	21.78	22.0	21.72	21.96	3200.0
2017-08-21	ARKK	ETF	30.94	30.94	30.47	30.75	66800.0
2017-08-21	ARKQ	ETF	28.83	28.83	28.351	28.57	16100.0
2017-08-21	ARKW	ETF	38.34	38.36	37.937	38.26	32200.0
2017-08-21	ASEA	ETF	15.21	15.33	15.21	15.29	1800.0
2017-08-21	ASET	ETF	27.825	27.8298	27.8059	27.8126	1974.0
2017-08-21	ASHR	ETF	28.3	28.37	28.29	28.37	324700.0
2017-08-21	ASHS	ETF	34.9	34.98	34.89	34.95	3600.0
2017-08-21	ASHX	ETF	21.18	21.18	21.18	21.18	200.0
2017-08-21	ATMP	ETF	20.63	20.68	20.39	20.44	164100.0
2017-08-21	BAB	ETF	30.4	30.46	30.375	30.4	112786.0
2017-08-21	BAL	ETF	44.3811	44.55	44.3811	44.43	2493.0
2017-08-21	BBC	ETF	23.37	23.7094	23.37	23.635	6976.0
2017-08-21	BBH	ETF	124.45	125.16	124.33	124.97	123300.0

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

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