PREVIEW / etf_daily / 2015-07-30

all etf daily files

  file:    by_date/etf_daily/2015/2015-07-30.parquet
  size:    47 KB
  rows:    1,186

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
2015-07-30	SPY	ETF	210.16	211.02	209.42	210.82	91304400.0
2015-07-30	QQQ	ETF	111.29	112.2663	110.621	112.08	25438057.0
2015-07-30	IWM	ETF	121.63	122.44	121.01	122.29	29383900.0
2015-07-30	DIA	ETF	177.04	177.39	176.13	177.22	3659000.0
2015-07-30	GLD	ETF	104.03	104.97	103.86	104.27	6652000.0
2015-07-30	TLT	ETF	121.21	121.94	121.15	121.63	6146600.0
2015-07-30	AAXJ	ETF	59.01	59.07	58.71	59.01	582700.0
2015-07-30	ACTX	ETF	1.77	1.77	1.475	1.77	48.0
2015-07-30	ACWI	ETF	59.62	59.87	59.46	59.86	475000.0
2015-07-30	ACWV	ETF	70.66	70.95	70.39	70.86	98800.0
2015-07-30	ACWX	ETF	43.7	43.81	43.5	43.8	255757.0
2015-07-30	ADRE	ETF	32.76	32.76	32.5608	32.6034	11764.0
2015-07-30	AFK	ETF	22.54	22.5899	22.5001	22.5421	2782.0
2015-07-30	AFTY	ETF	18.349	18.46	18.21	18.46	118200.0
2015-07-30	AGG	ETF	109.08	109.15	108.97	109.07	1959000.0
2015-07-30	AGQ	ETF	31.97	32.33	31.74	31.89	86900.0
2015-07-30	AGZ	ETF	113.12	113.26	113.12	113.26	7233.0
2015-07-30	AGZD	ETF	24.355	24.505	24.295	24.43	8800.0
2015-07-30	AIA	ETF	47.15	47.2596	46.99	47.2596	3432.0
2015-07-30	AIQ	ETF	14.73	14.92	13.65	13.77	64154.0
2015-07-30	AIRR	ETF	17.12	17.39	17.12	17.31	22500.0
2015-07-30	AIVI	ETF	43.0	43.04	42.79	43.01	38500.0
2015-07-30	AMJ	ETF	39.2	39.2	38.46	38.7	1747418.0
2015-07-30	AMLP	ETF	78.1	78.35	77.1	77.45	773240.0
2015-07-30	AMZA	ETF	188.8	190.1	185.5	187.4	2100.0
2015-07-30	ANGL	ETF	27.03	27.03	26.97	27.0	20400.0
2015-07-30	AOA	ETF	47.25	47.27	47.01	47.24	158900.0
2015-07-30	AOK	ETF	32.44	32.54	32.33	32.48	29337.0
2015-07-30	AOM	ETF	35.12	35.14	35.032	35.14	18875.0
2015-07-30	AOR	ETF	40.45	40.48	40.24	40.48	30526.0
2015-07-30	ARGT	ETF	18.59	18.61	18.52	18.52	1200.0
2015-07-30	ARKG	ETF	22.88	22.88	22.655	22.655	600.0
2015-07-30	ARKK	ETF	21.69	21.69	21.65	21.65	2700.0
2015-07-30	ARKQ	ETF	19.577	19.594	19.577	19.594	400.0
2015-07-30	ARKW	ETF	23.86	23.9	23.86	23.9	1100.0
2015-07-30	ASEA	ETF	14.44	14.45	14.36	14.43	3300.0
2015-07-30	ASHR	ETF	39.62	39.91	39.59	39.83	2299300.0
2015-07-30	ASHS	ETF	45.9	49.61	45.9	48.7	125800.0
2015-07-30	ATMP	ETF	26.63	26.63	26.27	26.45	117500.0
2015-07-30	AWAY	ETF	29.0	29.61	28.85	29.6	1111742.0
2015-07-30	BAB	ETF	28.94	29.08	28.9	29.05	42776.0
2015-07-30	BAL	ETF	42.7	42.7112	42.4205	42.4205	4574.0
2015-07-30	BBC	ETF	35.5	35.92	34.85	35.73	20219.0
2015-07-30	BBH	ETF	137.71	138.7	135.05	138.52	230500.0
2015-07-30	BBP	ETF	35.29	35.59	34.7	35.58	18700.0
2015-07-30	BCM	ETF	28.2816	28.2816	28.23	28.23	1355.0
2015-07-30	BFOR	ETF	8.2	8.2525	8.2	8.245	38000.0
2015-07-30	BIB	ETF	93.7	95.2	90.3	94.53	981688.0
2015-07-30	BIL	ETF	91.4	91.42	91.4	91.42	125550.0
2015-07-30	BIS	ETF	217.36	224.3992	213.12	215.04	50918.0

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

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