PREVIEW / etf_daily / 2014-12-19

all etf daily files

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

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-19	SPY	ETF	206.43	207.33	205.61	206.52	245084600.0
2014-12-19	QQQ	ETF	103.97	104.74	103.71	104.32	51419912.0
2014-12-19	IWM	ETF	118.65	119.48	118.14	118.9	49041800.0
2014-12-19	DIA	ETF	177.79	178.42	177.15	177.65	11452600.0
2014-12-19	GLD	ETF	115.06	115.22	114.77	114.77	4652300.0
2014-12-19	TLT	ETF	124.58	125.95	124.44	125.87	7894500.0
2014-12-19	AADR	ETF	37.63	37.63	37.57	37.57	900.0
2014-12-19	AAXJ	ETF	59.91	60.33	59.81	60.14	551200.0
2014-12-19	ACWI	ETF	58.91	59.14	58.61	58.87	2189100.0
2014-12-19	ACWV	ETF	68.99	70.24	68.77	69.0	90500.0
2014-12-19	ACWX	ETF	43.29	43.49	43.1201	43.3	2308519.0
2014-12-19	ADRE	ETF	35.63	35.82	35.43	35.7	29758.0
2014-12-19	AFK	ETF	25.41	26.6722	25.4	25.8	15602.0
2014-12-19	AGG	ETF	110.08	110.38	110.08	110.28	1865000.0
2014-12-19	AGQ	ETF	39.11	40.05	39.04	39.8	92000.0
2014-12-19	AGZ	ETF	112.95	113.35	112.95	113.25	33513.0
2014-12-19	AGZD	ETF	24.67	24.67	24.55	24.59	6800.0
2014-12-19	AIA	ETF	46.19	46.6	46.19	46.58	31553.0
2014-12-19	AIQ	ETF	21.54	21.7	21.0	21.44	37934.0
2014-12-19	AIRR	ETF	18.01	18.01	17.8	17.91	9800.0
2014-12-19	AIVI	ETF	43.72	43.76	43.32	43.69	53200.0
2014-12-19	AMJ	ETF	45.18	45.77	44.79	45.66	4019712.0
2014-12-19	AMLP	ETF	87.15	87.35	86.0	87.0	1525620.0
2014-12-19	AMZA	ETF	222.5	223.5	222.4	223.5	310.0
2014-12-19	ANGL	ETF	26.99	26.99	26.47	26.7	14300.0
2014-12-19	AOA	ETF	46.67	46.82	46.5	46.69	68400.0
2014-12-19	AOK	ETF	32.75	32.81	32.68	32.79	42718.0
2014-12-19	AOM	ETF	35.27	35.44	35.19	35.41	108589.0
2014-12-19	AOR	ETF	40.2728	40.4399	40.1495	40.39	30237.0
2014-12-19	ARGT	ETF	18.62	18.77	18.57	18.74	7500.0
2014-12-19	ARKG	ETF	21.49	21.49	21.29	21.37	2200.0
2014-12-19	ARKK	ETF	20.19	20.19	20.03	20.16	2100.0
2014-12-19	ARKQ	ETF	19.659	19.739	19.659	19.739	300.0
2014-12-19	ARKW	ETF	20.49	20.49	20.47	20.47	400.0
2014-12-19	ASEA	ETF	15.91	16.07	15.91	16.07	77900.0
2014-12-19	ASHR	ETF	35.8	35.9	35.52	35.68	517100.0
2014-12-19	ASHS	ETF	36.56	36.76	36.56	36.74	12400.0
2014-12-19	ATMP	ETF	29.95	30.07	29.75	30.06	31200.0
2014-12-19	AVIV	ETF	33.64	34.23	33.45	34.16	503826.0
2014-12-19	AWAY	ETF	28.87	30.0	28.6	29.79	2836107.0
2014-12-19	BAB	ETF	30.28	30.41	30.0501	30.4	97394.0
2014-12-19	BAL	ETF	41.211	41.71	41.1943	41.69	5154.0
2014-12-19	BALT	ETF	2.48	2.54	2.39	2.52	727166.0
2014-12-19	BAR	ETF	2.797	2.797	2.797	2.797	1800.0
2014-12-19	BBC	ETF	28.19	28.24	27.58	28.23	14809.0
2014-12-19	BBH	ETF	121.01	122.87	120.01	122.11	110400.0
2014-12-19	BBP	ETF	29.0	29.0	26.31	26.79	8800.0
2014-12-19	BCHP	ETF	18.27	18.35	18.24	18.25	2683.0
2014-12-19	BCM	ETF	32.64	32.98	32.64	32.97	73849.0
2014-12-19	BFOR	ETF	7.92	7.9375	7.8675	7.9375	120400.0

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

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