PREVIEW / etf_daily / 2015-11-23

all etf daily files

  file:    by_date/etf_daily/2015/2015-11-23.parquet
  size:    49 KB
  rows:    1,222

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-11-23	SPY	ETF	209.38	209.98	208.52	209.07	64931200.0
2015-11-23	QQQ	ETF	114.53	114.94	113.66	114.15	20696175.0
2015-11-23	IWM	ETF	116.71	117.89	116.68	117.39	22716400.0
2015-11-23	DIA	ETF	177.88	178.48	177.3	177.74	2597000.0
2015-11-23	GLD	ETF	102.48	102.75	102.16	102.26	4042500.0
2015-11-23	TLT	ETF	120.53	121.12	120.32	120.82	5436300.0
2015-11-23	AADR	ETF	39.4	39.71	39.3	39.3	10700.0
2015-11-23	AAXJ	ETF	56.3	56.31	55.97	56.06	673700.0
2015-11-23	ACTX	ETF	4.72	4.779	3.54	4.72	15873.0
2015-11-23	ACWF	ETF	23.85	23.85	23.85	23.85	379.0
2015-11-23	ACWI	ETF	58.02	58.23	57.81	57.91	1458400.0
2015-11-23	ACWV	ETF	70.3	70.58	70.14	70.31	117200.0
2015-11-23	ACWX	ETF	41.34	41.44	41.14	41.19	1211356.0
2015-11-23	ADRE	ETF	31.01	31.075	30.8301	30.96	2476.0
2015-11-23	AFK	ETF	19.02	19.02	18.74	18.75	42854.0
2015-11-23	AFTY	ETF	16.948	16.99	16.91	16.98	10700.0
2015-11-23	AGG	ETF	108.65	108.76	108.57	108.65	1976000.0
2015-11-23	AGQ	ETF	28.32	28.76	28.14	28.45	106300.0
2015-11-23	AGZ	ETF	113.2	113.5	113.08	113.24	16830.0
2015-11-23	AGZD	ETF	24.06	24.06	24.02	24.06	4000.0
2015-11-23	AIA	ETF	45.12	45.18	44.921	45.02	27183.0
2015-11-23	AIQ	ETF	8.5	8.89	8.37	8.8	34746.0
2015-11-23	AIRR	ETF	17.384	17.44	17.34	17.37	35200.0
2015-11-23	AIVI	ETF	39.5	39.54	39.24	39.3	15700.0
2015-11-23	AMJ	ETF	30.56	30.98	30.21	30.49	3459287.0
2015-11-23	AMLP	ETF	60.9	62.0	60.5	60.9	2222480.0
2015-11-23	AMZA	ETF	129.0	129.0	120.1	125.5	4350.0
2015-11-23	ANGL	ETF	25.7	25.7	25.42	25.42	34800.0
2015-11-23	AOA	ETF	46.13	46.17	45.92	46.01	190200.0
2015-11-23	AOK	ETF	32.01	32.09	32.01	32.03	25571.0
2015-11-23	AOM	ETF	34.61	34.6699	34.59	34.63	156538.0
2015-11-23	AOR	ETF	39.64	39.73	39.57	39.65	332785.0
2015-11-23	ARGT	ETF	21.0	21.0	19.07	19.15	145100.0
2015-11-23	ARKG	ETF	20.25	20.25	20.25	20.25	700.0
2015-11-23	ARKK	ETF	20.68	20.68	20.68	20.68	100.0
2015-11-23	ARKQ	ETF	19.17	19.17	19.17	19.17	100.0
2015-11-23	ARKW	ETF	23.535	23.593	23.535	23.586	700.0
2015-11-23	ASEA	ETF	12.88	12.89	12.88	12.89	500.0
2015-11-23	ASHR	ETF	37.48	37.49	37.27	37.4	1760000.0
2015-11-23	ASHS	ETF	47.58	47.58	46.8	46.87	253700.0
2015-11-23	ASHX	ETF	26.426	26.426	26.426	26.426	469.0
2015-11-23	ATMP	ETF	20.16	20.53	20.13	20.28	177100.0
2015-11-23	AWAY	ETF	35.78	36.2	35.475	35.74	1623083.0
2015-11-23	BAB	ETF	29.05	29.102	28.92	29.04	78534.0
2015-11-23	BAL	ETF	41.21	41.21	40.995	41.05	2772.0
2015-11-23	BBC	ETF	29.98	30.66	29.98	30.6068	8520.0
2015-11-23	BBH	ETF	124.69	126.31	124.69	125.31	55200.0
2015-11-23	BBP	ETF	31.249	31.461	31.249	31.31	4700.0
2015-11-23	BCM	ETF	24.9878	24.99	24.8535	24.93	9386.0
2015-11-23	BFOR	ETF	7.85	7.895	7.83	7.8675	69200.0

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

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