PREVIEW / etf_daily / 2017-08-11

all etf daily files

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

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-11	SPY	ETF	244.02	244.8	243.75	244.12	74869900.0
2017-08-11	QQQ	ETF	141.24	142.41	140.9	142.1	45862488.0
2017-08-11	IWM	ETF	136.21	136.74	135.77	136.47	32779600.0
2017-08-11	DIA	ETF	218.76	219.22	218.52	218.7	4944500.0
2017-08-11	GLD	ETF	122.24	122.83	122.03	122.79	8019500.0
2017-08-11	TLT	ETF	125.77	126.46	125.55	126.43	5717800.0
2017-08-11	AADR	ETF	48.77	49.27	48.45	49.22	7800.0
2017-08-11	AAXJ	ETF	69.21	69.53	69.03	69.24	1593200.0
2017-08-11	ACSI	ETF	28.7	28.8673	28.7	28.84	14970.0
2017-08-11	ACTX	ETF	82.6007	82.6007	72.5707	74.9307	434.0
2017-08-11	ACWF	ETF	27.52	27.61	27.48	27.48	920.0
2017-08-11	ACWI	ETF	66.34	66.49	66.22	66.35	1512200.0
2017-08-11	ACWV	ETF	80.11	80.3	80.08	80.17	70900.0
2017-08-11	ACWX	ETF	46.46	46.53	46.32	46.43	234016.0
2017-08-11	ADRE	ETF	40.71	41.088	40.6099	40.96	6005.0
2017-08-11	AFK	ETF	22.7	22.78	22.6424	22.78	6463.0
2017-08-11	AFTY	ETF	15.84	15.84	15.774	15.78	2000.0
2017-08-11	AGG	ETF	109.75	109.94	109.68	109.87	1913300.0
2017-08-11	AGGY	ETF	50.698	50.77	50.68	50.77	10000.0
2017-08-11	AGNG	ETF	18.23	18.23	18.23	18.23	600.0
2017-08-11	AGQ	ETF	35.03	35.43	34.69	35.42	133000.0
2017-08-11	AGZ	ETF	113.99	114.17	113.99	114.06	17748.0
2017-08-11	AGZD	ETF	23.995	23.995	23.94	23.98	1200.0
2017-08-11	AIA	ETF	58.73	58.94	58.62	58.78	78625.0
2017-08-11	AIQ	ETF	13.1	13.1	12.95	13.05	51064.0
2017-08-11	AIRR	ETF	23.25	23.25	23.09	23.13	204100.0
2017-08-11	AIVI	ETF	41.29	41.36	41.21	41.27	11300.0
2017-08-11	ALTY	ETF	15.41	15.5	15.4	15.45	10500.0
2017-08-11	AMJ	ETF	28.46	28.61	28.34	28.36	1400620.0
2017-08-11	AMLP	ETF	55.65	55.95	55.35	55.4	1165940.0
2017-08-11	AMZA	ETF	92.0	92.0	90.9	91.1	212020.0
2017-08-11	ANGL	ETF	29.58	29.63	29.55	29.57	160100.0
2017-08-11	AOA	ETF	51.89	52.02	51.84	51.95	41800.0
2017-08-11	AOK	ETF	34.08	34.12	34.0133	34.1	36336.0
2017-08-11	AOM	ETF	37.37	37.4	37.25	37.36	71006.0
2017-08-11	AOR	ETF	43.81	43.81	43.66	43.71	73883.0
2017-08-11	ARCM	ETF	100.05	100.05	100.05	100.05	2500.0
2017-08-11	ARGT	ETF	27.66	28.22	27.4	28.18	35400.0
2017-08-11	ARKG	ETF	21.89	22.402	21.89	22.385	8900.0
2017-08-11	ARKK	ETF	30.05	30.77	30.0	30.75	52000.0
2017-08-11	ARKQ	ETF	28.7	28.98	28.54	28.98	27000.0
2017-08-11	ARKW	ETF	36.94	37.53	36.79	37.51	25600.0
2017-08-11	ASEA	ETF	15.24	15.29	15.16	15.29	23800.0
2017-08-11	ASHR	ETF	27.49	27.49	27.4	27.42	922300.0
2017-08-11	ASHS	ETF	33.49	33.49	33.4	33.43	16600.0
2017-08-11	ASHX	ETF	20.7	20.7	20.7	20.7	690.0
2017-08-11	ATMP	ETF	21.5	21.5	21.27	21.28	97900.0
2017-08-11	BAB	ETF	30.34	30.48	30.2701	30.47	104624.0
2017-08-11	BAL	ETF	45.1029	45.6	44.902	44.902	1843.0
2017-08-11	BBC	ETF	23.4	23.86	23.4	23.76	970.0

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

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