PREVIEW / etf_daily / 2017-09-12

all etf daily files

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

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-12	SPY	ETF	249.63	250.09	249.42	250.05	56896000.0
2017-09-12	QQQ	ETF	146.25	146.41	145.53	146.22	30256661.0
2017-09-12	IWM	ETF	141.04	141.69	140.82	141.54	22679600.0
2017-09-12	DIA	ETF	221.33	221.57	221.07	221.42	2072900.0
2017-09-12	GLD	ETF	126.03	126.59	125.94	126.56	8349000.0
2017-09-12	TLT	ETF	127.05	127.09	126.53	126.79	7557400.0
2017-09-12	AADR	ETF	54.66	54.66	54.35	54.45	21700.0
2017-09-12	AAXJ	ETF	72.93	72.93	72.74	72.88	891900.0
2017-09-12	ACSI	ETF	28.99	29.0	28.975	28.99	1679.0
2017-09-12	ACTX	ETF	71.3906	76.7007	70.8006	71.9806	411.0
2017-09-12	ACWF	ETF	28.6599	28.6599	28.59	28.59	647.0
2017-09-12	ACWI	ETF	68.46	68.59	68.41	68.59	1144000.0
2017-09-12	ACWV	ETF	82.0	82.0	81.8	81.88	44300.0
2017-09-12	ACWX	ETF	48.3	48.35	48.24	48.35	521985.0
2017-09-12	ADRE	ETF	43.44	43.44	43.22	43.38	28532.0
2017-09-12	AFK	ETF	23.83	23.9	23.757	23.8085	7612.0
2017-09-12	AFTY	ETF	17.36	17.36	17.173	17.21	39100.0
2017-09-12	AGG	ETF	110.04	110.06	109.92	109.98	2403600.0
2017-09-12	AGGY	ETF	50.91	50.91	50.82	50.86	19000.0
2017-09-12	AGNG	ETF	19.83	19.83	19.59	19.59	900.0
2017-09-12	AGQ	ETF	38.06	38.41	37.93	38.29	79600.0
2017-09-12	AGZ	ETF	114.15	114.19	114.07	114.13	8632.0
2017-09-12	AIA	ETF	61.82	61.82	61.5	61.55	17306.0
2017-09-12	AIRR	ETF	24.01	24.359	24.01	24.31	57200.0
2017-09-12	AIVI	ETF	43.02	43.12	43.02	43.07	4500.0
2017-09-12	ALTY	ETF	15.73	15.73	15.625	15.659	1500.0
2017-09-12	AMJ	ETF	28.23	28.23	28.02	28.13	850058.0
2017-09-12	AMLP	ETF	55.9	56.15	55.8	56.05	1714360.0
2017-09-12	AMUB	ETF	17.719	17.719	17.719	17.719	100.0
2017-09-12	AMZA	ETF	92.7	92.82	92.2	92.3	43060.0
2017-09-12	ANGL	ETF	30.01	30.06	29.95	30.04	242500.0
2017-09-12	AOA	ETF	53.47	53.47	53.22	53.28	33400.0
2017-09-12	AOK	ETF	34.4	34.49	34.4	34.48	32408.0
2017-09-12	AOM	ETF	37.97	37.97	37.88	37.95	58502.0
2017-09-12	AOR	ETF	44.65	44.69	44.62	44.62	65779.0
2017-09-12	ARGT	ETF	31.16	31.24	30.95	31.11	17000.0
2017-09-12	ARKG	ETF	25.52	25.52	25.17	25.284	29100.0
2017-09-12	ARKK	ETF	33.95	34.05	33.61	33.87	109200.0
2017-09-12	ARKQ	ETF	30.78	30.84	30.678	30.82	23500.0
2017-09-12	ARKW	ETF	40.5	40.7	40.311	40.53	62600.0
2017-09-12	ASEA	ETF	15.72	15.73	15.67	15.72	7800.0
2017-09-12	ASET	ETF	28.84	28.84	28.4	28.42	3916.0
2017-09-12	ASHR	ETF	29.96	29.96	29.83	29.85	896800.0
2017-09-12	ASHS	ETF	37.39	37.39	37.26	37.34	6400.0
2017-09-12	ATMP	ETF	21.44	21.49	21.39	21.43	340600.0
2017-09-12	BAB	ETF	30.68	30.69	30.6	30.68	177921.0
2017-09-12	BAL	ETF	47.04	47.13	45.3403	45.64	20820.0
2017-09-12	BAR	ETF	13.291	13.33	13.2785	13.33	35620.0
2017-09-12	BBC	ETF	27.84	28.01	27.361	27.52	12829.0
2017-09-12	BBH	ETF	136.36	136.45	135.07	136.45	17500.0

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

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