PREVIEW / etf_daily / 2017-11-21

all etf daily files

  file:    by_date/etf_daily/2017/2017-11-21.parquet
  size:    59 KB
  rows:    1,517

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-21	SPY	ETF	259.18	260.2	258.26	259.99	69176800.0
2017-11-21	QQQ	ETF	154.56	155.57	154.485	155.5	20147763.0
2017-11-21	IWM	ETF	150.2	151.29	150.06	151.09	29392300.0
2017-11-21	DIA	ETF	235.17	235.99	235.1	235.73	2749900.0
2017-11-21	GLD	ETF	121.67	122.0	121.5	121.51	4956500.0
2017-11-21	TLT	ETF	127.09	127.29	126.31	126.74	5818400.0
2017-11-21	AADR	ETF	56.67	57.35	56.67	57.19	27500.0
2017-11-21	AAXJ	ETF	78.1	78.44	78.0	78.28	1381000.0
2017-11-21	ACSI	ETF	29.91	29.9399	29.91	29.9399	11305.0
2017-11-21	ACTX	ETF	70.8006	70.8006	57.2305	66.0806	984.0
2017-11-21	ACWF	ETF	30.5294	30.675	30.488	30.51	8408.0
2017-11-21	ACWI	ETF	70.89	71.1	70.88	71.06	872300.0
2017-11-21	ACWV	ETF	83.28	83.54	83.28	83.48	128200.0
2017-11-21	ACWX	ETF	49.66	49.77	49.645	49.7	647948.0
2017-11-21	ADRE	ETF	43.41	43.81	43.41	43.67	25284.0
2017-11-21	AFK	ETF	23.85	24.09	23.85	24.09	11455.0
2017-11-21	AFTY	ETF	19.49	19.51	19.421	19.51	18500.0
2017-11-21	AGG	ETF	109.39	109.43	109.22	109.36	2297400.0
2017-11-21	AGGY	ETF	50.56	50.64	50.539	50.6	93800.0
2017-11-21	AGNG	ETF	19.65	19.65	19.47	19.623	3800.0
2017-11-21	AGQ	ETF	34.26	34.51	34.09	34.11	55400.0
2017-11-21	AGZ	ETF	113.47	113.47	113.4	113.4	25099.0
2017-11-21	AGZD	ETF	24.075	24.09	24.025	24.025	3000.0
2017-11-21	AIA	ETF	68.3	68.509	68.18	68.18	170993.0
2017-11-21	AIEQ	ETF	25.04	25.1	25.0	25.07	112200.0
2017-11-21	AIRR	ETF	26.21	26.414	26.21	26.36	26100.0
2017-11-21	AIVI	ETF	42.88	42.88	42.77	42.79	31600.0
2017-11-21	ALTY	ETF	15.466	15.466	15.452	15.455	1500.0
2017-11-21	AMJ	ETF	26.58	26.66	26.13	26.18	3884911.0
2017-11-21	AMLP	ETF	51.5	51.75	50.5	50.55	3526760.0
2017-11-21	AMZA	ETF	80.5	80.97	78.4	78.7	160970.0
2017-11-21	ANGL	ETF	30.02	30.05	29.94	30.0	538600.0
2017-11-21	AOA	ETF	54.71	54.84	54.71	54.82	73800.0
2017-11-21	AOK	ETF	34.69	34.78	34.68	34.72	71829.0
2017-11-21	AOM	ETF	38.31	38.4	38.29	38.37	106068.0
2017-11-21	AOR	ETF	45.5	45.61	45.5	45.56	116699.0
2017-11-21	ARGT	ETF	32.01	32.25	32.01	32.07	64100.0
2017-11-21	ARKG	ETF	24.93	25.17	24.779	24.994	70600.0
2017-11-21	ARKK	ETF	36.13	36.52	36.08	36.44	193500.0
2017-11-21	ARKQ	ETF	33.89	34.47	33.828	34.45	202900.0
2017-11-21	ARKW	ETF	44.78	45.27	44.75	45.27	137000.0
2017-11-21	ASEA	ETF	16.48	16.48	16.41	16.42	2100.0
2017-11-21	ASET	ETF	28.3154	28.3154	28.3154	28.3154	429.0
2017-11-21	ASHR	ETF	32.31	32.5	32.26	32.45	1871400.0
2017-11-21	ASHS	ETF	35.54	35.73	35.5	35.67	6300.0
2017-11-21	ASHX	ETF	23.81	24.0	23.81	24.0	8594.0
2017-11-21	ATMP	ETF	20.35	20.35	19.71	19.72	673400.0
2017-11-21	BAB	ETF	30.64	30.655	30.55	30.6	55699.0
2017-11-21	BAL	ETF	46.76	46.87	46.149	46.149	16620.0
2017-11-21	BAR	ETF	12.807	12.828	12.795	12.795	23740.0

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

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