PREVIEW / etf_daily / 2014-12-31

all etf daily files

  file:    by_date/etf_daily/2014/2014-12-31.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
2014-12-31	SPY	ETF	207.99	208.19	205.39	205.54	130333800.0
2014-12-31	QQQ	ETF	104.5	104.91	103.1	103.25	24367121.0
2014-12-31	IWM	ETF	120.8	121.41	119.54	119.62	35688700.0
2014-12-31	DIA	ETF	179.82	180.12	177.88	177.88	4514400.0
2014-12-31	GLD	ETF	114.89	115.0	113.28	113.58	7624200.0
2014-12-31	TLT	ETF	125.7	126.17	125.65	125.92	4993300.0
2014-12-31	AADR	ETF	37.45	37.45	37.45	37.45	5100.0
2014-12-31	AAXJ	ETF	61.17	61.27	60.89	60.93	595800.0
2014-12-31	ACWI	ETF	59.19	59.25	58.32	58.5	5750200.0
2014-12-31	ACWV	ETF	69.27	69.56	68.84	68.84	46400.0
2014-12-31	ACWX	ETF	43.29	43.371	42.98	43.02	1047326.0
2014-12-31	ADRE	ETF	35.62	35.713	35.5001	35.52	41609.0
2014-12-31	AFK	ETF	26.02	26.066	25.8	25.94	43246.0
2014-12-31	AGG	ETF	110.14	110.26	110.1	110.12	2493900.0
2014-12-31	AGQ	ETF	39.61	39.64	37.32	38.05	520800.0
2014-12-31	AGZ	ETF	113.33	113.45	112.71	113.1	19574.0
2014-12-31	AGZD	ETF	24.645	24.67	24.57	24.67	4800.0
2014-12-31	AIA	ETF	46.937	47.3499	46.937	47.05	26217.0
2014-12-31	AIQ	ETF	22.0	22.0	20.88	20.99	14249.0
2014-12-31	AIRR	ETF	18.441	18.59	18.33	18.33	15800.0
2014-12-31	AIVI	ETF	43.36	43.57	43.0	43.01	533000.0
2014-12-31	AMJ	ETF	46.46	46.78	45.785	45.95	1660750.0
2014-12-31	AMLP	ETF	88.05	88.75	87.5	87.6	718020.0
2014-12-31	AMZA	ETF	230.0	232.39	229.5	229.5	170.0
2014-12-31	ANGL	ETF	26.27	26.27	25.93	26.04	1600.0
2014-12-31	AOA	ETF	46.78	46.78	46.28	46.28	59300.0
2014-12-31	AOK	ETF	32.69	32.73	32.6	32.6	103174.0
2014-12-31	AOM	ETF	35.3	35.41	35.17	35.17	152056.0
2014-12-31	AOR	ETF	40.48	40.48	40.071	40.12	173030.0
2014-12-31	ARGT	ETF	18.94	18.94	18.47	18.76	19500.0
2014-12-31	ARKG	ETF	21.48	21.48	21.23	21.23	1400.0
2014-12-31	ARKK	ETF	20.35	20.41	20.16	20.16	1300.0
2014-12-31	ARKQ	ETF	19.832	19.92	19.832	19.85	1100.0
2014-12-31	ARKW	ETF	20.65	20.73	20.53	20.53	3600.0
2014-12-31	ASEA	ETF	15.85	15.86	15.79	15.79	6500.0
2014-12-31	ASHR	ETF	37.39	37.4	37.1	37.21	833700.0
2014-12-31	ASHS	ETF	35.53	35.53	35.13	35.13	10800.0
2014-12-31	ATMP	ETF	30.84	31.04	30.39	30.59	31400.0
2014-12-31	AVIV	ETF	35.57	35.9	34.46	34.48	145090.0
2014-12-31	AWAY	ETF	29.14	29.98	29.01	29.78	962276.0
2014-12-31	BAB	ETF	30.4	30.46	30.34	30.44	76440.0
2014-12-31	BAL	ETF	41.58	41.71	41.01	41.18	24150.0
2014-12-31	BALT	ETF	2.4	2.52	2.33	2.51	668456.0
2014-12-31	BAR	ETF	2.789	2.789	2.677	2.6982	170920.0
2014-12-31	BBC	ETF	27.89	28.1799	27.74	27.74	23164.0
2014-12-31	BBH	ETF	116.21	117.7	115.29	115.38	53200.0
2014-12-31	BBP	ETF	26.41	26.549	26.11	26.12	7200.0
2014-12-31	BCHP	ETF	18.05	18.12	18.05	18.12	1421.0
2014-12-31	BCM	ETF	32.0	32.049	31.723	31.98	177409.0
2014-12-31	BFOR	ETF	7.9475	7.97	7.7575	7.88	81200.0

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

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