PREVIEW / etf_daily / 2015-02-03

all etf daily files

  file:    by_date/etf_daily/2015/2015-02-03.parquet
  size:    47 KB
  rows:    1,163

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-02-03	SPY	ETF	203.0	204.85	202.55	204.84	124212900.0
2015-02-03	QQQ	ETF	102.35	103.03	101.68	102.96	30750360.0
2015-02-03	IWM	ETF	117.33	119.0	117.27	118.85	43920000.0
2015-02-03	DIA	ETF	174.13	176.4	174.1	176.33	7543400.0
2015-02-03	GLD	ETF	121.74	121.76	120.56	121.05	8255900.0
2015-02-03	TLT	ETF	135.65	135.79	134.37	134.57	14008700.0
2015-02-03	AADR	ETF	37.19	37.19	37.19	37.19	200.0
2015-02-03	AAXJ	ETF	63.17	63.58	62.9	63.54	3336000.0
2015-02-03	ACWI	ETF	58.75	59.4	58.75	59.39	3016300.0
2015-02-03	ACWV	ETF	70.59	70.96	70.35	70.96	164300.0
2015-02-03	ACWX	ETF	43.67	44.2	43.67	44.17	510763.0
2015-02-03	ADRE	ETF	36.13	36.47	36.13	36.43	15411.0
2015-02-03	AFK	ETF	26.59	26.7	26.35	26.61	178076.0
2015-02-03	AGG	ETF	112.1	112.1	111.76	111.77	1815400.0
2015-02-03	AGQ	ETF	45.86	46.58	44.44	45.46	294300.0
2015-02-03	AGZ	ETF	114.41	114.91	114.39	114.73	24222.0
2015-02-03	AGZD	ETF	24.505	24.51	24.435	24.465	7600.0
2015-02-03	AIA	ETF	48.92	49.126	48.788	49.126	41002.0
2015-02-03	AIQ	ETF	22.69	23.475	22.66	23.45	7660.0
2015-02-03	AIRR	ETF	17.43	17.85	17.43	17.85	53900.0
2015-02-03	AIVI	ETF	44.26	44.8	44.26	44.75	19200.0
2015-02-03	AMJ	ETF	45.65	46.24	45.0034	45.78	2085515.0
2015-02-03	AMLP	ETF	86.55	87.45	86.4	87.15	1168240.0
2015-02-03	AMZA	ETF	220.1	222.19	218.9	220.5	970.0
2015-02-03	ANGL	ETF	26.85	27.04	26.84	26.97	1400.0
2015-02-03	AOA	ETF	46.39	46.73	46.28	46.7	81100.0
2015-02-03	AOK	ETF	32.83	32.83	32.621	32.75	67727.0
2015-02-03	AOM	ETF	35.41	35.41	35.18	35.28	81137.0
2015-02-03	AOR	ETF	40.2	40.488	40.04	40.38	197051.0
2015-02-03	ARGT	ETF	18.81	19.24	18.81	19.24	4500.0
2015-02-03	ARKG	ETF	22.75	22.75	22.001	22.396	8300.0
2015-02-03	ARKK	ETF	20.67	20.67	20.18	20.23	11600.0
2015-02-03	ARKQ	ETF	18.99	18.99	18.866	18.984	8100.0
2015-02-03	ARKW	ETF	20.7	20.73	20.61	20.73	5400.0
2015-02-03	ASEA	ETF	15.7	15.77	15.7	15.75	11700.0
2015-02-03	ASHR	ETF	35.46	35.98	35.24	35.93	1792500.0
2015-02-03	ASHS	ETF	37.71	37.75	37.64	37.75	2800.0
2015-02-03	ATMP	ETF	30.19	30.61	30.18	30.34	23300.0
2015-02-03	AVIV	ETF	38.57	39.13	38.08	39.1	135233.0
2015-02-03	AWAY	ETF	25.89	26.19	25.485	25.5	1108411.0
2015-02-03	BAB	ETF	31.24	31.25	31.0	31.01	181481.0
2015-02-03	BAL	ETF	41.06	42.02	41.05	42.02	19032.0
2015-02-03	BALT	ETF	1.6	1.71	1.58	1.69	4040936.0
2015-02-03	BAR	ETF	3.255	3.307	3.2	3.273	29910.0
2015-02-03	BBC	ETF	27.61	27.87	27.1	27.85	8213.0
2015-02-03	BBH	ETF	123.48	123.48	118.8	121.51	249900.0
2015-02-03	BBP	ETF	27.85	27.85	27.05	27.654	4400.0
2015-02-03	BCM	ETF	32.022	32.2	32.022	32.12	14193.0
2015-02-03	BFOR	ETF	7.7575	7.875	7.7575	7.875	260000.0
2015-02-03	BIB	ETF	70.045	70.045	65.11	68.535	1184232.0

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

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