PREVIEW / etf_daily / 2015-09-23

all etf daily files

  file:    by_date/etf_daily/2015/2015-09-23.parquet
  size:    48 KB
  rows:    1,198

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-09-23	SPY	ETF	194.11	194.67	192.91	193.6	92790600.0
2015-09-23	QQQ	ETF	104.38	104.66	103.64	104.18	21775134.0
2015-09-23	IWM	ETF	114.02	114.42	113.07	113.42	25506800.0
2015-09-23	DIA	ETF	163.26	163.38	161.88	162.59	4554900.0
2015-09-23	GLD	ETF	108.54	108.64	108.2	108.22	2744200.0
2015-09-23	TLT	ETF	121.62	122.07	120.99	121.77	6769900.0
2015-09-23	AADR	ETF	36.3	36.3	36.0	36.0	1800.0
2015-09-23	AAXJ	ETF	52.96	53.03	52.57	52.64	751500.0
2015-09-23	ACTX	ETF	3.54	4.72	3.54	4.72	565.0
2015-09-23	ACWF	ETF	22.6199	22.6199	22.6199	22.6199	890.0
2015-09-23	ACWI	ETF	54.35	54.53	54.02	54.18	1225700.0
2015-09-23	ACWV	ETF	66.99	67.02	66.53	66.83	93900.0
2015-09-23	ACWX	ETF	39.24	39.2799	38.8401	38.91	1258770.0
2015-09-23	ADRE	ETF	28.15	28.15	27.625	27.63	26851.0
2015-09-23	AFK	ETF	19.97	19.98	19.74	19.74	8130.0
2015-09-23	AFTY	ETF	14.99	15.09	14.84	14.84	59400.0
2015-09-23	AGG	ETF	109.29	109.29	109.1	109.16	1562100.0
2015-09-23	AGGY	ETF	49.67	49.68	49.62	49.67	1300.0
2015-09-23	AGQ	ETF	32.14	32.25	31.57	31.63	77400.0
2015-09-23	AGZ	ETF	113.7	113.94	113.56	113.8	21410.0
2015-09-23	AGZD	ETF	24.085	24.085	24.025	24.06	3200.0
2015-09-23	AIA	ETF	42.11	42.11	41.8001	41.9	371941.0
2015-09-23	AIQ	ETF	10.91	11.3874	9.11	9.46	134376.0
2015-09-23	AIRR	ETF	15.93	15.93	15.6	15.64	27000.0
2015-09-23	AIVI	ETF	38.29	38.29	37.91	38.05	11600.0
2015-09-23	ALTY	ETF	14.32	14.32	14.29	14.29	1300.0
2015-09-23	AMJ	ETF	33.12	33.195	31.79	31.86	1811160.0
2015-09-23	AMLP	ETF	68.5	68.9	65.6	65.8	1557900.0
2015-09-23	AMZA	ETF	155.6	155.6	142.6	144.6	5780.0
2015-09-23	ANGL	ETF	26.9	26.9	26.22	26.27	6000.0
2015-09-23	AOA	ETF	44.08	44.08	43.66	43.81	35000.0
2015-09-23	AOK	ETF	31.59	31.6284	31.46	31.54	34758.0
2015-09-23	AOM	ETF	34.0	34.0	33.81	33.82	131267.0
2015-09-23	AOR	ETF	38.32	38.3514	38.14	38.22	72311.0
2015-09-23	ARGT	ETF	16.6	16.61	16.35	16.35	10800.0
2015-09-23	ARKG	ETF	20.95	20.99	20.81	20.81	600.0
2015-09-23	ARKK	ETF	20.07	20.07	19.84	19.84	400.0
2015-09-23	ARKQ	ETF	18.02	18.02	18.02	18.02	100.0
2015-09-23	ARKW	ETF	22.012	22.012	21.886	21.886	800.0
2015-09-23	ASEA	ETF	12.12	12.17	12.09	12.09	6900.0
2015-09-23	ASHR	ETF	32.53	32.72	32.42	32.53	2471100.0
2015-09-23	ASHS	ETF	36.42	36.62	36.11	36.44	61900.0
2015-09-23	ATMP	ETF	22.8	22.8	21.74	21.75	49700.0
2015-09-23	AWAY	ETF	27.28	27.82	26.73	27.12	852713.0
2015-09-23	BAB	ETF	28.89	28.91	28.8001	28.86	30285.0
2015-09-23	BAL	ETF	39.99	39.99	39.726	39.726	1165.0
2015-09-23	BBC	ETF	31.96	32.6699	31.4	32.02	19324.0
2015-09-23	BBH	ETF	124.79	125.54	123.08	123.74	107200.0
2015-09-23	BBP	ETF	30.666	31.55	30.492	31.05	8100.0
2015-09-23	BCM	ETF	26.744	26.7499	26.564	26.564	1897.0

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

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