PREVIEW / etf_daily / 2014-12-12

all etf daily files

  file:    by_date/etf_daily/2014/2014-12-12.parquet
  size:    47 KB
  rows:    1,155

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
2014-12-12	SPY	ETF	202.64	203.82	200.85	200.89	202330200.0
2014-12-12	QQQ	ETF	102.81	103.99	102.66	102.67	46889391.0
2014-12-12	IWM	ETF	114.78	115.99	114.6	114.71	44816000.0
2014-12-12	DIA	ETF	174.77	175.67	172.93	173.0	12284400.0
2014-12-12	GLD	ETF	117.39	117.8	116.68	117.41	4736500.0
2014-12-12	TLT	ETF	125.45	126.35	125.02	126.3	9317400.0
2014-12-12	AADR	ETF	37.0	37.09	36.21	36.21	2100.0
2014-12-12	AAXJ	ETF	60.37	60.65	59.95	59.96	497300.0
2014-12-12	ACWI	ETF	58.5	58.66	57.79	57.79	2015400.0
2014-12-12	ACWV	ETF	68.93	69.11	68.32	68.32	77100.0
2014-12-12	ACWX	ETF	43.39	43.52	42.8	42.8	1163069.0
2014-12-12	ADRE	ETF	35.5	35.56	35.04	35.04	10009.0
2014-12-12	AFK	ETF	25.58	25.7399	25.48	25.48	27088.0
2014-12-12	AGG	ETF	110.5	110.66	110.31	110.56	1714100.0
2014-12-12	AGQ	ETF	45.19	45.58	44.73	44.93	298700.0
2014-12-12	AGZ	ETF	113.378	113.63	113.21	113.31	5357.0
2014-12-12	AGZD	ETF	24.55	24.665	24.55	24.565	5400.0
2014-12-12	AIA	ETF	46.51	46.51	46.28	46.284	43139.0
2014-12-12	AIQ	ETF	20.5	21.1699	19.88	20.28	20861.0
2014-12-12	AIRR	ETF	16.9	17.28	16.76	17.12	27600.0
2014-12-12	AIVI	ETF	44.0	44.01	43.21	43.21	56300.0
2014-12-12	AMJ	ETF	43.56	43.93	42.69	43.28	3369238.0
2014-12-12	AMLP	ETF	83.75	84.7	83.0	84.05	1527540.0
2014-12-12	AMZA	ETF	212.6	212.6	207.4	212.2	350.0
2014-12-12	ANGL	ETF	26.93	26.96	26.51	26.56	2700.0
2014-12-12	AOA	ETF	45.99	46.02	45.54	45.55	112800.0
2014-12-12	AOK	ETF	32.51	32.54	32.45	32.45	94514.0
2014-12-12	AOM	ETF	35.08	35.08	34.88	34.88	128752.0
2014-12-12	AOR	ETF	39.88	39.88	39.59	39.609	136275.0
2014-12-12	ARGT	ETF	19.11	19.14	18.78	18.78	18700.0
2014-12-12	ARKG	ETF	20.73	20.73	20.6	20.67	1400.0
2014-12-12	ARKK	ETF	19.82	19.82	19.608	19.608	800.0
2014-12-12	ARKQ	ETF	19.54	19.54	19.54	19.54	300.0
2014-12-12	ARKW	ETF	20.06	20.06	20.06	20.06	300.0
2014-12-12	ASEA	ETF	16.04	16.07	15.94	15.94	3600.0
2014-12-12	ASHR	ETF	33.83	33.91	33.31	33.43	776100.0
2014-12-12	ASHS	ETF	36.93	36.98	36.73	36.73	14100.0
2014-12-12	ATMP	ETF	29.16	29.92	28.46	28.74	51300.0
2014-12-12	AVIV	ETF	33.61	34.44	33.61	34.24	246558.0
2014-12-12	AWAY	ETF	29.75	30.61	29.7	30.19	1413055.0
2014-12-12	BAB	ETF	30.39	30.57	30.3201	30.56	155938.0
2014-12-12	BAL	ETF	41.6	41.7712	41.29	41.3603	9727.0
2014-12-12	BALT	ETF	2.46	2.55	2.44	2.51	883417.0
2014-12-12	BAR	ETF	3.0	3.026	2.983	3.026	14570.0
2014-12-12	BBH	ETF	118.27	120.06	118.0	118.01	99700.0
2014-12-12	BCHP	ETF	17.78	17.78	17.75	17.75	400.0
2014-12-12	BCM	ETF	33.416	33.416	33.3	33.3	9987.0
2014-12-12	BFOR	ETF	7.7125	7.7225	7.65	7.65	55600.0
2014-12-12	BIB	ETF	65.0	66.37	64.15	64.415	457822.0
2014-12-12	BICK	ETF	23.68	23.68	23.377	23.377	215.0

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

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