PREVIEW / etf_daily / 2015-08-21

all etf daily files

  file:    by_date/etf_daily/2015/2015-08-21.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-08-21	SPY	ETF	201.73	203.94	197.52	197.83	346588500.0
2015-08-21	QQQ	ETF	105.57	106.47	102.4	102.4	97763445.0
2015-08-21	IWM	ETF	115.13	116.66	114.37	115.03	79168300.0
2015-08-21	DIA	ETF	167.79	168.67	164.41	164.41	18858700.0
2015-08-21	GLD	ETF	110.93	111.33	110.12	111.13	13917600.0
2015-08-21	TLT	ETF	126.16	126.74	125.59	126.4	10718300.0
2015-08-21	AADR	ETF	37.47	37.47	36.86	36.86	2300.0
2015-08-21	AAXJ	ETF	53.2	53.48	52.26	52.27	3267900.0
2015-08-21	ACTX	ETF	1.77	1.77	1.77	1.77	327.0
2015-08-21	ACWF	ETF	23.48	23.48	23.12	23.15	1360.0
2015-08-21	ACWI	ETF	56.75	56.98	55.56	55.56	2641600.0
2015-08-21	ACWV	ETF	69.39	69.62	68.23	68.41	104800.0
2015-08-21	ACWX	ETF	41.24	41.3714	40.33	40.44	646013.0
2015-08-21	ADRE	ETF	29.94	30.14	29.44	29.44	53353.0
2015-08-21	AFK	ETF	20.28	20.62	20.02	20.38	211186.0
2015-08-21	AFTY	ETF	16.17	16.25	16.03	16.03	9800.0
2015-08-21	AGG	ETF	109.68	109.87	109.57	109.76	2443400.0
2015-08-21	AGQ	ETF	34.54	34.74	33.4	34.06	220700.0
2015-08-21	AGZ	ETF	113.65	113.8999	113.5901	113.76	10898.0
2015-08-21	AGZD	ETF	24.155	24.18	24.03	24.055	2452800.0
2015-08-21	AIA	ETF	42.25	42.33	41.42	41.48	95409.0
2015-08-21	AIQ	ETF	14.6	14.93	14.6	14.7	26718.0
2015-08-21	AIRR	ETF	16.34	16.37	16.23	16.28	9600.0
2015-08-21	AIVI	ETF	41.1	41.2	40.17	40.23	110300.0
2015-08-21	ALTY	ETF	14.66	14.66	14.56	14.587	1300.0
2015-08-21	AMJ	ETF	35.4	35.74	34.75	34.77	5165054.0
2015-08-21	AMLP	ETF	71.4	71.85	70.3	70.35	1964740.0
2015-08-21	AMZA	ETF	161.33	162.1	156.7	156.7	3160.0
2015-08-21	ANGL	ETF	26.5	26.5	26.33	26.33	22200.0
2015-08-21	AOA	ETF	45.49	45.54	44.69	44.76	173300.0
2015-08-21	AOK	ETF	32.06	32.12	31.81	31.81	77729.0
2015-08-21	AOM	ETF	34.57	34.6	34.2	34.2	93151.0
2015-08-21	AOR	ETF	39.33	39.5	38.83	38.83	126591.0
2015-08-21	ARGT	ETF	17.76	17.76	17.26	17.53	20400.0
2015-08-21	ARKG	ETF	20.49	20.84	20.26	20.51	3300.0
2015-08-21	ARKK	ETF	19.576	19.705	19.528	19.53	3800.0
2015-08-21	ARKQ	ETF	17.95	18.09	17.95	18.0	2800.0
2015-08-21	ARKW	ETF	22.33	22.33	21.6	21.62	5400.0
2015-08-21	ASEA	ETF	12.72	12.72	12.49	12.49	3500.0
2015-08-21	ASHR	ETF	35.38	35.71	34.73	34.87	9228800.0
2015-08-21	ASHS	ETF	44.86	45.5	43.86	43.94	106900.0
2015-08-21	ATMP	ETF	24.12	24.12	23.69	23.69	78200.0
2015-08-21	AWAY	ETF	29.55	29.97	29.08	29.2	1572996.0
2015-08-21	BAB	ETF	29.3	29.4144	29.2301	29.32	63874.0
2015-08-21	BAL	ETF	44.5101	44.88	44.5101	44.88	6454.0
2015-08-21	BBC	ETF	30.0	31.3818	29.37	30.5254	72064.0
2015-08-21	BBH	ETF	129.16	131.19	125.84	125.84	557700.0
2015-08-21	BBP	ETF	31.81	32.93	31.01	32.07	100400.0
2015-08-21	BCHP	ETF	17.84	17.84	17.8	17.8	1074.0
2015-08-21	BCM	ETF	26.43	26.49	26.42	26.48	3647.0

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

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