PREVIEW / etf_daily / 2017-09-07

all etf daily files

  file:    by_date/etf_daily/2017/2017-09-07.parquet
  size:    56 KB
  rows:    1,439

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-07	SPY	ETF	247.25	247.27	246.4	246.87	58034700.0
2017-09-07	QQQ	ETF	145.4	145.84	144.94	145.47	22721131.0
2017-09-07	IWM	ETF	139.59	139.69	138.59	139.11	18159800.0
2017-09-07	DIA	ETF	218.47	218.72	217.68	218.11	1982800.0
2017-09-07	GLD	ETF	127.56	128.32	127.39	128.13	10219700.0
2017-09-07	TLT	ETF	128.33	129.57	128.33	129.28	13618900.0
2017-09-07	AADR	ETF	53.38	53.96	53.38	53.91	23800.0
2017-09-07	AAXJ	ETF	72.01	72.22	71.94	72.22	585100.0
2017-09-07	ACSI	ETF	28.531	28.63	28.531	28.629	32960.0
2017-09-07	ACTX	ETF	66.0806	70.8006	65.7856	66.0806	371.0
2017-09-07	ACWF	ETF	28.29	28.29	28.252	28.255	1767.0
2017-09-07	ACWI	ETF	67.76	67.81	67.63	67.76	1050200.0
2017-09-07	ACWV	ETF	81.36	81.36	81.15	81.3	45300.0
2017-09-07	ACWX	ETF	47.85	47.8738	47.75	47.87	420767.0
2017-09-07	ADRE	ETF	42.65	42.99	42.61	42.99	11821.0
2017-09-07	AFK	ETF	24.0	24.1	23.91	24.1	10776.0
2017-09-07	AFTY	ETF	17.29	17.319	17.29	17.319	300.0
2017-09-07	AGG	ETF	110.43	110.66	110.42	110.57	1648800.0
2017-09-07	AGGY	ETF	51.02	51.19	51.02	51.19	15500.0
2017-09-07	AGNG	ETF	19.449	19.5	19.41	19.5	1100.0
2017-09-07	AGQ	ETF	38.74	39.51	38.74	39.29	217800.0
2017-09-07	AGZ	ETF	114.33	114.5799	114.33	114.51	18051.0
2017-09-07	AGZD	ETF	23.905	23.91	23.905	23.91	600.0
2017-09-07	AIA	ETF	60.71	60.829	60.66	60.8	25167.0
2017-09-07	AIRR	ETF	23.77	23.77	23.47	23.54	21700.0
2017-09-07	AIVI	ETF	42.83	42.92	42.8	42.9	4900.0
2017-09-07	ALTY	ETF	15.477	15.59	15.45	15.59	4600.0
2017-09-07	AMJ	ETF	28.08	28.195	27.93	28.13	2066736.0
2017-09-07	AMLP	ETF	55.95	56.15	55.65	55.9	1634740.0
2017-09-07	AMZA	ETF	92.1	93.0	91.4	92.3	30470.0
2017-09-07	ANGL	ETF	30.0	30.07	30.0	30.05	313400.0
2017-09-07	AOA	ETF	52.88	52.88	52.77	52.86	30700.0
2017-09-07	AOK	ETF	34.43	34.4664	34.3584	34.45	42495.0
2017-09-07	AOM	ETF	37.78	37.87	37.7633	37.86	84999.0
2017-09-07	AOR	ETF	44.42	44.4564	44.3716	44.44	58781.0
2017-09-07	ARCM	ETF	100.0	100.0	100.0	100.0	10000.0
2017-09-07	ARGT	ETF	30.51	30.68	30.48	30.63	19500.0
2017-09-07	ARKG	ETF	25.15	25.3	24.84	25.3	23400.0
2017-09-07	ARKK	ETF	33.88	34.01	33.65	33.75	79200.0
2017-09-07	ARKQ	ETF	30.01	30.34	30.01	30.27	11800.0
2017-09-07	ARKW	ETF	40.53	40.74	40.33	40.38	50800.0
2017-09-07	ASEA	ETF	15.72	15.72	15.6	15.64	1300.0
2017-09-07	ASET	ETF	28.32	28.32	28.32	28.32	481.0
2017-09-07	ASHR	ETF	30.01	30.05	29.96	29.99	516800.0
2017-09-07	ASHS	ETF	36.95	37.04	36.94	37.0	2300.0
2017-09-07	ATMP	ETF	21.43	21.47	21.26	21.44	49300.0
2017-09-07	BAB	ETF	30.82	30.9793	30.7701	30.92	102412.0
2017-09-07	BAL	ETF	49.05	49.3	48.7163	49.22	21545.0
2017-09-07	BAR	ETF	13.5	13.5	13.487	13.487	12060.0
2017-09-07	BBC	ETF	27.52	28.2963	27.52	28.24	12778.0

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

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