PREVIEW / etf_daily / 2016-04-11

all etf daily files

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

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-11	SPY	ETF	205.25	206.07	203.91	204.02	83757500.0
2016-04-11	QQQ	ETF	109.48	110.02	108.585	108.6	25772058.0
2016-04-11	IWM	ETF	109.74	110.55	108.75	108.77	25842100.0
2016-04-11	DIA	ETF	176.12	177.17	175.41	175.44	3237700.0
2016-04-11	GLD	ETF	119.47	120.3	119.42	120.03	9846000.0
2016-04-11	TLT	ETF	131.32	132.18	131.11	131.84	4805500.0
2016-04-11	AADR	ETF	38.31	38.31	38.1	38.12	900.0
2016-04-11	AAXJ	ETF	53.97	54.19	53.82	53.83	548400.0
2016-04-11	ACTX	ETF	5.31	6.4901	5.31	6.4901	158.0
2016-04-11	ACWI	ETF	55.88	56.06	55.52	55.53	1322000.0
2016-04-11	ACWV	ETF	73.84	73.94	73.39	73.47	179600.0
2016-04-11	ACWX	ETF	39.26	39.44	39.06	39.06	356252.0
2016-04-11	ADRE	ETF	30.83	31.02	30.71	30.7307	16408.0
2016-04-11	AFK	ETF	19.05	19.2386	18.87	18.87	46723.0
2016-04-11	AFTY	ETF	12.96	12.96	12.85	12.87	15200.0
2016-04-11	AGG	ETF	110.87	110.96	110.76	110.96	1718400.0
2016-04-11	AGGY	ETF	50.7	50.767	50.65	50.737	43800.0
2016-04-11	AGQ	ETF	34.02	35.17	34.0	34.95	391900.0
2016-04-11	AGZ	ETF	114.58	114.78	114.58	114.76	11621.0
2016-04-11	AGZD	ETF	23.75	23.75	23.67	23.67	4200.0
2016-04-11	AIA	ETF	42.67	42.8299	42.54	42.55	11913.0
2016-04-11	AIQ	ETF	6.9101	7.1	6.9	6.9	12497.0
2016-04-11	AIRR	ETF	17.4	17.53	17.274	17.274	600.0
2016-04-11	AIVI	ETF	38.18	38.37	38.1	38.16	9800.0
2016-04-11	ALTY	ETF	14.312	14.34	14.312	14.34	1000.0
2016-04-11	AMJ	ETF	27.28	27.5201	26.7589	26.87	2345508.0
2016-04-11	AMLP	ETF	55.1	55.85	54.15	54.45	2136040.0
2016-04-11	AMZA	ETF	88.5	90.7	87.5	88.0	5330.0
2016-04-11	ANGL	ETF	25.83	25.83	25.75	25.83	62300.0
2016-04-11	AOA	ETF	45.02	45.19	44.8	44.83	26800.0
2016-04-11	AOK	ETF	32.3	32.3099	32.2	32.22	55407.0
2016-04-11	AOM	ETF	34.65	34.73	34.54	34.54	79759.0
2016-04-11	AOR	ETF	39.19	39.3299	39.03	39.03	88192.0
2016-04-11	ARGT	ETF	19.01	19.28	18.99	19.0	17700.0
2016-04-11	ARKG	ETF	18.34	18.34	18.07	18.07	400.0
2016-04-11	ARKQ	ETF	19.49	19.49	19.056	19.056	1400.0
2016-04-11	ARKW	ETF	20.639	20.639	20.55	20.55	700.0
2016-04-11	ASEA	ETF	13.3	13.3	13.29	13.3	2300.0
2016-04-11	ASET	ETF	25.67	25.67	25.67	25.67	552.0
2016-04-11	ASHR	ETF	24.67	24.83	24.58	24.63	1583900.0
2016-04-11	ASHS	ETF	35.55	35.65	35.36	35.36	15800.0
2016-04-11	ASHX	ETF	21.73	21.81	21.73	21.81	200.0
2016-04-11	ATMP	ETF	18.55	18.55	18.21	18.26	18000.0
2016-04-11	BAB	ETF	30.36	30.44	30.36	30.39	51495.0
2016-04-11	BAL	ETF	39.74	39.86	39.59	39.6	34647.0
2016-04-11	BBC	ETF	20.91	20.91	20.19	20.22	12493.0
2016-04-11	BBH	ETF	109.6	109.75	107.43	107.7	75800.0
2016-04-11	BBP	ETF	26.73	26.73	25.66	25.66	16600.0
2016-04-11	BDCZ	ETF	20.11	20.11	20.11	20.11	592.0
2016-04-11	BFOR	ETF	7.465	7.4825	7.425	7.425	32000.0

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

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