PREVIEW / etf_daily / 2015-09-08

all etf daily files

  file:    by_date/etf_daily/2015/2015-09-08.parquet
  size:    49 KB
  rows:    1,203

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-09-08	SPY	ETF	195.94	197.61	195.17	197.43	116025700.0
2015-09-08	QQQ	ETF	104.12	105.165	103.69	105.04	37343527.0
2015-09-08	IWM	ETF	114.56	115.57	114.11	115.45	29916300.0
2015-09-08	DIA	ETF	163.81	165.03	163.28	164.91	6821700.0
2015-09-08	GLD	ETF	107.6	107.94	107.31	107.52	5982100.0
2015-09-08	TLT	ETF	121.38	121.56	120.76	120.87	7049500.0
2015-09-08	AADR	ETF	36.72	36.76	36.36	36.76	1500.0
2015-09-08	AAXJ	ETF	52.51	53.01	52.5	52.97	1044300.0
2015-09-08	ACTX	ETF	1.18	2.36	1.18	2.36	1844.0
2015-09-08	ACWI	ETF	55.16	55.5	54.98	55.48	3111400.0
2015-09-08	ACWV	ETF	67.01	67.22	66.63	67.2	47500.0
2015-09-08	ACWX	ETF	40.08	40.24	39.97	40.24	1030118.0
2015-09-08	ADRE	ETF	29.18	29.36	29.0501	29.16	10151.0
2015-09-08	AFK	ETF	20.06	20.47	19.82	20.47	13664.0
2015-09-08	AFTY	ETF	15.31	15.43	15.25	15.4	38300.0
2015-09-08	AGG	ETF	108.96	109.04	108.91	109.01	2130400.0
2015-09-08	AGQ	ETF	31.53	32.22	30.98	31.82	136600.0
2015-09-08	AGZ	ETF	113.6	113.67	113.41	113.5	37815.0
2015-09-08	AGZD	ETF	24.05	24.055	23.97	23.99	2000.0
2015-09-08	AIA	ETF	42.07	42.3	41.98	42.3	40834.0
2015-09-08	AIQ	ETF	14.71	15.0	14.34	14.69	20390.0
2015-09-08	AIRR	ETF	16.97	16.97	16.53	16.57	3300.0
2015-09-08	AIVI	ETF	39.67	39.93	39.57	39.81	26600.0
2015-09-08	ALTY	ETF	14.31	14.31	14.29	14.295	500.0
2015-09-08	AMJ	ETF	35.32	35.4799	34.91	35.11	1402549.0
2015-09-08	AMLP	ETF	71.65	71.9	71.25	71.55	856080.0
2015-09-08	AMZA	ETF	166.0	166.3	164.9	165.18	990.0
2015-09-08	ANGL	ETF	26.48	26.5	26.3	26.5	6100.0
2015-09-08	AOA	ETF	44.44	44.51	44.25	44.51	46800.0
2015-09-08	AOK	ETF	31.7	31.7	31.59	31.64	22039.0
2015-09-08	AOM	ETF	34.11	34.1499	34.0	34.13	35612.0
2015-09-08	AOR	ETF	38.79	38.79	38.48	38.71	176673.0
2015-09-08	ARGT	ETF	18.17	18.17	17.87	17.89	6900.0
2015-09-08	ARKG	ETF	20.98	21.29	20.98	21.29	6300.0
2015-09-08	ARKK	ETF	20.02	20.02	20.02	20.02	100.0
2015-09-08	ARKQ	ETF	18.19	18.248	18.19	18.248	400.0
2015-09-08	ARKW	ETF	21.82	22.0	21.759	22.0	1300.0
2015-09-08	ASEA	ETF	12.47	12.47	12.37	12.43	10500.0
2015-09-08	ASHR	ETF	33.23	33.6	33.01	33.6	5287200.0
2015-09-08	ASHS	ETF	36.88	38.59	36.85	37.43	146600.0
2015-09-08	ATMP	ETF	23.97	23.98	23.78	23.93	312800.0
2015-09-08	AWAY	ETF	28.28	28.62	28.08	28.5	679594.0
2015-09-08	BAB	ETF	29.02	29.02	28.82	28.87	112428.0
2015-09-08	BAL	ETF	42.28	42.49	42.09	42.4	3697.0
2015-09-08	BBC	ETF	32.24	32.8624	31.57	32.8	15699.0
2015-09-08	BBH	ETF	127.2	129.89	125.26	129.7	180300.0
2015-09-08	BBP	ETF	32.63	33.13	32.3	33.11	6600.0
2015-09-08	BCHP	ETF	17.729	17.81	17.729	17.81	496.0
2015-09-08	BCM	ETF	26.932	27.22	26.932	27.214	4891.0
2015-09-08	BFOR	ETF	7.7	7.775	7.685	7.7675	94400.0

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

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