PREVIEW / etf_daily / 2015-10-01

all etf daily files

  file:    by_date/etf_daily/2015/2015-10-01.parquet
  size:    49 KB
  rows:    1,214

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-10-01	SPY	ETF	192.08	192.49	189.82	192.13	131079000.0
2015-10-01	QQQ	ETF	101.94	102.23	100.59	102.22	39339134.0
2015-10-01	IWM	ETF	109.37	109.68	107.43	109.01	44985900.0
2015-10-01	DIA	ETF	163.01	163.29	160.51	162.49	6862800.0
2015-10-01	GLD	ETF	106.98	107.21	106.63	106.73	4278600.0
2015-10-01	TLT	ETF	124.08	124.52	123.66	123.81	9069400.0
2015-10-01	AADR	ETF	35.94	36.45	35.94	36.12	2100.0
2015-10-01	AAXJ	ETF	53.03	53.31	52.65	53.01	2744800.0
2015-10-01	ACTX	ETF	17.1102	19.4702	11.8001	13.5701	3175.0
2015-10-01	ACWF	ETF	22.27	22.27	22.2699	22.2699	2000.0
2015-10-01	ACWI	ETF	54.19	55.34	53.52	54.06	1950500.0
2015-10-01	ACWV	ETF	67.01	67.11	66.5	66.92	1361100.0
2015-10-01	ACWX	ETF	39.28	39.31	38.85	39.18	1359098.0
2015-10-01	ADRE	ETF	28.04	28.0977	27.7801	27.97	10949.0
2015-10-01	AFK	ETF	19.87	19.98	19.8328	19.8328	2809.0
2015-10-01	AFTY	ETF	15.04	15.04	14.98	15.0	5500.0
2015-10-01	AGG	ETF	109.48	109.65	109.45	109.46	4274900.0
2015-10-01	AGQ	ETF	30.95	31.25	30.33	30.61	144500.0
2015-10-01	AGZ	ETF	113.98	114.18	113.68	113.68	89152.0
2015-10-01	AGZD	ETF	23.965	23.995	23.91	23.91	5400.0
2015-10-01	AIA	ETF	41.93	41.98	41.64	41.98	18676.0
2015-10-01	AIQ	ETF	9.69	10.06	9.0	10.04	61269.0
2015-10-01	AIRR	ETF	15.14	15.14	14.98	15.08	7000.0
2015-10-01	AIVI	ETF	38.32	38.32	37.89	38.1	11400.0
2015-10-01	AMJ	ETF	30.72	31.69	30.506	31.61	5497504.0
2015-10-01	AMLP	ETF	63.1	65.35	63.0	65.05	2787540.0
2015-10-01	AMZA	ETF	137.7	140.99	135.0	140.5	1080.0
2015-10-01	ANGL	ETF	25.6	25.6	25.5	25.52	11500.0
2015-10-01	AOA	ETF	43.72	43.75	43.4	43.68	42800.0
2015-10-01	AOK	ETF	31.5	31.5555	31.44	31.5	113171.0
2015-10-01	AOM	ETF	33.78	33.87	33.7401	33.87	142806.0
2015-10-01	AOR	ETF	38.26	38.3999	37.998	38.23	262529.0
2015-10-01	ARGT	ETF	16.11	16.12	15.78	15.92	3500.0
2015-10-01	ARKG	ETF	18.41	18.41	18.41	18.41	100.0
2015-10-01	ARKK	ETF	18.53	18.53	18.53	18.53	1300.0
2015-10-01	ARKQ	ETF	17.2	17.2	17.2	17.2	100.0
2015-10-01	ARKW	ETF	21.0	21.13	21.0	21.13	2200.0
2015-10-01	ASEA	ETF	11.98	11.98	11.85	11.87	35400.0
2015-10-01	ASHR	ETF	32.5	32.62	32.22	32.59	672700.0
2015-10-01	ASHS	ETF	36.94	36.94	36.47	36.69	32100.0
2015-10-01	ATMP	ETF	21.01	21.44	20.87	21.41	76000.0
2015-10-01	AWAY	ETF	26.52	26.64	25.9	26.59	1148276.0
2015-10-01	BAB	ETF	29.26	29.38	29.2501	29.31	77216.0
2015-10-01	BAL	ETF	40.05	40.58	39.79	40.58	4033.0
2015-10-01	BBC	ETF	26.12	26.55	25.55	26.55	8300.0
2015-10-01	BBH	ETF	114.44	115.6	112.59	115.48	183800.0
2015-10-01	BBP	ETF	27.74	27.75	26.965	27.71	16200.0
2015-10-01	BCM	ETF	27.01	27.01	26.567	26.5799	12922.0
2015-10-01	BFOR	ETF	7.4375	7.4375	7.335	7.4025	20800.0
2015-10-01	BIB	ETF	58.54	59.72	56.25	59.6	2012997.0

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

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