PREVIEW / etf_daily / 2015-02-09

all etf daily files

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

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-09	SPY	ETF	204.77	205.64	204.14	204.63	87219000.0
2015-02-09	QQQ	ETF	102.73	103.285	102.55	102.8	22604655.0
2015-02-09	IWM	ETF	119.4	120.22	118.72	118.86	32367900.0
2015-02-09	DIA	ETF	177.18	177.94	176.68	177.09	3723100.0
2015-02-09	GLD	ETF	118.83	119.4	118.77	119.17	5237200.0
2015-02-09	TLT	ETF	131.97	131.98	130.75	130.75	8025500.0
2015-02-09	AADR	ETF	37.04	37.34	37.03	37.34	3500.0
2015-02-09	AAXJ	ETF	62.65	62.66	62.41	62.52	377000.0
2015-02-09	ACWI	ETF	58.96	59.18	58.86	58.97	1836200.0
2015-02-09	ACWV	ETF	70.58	70.64	70.23	70.36	162800.0
2015-02-09	ACWX	ETF	43.46	43.7326	43.46	43.62	361625.0
2015-02-09	ADRE	ETF	35.67	36.0395	35.67	35.9	12911.0
2015-02-09	AFK	ETF	25.94	26.11	25.8	25.81	66933.0
2015-02-09	AGG	ETF	111.31	111.31	111.04	111.04	1724900.0
2015-02-09	AGQ	ETF	43.64	44.61	43.57	44.12	192200.0
2015-02-09	AGZ	ETF	114.39	114.3999	114.16	114.2	16673.0
2015-02-09	AGZD	ETF	24.555	24.67	24.485	24.63	31200.0
2015-02-09	AIA	ETF	48.424	48.4599	48.3508	48.36	4699.0
2015-02-09	AIQ	ETF	23.42	23.96	23.42	23.65	9460.0
2015-02-09	AIRR	ETF	17.91	18.09	17.67	17.928	33200.0
2015-02-09	AIVI	ETF	43.77	44.11	43.72	43.92	15000.0
2015-02-09	ALTL	ETF	37.756	37.7899	37.75	37.75	1480.0
2015-02-09	AMJ	ETF	46.22	46.44	45.4542	45.59	806709.0
2015-02-09	AMLP	ETF	87.4	87.55	86.1	86.25	1115420.0
2015-02-09	AMZA	ETF	220.59	220.6	217.4	217.4	370.0
2015-02-09	ANGL	ETF	27.14	27.14	26.89	27.07	9800.0
2015-02-09	AOA	ETF	46.5	46.6	46.34	46.48	40700.0
2015-02-09	AOK	ETF	32.5	32.6	32.474	32.54	27316.0
2015-02-09	AOM	ETF	35.19	35.2	35.07	35.12	57818.0
2015-02-09	AOR	ETF	40.18	40.243	40.07	40.07	73818.0
2015-02-09	ARGT	ETF	19.08	19.17	19.02	19.07	29800.0
2015-02-09	ARKG	ETF	22.64	22.64	22.198	22.198	2100.0
2015-02-09	ARKK	ETF	20.71	20.71	20.631	20.678	2200.0
2015-02-09	ARKQ	ETF	19.301	19.38	19.28	19.38	1300.0
2015-02-09	ARKW	ETF	21.34	21.34	21.12	21.12	600.0
2015-02-09	ASEA	ETF	15.73	15.81	15.73	15.75	11700.0
2015-02-09	ASHR	ETF	34.16	34.31	34.05	34.11	741600.0
2015-02-09	ASHS	ETF	36.06	36.17	36.01	36.01	3500.0
2015-02-09	ATMP	ETF	30.49	30.51	30.04	30.15	236000.0
2015-02-09	AVIV	ETF	36.82	37.05	36.19	36.52	254542.0
2015-02-09	AWAY	ETF	27.13	27.19	26.86	26.93	987100.0
2015-02-09	BAB	ETF	30.75	30.9	30.68	30.78	121255.0
2015-02-09	BAL	ETF	42.23	42.7301	42.23	42.6731	2903.0
2015-02-09	BALT	ETF	1.79	1.82	1.75	1.75	567479.0
2015-02-09	BAR	ETF	3.05	3.114	3.05	3.0704	18510.0
2015-02-09	BBC	ETF	28.08	28.08	27.36	27.46	9392.0
2015-02-09	BBH	ETF	119.19	120.43	118.74	118.8	80300.0
2015-02-09	BBP	ETF	27.5	28.1	27.5	27.74	3600.0
2015-02-09	BCHP	ETF	18.6725	18.6725	18.6725	18.6725	100.0
2015-02-09	BCM	ETF	32.07	32.23	32.0	32.06	177671.0

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

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