PREVIEW / etf_daily / 2015-08-17

all etf daily files

  file:    by_date/etf_daily/2015/2015-08-17.parquet
  size:    48 KB
  rows:    1,182

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-17	SPY	ETF	208.71	210.59	208.16	210.59	79072600.0
2015-08-17	QQQ	ETF	110.24	111.46	109.96	111.43	21224913.0
2015-08-17	IWM	ETF	120.03	121.68	119.6	121.63	22328200.0
2015-08-17	DIA	ETF	174.24	175.73	173.62	175.7	4055400.0
2015-08-17	GLD	ETF	107.37	107.51	107.0	107.13	5769100.0
2015-08-17	TLT	ETF	124.71	125.1	124.39	124.52	7880300.0
2015-08-17	AADR	ETF	38.67	38.67	38.67	38.67	200.0
2015-08-17	AAXJ	ETF	56.18	56.49	56.09	56.49	657800.0
2015-08-17	ACTX	ETF	1.18	1.18	1.18	1.18	26.0
2015-08-17	ACWF	ETF	24.5	24.5	24.43	24.43	1715.0
2015-08-17	ACWI	ETF	58.95	59.35	58.81	59.31	3103500.0
2015-08-17	ACWV	ETF	71.14	71.58	70.94	71.47	154800.0
2015-08-17	ACWX	ETF	42.97	43.22	42.89	43.19	764292.0
2015-08-17	ADRE	ETF	31.21	31.45	31.13	31.35	12106.0
2015-08-17	AFK	ETF	21.29	21.4	21.1801	21.3	43703.0
2015-08-17	AFTY	ETF	17.89	17.96	17.72	17.84	52300.0
2015-08-17	AGG	ETF	109.33	109.4	109.2	109.26	1387100.0
2015-08-17	AGQ	ETF	34.7	34.77	34.2	34.35	37100.0
2015-08-17	AGZ	ETF	113.21	113.59	113.21	113.3101	7698.0
2015-08-17	AGZD	ETF	24.185	24.415	24.16	24.19	8000.0
2015-08-17	AIA	ETF	44.61	44.84	44.49	44.84	22306.0
2015-08-17	AIQ	ETF	15.08	15.42	15.05	15.17	8525.0
2015-08-17	AIRR	ETF	16.95	17.13	16.93	17.1	36700.0
2015-08-17	AIVI	ETF	42.4	42.66	42.3	42.64	17600.0
2015-08-17	AMJ	ETF	36.39	37.43	36.35	37.3	1238882.0
2015-08-17	AMLP	ETF	72.9	73.95	72.6	73.8	788900.0
2015-08-17	AMZA	ETF	168.0	173.3	168.0	173.2	390.0
2015-08-17	ANGL	ETF	26.58	26.62	26.55	26.61	11700.0
2015-08-17	AOA	ETF	46.95	47.08	46.66	47.06	43900.0
2015-08-17	AOK	ETF	32.32	32.45	32.305	32.44	23901.0
2015-08-17	AOM	ETF	34.96	35.15	34.96	35.13	34878.0
2015-08-17	AOR	ETF	40.3	40.37	40.09	40.37	49009.0
2015-08-17	ARGT	ETF	18.79	19.07	18.73	19.07	2200.0
2015-08-17	ARKG	ETF	21.43	21.735	21.43	21.735	1900.0
2015-08-17	ARKK	ETF	21.117	21.117	21.117	21.117	200.0
2015-08-17	ARKQ	ETF	19.14	19.286	19.14	19.286	300.0
2015-08-17	ARKW	ETF	23.64	23.64	23.64	23.64	100.0
2015-08-17	ASEA	ETF	13.24	13.24	13.12	13.22	5000.0
2015-08-17	ASHR	ETF	40.59	40.64	40.28	40.49	1771800.0
2015-08-17	ASHS	ETF	53.12	53.38	53.04	53.37	77400.0
2015-08-17	ATMP	ETF	24.93	25.6	24.93	25.53	35600.0
2015-08-17	AWAY	ETF	30.8	31.33	30.52	31.33	1073657.0
2015-08-17	BAB	ETF	29.17	29.22	29.0685	29.09	143141.0
2015-08-17	BAL	ETF	44.6699	44.8399	44.34	44.66	23931.0
2015-08-17	BBC	ETF	32.0	33.7016	32.0	33.7016	33738.0
2015-08-17	BBH	ETF	134.7	137.58	133.93	137.5	186500.0
2015-08-17	BBP	ETF	33.3	34.57	33.3	34.57	41200.0
2015-08-17	BCM	ETF	27.1501	27.1501	27.0601	27.0601	1072.0
2015-08-17	BFOR	ETF	8.165	8.21	8.1225	8.21	39200.0
2015-08-17	BIB	ETF	85.75	90.85	85.22	90.75	765032.0

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

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