PREVIEW / etf_daily / 2016-04-08

all etf daily files

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

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-04-08	SPY	ETF	205.34	205.85	203.87	204.5	95040600.0
2016-04-08	QQQ	ETF	109.77	110.02	108.615	109.0	22897951.0
2016-04-08	IWM	ETF	109.61	110.07	108.63	109.11	26151700.0
2016-04-08	DIA	ETF	176.25	176.81	175.11	175.66	2565300.0
2016-04-08	GLD	ETF	118.07	118.77	117.98	118.43	9078900.0
2016-04-08	TLT	ETF	132.17	132.4	131.64	132.01	5584800.0
2016-04-08	AADR	ETF	38.15	38.15	38.09	38.14	3100.0
2016-04-08	AAXJ	ETF	53.6	53.73	53.22	53.35	1186300.0
2016-04-08	ACTX	ETF	5.9001	5.9001	4.72	5.31	847.0
2016-04-08	ACWI	ETF	55.59	55.81	55.37	55.55	3401200.0
2016-04-08	ACWV	ETF	73.55	73.74	73.37	73.51	146900.0
2016-04-08	ACWX	ETF	38.96	39.1	38.85	38.97	898898.0
2016-04-08	ADRE	ETF	30.4	30.615	30.3601	30.37	5002.0
2016-04-08	AFK	ETF	18.92	19.1001	18.723	18.89	132165.0
2016-04-08	AFTY	ETF	12.909	12.909	12.72	12.73	22800.0
2016-04-08	AGG	ETF	111.0	111.0	110.81	110.88	2318300.0
2016-04-08	AGGY	ETF	50.79	50.8	50.718	50.757	14000.0
2016-04-08	AGQ	ETF	32.01	32.69	31.99	32.56	158300.0
2016-04-08	AGZ	ETF	114.75	114.85	114.63	114.85	11848.0
2016-04-08	AGZD	ETF	23.55	23.76	23.55	23.76	3000.0
2016-04-08	AIA	ETF	42.42	42.57	42.1877	42.2001	31342.0
2016-04-08	AIQ	ETF	7.01	7.07	6.93	7.0	8412.0
2016-04-08	AIVI	ETF	37.82	38.0	37.82	37.84	11400.0
2016-04-08	ALTY	ETF	14.246	14.328	14.246	14.311	6000.0
2016-04-08	AMJ	ETF	26.69	27.25	26.69	26.93	2088500.0
2016-04-08	AMLP	ETF	54.65	55.05	54.05	54.45	1487280.0
2016-04-08	AMZA	ETF	87.3	88.8	85.92	87.3	5250.0
2016-04-08	ANGL	ETF	25.79	25.98	25.71	25.77	67800.0
2016-04-08	AOA	ETF	44.94	45.0	44.75	44.82	65500.0
2016-04-08	AOK	ETF	32.27	32.2799	32.1701	32.24	33387.0
2016-04-08	AOM	ETF	34.65	34.6905	34.52	34.61	130048.0
2016-04-08	AOR	ETF	39.15	39.2067	39.03	39.06	120279.0
2016-04-08	ARGT	ETF	18.71	18.88	18.67	18.88	13200.0
2016-04-08	ARKG	ETF	18.57	18.69	18.26	18.366	3000.0
2016-04-08	ARKK	ETF	19.39	19.39	19.39	19.39	200.0
2016-04-08	ARKW	ETF	20.873	20.88	20.59	20.73	9800.0
2016-04-08	ASEA	ETF	13.48	13.48	13.2	13.26	700.0
2016-04-08	ASHR	ETF	24.5	24.53	24.24	24.36	1673700.0
2016-04-08	ASHS	ETF	34.99	35.04	34.69	34.81	12000.0
2016-04-08	ATMP	ETF	17.91	18.3	17.91	18.03	138000.0
2016-04-08	BAB	ETF	30.39	30.489	30.2901	30.35	298939.0
2016-04-08	BAL	ETF	39.31	39.59	39.29	39.41	4804.0
2016-04-08	BBC	ETF	21.75	21.75	20.67	20.72	10235.0
2016-04-08	BBH	ETF	110.97	111.0	108.32	109.08	69600.0
2016-04-08	BBP	ETF	26.67	26.67	25.761	25.993	3600.0
2016-04-08	BCM	ETF	24.385	24.45	24.384	24.45	838.0
2016-04-08	BFOR	ETF	7.5075	7.5075	7.4175	7.4375	58000.0
2016-04-08	BIB	ETF	48.56	48.56	45.25	46.12	1341140.0
2016-04-08	BICK	ETF	19.62	19.6401	19.62	19.6401	300.0
2016-04-08	BIL	ETF	91.38	91.4	91.38	91.4	191950.0

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

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