PREVIEW / etf_daily / 2016-01-08

all etf daily files

  file:    by_date/etf_daily/2016/2016-01-08.parquet
  size:    50 KB
  rows:    1,247

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-01-08	SPY	ETF	195.19	195.85	191.58	191.92	209817200.0
2016-01-08	QQQ	ETF	105.67	106.29	103.9	104.01	69344012.0
2016-01-08	IWM	ETF	105.87	106.49	103.66	103.85	60299300.0
2016-01-08	DIA	ETF	165.96	166.39	163.0	163.24	12512400.0
2016-01-08	GLD	ETF	105.48	105.8	105.04	105.68	7678200.0
2016-01-08	TLT	ETF	122.43	123.47	122.23	123.36	9577200.0
2016-01-08	AAXJ	ETF	49.97	49.97	49.08	49.11	4737400.0
2016-01-08	ACTX	ETF	8.2601	8.8501	8.2601	8.8501	792.0
2016-01-08	ACWF	ETF	22.28	22.28	22.0	22.0	2243.0
2016-01-08	ACWI	ETF	53.11	53.23	52.11	52.18	2437800.0
2016-01-08	ACWV	ETF	67.62	67.62	66.62	66.73	127500.0
2016-01-08	ACWX	ETF	37.44	37.5346	36.77	36.84	1841544.0
2016-01-08	ADRE	ETF	27.21	27.46	26.51	26.51	7628.0
2016-01-08	AFK	ETF	16.9	16.93	16.58	16.7499	18830.0
2016-01-08	AFTY	ETF	12.84	12.88	12.71	12.75	17500.0
2016-01-08	AGG	ETF	108.57	108.71	108.35	108.66	4016900.0
2016-01-08	AGQ	ETF	28.03	28.12	27.3	27.54	283700.0
2016-01-08	AGZ	ETF	113.37	113.51	113.2601	113.5	57998.0
2016-01-08	AGZD	ETF	24.015	24.015	23.955	23.955	800.0
2016-01-08	AIA	ETF	39.44	39.44	38.925	38.94	51527.0
2016-01-08	AIQ	ETF	7.92	8.12	7.92	8.02	23260.0
2016-01-08	AIRR	ETF	15.49	15.493	15.28	15.384	2000.0
2016-01-08	AIVI	ETF	36.45	36.45	35.8	35.8	20800.0
2016-01-08	ALTY	ETF	13.525	13.525	13.525	13.525	300.0
2016-01-08	AMJ	ETF	26.28	27.17	26.26	26.72	7557387.0
2016-01-08	AMLP	ETF	54.55	56.0	54.25	54.95	4146920.0
2016-01-08	AMZA	ETF	100.0	100.0	92.6	93.2	2750.0
2016-01-08	ANGL	ETF	24.29	24.3	24.22	24.24	20900.0
2016-01-08	AOA	ETF	43.35	43.35	42.6	42.63	211000.0
2016-01-08	AOK	ETF	31.23	31.289	31.11	31.13	42815.0
2016-01-08	AOM	ETF	33.61	33.61	33.28	33.28	452492.0
2016-01-08	AOR	ETF	37.86	37.86	37.41	37.41	333006.0
2016-01-08	ARGT	ETF	17.1	17.13	16.8	16.81	28100.0
2016-01-08	ARKG	ETF	19.287	19.287	18.9	18.9	600.0
2016-01-08	ARKK	ETF	18.83	18.83	18.83	18.83	600.0
2016-01-08	ARKQ	ETF	17.57	17.57	17.57	17.57	100.0
2016-01-08	ARKW	ETF	21.254	21.27	21.254	21.26	3500.0
2016-01-08	ASEA	ETF	11.67	11.67	11.5	11.5	3300.0
2016-01-08	ASET	ETF	23.33	23.33	23.33	23.33	100.0
2016-01-08	ASHR	ETF	24.65	24.71	24.19	24.26	2061400.0
2016-01-08	ASHS	ETF	35.08	35.17	34.41	34.45	81200.0
2016-01-08	ASHX	ETF	22.54	22.54	22.4001	22.4001	605.0
2016-01-08	ATMP	ETF	17.42	17.64	17.1	17.43	47700.0
2016-01-08	BAB	ETF	29.39	29.58	29.39	29.57	394033.0
2016-01-08	BAL	ETF	40.7178	41.0	40.6701	40.6701	2932.0
2016-01-08	BBC	ETF	24.9341	24.9341	23.755	23.81	5807.0
2016-01-08	BBH	ETF	118.76	119.62	115.87	115.94	110200.0
2016-01-08	BBP	ETF	27.74	28.056	27.11	27.11	7800.0
2016-01-08	BCM	ETF	23.04	23.04	22.93	22.962	5417.0
2016-01-08	BDCZ	ETF	19.97	19.97	19.93	19.93	300.0

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

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