PREVIEW / etf_daily / 2016-04-12

all etf daily files

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

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-12	SPY	ETF	204.22	206.25	203.7	205.92	115350600.0
2016-04-12	QQQ	ETF	108.66	109.72	108.015	109.51	28564087.0
2016-04-12	IWM	ETF	108.79	110.18	108.43	109.94	25058700.0
2016-04-12	DIA	ETF	175.73	177.28	175.36	177.09	3588400.0
2016-04-12	GLD	ETF	120.23	120.35	119.55	120.05	9689500.0
2016-04-12	TLT	ETF	131.08	131.55	130.53	130.93	4276000.0
2016-04-12	AADR	ETF	38.03	38.3	38.0	38.28	1700.0
2016-04-12	AAXJ	ETF	53.99	54.63	53.83	54.46	473200.0
2016-04-12	ACTX	ETF	7.0801	7.0801	5.9001	6.4901	280.0
2016-04-12	ACWI	ETF	55.7	56.32	55.55	56.23	1346000.0
2016-04-12	ACWV	ETF	73.61	74.1	73.37	73.97	134600.0
2016-04-12	ACWX	ETF	39.4	39.78	39.17	39.7	706088.0
2016-04-12	ADRE	ETF	30.8701	31.337	30.738	31.337	4684.0
2016-04-12	AFK	ETF	19.1	19.48	18.97	19.48	84562.0
2016-04-12	AFTY	ETF	12.86	12.94	12.86	12.94	1900.0
2016-04-12	AGG	ETF	110.85	110.86	110.65	110.78	1984500.0
2016-04-12	AGGY	ETF	50.66	50.69	50.605	50.66	5000.0
2016-04-12	AGQ	ETF	35.51	36.24	35.18	36.13	412800.0
2016-04-12	AGZ	ETF	114.71	114.8599	114.567	114.68	30961.0
2016-04-12	AGZD	ETF	23.74	23.83	23.74	23.775	12400.0
2016-04-12	AIA	ETF	42.75	43.1599	42.58	43.03	17958.0
2016-04-12	AIQ	ETF	6.9	7.0	6.9	6.97	10688.0
2016-04-12	AIRR	ETF	17.342	17.534	17.342	17.534	1200.0
2016-04-12	AIVI	ETF	38.16	38.53	37.96	38.52	14700.0
2016-04-12	ALTY	ETF	14.4	14.44	14.337	14.43	1200.0
2016-04-12	AMJ	ETF	26.94	28.049	26.9	27.85	2016571.0
2016-04-12	AMLP	ETF	54.65	56.95	54.5	56.5	2168880.0
2016-04-12	AMZA	ETF	89.3	93.6	88.2	92.74	10830.0
2016-04-12	ANGL	ETF	25.86	25.99	25.8	25.97	87500.0
2016-04-12	AOA	ETF	44.99	45.29	44.83	45.25	28600.0
2016-04-12	AOK	ETF	32.25	32.3399	32.205	32.31	42179.0
2016-04-12	AOM	ETF	34.65	34.75	34.5295	34.69	64939.0
2016-04-12	AOR	ETF	39.06	39.37	39.06	39.36	60407.0
2016-04-12	ARGT	ETF	19.14	19.58	19.14	19.58	36700.0
2016-04-12	ARKG	ETF	18.01	18.19	18.01	18.19	1100.0
2016-04-12	ARKK	ETF	19.49	19.49	19.49	19.49	3100.0
2016-04-12	ARKQ	ETF	18.93	19.03	18.91	18.99	3900.0
2016-04-12	ARKW	ETF	20.56	20.569	20.55	20.55	1000.0
2016-04-12	ASEA	ETF	13.2	13.51	13.18	13.51	4500.0
2016-04-12	ASHR	ETF	24.59	24.76	24.42	24.74	1262600.0
2016-04-12	ASHS	ETF	35.12	35.53	35.05	35.52	21300.0
2016-04-12	ATMP	ETF	18.17	19.02	18.17	18.92	21800.0
2016-04-12	BAB	ETF	30.36	30.36	30.2	30.28	112356.0
2016-04-12	BAL	ETF	40.38	40.45	39.56	40.1899	9646.0
2016-04-12	BBC	ETF	20.26	20.45	19.77	20.36	25635.0
2016-04-12	BBH	ETF	107.68	109.17	106.95	108.97	66100.0
2016-04-12	BBP	ETF	25.411	25.9	25.36	25.86	7800.0
2016-04-12	BCM	ETF	25.16	25.2646	25.16	25.2219	1618.0
2016-04-12	BFOR	ETF	7.435	7.4975	7.405	7.475	85200.0
2016-04-12	BIB	ETF	44.43	45.82	43.75	45.58	1058123.0

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

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