PREVIEW / etf_daily / 2017-10-30

all etf daily files

  file:    by_date/etf_daily/2017/2017-10-30.parquet
  size:    58 KB
  rows:    1,493

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-10-30	SPY	ETF	256.47	257.6	256.41	256.75	54285700.0
2017-10-30	QQQ	ETF	151.08	152.19	150.9899	151.58	31733386.0
2017-10-30	IWM	ETF	148.88	149.45	147.39	148.21	30524800.0
2017-10-30	DIA	ETF	233.52	234.14	233.15	233.33	2672500.0
2017-10-30	GLD	ETF	120.38	121.47	120.38	121.13	5119200.0
2017-10-30	TLT	ETF	123.86	124.46	123.56	124.42	9051600.0
2017-10-30	AADR	ETF	57.01	57.31	56.87	57.13	24500.0
2017-10-30	AAXJ	ETF	74.63	74.88	74.45	74.59	548700.0
2017-10-30	ACSI	ETF	29.5224	29.54	29.5125	29.5125	1100.0
2017-10-30	ACTX	ETF	47.7904	50.3865	44.2504	46.0204	1133.0
2017-10-30	ACWF	ETF	29.8776	29.9601	29.73	29.8	9580.0
2017-10-30	ACWI	ETF	70.06	70.21	70.0	70.08	771100.0
2017-10-30	ACWV	ETF	82.6	82.6	82.34	82.41	80000.0
2017-10-30	ACWX	ETF	49.03	49.09	49.0	49.08	743983.0
2017-10-30	ADRE	ETF	42.68	42.98	42.46	42.49	10280.0
2017-10-30	AFK	ETF	23.58	23.77	23.4857	23.6	10068.0
2017-10-30	AFTY	ETF	17.83	17.901	17.83	17.881	3800.0
2017-10-30	AGG	ETF	109.43	109.56	109.36	109.54	2384800.0
2017-10-30	AGGY	ETF	50.64	50.7	50.58	50.684	26600.0
2017-10-30	AGNG	ETF	19.53	19.547	19.37	19.48	23400.0
2017-10-30	AGQ	ETF	33.56	33.98	33.38	33.79	74900.0
2017-10-30	AGZ	ETF	113.43	113.58	113.4211	113.54	16327.0
2017-10-30	AGZD	ETF	24.12	24.13	24.12	24.125	35800.0
2017-10-30	AIA	ETF	64.2	64.29	64.04	64.1	109117.0
2017-10-30	AIEQ	ETF	25.02	25.02	24.721	24.77	377700.0
2017-10-30	AIRR	ETF	26.68	26.68	26.37	26.51	16400.0
2017-10-30	AIVI	ETF	42.74	42.86	42.74	42.85	46300.0
2017-10-30	ALTY	ETF	15.56	15.57	15.45	15.498	8500.0
2017-10-30	AMJ	ETF	26.94	27.4001	26.94	27.09	4085201.0
2017-10-30	AMLP	ETF	53.5	54.35	53.45	53.7	2796600.0
2017-10-30	AMUB	ETF	17.0233	17.0233	17.0233	17.0233	451.0
2017-10-30	AMZA	ETF	83.4	84.8	83.2	83.7	93210.0
2017-10-30	ANGL	ETF	30.31	30.33	30.17	30.22	631900.0
2017-10-30	AOA	ETF	54.31	54.32	54.19	54.21	153800.0
2017-10-30	AOK	ETF	34.62	34.66	34.5885	34.65	65871.0
2017-10-30	AOM	ETF	38.14	38.18	38.1	38.14	215949.0
2017-10-30	AOR	ETF	45.22	45.25	45.1498	45.25	88924.0
2017-10-30	ARGT	ETF	31.91	31.93	31.63	31.76	56200.0
2017-10-30	ARKG	ETF	25.7	25.99	25.49	25.82	109600.0
2017-10-30	ARKK	ETF	34.92	35.24	34.79	35.04	251600.0
2017-10-30	ARKQ	ETF	32.92	33.13	32.85	32.93	27700.0
2017-10-30	ARKW	ETF	42.67	42.88	42.33	42.74	87000.0
2017-10-30	ASEA	ETF	15.93	15.93	15.92	15.92	1100.0
2017-10-30	ASET	ETF	28.109	28.109	28.099	28.1	1367.0
2017-10-30	ASHR	ETF	30.51	30.59	30.46	30.51	446400.0
2017-10-30	ASHS	ETF	35.68	35.7	35.57	35.57	14800.0
2017-10-30	ATMP	ETF	20.67	20.74	20.45	20.45	31900.0
2017-10-30	BAB	ETF	30.35	30.41	30.31	30.39	83183.0
2017-10-30	BAL	ETF	45.235	45.59	45.235	45.585	1403.0
2017-10-30	BAR	ETF	12.747	12.747	12.747	12.747	24040.0

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

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