PREVIEW / etf_daily / 2014-09-23

all etf daily files

  file:    by_date/etf_daily/2014/2014-09-23.parquet
  size:    46 KB
  rows:    1,119

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-09-23	SPY	ETF	198.43	199.26	197.95	198.01	111393000.0
2014-09-23	QQQ	ETF	98.67	99.22	98.58	98.78	33989583.0
2014-09-23	IWM	ETF	111.9	112.62	111.19	111.32	51616800.0
2014-09-23	DIA	ETF	170.85	171.38	170.21	170.21	5521800.0
2014-09-23	GLD	ETF	117.99	117.99	117.31	117.6	4664800.0
2014-09-23	TLT	ETF	114.91	115.47	114.77	115.45	6362400.0
2014-09-23	AADR	ETF	37.75	37.82	37.61	37.61	4400.0
2014-09-23	AAXJ	ETF	62.86	63.07	62.68	62.7	794700.0
2014-09-23	ACWI	ETF	59.72	59.87	59.56	59.58	1246300.0
2014-09-23	ACWV	ETF	67.18	67.21	66.87	66.87	46200.0
2014-09-23	ACWX	ETF	46.33	46.5	46.21	46.24	284501.0
2014-09-23	ADRE	ETF	40.57	40.87	40.406	40.5028	17071.0
2014-09-23	AFK	ETF	31.64	31.78	31.5	31.58	48807.0
2014-09-23	AGG	ETF	108.91	108.95	108.83	108.93	705200.0
2014-09-23	AGQ	ETF	50.5	50.64	49.91	50.28	144800.0
2014-09-23	AGZ	ETF	112.05	112.54	112.05	112.39	10400.0
2014-09-23	AGZD	ETF	24.935	24.935	24.84	24.89	8400.0
2014-09-23	AIA	ETF	47.92	48.002	47.731	47.87	47218.0
2014-09-23	AIQ	ETF	24.57	25.26	24.4675	24.8	23967.0
2014-09-23	AIRR	ETF	18.858	18.98	18.79	18.87	14400.0
2014-09-23	AIVI	ETF	47.56	47.71	47.34	47.47	82800.0
2014-09-23	ALTL	ETF	35.7653	35.7653	35.74	35.74	2100.0
2014-09-23	AMJ	ETF	53.05	53.18	52.36	52.36	1333660.0
2014-09-23	AMLP	ETF	95.0	95.3	94.4	94.4	502240.0
2014-09-23	ANGL	ETF	27.99	27.99	27.99	27.99	300.0
2014-09-23	AOA	ETF	46.16	46.24	46.01	46.01	20500.0
2014-09-23	AOK	ETF	32.5701	32.64	32.5601	32.58	10617.0
2014-09-23	AOM	ETF	35.17	35.19	35.0803	35.1	24566.0
2014-09-23	AOR	ETF	39.77	39.89	39.7001	39.73	23302.0
2014-09-23	ARGT	ETF	21.62	21.62	21.27	21.41	644500.0
2014-09-23	ASEA	ETF	16.88	17.0	16.88	16.9	7900.0
2014-09-23	ASHR	ETF	25.06	25.15	24.97	25.04	529200.0
2014-09-23	ASHS	ETF	32.45	32.46	32.36	32.36	3200.0
2014-09-23	ATMP	ETF	32.11	32.47	31.94	31.97	86700.0
2014-09-23	AVIV	ETF	27.5	27.61	27.2	27.24	194783.0
2014-09-23	AWAY	ETF	32.69	33.3	32.486	33.13	695433.0
2014-09-23	BAB	ETF	29.48	29.6	29.48	29.59	85324.0
2014-09-23	BAL	ETF	41.78	42.26	41.75	41.91	5741.0
2014-09-23	BALT	ETF	4.64	4.72	4.44	4.49	952360.0
2014-09-23	BAR	ETF	3.181	3.181	3.1302	3.1302	28670.0
2014-09-23	BBH	ETF	105.48	106.56	105.48	105.53	30400.0
2014-09-23	BCHP	ETF	19.6228	19.67	19.601	19.601	649.0
2014-09-23	BCM	ETF	37.1199	37.1199	37.083	37.083	6044.0
2014-09-23	BFOR	ETF	7.645	7.67	7.61	7.625	102400.0
2014-09-23	BIB	ETF	50.75	52.25	50.75	51.374	352834.0
2014-09-23	BICK	ETF	25.74	25.83	25.74	25.7499	1253.0
2014-09-23	BIL	ETF	91.5	91.52	91.5	91.52	112100.0
2014-09-23	BIS	ETF	497.2	497.2	482.4	490.4	8677.0
2014-09-23	BIV	ETF	84.07	84.17	84.03	84.16	143300.0
2014-09-23	BIZD	ETF	19.84	19.87	19.8	19.8	6900.0

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

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