PREVIEW / etf_daily / 2016-06-14

all etf daily files

  file:    by_date/etf_daily/2016/2016-06-14.parquet
  size:    51 KB
  rows:    1,287

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-06-14	SPY	ETF	208.0	208.74	206.92	208.04	125059300.0
2016-06-14	QQQ	ETF	107.78	108.415	107.24	108.03	24588506.0
2016-06-14	IWM	ETF	114.39	115.11	113.67	114.48	34267600.0
2016-06-14	DIA	ETF	177.0	177.42	176.0	176.81	3643400.0
2016-06-14	GLD	ETF	123.0	123.06	122.3	122.77	11651700.0
2016-06-14	TLT	ETF	136.19	136.22	135.22	135.28	9012500.0
2016-06-14	AADR	ETF	37.95	37.95	37.95	37.95	100.0
2016-06-14	AAXJ	ETF	52.79	53.02	52.52	52.9	1168100.0
2016-06-14	ACTX	ETF	3.54	3.54	3.54	3.54	643.0
2016-06-14	ACWF	ETF	22.5401	22.5401	22.5401	22.5401	183.0
2016-06-14	ACWI	ETF	55.84	56.03	55.44	55.73	3449400.0
2016-06-14	ACWV	ETF	74.08	74.24	73.88	74.23	285200.0
2016-06-14	ACWX	ETF	38.7	38.82	38.33	38.52	1653901.0
2016-06-14	ADRE	ETF	29.76	29.77	29.73	29.77	1273.0
2016-06-14	AFK	ETF	20.27	20.43	19.73	19.94	23597.0
2016-06-14	AFTY	ETF	12.251	12.29	12.239	12.239	400.0
2016-06-14	AGG	ETF	111.68	111.73	111.55	111.56	1871500.0
2016-06-14	AGGY	ETF	51.45	51.45	51.14	51.14	5200.0
2016-06-14	AGNG	ETF	15.37	15.37	15.37	15.37	500.0
2016-06-14	AGQ	ETF	41.45	41.45	40.7	41.07	114700.0
2016-06-14	AGZ	ETF	115.54	115.5428	115.34	115.37	8865.0
2016-06-14	AGZD	ETF	23.86	23.86	23.815	23.815	7400.0
2016-06-14	AIA	ETF	42.83	43.0675	42.67	42.9	24888.0
2016-06-14	AIQ	ETF	6.65	6.6712	6.2563	6.28	34121.0
2016-06-14	AIRR	ETF	18.17	18.189	17.96	18.01	9600.0
2016-06-14	AIVI	ETF	37.15	37.15	36.71	36.95	67400.0
2016-06-14	AMJ	ETF	30.5	30.57	29.84	30.32	2070936.0
2016-06-14	AMLP	ETF	61.9	62.05	60.5	61.45	2256880.0
2016-06-14	AMZA	ETF	110.1	110.1	105.0	109.6	14650.0
2016-06-14	ANGL	ETF	27.22	27.24	27.06	27.08	68300.0
2016-06-14	AOA	ETF	45.24	45.24	44.92	45.14	23700.0
2016-06-14	AOK	ETF	32.61	32.61	32.36	32.4	40170.0
2016-06-14	AOM	ETF	35.0	35.28	34.79	34.89	94286.0
2016-06-14	AOR	ETF	39.5	39.5599	39.26	39.4	98548.0
2016-06-14	ARGT	ETF	21.42	21.62	21.25	21.48	34300.0
2016-06-14	ARKG	ETF	17.12	17.12	16.75	16.825	1800.0
2016-06-14	ARKK	ETF	19.43	19.43	19.14	19.24	6700.0
2016-06-14	ARKQ	ETF	19.292	19.292	19.292	19.292	100.0
2016-06-14	ARKW	ETF	22.38	22.4	22.08	22.08	3800.0
2016-06-14	ASEA	ETF	12.95	12.95	12.85	12.9	4200.0
2016-06-14	ASET	ETF	25.84	25.84	25.84	25.84	100.0
2016-06-14	ASHR	ETF	22.96	23.11	22.9	23.1	1833300.0
2016-06-14	ASHS	ETF	31.92	32.04	31.84	32.04	10400.0
2016-06-14	ASHX	ETF	20.7501	20.8499	20.75	20.8499	1620.0
2016-06-14	ATMP	ETF	20.93	21.23	20.64	20.9	19600.0
2016-06-14	BAB	ETF	31.33	31.393	31.16	31.21	179322.0
2016-06-14	BAL	ETF	42.05	42.41	41.77	42.41	20319.0
2016-06-14	BBC	ETF	19.19	19.35	18.6594	18.835	10646.0
2016-06-14	BBH	ETF	103.99	104.84	102.83	103.85	64100.0
2016-06-14	BBP	ETF	26.98	27.065	26.518	26.85	3600.0

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

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