PREVIEW / etf_daily / 2017-12-04

all etf daily files

  file:    by_date/etf_daily/2017/2017-12-04.parquet
  size:    59 KB
  rows:    1,531

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-12-04	SPY	ETF	266.31	266.8	264.08	264.14	94040600.0
2017-12-04	QQQ	ETF	155.47	155.625	152.56	152.71	51319146.0
2017-12-04	IWM	ETF	154.9	155.41	152.3	152.45	36366800.0
2017-12-04	DIA	ETF	245.01	245.57	243.07	243.11	6565800.0
2017-12-04	GLD	ETF	121.15	121.2	120.84	121.18	6943700.0
2017-12-04	TLT	ETF	125.92	126.67	125.81	126.61	9609200.0
2017-12-04	AADR	ETF	55.8	55.8	55.09	55.27	23700.0
2017-12-04	AAXJ	ETF	75.81	75.97	74.95	75.0	1450100.0
2017-12-04	ACSI	ETF	31.281	31.3	31.139	31.139	3151.0
2017-12-04	ACTX	ETF	71.9806	72.5707	60.1805	70.2106	700.0
2017-12-04	ACWF	ETF	30.64	30.64	30.3567	30.37	9199.0
2017-12-04	ACWI	ETF	71.88	72.03	71.36	71.36	2408800.0
2017-12-04	ACWV	ETF	84.77	84.77	84.26	84.28	69800.0
2017-12-04	ACWX	ETF	49.61	49.61	49.21	49.21	563029.0
2017-12-04	ADRE	ETF	42.52	42.52	41.82	41.82	8145.0
2017-12-04	AFK	ETF	24.32	24.36	24.32	24.32	7254.0
2017-12-04	AFTY	ETF	18.47	18.47	18.301	18.338	6700.0
2017-12-04	AGG	ETF	109.03	109.17	109.0	109.15	2652800.0
2017-12-04	AGGY	ETF	50.61	50.72	50.577	50.652	52600.0
2017-12-04	AGNG	ETF	19.59	19.72	19.436	19.436	6500.0
2017-12-04	AGQ	ETF	31.66	31.72	31.3	31.66	91400.0
2017-12-04	AGZ	ETF	113.22	113.27	113.17	113.27	18275.0
2017-12-04	AGZD	ETF	24.06	24.15	24.06	24.15	17600.0
2017-12-04	AIA	ETF	65.54	65.72	65.0	65.0	195210.0
2017-12-04	AIEQ	ETF	25.76	25.93	25.55	25.56	106500.0
2017-12-04	AIRR	ETF	27.29	27.619	27.241	27.25	34400.0
2017-12-04	AIVI	ETF	43.4	43.44	43.32	43.34	21900.0
2017-12-04	ALTY	ETF	15.28	15.34	15.28	15.34	700.0
2017-12-04	AMJ	ETF	26.71	26.8	26.46	26.47	4159690.0
2017-12-04	AMLP	ETF	52.8	53.0	52.25	52.35	3552700.0
2017-12-04	AMZA	ETF	83.3	83.6	82.32	82.6	90250.0
2017-12-04	ANGL	ETF	30.0	30.01	29.94	29.95	383400.0
2017-12-04	AOA	ETF	55.38	55.44	55.01	55.01	60400.0
2017-12-04	AOK	ETF	34.55	34.59	34.45	34.48	91937.0
2017-12-04	AOM	ETF	38.6	38.6	38.44	38.48	150772.0
2017-12-04	AOR	ETF	45.9	45.91	45.72	45.74	134401.0
2017-12-04	ARGT	ETF	32.77	32.92	32.4	32.4	65200.0
2017-12-04	ARKG	ETF	26.16	26.5	24.99	24.99	44300.0
2017-12-04	ARKK	ETF	38.04	38.09	36.621	36.74	305400.0
2017-12-04	ARKQ	ETF	34.27	34.27	33.13	33.17	73300.0
2017-12-04	ARKW	ETF	45.87	45.96	44.42	44.6	201800.0
2017-12-04	ASEA	ETF	16.69	16.71	16.62	16.62	2700.0
2017-12-04	ASET	ETF	28.6968	28.7	28.69	28.7	5005.0
2017-12-04	ASHR	ETF	30.64	30.65	30.46	30.53	879300.0
2017-12-04	ASHS	ETF	34.55	34.55	34.27	34.27	3000.0
2017-12-04	ASHX	ETF	22.5	22.5	22.5	22.5	100.0
2017-12-04	ATMP	ETF	20.21	20.22	20.03	20.04	569100.0
2017-12-04	BAB	ETF	30.49	30.6	30.45	30.59	128419.0
2017-12-04	BAL	ETF	48.25	48.25	48.22	48.22	1609.0
2017-12-04	BAR	ETF	12.758	12.758	12.728	12.752	55260.0

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

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