PREVIEW / etf_daily / 2017-09-14

all etf daily files

  file:    by_date/etf_daily/2017/2017-09-14.parquet
  size:    57 KB
  rows:    1,452

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-09-14	SPY	ETF	249.8	250.32	249.6	250.09	95446300.0
2017-09-14	QQQ	ETF	145.85	146.2869	145.47	145.56	35296413.0
2017-09-14	IWM	ETF	141.78	142.16	141.42	141.83	18353800.0
2017-09-14	DIA	ETF	221.65	222.43	221.62	222.32	1893700.0
2017-09-14	GLD	ETF	125.66	126.44	125.62	126.16	5330700.0
2017-09-14	TLT	ETF	126.37	126.83	126.33	126.81	6674500.0
2017-09-14	AADR	ETF	54.44	54.79	54.4	54.53	43000.0
2017-09-14	AAXJ	ETF	72.47	72.69	72.35	72.6	738100.0
2017-09-14	ACSI	ETF	29.04	29.05	29.03	29.04	3042.0
2017-09-14	ACTX	ETF	72.5707	76.7007	71.3906	75.5207	517.0
2017-09-14	ACWF	ETF	28.46	28.62	28.46	28.53	1088.0
2017-09-14	ACWI	ETF	68.3	68.46	68.25	68.44	358200.0
2017-09-14	ACWV	ETF	81.39	81.58	81.3	81.58	62100.0
2017-09-14	ACWX	ETF	48.0	48.22	48.0	48.21	127780.0
2017-09-14	ADRE	ETF	43.1942	43.44	43.18	43.24	26180.0
2017-09-14	AFK	ETF	23.55	23.64	22.8767	23.5132	19493.0
2017-09-14	AFTY	ETF	17.15	17.15	16.97	17.03	3800.0
2017-09-14	AGG	ETF	109.81	109.97	109.81	109.93	1704200.0
2017-09-14	AGGY	ETF	50.82	50.89	50.786	50.89	16500.0
2017-09-14	AGNG	ETF	19.56	19.56	19.477	19.553	500.0
2017-09-14	AGQ	ETF	37.48	37.9	37.4	37.76	40100.0
2017-09-14	AGZ	ETF	113.85	114.08	113.85	114.07	7273.0
2017-09-14	AGZD	ETF	23.955	24.025	23.955	23.975	1400.0
2017-09-14	AIA	ETF	61.18	61.2499	61.0499	61.17	23617.0
2017-09-14	AIRR	ETF	24.32	24.397	24.316	24.34	14300.0
2017-09-14	AIVI	ETF	42.65	42.83	42.64	42.79	4500.0
2017-09-14	ALTY	ETF	15.63	15.66	15.57	15.593	4900.0
2017-09-14	AMJ	ETF	28.33	28.56	28.3	28.41	1352344.0
2017-09-14	AMLP	ETF	56.65	57.05	56.45	56.8	1785840.0
2017-09-14	AMZA	ETF	93.7	93.8	92.9	93.2	43650.0
2017-09-14	ANGL	ETF	30.06	30.11	30.0	30.11	228600.0
2017-09-14	AOA	ETF	53.11	53.27	53.08	53.27	47900.0
2017-09-14	AOK	ETF	34.33	34.44	34.33	34.41	67068.0
2017-09-14	AOM	ETF	37.77	37.9	37.77	37.88	102273.0
2017-09-14	AOR	ETF	44.57	44.65	44.5452	44.65	42001.0
2017-09-14	ARGT	ETF	31.07	31.35	31.07	31.15	35700.0
2017-09-14	ARKG	ETF	25.51	25.71	25.241	25.49	18100.0
2017-09-14	ARKK	ETF	33.58	33.803	33.3	33.55	70200.0
2017-09-14	ARKQ	ETF	30.8	30.95	30.642	30.9	31100.0
2017-09-14	ARKW	ETF	40.06	40.182	39.54	39.99	63500.0
2017-09-14	ASEA	ETF	15.64	15.67	15.64	15.64	1300.0
2017-09-14	ASET	ETF	28.2	28.29	28.2	28.29	724.0
2017-09-14	ASHR	ETF	29.57	29.65	29.57	29.64	511700.0
2017-09-14	ASHS	ETF	37.26	37.28	37.2	37.24	2100.0
2017-09-14	ASHX	ETF	21.72	21.72	21.72	21.72	100.0
2017-09-14	ATMP	ETF	21.7	21.7	21.57	21.63	22600.0
2017-09-14	BAB	ETF	30.54	30.6243	30.54	30.6	72761.0
2017-09-14	BAL	ETF	45.33	45.6186	45.33	45.58	2133.0
2017-09-14	BAR	ETF	13.2527	13.269	13.2527	13.269	29460.0
2017-09-14	BBC	ETF	27.9	27.9	27.52	27.79	8870.0

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

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