PREVIEW / etf_daily / 2016-09-22

all etf daily files

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

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-22	SPY	ETF	217.0	217.53	216.71	217.18	76678700.0
2016-09-22	QQQ	ETF	118.85	119.22	118.7177	119.09	22614422.0
2016-09-22	IWM	ETF	124.73	125.8	124.66	125.7	36287700.0
2016-09-22	DIA	ETF	183.66	184.26	183.32	183.66	2323500.0
2016-09-22	GLD	ETF	127.57	128.2	127.5	127.57	15188000.0
2016-09-22	TLT	ETF	136.67	137.29	136.5	136.95	12426200.0
2016-09-22	AADR	ETF	40.9	41.02	40.75	41.01	1700.0
2016-09-22	AAXJ	ETF	61.38	61.63	61.29	61.43	2209600.0
2016-09-22	ACTX	ETF	7.6701	7.6701	5.9001	5.9001	171.0
2016-09-22	ACWI	ETF	59.55	59.76	59.45	59.54	2545700.0
2016-09-22	ACWV	ETF	76.94	77.12	76.86	77.0	103500.0
2016-09-22	ACWX	ETF	42.2	42.26	41.94	42.0	242480.0
2016-09-22	ADRE	ETF	35.42	35.5756	35.26	35.4	19975.0
2016-09-22	AFK	ETF	20.58	20.7899	20.35	20.63	22652.0
2016-09-22	AFTY	ETF	13.56	13.58	13.53	13.53	4200.0
2016-09-22	AGG	ETF	112.1	112.35	112.1	112.26	2017200.0
2016-09-22	AGGY	ETF	51.84	51.99	51.84	51.98	10500.0
2016-09-22	AGQ	ETF	52.33	52.75	51.59	51.85	200400.0
2016-09-22	AGZ	ETF	115.3315	115.5778	115.33	115.42	8796.0
2016-09-22	AGZD	ETF	23.98	23.98	23.975	23.975	7000.0
2016-09-22	AIA	ETF	50.65	50.68	50.42	50.5	121413.0
2016-09-22	AIQ	ETF	6.79	7.25	6.79	6.88	46036.0
2016-09-22	AIRR	ETF	20.25	20.31	20.165	20.3	4900.0
2016-09-22	AIVI	ETF	39.25	39.35	39.1	39.12	12000.0
2016-09-22	ALTY	ETF	15.755	15.755	15.676	15.68	5100.0
2016-09-22	AMJ	ETF	31.25	31.49	30.998	31.42	1608521.0
2016-09-22	AMLP	ETF	62.9	63.25	62.75	63.05	1126840.0
2016-09-22	AMZA	ETF	115.0	116.5	114.2	115.4	22100.0
2016-09-22	ANGL	ETF	28.61	28.68	28.61	28.64	94600.0
2016-09-22	AOA	ETF	47.65	47.94	47.65	47.79	48000.0
2016-09-22	AOK	ETF	33.4	33.46	33.271	33.42	54165.0
2016-09-22	AOM	ETF	36.13	36.241	36.04	36.04	77023.0
2016-09-22	AOR	ETF	41.28	41.3599	41.2001	41.26	59018.0
2016-09-22	ARGT	ETF	23.25	23.62	22.96	23.62	43700.0
2016-09-22	ARKG	ETF	19.95	19.95	19.95	19.95	1100.0
2016-09-22	ARKK	ETF	21.75	21.85	21.75	21.85	1200.0
2016-09-22	ARKQ	ETF	21.66	21.69	21.66	21.69	400.0
2016-09-22	ARKW	ETF	25.17	25.17	25.17	25.17	600.0
2016-09-22	ASEA	ETF	14.31	14.32	14.13	14.17	16000.0
2016-09-22	ASET	ETF	27.03	27.04	27.03	27.04	400.0
2016-09-22	ASHR	ETF	25.0	25.0	24.85	24.9	580300.0
2016-09-22	ASHS	ETF	35.04	35.11	34.96	34.98	3700.0
2016-09-22	ATMP	ETF	23.0	23.27	23.0	23.24	71700.0
2016-09-22	BAB	ETF	31.23	31.359	31.23	31.28	145759.0
2016-09-22	BAL	ETF	47.89	47.94	47.522	47.6201	8537.0
2016-09-22	BBC	ETF	23.13	23.13	22.7558	23.12	11703.0
2016-09-22	BBH	ETF	118.76	119.36	117.9	119.17	38500.0
2016-09-22	BBP	ETF	34.66	34.66	33.992	34.62	8200.0
2016-09-22	BCM	ETF	26.3	26.3	26.23	26.2716	1044.0
2016-09-22	BFOR	ETF	8.06	8.135	8.06	8.135	34400.0

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

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