PREVIEW / etf_daily / 2015-12-04

all etf daily files

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

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-12-04	SPY	ETF	205.61	209.97	205.61	209.62	192913900.0
2015-12-04	QQQ	ETF	112.84	115.33	112.62	115.14	40037322.0
2015-12-04	IWM	ETF	116.6	117.93	116.34	117.78	32669900.0
2015-12-04	DIA	ETF	175.25	178.68	175.14	178.42	6251600.0
2015-12-04	GLD	ETF	102.74	104.21	102.65	104.02	10670200.0
2015-12-04	TLT	ETF	119.53	120.93	119.47	120.58	11843800.0
2015-12-04	AADR	ETF	39.1	39.24	39.1	39.24	600.0
2015-12-04	AAXJ	ETF	54.94	55.76	54.79	55.66	2852300.0
2015-12-04	ACTX	ETF	8.8501	9.4401	7.6701	8.2601	603.0
2015-12-04	ACWI	ETF	57.12	57.98	57.03	57.92	1658700.0
2015-12-04	ACWV	ETF	69.44	70.56	69.44	70.49	99400.0
2015-12-04	ACWX	ETF	40.75	41.2	40.65	41.15	1108493.0
2015-12-04	ADRE	ETF	30.44	30.8	30.401	30.7255	6797.0
2015-12-04	AFK	ETF	18.84	18.94	18.74	18.89	51884.0
2015-12-04	AFTY	ETF	16.72	16.92	16.68	16.91	34500.0
2015-12-04	AGG	ETF	108.05	108.3	108.0	108.24	2181300.0
2015-12-04	AGGY	ETF	49.23	49.3	49.2	49.28	3200.0
2015-12-04	AGQ	ETF	29.23	30.44	29.13	30.22	445700.0
2015-12-04	AGZ	ETF	112.88	113.0999	112.88	113.03	27887.0
2015-12-04	AGZD	ETF	24.075	24.075	24.055	24.055	3400.0
2015-12-04	AIA	ETF	44.22	44.73	44.22	44.66	10089.0
2015-12-04	AIQ	ETF	8.92	8.92	8.5	8.8	16054.0
2015-12-04	AIRR	ETF	17.68	17.84	17.68	17.83	147500.0
2015-12-04	AIVI	ETF	39.07	39.47	39.0	39.45	33400.0
2015-12-04	AMJ	ETF	27.67	27.7199	26.57	26.89	7319609.0
2015-12-04	AMLP	ETF	56.0	56.6	54.05	54.55	5836000.0
2015-12-04	AMUB	ETF	17.01	17.01	16.96	16.96	300.0
2015-12-04	AMZA	ETF	111.7	111.7	103.4	105.6	3750.0
2015-12-04	ANGL	ETF	25.31	25.34	25.26	25.31	16600.0
2015-12-04	AOA	ETF	45.55	46.13	45.51	46.09	154000.0
2015-12-04	AOK	ETF	31.93	32.0694	31.83	32.04	104774.0
2015-12-04	AOM	ETF	34.38	34.67	34.38	34.67	163074.0
2015-12-04	AOR	ETF	39.4	39.7	39.3546	39.69	439769.0
2015-12-04	ARGT	ETF	18.14	18.27	18.02	18.24	11300.0
2015-12-04	ARKG	ETF	19.89	20.181	19.89	20.181	400.0
2015-12-04	ARKK	ETF	21.06	21.06	21.055	21.055	400.0
2015-12-04	ARKQ	ETF	19.62	19.65	19.62	19.65	200.0
2015-12-04	ARKW	ETF	23.7	24.0	23.7	24.0	1300.0
2015-12-04	ASEA	ETF	12.95	12.96	12.93	12.96	1200.0
2015-12-04	ASHR	ETF	36.39	36.93	36.34	36.82	688000.0
2015-12-04	ASHS	ETF	45.44	45.99	45.44	45.82	79800.0
2015-12-04	ASHX	ETF	26.13	26.13	26.0929	26.0929	410.0
2015-12-04	ATMP	ETF	17.8	18.33	17.49	17.71	232800.0
2015-12-04	AWAY	ETF	35.35	36.01	35.19	35.98	3885189.0
2015-12-04	BAB	ETF	29.01	29.1799	28.96	29.14	172010.0
2015-12-04	BAL	ETF	42.82	43.1389	42.7	43.1091	4490.0
2015-12-04	BBC	ETF	30.5089	30.53	29.7501	30.5	9965.0
2015-12-04	BBH	ETF	120.29	123.99	120.29	123.9	94500.0
2015-12-04	BBP	ETF	30.873	30.921	30.23	30.921	2200.0
2015-12-04	BCM	ETF	24.976	25.0	24.976	25.0	829.0

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

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