PREVIEW / etf_daily / 2017-03-28

all etf daily files

  file:    by_date/etf_daily/2017/2017-03-28.parquet
  size:    54 KB
  rows:    1,365

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-03-28	SPY	ETF	233.27	235.81	233.14	235.32	93483900.0
2017-03-28	QQQ	ETF	130.81	132.03	130.55	131.64	23721947.0
2017-03-28	IWM	ETF	134.28	135.9	134.14	135.79	26891900.0
2017-03-28	DIA	ETF	205.08	207.07	204.91	206.75	3538000.0
2017-03-28	GLD	ETF	119.74	119.83	118.78	119.04	7112800.0
2017-03-28	TLT	ETF	121.79	121.82	120.49	120.62	6811200.0
2017-03-28	AADR	ETF	46.33	46.51	46.3	46.48	4300.0
2017-03-28	AAXJ	ETF	63.17	63.62	63.17	63.5	1003000.0
2017-03-28	ACSI	ETF	27.56	27.85	27.56	27.85	2455.0
2017-03-28	ACTX	ETF	100.8909	106.201	99.5339	106.201	1231.0
2017-03-28	ACWI	ETF	63.07	63.51	63.04	63.41	4208000.0
2017-03-28	ACWV	ETF	77.41	77.65	77.33	77.6	426000.0
2017-03-28	ACWX	ETF	43.74	43.93	43.74	43.85	1348336.0
2017-03-28	ADRE	ETF	36.67	36.93	36.67	36.77	23805.0
2017-03-28	AFK	ETF	20.91	21.09	20.86	20.86	10173.0
2017-03-28	AFTY	ETF	13.91	13.91	13.81	13.81	600.0
2017-03-28	AGG	ETF	108.63	108.68	108.35	108.37	2016100.0
2017-03-28	AGGY	ETF	49.85	49.86	49.71	49.71	10600.0
2017-03-28	AGNG	ETF	16.86	16.86	16.86	16.86	10500.0
2017-03-28	AGQ	ETF	41.05	41.39	40.71	40.9	201100.0
2017-03-28	AGZ	ETF	112.93	113.14	112.9	112.9852	14826.0
2017-03-28	AGZD	ETF	24.03	24.03	24.01	24.02	3200.0
2017-03-28	AIA	ETF	53.08	53.3	53.0356	53.24	9069.0
2017-03-28	AIQ	ETF	10.1	10.15	10.0	10.1	4244.0
2017-03-28	AIRR	ETF	22.97	23.309	22.97	23.28	38900.0
2017-03-28	AIVI	ETF	39.62	39.78	39.62	39.73	14500.0
2017-03-28	ALTY	ETF	15.4	15.476	15.395	15.45	2300.0
2017-03-28	AMJ	ETF	31.45	31.68	31.23	31.5	990711.0
2017-03-28	AMLP	ETF	62.6	62.9	62.55	62.8	1399680.0
2017-03-28	AMZA	ETF	109.5	109.7	108.97	109.4	66550.0
2017-03-28	ANGL	ETF	29.1	29.24	29.07	29.22	187400.0
2017-03-28	AOA	ETF	49.77	50.02	49.72	49.96	35400.0
2017-03-28	AOK	ETF	33.3	33.325	33.2301	33.29	39718.0
2017-03-28	AOM	ETF	36.31	36.41	36.2812	36.32	75191.0
2017-03-28	AOR	ETF	42.3	42.42	42.25	42.42	78530.0
2017-03-28	ARGT	ETF	27.62	27.96	27.62	27.86	50600.0
2017-03-28	ARKG	ETF	20.42	20.44	20.3	20.44	2000.0
2017-03-28	ARKK	ETF	23.56	23.595	23.56	23.595	1200.0
2017-03-28	ARKQ	ETF	24.3	24.336	24.18	24.29	32900.0
2017-03-28	ARKW	ETF	28.5	28.6	28.496	28.58	2700.0
2017-03-28	ASEA	ETF	14.1	14.19	14.1	14.19	2000.0
2017-03-28	ASET	ETF	26.3956	26.41	26.3956	26.41	760.0
2017-03-28	ASHR	ETF	25.19	25.31	25.19	25.21	462500.0
2017-03-28	ASHS	ETF	34.17	34.38	34.17	34.29	12800.0
2017-03-28	ATMP	ETF	23.08	23.37	23.08	23.33	79900.0
2017-03-28	BAB	ETF	29.51	29.5125	29.38	29.4023	178198.0
2017-03-28	BAL	ETF	49.8501	50.2543	49.8501	49.88	5186.0
2017-03-28	BBC	ETF	23.36	23.385	23.14	23.22	4815.0
2017-03-28	BBH	ETF	118.18	118.3	117.7	117.92	28800.0
2017-03-28	BBP	ETF	38.022	38.34	37.83	38.05	12900.0

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

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