PREVIEW / etf_daily / 2015-07-08

all etf daily files

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

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-07-08	SPY	ETF	206.42	206.76	204.25	204.53	164020100.0
2015-07-08	QQQ	ETF	107.2	107.33	105.8942	106.09	39691475.0
2015-07-08	IWM	ETF	122.8	123.35	121.28	121.99	40724500.0
2015-07-08	DIA	ETF	176.11	176.44	174.78	175.0	6849400.0
2015-07-08	GLD	ETF	111.38	111.65	111.08	111.09	5694900.0
2015-07-08	TLT	ETF	120.02	120.57	119.5	120.29	9951800.0
2015-07-08	AADR	ETF	37.86	37.86	37.86	37.86	100.0
2015-07-08	AAXJ	ETF	58.77	58.97	58.08	58.14	4831200.0
2015-07-08	ACTX	ETF	1.18	1.77	1.18	1.18	18389.0
2015-07-08	ACWF	ETF	23.77	23.78	23.77	23.77	953.0
2015-07-08	ACWI	ETF	58.57	58.59	57.92	58.0	1526100.0
2015-07-08	ACWV	ETF	69.66	69.76	69.11	69.21	171100.0
2015-07-08	ACWX	ETF	42.73	42.86	42.28	42.35	1267977.0
2015-07-08	ADRE	ETF	33.11	33.2352	32.8601	32.9295	10219.0
2015-07-08	AFK	ETF	22.95	22.95	22.73	22.74	27331.0
2015-07-08	AFTY	ETF	17.88	18.087	17.43	17.51	411300.0
2015-07-08	AGG	ETF	109.16	109.36	109.03	109.24	2892900.0
2015-07-08	AGQ	ETF	33.93	34.36	33.56	33.8	197100.0
2015-07-08	AGZ	ETF	113.46	113.61	113.26	113.485	11485.0
2015-07-08	AGZD	ETF	24.41	24.41	24.335	24.4	8200.0
2015-07-08	AIA	ETF	47.5	47.5	46.0001	46.1	104719.0
2015-07-08	AIQ	ETF	17.0	17.4	16.6	16.64	20141.0
2015-07-08	AIRR	ETF	17.82	17.856	17.795	17.83	3700.0
2015-07-08	AIVI	ETF	41.22	41.35	40.91	40.99	32600.0
2015-07-08	AMJ	ETF	40.01	40.15	39.13	39.35	1126588.0
2015-07-08	AMLP	ETF	78.35	78.75	77.3	77.5	1096940.0
2015-07-08	AMZA	ETF	184.3	193.5	184.3	187.8	1050.0
2015-07-08	ANGL	ETF	27.06	27.13	26.92	27.05	14300.0
2015-07-08	AOA	ETF	46.5	46.5	46.07	46.09	52300.0
2015-07-08	AOK	ETF	32.21	32.2999	32.1355	32.201	20232.0
2015-07-08	AOM	ETF	34.95	34.95	34.7	34.7	44237.0
2015-07-08	AOR	ETF	40.04	40.11	39.63	39.63	57960.0
2015-07-08	ARGT	ETF	19.32	19.32	18.86	18.86	5800.0
2015-07-08	ARKG	ETF	22.37	22.37	22.37	22.37	200.0
2015-07-08	ARKK	ETF	20.78	20.78	20.78	20.78	100.0
2015-07-08	ARKQ	ETF	19.405	19.405	19.279	19.279	1600.0
2015-07-08	ARKW	ETF	23.09	23.09	22.4	22.45	3000.0
2015-07-08	ASEA	ETF	14.8	14.85	14.71	14.83	36100.0
2015-07-08	ASHR	ETF	34.8	35.82	33.89	33.89	13854300.0
2015-07-08	ASHS	ETF	36.28	38.2	36.28	36.76	445200.0
2015-07-08	ATMP	ETF	27.31	27.31	26.8	26.85	16000.0
2015-07-08	AWAY	ETF	29.74	30.05	29.01	29.31	853046.0
2015-07-08	BAB	ETF	29.15	29.16	28.99	29.13	70446.0
2015-07-08	BAL	ETF	43.95	43.95	43.6	43.6952	2721.0
2015-07-08	BALT	ETF	1.52	1.53	1.49	1.49	129107.0
2015-07-08	BBC	ETF	36.41	36.41	34.855	35.0	17726.0
2015-07-08	BBH	ETF	135.08	135.08	132.1	132.43	112100.0
2015-07-08	BBP	ETF	34.14	34.45	33.67	33.77	13000.0
2015-07-08	BCHP	ETF	18.654	18.671	18.654	18.671	751.0
2015-07-08	BCM	ETF	29.86	29.86	29.8	29.8	1897.0

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

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