PREVIEW / etf_daily / 2017-11-24

all etf daily files

  file:    by_date/etf_daily/2017/2017-11-24.parquet
  size:    55 KB
  rows:    1,442

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-11-24	SPY	ETF	260.32	260.48	260.16	260.36	27856500.0
2017-11-24	QQQ	ETF	155.86	156.31	155.76	156.26	8280586.0
2017-11-24	IWM	ETF	151.21	151.37	150.77	150.95	6816300.0
2017-11-24	DIA	ETF	235.56	235.87	235.41	235.47	1435500.0
2017-11-24	GLD	ETF	122.36	122.61	122.22	122.32	1779700.0
2017-11-24	TLT	ETF	126.93	127.03	126.69	126.8	3141400.0
2017-11-24	AADR	ETF	57.36	57.52	57.28	57.52	4400.0
2017-11-24	AAXJ	ETF	78.12	78.38	78.12	78.28	340400.0
2017-11-24	ACSI	ETF	30.19	30.19	30.01	30.03	8710.0
2017-11-24	ACTX	ETF	84.9608	87.3208	76.7007	84.3708	810.0
2017-11-24	ACWF	ETF	30.4864	30.4901	30.47	30.4901	5172.0
2017-11-24	ACWI	ETF	71.35	71.42	71.33	71.35	700600.0
2017-11-24	ACWV	ETF	83.5	83.71	83.46	83.54	50700.0
2017-11-24	ACWX	ETF	50.1	50.1305	50.05	50.09	429740.0
2017-11-24	ADRE	ETF	43.9	44.1399	43.9	44.1399	3914.0
2017-11-24	AFK	ETF	24.2	24.49	24.2	24.4	7180.0
2017-11-24	AFTY	ETF	19.22	19.22	18.93	19.0	29300.0
2017-11-24	AGG	ETF	109.5	109.56	109.48	109.53	1693500.0
2017-11-24	AGGY	ETF	50.73	50.74	50.668	50.685	47000.0
2017-11-24	AGNG	ETF	19.73	19.745	19.73	19.745	500.0
2017-11-24	AGQ	ETF	34.43	34.87	34.3	34.42	44200.0
2017-11-24	AGZ	ETF	113.48	113.56	113.4601	113.4601	7433.0
2017-11-24	AIA	ETF	68.2	68.3	68.12	68.14	28501.0
2017-11-24	AIEQ	ETF	25.07	25.15	25.02	25.09	46800.0
2017-11-24	AIRR	ETF	26.46	26.46	26.15	26.19	2400.0
2017-11-24	AIVI	ETF	43.32	43.4	43.29	43.29	5400.0
2017-11-24	AMJ	ETF	26.51	26.56	26.24	26.34	1745659.0
2017-11-24	AMLP	ETF	51.15	51.3	50.7	50.8	1109320.0
2017-11-24	AMZA	ETF	80.0	80.3	79.3	79.5	49480.0
2017-11-24	ANGL	ETF	30.07	30.15	30.07	30.1	373100.0
2017-11-24	AOA	ETF	55.0	55.03	54.99	55.0	12400.0
2017-11-24	AOK	ETF	34.8	34.8899	34.8	34.85	55342.0
2017-11-24	AOM	ETF	38.44	38.49	38.4233	38.48	51481.0
2017-11-24	AOR	ETF	45.73	45.74	45.69	45.73	34222.0
2017-11-24	ARCM	ETF	100.2	100.2	100.2	100.2	600.0
2017-11-24	ARGT	ETF	32.41	32.72	32.36	32.72	16900.0
2017-11-24	ARKG	ETF	25.44	25.619	25.22	25.22	39900.0
2017-11-24	ARKK	ETF	36.93	37.03	36.797	36.94	229100.0
2017-11-24	ARKQ	ETF	34.41	34.55	34.4	34.55	14000.0
2017-11-24	ARKW	ETF	45.58	45.87	45.43	45.84	97000.0
2017-11-24	ASEA	ETF	16.5	16.67	16.49	16.49	4000.0
2017-11-24	ASET	ETF	28.49	28.5	28.49	28.4999	592.0
2017-11-24	ASHR	ETF	31.64	31.71	31.48	31.53	1333700.0
2017-11-24	ASHS	ETF	34.64	34.76	34.64	34.72	7800.0
2017-11-24	ASHX	ETF	23.23	23.23	23.11	23.1648	1560.0
2017-11-24	ATMP	ETF	19.85	19.97	19.84	19.84	5500.0
2017-11-24	BAB	ETF	30.68	30.69	30.5684	30.64	30335.0
2017-11-24	BAL	ETF	47.14	47.51	47.14	47.51	1995.0
2017-11-24	BBC	ETF	27.85	28.08	27.673	27.8434	3518.0
2017-11-24	BBH	ETF	124.69	124.77	124.25	124.34	5000.0

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

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