PREVIEW / etf_daily / 2016-03-21

all etf daily files

  file:    by_date/etf_daily/2016/2016-03-21.parquet
  size:    50 KB
  rows:    1,246

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-03-21	SPY	ETF	204.07	204.94	203.8	204.67	72926700.0
2016-03-21	QQQ	ETF	107.16	107.89	107.12	107.79	17288559.0
2016-03-21	IWM	ETF	109.44	109.94	109.08	109.35	29903700.0
2016-03-21	DIA	ETF	175.62	176.21	175.25	176.01	2884900.0
2016-03-21	GLD	ETF	119.0	119.33	118.73	118.96	7240600.0
2016-03-21	TLT	ETF	128.25	128.62	127.75	128.07	5514800.0
2016-03-21	AADR	ETF	38.38	38.4	38.18	38.23	1600.0
2016-03-21	AAXJ	ETF	54.27	54.47	54.19	54.38	442200.0
2016-03-21	ACTX	ETF	7.6701	8.8501	5.31	7.0801	2581.0
2016-03-21	ACWI	ETF	55.82	56.08	55.78	56.0	1104400.0
2016-03-21	ACWV	ETF	72.72	72.98	72.04	72.75	319500.0
2016-03-21	ACWX	ETF	39.53	39.64	39.435	39.57	651873.0
2016-03-21	ADRE	ETF	30.64	30.855	30.64	30.8499	8440.0
2016-03-21	AFK	ETF	19.5	19.7268	19.3	19.58	15616.0
2016-03-21	AFTY	ETF	13.18	13.2	13.1	13.197	19300.0
2016-03-21	AGG	ETF	110.06	110.13	109.91	109.93	2152300.0
2016-03-21	AGGY	ETF	50.07	50.21	50.03	50.13	90900.0
2016-03-21	AGQ	ETF	34.51	34.95	34.3	34.75	126400.0
2016-03-21	AGZ	ETF	114.21	114.2599	114.12	114.19	15263.0
2016-03-21	AGZD	ETF	23.76	23.925	23.735	23.775	2200.0
2016-03-21	AIA	ETF	43.03	43.096	42.98	43.05	2822.0
2016-03-21	AIQ	ETF	7.035	7.1568	6.825	6.86	21645.0
2016-03-21	AIRR	ETF	17.36	17.46	17.35	17.46	1800.0
2016-03-21	AIVI	ETF	38.28	38.38	38.22	38.24	15200.0
2016-03-21	AMJ	ETF	27.74	27.74	26.7189	26.82	2173105.0
2016-03-21	AMLP	ETF	55.5	55.6	53.75	54.2	2076100.0
2016-03-21	AMZA	ETF	93.2	93.8	88.25	89.5	9500.0
2016-03-21	ANGL	ETF	26.03	26.09	25.97	26.03	84500.0
2016-03-21	AOA	ETF	45.22	45.22	44.99	45.2	58000.0
2016-03-21	AOK	ETF	32.11	32.1599	32.09	32.13	28420.0
2016-03-21	AOM	ETF	34.59	34.67	34.5	34.65	80721.0
2016-03-21	AOR	ETF	39.18	39.3267	39.18	39.29	99836.0
2016-03-21	ARGT	ETF	19.29	19.48	19.14	19.29	65600.0
2016-03-21	ARKG	ETF	17.25	17.25	17.175	17.19	1400.0
2016-03-21	ARKK	ETF	18.685	18.685	18.685	18.685	100.0
2016-03-21	ARKQ	ETF	18.61	18.61	18.61	18.61	100.0
2016-03-21	ARKW	ETF	20.19	20.25	20.19	20.25	600.0
2016-03-21	ASEA	ETF	13.44	13.44	13.44	13.44	300.0
2016-03-21	ASET	ETF	25.58	25.58	25.56	25.56	200.0
2016-03-21	ASHR	ETF	25.02	25.11	24.86	25.06	3282600.0
2016-03-21	ASHS	ETF	34.47	34.72	34.4	34.67	39600.0
2016-03-21	ATMP	ETF	18.21	18.25	17.86	18.02	41500.0
2016-03-21	BAB	ETF	29.85	29.92	29.8	29.85	234774.0
2016-03-21	BAL	ETF	37.54	38.17	37.54	38.038	8099.0
2016-03-21	BBC	ETF	17.52	18.8199	17.52	18.5235	11793.0
2016-03-21	BBH	ETF	100.02	102.55	99.81	101.98	71700.0
2016-03-21	BBP	ETF	23.35	24.136	23.35	23.98	4900.0
2016-03-21	BCM	ETF	25.06	25.1	24.9105	25.1	3143.0
2016-03-21	BDCZ	ETF	20.16	20.16	20.16	20.16	2000.0
2016-03-21	BFOR	ETF	7.4775	7.5	7.455	7.485	49200.0

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

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