PREVIEW / etf_daily / 2015-04-09

all etf daily files

  file:    by_date/etf_daily/2015/2015-04-09.parquet
  size:    47 KB
  rows:    1,178

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-04-09	SPY	ETF	207.78	209.18	207.19	208.9	85548900.0
2015-04-09	QQQ	ETF	106.59	107.35	106.23	107.31	23114727.0
2015-04-09	IWM	ETF	125.36	125.73	123.77	125.02	22325300.0
2015-04-09	DIA	ETF	178.66	179.63	177.98	179.4	4483800.0
2015-04-09	GLD	ETF	114.8	114.85	114.48	114.67	4707000.0
2015-04-09	TLT	ETF	130.87	130.92	129.13	129.43	6484200.0
2015-04-09	AADR	ETF	39.99	40.0	39.99	40.0	500.0
2015-04-09	AAXJ	ETF	67.75	68.54	67.75	68.36	1723600.0
2015-04-09	ACWI	ETF	61.35	61.65	61.23	61.59	1020500.0
2015-04-09	ACWV	ETF	73.1	73.3	72.88	73.24	64400.0
2015-04-09	ACWX	ETF	46.35	46.45	46.24	46.45	524548.0
2015-04-09	ADRE	ETF	36.81	36.99	36.73	36.96	7107.0
2015-04-09	AFK	ETF	26.02	26.2199	25.91	26.13	20067.0
2015-04-09	AFTY	ETF	20.74	20.74	20.235	20.46	86400.0
2015-04-09	AGG	ETF	111.56	111.56	111.17	111.25	1728500.0
2015-04-09	AGQ	ETF	39.41	39.74	39.12	39.41	211700.0
2015-04-09	AGZ	ETF	114.1	114.2	113.87	113.95	13551.0
2015-04-09	AGZD	ETF	24.525	24.56	24.455	24.455	11000.0
2015-04-09	AIA	ETF	52.89	53.444	52.81	53.4105	43773.0
2015-04-09	AIQ	ETF	23.5	23.89	23.25	23.51	18257.0
2015-04-09	AIRR	ETF	19.19	19.19	18.96	18.992	4000.0
2015-04-09	AIVI	ETF	45.23	45.23	44.93	45.07	19300.0
2015-04-09	ALTL	ETF	37.59	37.59	37.59	37.59	336.0
2015-04-09	AMJ	ETF	43.49	43.61	43.26	43.51	1269345.0
2015-04-09	AMLP	ETF	83.45	83.75	83.25	83.6	413620.0
2015-04-09	AMZA	ETF	213.0	213.7	211.8	213.7	360.0
2015-04-09	ANGL	ETF	27.4	27.49	27.4	27.49	6100.0
2015-04-09	AOA	ETF	48.19	48.25	48.01	48.23	36900.0
2015-04-09	AOK	ETF	33.15	33.17	33.09	33.16	23160.0
2015-04-09	AOM	ETF	35.96	35.96	35.82	35.89	91350.0
2015-04-09	AOR	ETF	41.29	41.32	41.1601	41.32	84475.0
2015-04-09	ARGT	ETF	21.99	22.02	21.86	22.01	7000.0
2015-04-09	ARKG	ETF	23.108	23.108	23.01	23.064	1700.0
2015-04-09	ARKK	ETF	21.2	21.32	21.18	21.32	1500.0
2015-04-09	ARKQ	ETF	20.4	20.4	20.4	20.4	100.0
2015-04-09	ARKW	ETF	22.42	22.42	22.3	22.42	400.0
2015-04-09	ASEA	ETF	16.03	16.08	16.03	16.04	2000.0
2015-04-09	ASHR	ETF	43.59	43.59	43.16	43.26	2333400.0
2015-04-09	ASHS	ETF	51.14	51.17	49.94	50.46	145700.0
2015-04-09	ATMP	ETF	29.58	29.67	29.51	29.65	30200.0
2015-04-09	AWAY	ETF	31.77	31.83	30.99	31.5	1033756.0
2015-04-09	BAB	ETF	30.44	30.4499	30.2601	30.3	73675.0
2015-04-09	BAL	ETF	45.45	45.6831	45.2105	45.3	11362.0
2015-04-09	BALT	ETF	1.38	1.45	1.36	1.39	2652222.0
2015-04-09	BAR	ETF	2.702	2.737	2.687	2.737	26120.0
2015-04-09	BBC	ETF	33.59	33.86	32.73	33.2	12015.0
2015-04-09	BBH	ETF	131.16	132.39	129.99	131.6	139600.0
2015-04-09	BBP	ETF	32.73	32.87	31.91	32.357	18600.0
2015-04-09	BCHP	ETF	19.71	19.8	19.71	19.79	1927.0
2015-04-09	BCM	ETF	30.85	30.85	30.85	30.85	200.0

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

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