PREVIEW / etf_daily / 2014-12-01

all etf daily files

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

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-01	SPY	ETF	206.4	206.54	205.38	205.76	103968400.0
2014-12-01	QQQ	ETF	105.72	105.9199	104.42	104.81	35969494.0
2014-12-01	IWM	ETF	116.32	116.47	114.81	114.87	36244100.0
2014-12-01	DIA	ETF	177.54	178.02	177.03	177.6	6671800.0
2014-12-01	GLD	ETF	113.8	117.36	113.74	116.58	15644000.0
2014-12-01	TLT	ETF	122.68	122.81	121.46	121.5	7728600.0
2014-12-01	AADR	ETF	37.61	38.03	37.58	37.58	500.0
2014-12-01	AAXJ	ETF	62.12	62.12	61.73	61.88	648400.0
2014-12-01	ACWI	ETF	60.13	60.27	59.89	60.05	1393200.0
2014-12-01	ACWV	ETF	69.87	70.04	69.77	69.95	312400.0
2014-12-01	ACWX	ETF	45.17	45.26	44.99	45.15	813975.0
2014-12-01	ADRE	ETF	38.39	38.39	37.84	37.96	10619.0
2014-12-01	AFK	ETF	27.82	28.07	27.58	27.6599	107131.0
2014-12-01	AGG	ETF	110.6	110.6	110.08	110.08	2811700.0
2014-12-01	AGQ	ETF	39.25	43.69	39.25	42.1	515200.0
2014-12-01	AGZ	ETF	113.1	113.47	113.0501	113.11	8262.0
2014-12-01	AGZD	ETF	24.81	24.81	24.7	24.705	8600.0
2014-12-01	AIA	ETF	47.27	47.27	47.06	47.17	70788.0
2014-12-01	AIQ	ETF	22.01	22.02	21.1	21.37	36372.0
2014-12-01	AIRR	ETF	18.05	18.05	17.53	17.66	267000.0
2014-12-01	AIVI	ETF	45.82	45.92	45.72	45.89	38600.0
2014-12-01	AMJ	ETF	48.4	48.63	45.96	46.55	4419494.0
2014-12-01	AMLP	ETF	90.0	90.0	86.95	87.8	1753640.0
2014-12-01	AMZA	ETF	243.0	243.0	226.41	228.2	1540.0
2014-12-01	ANGL	ETF	27.35	27.49	27.27	27.45	3100.0
2014-12-01	AOA	ETF	46.95	46.95	46.62	46.67	105100.0
2014-12-01	AOK	ETF	32.94	32.95	32.79	32.8199	19157.0
2014-12-01	AOM	ETF	35.49	35.51	35.35	35.38	128298.0
2014-12-01	AOR	ETF	40.54	40.54	40.3	40.3	101001.0
2014-12-01	ARGT	ETF	20.51	20.51	20.28	20.37	7800.0
2014-12-01	ARKG	ETF	20.28	20.32	20.07	20.17	1000.0
2014-12-01	ARKK	ETF	20.27	20.27	20.27	20.27	600.0
2014-12-01	ARKQ	ETF	20.17	20.17	20.0	20.0	2100.0
2014-12-01	ARKW	ETF	20.7	20.7	20.2	20.2	1500.0
2014-12-01	ASEA	ETF	16.67	16.67	16.48	16.49	9000.0
2014-12-01	ASHR	ETF	29.69	29.75	29.17	29.22	1261600.0
2014-12-01	ASHS	ETF	35.36	35.36	34.85	34.92	99100.0
2014-12-01	ATMP	ETF	30.88	30.88	29.75	30.22	65400.0
2014-12-01	AVIV	ETF	33.74	34.0	33.36	33.87	349883.0
2014-12-01	AWAY	ETF	31.14	31.8	30.34	31.74	2351080.0
2014-12-01	BAB	ETF	30.1	30.2	29.91	29.9901	349940.0
2014-12-01	BAL	ETF	40.74	40.74	40.0	40.2344	4606.0
2014-12-01	BALT	ETF	3.11	3.12	2.72	2.81	1549190.0
2014-12-01	BAR	ETF	2.7946	3.0	2.793	2.9116	72000.0
2014-12-01	BBH	ETF	116.6	117.56	115.83	116.33	95700.0
2014-12-01	BCHP	ETF	18.74	18.74	18.5429	18.5429	2503.0
2014-12-01	BCM	ETF	34.559	34.632	34.508	34.63	1407.0
2014-12-01	BFOR	ETF	7.9	7.9075	7.775	7.7825	46400.0
2014-12-01	BIB	ETF	63.0	63.6499	61.67	62.12	398994.0
2014-12-01	BICK	ETF	24.569	24.569	24.569	24.569	365.0

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

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