PREVIEW / etf_daily / 2014-12-26

all etf daily files

  file:    by_date/etf_daily/2014/2014-12-26.parquet
  size:    46 KB
  rows:    1,150

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-26	SPY	ETF	208.31	208.85	208.25	208.44	57326700.0
2014-12-26	QQQ	ETF	104.6	105.26	104.57	105.04	13924332.0
2014-12-26	IWM	ETF	120.14	120.83	120.07	120.54	18261900.0
2014-12-26	DIA	ETF	180.49	180.71	180.19	180.19	1921200.0
2014-12-26	GLD	ETF	114.82	114.98	114.53	114.83	3765600.0
2014-12-26	TLT	ETF	124.55	124.59	124.02	124.41	2921300.0
2014-12-26	AADR	ETF	38.0	38.02	37.98	38.0	500.0
2014-12-26	AAXJ	ETF	60.97	61.27	60.97	61.02	259700.0
2014-12-26	ACWI	ETF	59.47	59.64	59.35	59.55	726900.0
2014-12-26	ACWV	ETF	69.6	69.87	69.46	69.71	65500.0
2014-12-26	ACWX	ETF	43.87	43.95	43.72	43.73	1430395.0
2014-12-26	ADRE	ETF	35.76	36.1888	35.76	35.89	15291.0
2014-12-26	AFK	ETF	25.78	25.99	25.76	25.76	24608.0
2014-12-26	AGG	ETF	109.72	109.87	109.62	109.74	1124900.0
2014-12-26	AGQ	ETF	40.39	40.42	39.64	39.65	148900.0
2014-12-26	AGZ	ETF	112.8	113.3399	112.8	113.09	49515.0
2014-12-26	AGZD	ETF	24.61	24.67	24.59	24.64	5600.0
2014-12-26	AIA	ETF	47.37	47.58	47.289	47.35	115806.0
2014-12-26	AIQ	ETF	22.09	22.09	21.2	21.53	13608.0
2014-12-26	AIRR	ETF	18.33	18.59	18.33	18.49	20400.0
2014-12-26	AIVI	ETF	44.06	44.12	43.9	44.08	31300.0
2014-12-26	ALTL	ETF	38.11	38.12	38.11	38.12	500.0
2014-12-26	AMJ	ETF	45.91	46.17	45.71	45.95	502094.0
2014-12-26	AMLP	ETF	87.8	87.85	87.25	87.6	437680.0
2014-12-26	AMZA	ETF	228.5	228.5	227.6	227.6	120.0
2014-12-26	ANGL	ETF	26.8	26.8	26.6	26.6	2000.0
2014-12-26	AOA	ETF	46.72	46.93	46.72	46.81	58000.0
2014-12-26	AOK	ETF	32.69	32.8	32.69	32.79	72507.0
2014-12-26	AOM	ETF	35.34	35.43	35.34	35.36	89625.0
2014-12-26	AOR	ETF	40.46	40.52	40.406	40.4599	134107.0
2014-12-26	ARGT	ETF	18.99	19.17	18.99	19.12	3600.0
2014-12-26	ARKG	ETF	21.18	21.51	21.18	21.46	1300.0
2014-12-26	ARKK	ETF	20.41	20.6	20.41	20.6	2400.0
2014-12-26	ARKQ	ETF	20.09	20.09	19.97	20.09	1400.0
2014-12-26	ARKW	ETF	20.949	20.96	20.939	20.939	300.0
2014-12-26	ASEA	ETF	16.2	16.3	16.17	16.18	4000.0
2014-12-26	ASHR	ETF	35.81	36.3	35.81	36.16	1062100.0
2014-12-26	ASHS	ETF	35.81	36.05	35.81	36.03	60300.0
2014-12-26	ATMP	ETF	29.65	30.64	29.63	30.51	54000.0
2014-12-26	AVIV	ETF	34.75	35.19	34.75	35.03	54330.0
2014-12-26	AWAY	ETF	28.71	29.23	28.71	29.02	277185.0
2014-12-26	BAB	ETF	30.21	30.24	30.09	30.22	56283.0
2014-12-26	BAL	ETF	42.26	42.26	42.051	42.051	6827.0
2014-12-26	BALT	ETF	2.48	2.55	2.44	2.45	223231.0
2014-12-26	BAR	ETF	2.787	2.812	2.787	2.8036	10630.0
2014-12-26	BBC	ETF	27.15	27.61	27.15	27.39	107118.0
2014-12-26	BBH	ETF	114.83	116.9	114.83	116.6	94300.0
2014-12-26	BBP	ETF	26.0	26.18	25.9	26.157	4200.0
2014-12-26	BCHP	ETF	18.29	18.42	18.27	18.2956	30391.0
2014-12-26	BCM	ETF	32.48	32.48	29.23	32.41	96853.0

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

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