PREVIEW / etf_daily / 2015-05-07

all etf daily files

  file:    by_date/etf_daily/2015/2015-05-07.parquet
  size:    47 KB
  rows:    1,176

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-05-07	SPY	ETF	207.92	209.38	207.52	208.87	88244900.0
2015-05-07	QQQ	ETF	106.68	107.65	106.6	107.35	29335806.0
2015-05-07	IWM	ETF	121.14	122.23	120.57	121.73	29826100.0
2015-05-07	DIA	ETF	178.12	179.7	177.89	179.28	4142800.0
2015-05-07	GLD	ETF	113.84	114.01	113.32	113.42	5455100.0
2015-05-07	TLT	ETF	121.43	122.57	121.35	122.18	11933700.0
2015-05-07	AAXJ	ETF	66.62	66.93	66.47	66.92	1534200.0
2015-05-07	ACTX	ETF	3.54	4.13	2.95	4.13	1516.0
2015-05-07	ACWF	ETF	24.85	24.85	24.85	24.85	310.0
2015-05-07	ACWI	ETF	61.36	61.57	61.17	61.49	1015500.0
2015-05-07	ACWV	ETF	72.36	72.72	72.36	72.7	70500.0
2015-05-07	ACWX	ETF	46.4	46.49	46.201	46.45	84752.0
2015-05-07	ADRE	ETF	37.05	37.2094	36.8901	37.2094	7444.0
2015-05-07	AFK	ETF	26.63	26.63	26.42	26.56	20276.0
2015-05-07	AFTY	ETF	21.61	21.81	21.49	21.81	54500.0
2015-05-07	AGG	ETF	109.85	110.04	109.76	109.93	1986200.0
2015-05-07	AGQ	ETF	40.57	40.58	39.64	39.72	139700.0
2015-05-07	AGZ	ETF	113.22	113.2599	113.02	113.1707	9076.0
2015-05-07	AGZD	ETF	24.53	24.55	24.505	24.505	14200.0
2015-05-07	AIA	ETF	52.6	52.9	52.6	52.85	64574.0
2015-05-07	AIQ	ETF	20.89	21.29	20.55	21.29	18723.0
2015-05-07	AIRR	ETF	17.97	18.44	17.97	18.13	4400.0
2015-05-07	AIVI	ETF	45.55	45.58	45.3	45.44	34000.0
2015-05-07	ALTL	ETF	37.009	37.009	37.009	37.009	500.0
2015-05-07	AMJ	ETF	45.0	45.0	44.1648	44.2	908608.0
2015-05-07	AMLP	ETF	85.15	85.4	84.4	84.5	803980.0
2015-05-07	AMZA	ETF	222.0	222.5	218.6	219.2	1000.0
2015-05-07	ANGL	ETF	27.57	27.61	27.54	27.59	38800.0
2015-05-07	AOA	ETF	48.02	48.1	47.84	48.0	20600.0
2015-05-07	AOK	ETF	32.78	32.8887	32.76	32.87	23464.0
2015-05-07	AOM	ETF	35.51	35.66	35.47	35.64	69045.0
2015-05-07	AOR	ETF	41.06	41.12	40.9266	41.12	40856.0
2015-05-07	ARGT	ETF	22.18	22.18	21.61	21.73	25300.0
2015-05-07	ARKG	ETF	22.63	22.82	22.58	22.74	1300.0
2015-05-07	ARKK	ETF	20.76	20.86	20.76	20.86	300.0
2015-05-07	ARKQ	ETF	19.53	19.53	19.51	19.51	700.0
2015-05-07	ARKW	ETF	22.38	22.38	22.38	22.38	200.0
2015-05-07	ASEA	ETF	15.9	15.94	15.86	15.94	3300.0
2015-05-07	ASHR	ETF	45.31	45.94	45.19	45.92	1668400.0
2015-05-07	ASHS	ETF	50.7	51.7	50.5	51.4	78800.0
2015-05-07	ATMP	ETF	30.0	30.02	29.65	29.89	20100.0
2015-05-07	AWAY	ETF	27.04	27.32	26.75	27.09	1497808.0
2015-05-07	BAB	ETF	29.2	29.4294	29.2	29.34	123104.0
2015-05-07	BAL	ETF	44.1101	44.5599	44.1101	44.4666	2690.0
2015-05-07	BALT	ETF	1.42	1.42	1.38	1.38	498455.0
2015-05-07	BBC	ETF	32.33	32.33	31.16	32.0	33056.0
2015-05-07	BBH	ETF	127.25	128.18	126.15	127.97	54300.0
2015-05-07	BBP	ETF	30.04	30.67	30.04	30.67	16200.0
2015-05-07	BCHP	ETF	20.45	20.47	20.45	20.47	511.0
2015-05-07	BCM	ETF	32.35	32.42	32.2	32.2	30062.0

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

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