PREVIEW / etf_daily / 2016-09-21

all etf daily files

  file:    by_date/etf_daily/2016/2016-09-21.parquet
  size:    52 KB
  rows:    1,303

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
2016-09-21	SPY	ETF	214.24	216.03	213.44	215.82	110284400.0
2016-09-21	QQQ	ETF	117.48	118.32	116.81	118.15	31546776.0
2016-09-21	IWM	ETF	122.58	123.97	122.1	123.92	30784700.0
2016-09-21	DIA	ETF	181.66	182.84	180.96	182.66	4496500.0
2016-09-21	GLD	ETF	126.33	127.42	125.96	127.27	13646400.0
2016-09-21	TLT	ETF	134.6	135.89	134.18	135.87	10698100.0
2016-09-21	AADR	ETF	39.91	40.3	39.6	40.3	2500.0
2016-09-21	AAXJ	ETF	60.26	61.25	60.14	61.21	2175100.0
2016-09-21	ACTX	ETF	7.0801	7.6701	5.9001	6.3131	1950.0
2016-09-21	ACWI	ETF	58.5	59.16	58.38	59.11	2570400.0
2016-09-21	ACWV	ETF	75.86	76.61	75.57	76.54	305000.0
2016-09-21	ACWX	ETF	41.22	41.65	41.08	41.59	614983.0
2016-09-21	ADRE	ETF	34.39	35.11	34.39	35.008	20343.0
2016-09-21	AFK	ETF	19.88	20.4999	19.88	20.42	4775.0
2016-09-21	AGG	ETF	111.69	112.03	111.65	112.03	1899500.0
2016-09-21	AGGY	ETF	51.71	51.86	51.664	51.74	4000.0
2016-09-21	AGQ	ETF	50.23	51.78	50.0	51.61	310700.0
2016-09-21	AGZ	ETF	115.15	115.49	115.051	115.25	15962.0
2016-09-21	AIA	ETF	49.74	50.31	49.3	50.31	59699.0
2016-09-21	AIQ	ETF	6.589	6.84	6.526	6.71	26853.0
2016-09-21	AIRR	ETF	19.84	19.867	19.84	19.84	800.0
2016-09-21	AIVI	ETF	38.21	38.62	38.16	38.62	13100.0
2016-09-21	ALTY	ETF	15.52	15.604	15.453	15.604	900.0
2016-09-21	AMJ	ETF	30.28	30.98	30.17	30.93	1093492.0
2016-09-21	AMLP	ETF	61.55	62.55	61.5	62.45	1153840.0
2016-09-21	AMZA	ETF	113.2	114.2	112.5	114.01	23530.0
2016-09-21	ANGL	ETF	28.44	28.52	28.4	28.51	114700.0
2016-09-21	AOA	ETF	47.05	47.49	47.01	47.45	28300.0
2016-09-21	AOK	ETF	33.17	33.29	33.0798	33.2696	68780.0
2016-09-21	AOM	ETF	35.75	36.019	35.6576	35.95	132050.0
2016-09-21	AOR	ETF	40.83	41.05	40.65	41.04	205528.0
2016-09-21	ARGT	ETF	22.79	23.19	22.67	23.09	10200.0
2016-09-21	ARKG	ETF	19.75	20.016	19.579	20.016	5300.0
2016-09-21	ARKK	ETF	21.364	21.364	21.25	21.25	2200.0
2016-09-21	ARKQ	ETF	21.32	21.32	21.32	21.32	200.0
2016-09-21	ARKW	ETF	24.691	24.691	24.691	24.691	100.0
2016-09-21	ASEA	ETF	13.93	14.17	13.92	14.17	7100.0
2016-09-21	ASHR	ETF	24.6	24.87	24.6	24.84	651800.0
2016-09-21	ASHS	ETF	34.69	34.95	34.62	34.95	9500.0
2016-09-21	ATMP	ETF	22.59	22.87	22.58	22.87	26800.0
2016-09-21	BAB	ETF	31.16	31.25	31.02	31.25	142696.0
2016-09-21	BAL	ETF	47.3	47.905	46.99	47.76	23377.0
2016-09-21	BBC	ETF	22.91	23.0	22.16	22.88	16972.0
2016-09-21	BBH	ETF	118.03	118.45	116.1	118.17	36200.0
2016-09-21	BBP	ETF	33.91	34.195	33.292	34.18	17200.0
2016-09-21	BCM	ETF	25.9	26.01	25.9	26.0091	1574.0
2016-09-21	BFIT	ETF	15.9	15.9	15.8999	15.8999	501.0
2016-09-21	BFOR	ETF	7.965	8.045	7.965	8.04	50800.0
2016-09-21	BIB	ETF	51.0	51.64	49.25	51.33	1043764.0
2016-09-21	BIL	ETF	91.44	91.46	91.44	91.44	536150.0

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

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