PREVIEW / etf_daily / 2015-08-14

all etf daily files

  file:    by_date/etf_daily/2015/2015-08-14.parquet
  size:    47 KB
  rows:    1,178

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-08-14	SPY	ETF	208.43	209.51	208.26	209.42	72786500.0
2015-08-14	QQQ	ETF	110.08	110.67	109.86	110.51	17924931.0
2015-08-14	IWM	ETF	119.49	120.49	119.02	120.36	21091500.0
2015-08-14	DIA	ETF	174.17	175.08	174.06	174.9	3512200.0
2015-08-14	GLD	ETF	107.07	107.41	106.54	106.85	3509200.0
2015-08-14	TLT	ETF	123.47	124.37	123.2	123.96	4324700.0
2015-08-14	AADR	ETF	38.99	39.08	38.4	38.99	4300.0
2015-08-14	AAXJ	ETF	56.92	57.19	56.92	57.07	1702600.0
2015-08-14	ACTX	ETF	1.77	1.77	1.18	1.18	230.0
2015-08-14	ACWI	ETF	59.09	59.34	59.01	59.29	507600.0
2015-08-14	ACWV	ETF	71.1	71.45	70.83	71.42	135700.0
2015-08-14	ACWX	ETF	43.24	43.4	43.18	43.37	158512.0
2015-08-14	ADRE	ETF	31.4	31.61	31.35	31.45	18021.0
2015-08-14	AFK	ETF	21.65	22.0	21.58	21.87	50767.0
2015-08-14	AFTY	ETF	18.3	18.3	18.09	18.1	17100.0
2015-08-14	AGG	ETF	109.12	109.24	109.02	109.07	1890500.0
2015-08-14	AGQ	ETF	35.15	35.75	33.75	34.01	181400.0
2015-08-14	AGZ	ETF	113.28	113.38	112.954	113.3399	18523.0
2015-08-14	AGZD	ETF	24.195	24.44	24.18	24.2	6000.0
2015-08-14	AIA	ETF	45.31	45.43	45.2601	45.35	23432.0
2015-08-14	AIQ	ETF	14.94	15.27	14.83	15.22	15953.0
2015-08-14	AIRR	ETF	17.07	17.1	17.02	17.07	51100.0
2015-08-14	AIVI	ETF	42.7	42.82	42.48	42.82	11500.0
2015-08-14	ALTY	ETF	14.91	14.91	14.91	14.91	300.0
2015-08-14	AMJ	ETF	36.37	37.02	36.37	36.66	2067950.0
2015-08-14	AMLP	ETF	72.85	73.4	72.6	73.0	1611140.0
2015-08-14	AMZA	ETF	169.6	170.3	167.9	168.62	8230.0
2015-08-14	ANGL	ETF	26.62	26.63	26.57	26.62	11000.0
2015-08-14	AOA	ETF	46.78	47.01	46.78	47.01	23900.0
2015-08-14	AOK	ETF	32.36	32.4	32.3	32.383	10739.0
2015-08-14	AOM	ETF	34.93	35.09	34.93	35.08	39066.0
2015-08-14	AOR	ETF	40.19	40.3186	40.14	40.3	73267.0
2015-08-14	ARGT	ETF	19.08	19.1	18.96	19.04	7800.0
2015-08-14	ARKG	ETF	21.44	21.44	21.44	21.44	500.0
2015-08-14	ARKK	ETF	20.96	20.96	20.96	20.96	200.0
2015-08-14	ARKQ	ETF	19.22	19.22	19.19	19.19	500.0
2015-08-14	ARKW	ETF	23.413	23.413	23.4	23.4	300.0
2015-08-14	ASEA	ETF	13.48	13.48	13.48	13.48	200.0
2015-08-14	ASHR	ETF	40.75	40.9	40.65	40.77	1112500.0
2015-08-14	ASHS	ETF	51.61	52.15	51.61	52.11	63000.0
2015-08-14	ATMP	ETF	25.15	25.22	25.07	25.12	21600.0
2015-08-14	AWAY	ETF	30.4	30.8	30.29	30.67	1457149.0
2015-08-14	BAB	ETF	29.08	29.11	29.0	29.05	53098.0
2015-08-14	BAL	ETF	44.03	44.56	44.03	44.21	3303.0
2015-08-14	BBC	ETF	32.87	32.87	31.5195	32.16	16514.0
2015-08-14	BBH	ETF	135.51	135.81	133.37	134.99	97600.0
2015-08-14	BBP	ETF	33.57	33.9	33.11	33.75	27300.0
2015-08-14	BCM	ETF	27.23	27.23	27.21	27.21	8499.0
2015-08-14	BFOR	ETF	8.12	8.1775	8.12	8.1675	35200.0
2015-08-14	BIB	ETF	87.64	88.5	84.7499	87.17	540604.0

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

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