PREVIEW / etf_daily / 2015-01-14

all etf daily files

  file:    by_date/etf_daily/2015/2015-01-14.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
2015-01-14	SPY	ETF	199.65	201.1	198.57	200.86	192991100.0
2015-01-14	QQQ	ETF	100.5	101.4829	100.07	100.96	51354217.0
2015-01-14	IWM	ETF	115.98	117.1	115.55	116.8	34224200.0
2015-01-14	DIA	ETF	173.44	174.72	172.42	174.06	11090600.0
2015-01-14	GLD	ETF	119.08	119.32	117.9	117.97	7727400.0
2015-01-14	TLT	ETF	133.72	134.12	132.7	132.82	12324500.0
2015-01-14	AADR	ETF	36.2	36.25	36.2	36.25	1100.0
2015-01-14	AAXJ	ETF	61.36	61.49	60.96	61.43	1837000.0
2015-01-14	ACWI	ETF	57.06	57.41	56.78	57.34	3271000.0
2015-01-14	ACWV	ETF	68.78	69.23	68.68	69.19	277400.0
2015-01-14	ACWX	ETF	41.97	42.15	41.74	42.09	579928.0
2015-01-14	ADRE	ETF	35.21	35.35	34.96	35.35	10819.0
2015-01-14	AFK	ETF	25.27	25.31	25.04	25.16	53802.0
2015-01-14	AGG	ETF	111.64	111.65	111.4	111.42	3043600.0
2015-01-14	AGQ	ETF	44.16	44.8	43.48	43.48	190300.0
2015-01-14	AGZ	ETF	114.47	115.14	114.1	114.5	58604.0
2015-01-14	AGZD	ETF	24.46	24.53	24.46	24.48	4200.0
2015-01-14	AIA	ETF	47.67	47.67	47.31	47.64	12966.0
2015-01-14	AIQ	ETF	21.0	21.64	21.0	21.02	20154.0
2015-01-14	AIRR	ETF	16.87	17.02	16.728	16.94	52900.0
2015-01-14	AIVI	ETF	42.0	42.13	41.79	42.08	34000.0
2015-01-14	AMJ	ETF	41.05	42.24	40.55	42.08	2747726.0
2015-01-14	AMLP	ETF	81.05	82.5	80.35	82.4	1886600.0
2015-01-14	AMZA	ETF	192.4	197.6	189.9	197.6	1720.0
2015-01-14	ANGL	ETF	26.5	26.5	26.45	26.45	700.0
2015-01-14	AOA	ETF	45.56	45.76	45.38	45.72	83400.0
2015-01-14	AOK	ETF	32.44	32.5435	32.4374	32.52	18374.0
2015-01-14	AOM	ETF	34.99	35.01	34.837	34.96	199398.0
2015-01-14	AOR	ETF	39.62	39.7999	39.53	39.75	112874.0
2015-01-14	ARGT	ETF	17.85	17.99	17.66	17.99	6900.0
2015-01-14	ARKG	ETF	22.42	22.59	22.42	22.566	2300.0
2015-01-14	ARKK	ETF	19.93	19.93	19.826	19.93	3200.0
2015-01-14	ARKQ	ETF	18.64	18.67	18.505	18.62	2900.0
2015-01-14	ARKW	ETF	20.09	20.09	19.83	19.93	1800.0
2015-01-14	ASEA	ETF	15.31	15.36	15.3	15.36	19600.0
2015-01-14	ASHR	ETF	36.14	36.33	36.0	36.09	877500.0
2015-01-14	ASHS	ETF	35.63	35.63	35.41	35.48	11400.0
2015-01-14	ATMP	ETF	27.83	28.17	27.2	28.17	27800.0
2015-01-14	AVIV	ETF	37.95	38.67	37.95	38.56	204657.0
2015-01-14	AWAY	ETF	26.52	26.97	26.16	26.41	1256780.0
2015-01-14	BAB	ETF	31.01	31.15	30.9	31.05	480174.0
2015-01-14	BAL	ETF	40.71	40.73	40.0	40.24	12183.0
2015-01-14	BALT	ETF	1.91	1.99	1.88	1.95	704991.0
2015-01-14	BAR	ETF	3.138	3.138	3.083	3.083	51070.0
2015-01-14	BBC	ETF	29.13	29.52	28.882	29.46	11477.0
2015-01-14	BBH	ETF	118.41	120.5	118.41	120.08	287000.0
2015-01-14	BBP	ETF	27.365	27.9	27.365	27.81	2300.0
2015-01-14	BCHP	ETF	17.6	17.6	17.5	17.5507	3109.0
2015-01-14	BCM	ETF	30.45	30.68	30.41	30.68	858.0
2015-01-14	BFOR	ETF	7.61	7.665	7.565	7.645	62000.0

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

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