PREVIEW / etf_daily / 2015-10-07

all etf daily files

  file:    by_date/etf_daily/2015/2015-10-07.parquet
  size:    48 KB
  rows:    1,206

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-07	SPY	ETF	198.9	199.83	197.48	199.41	124307300.0
2015-10-07	QQQ	ETF	105.66	105.86	104.29	105.63	37389334.0
2015-10-07	IWM	ETF	113.1	114.5	112.63	114.48	36371000.0
2015-10-07	DIA	ETF	168.6	169.48	167.47	168.95	8832800.0
2015-10-07	GLD	ETF	109.75	110.14	109.34	109.7	5355500.0
2015-10-07	TLT	ETF	122.81	123.33	122.51	122.99	6712800.0
2015-10-07	AADR	ETF	37.55	37.55	37.55	37.55	500.0
2015-10-07	AAXJ	ETF	56.39	56.87	56.19	56.57	1039300.0
2015-10-07	ACTX	ETF	9.4401	12.3901	8.8501	12.3901	3117.0
2015-10-07	ACWI	ETF	56.48	56.77	56.13	56.61	1450700.0
2015-10-07	ACWV	ETF	68.82	69.01	68.56	68.86	69100.0
2015-10-07	ACWX	ETF	41.33	41.548	41.1	41.39	979151.0
2015-10-07	ADRE	ETF	30.0	30.3	29.931	30.0628	5142.0
2015-10-07	AFK	ETF	21.13	21.13	20.78	20.97	43242.0
2015-10-07	AFTY	ETF	16.19	16.19	15.86	15.96	23500.0
2015-10-07	AGG	ETF	109.55	109.68	109.48	109.57	1983200.0
2015-10-07	AGQ	ETF	36.47	37.35	36.29	36.96	139500.0
2015-10-07	AGZ	ETF	113.8	114.05	113.72	113.86	20489.0
2015-10-07	AGZD	ETF	23.98	23.985	23.9	23.955	2400.0
2015-10-07	AIA	ETF	44.72	45.12	44.63	44.75	18305.0
2015-10-07	AIQ	ETF	10.22	10.29	10.04	10.25	21896.0
2015-10-07	AIRR	ETF	16.4	16.426	16.11	16.345	24600.0
2015-10-07	AIVI	ETF	40.35	40.54	40.18	40.41	13200.0
2015-10-07	AMJ	ETF	33.85	34.4	33.58	34.25	3591476.0
2015-10-07	AMLP	ETF	69.9	70.25	69.0	70.1	1706520.0
2015-10-07	AMZA	ETF	151.0	152.5	149.6	151.8	1040.0
2015-10-07	ANGL	ETF	25.88	26.13	25.8	26.06	39600.0
2015-10-07	AOA	ETF	45.2	45.29	44.93	45.22	45300.0
2015-10-07	AOK	ETF	31.98	31.9899	31.86	31.98	43944.0
2015-10-07	AOM	ETF	34.26	34.43	34.26	34.42	31869.0
2015-10-07	AOR	ETF	39.12	39.19	38.9555	39.16	128865.0
2015-10-07	ARGT	ETF	17.31	17.54	17.23	17.45	9900.0
2015-10-07	ARKG	ETF	19.0	19.0	19.0	19.0	100.0
2015-10-07	ARKK	ETF	19.51	19.51	19.51	19.51	100.0
2015-10-07	ARKQ	ETF	18.17	18.17	18.17	18.17	300.0
2015-10-07	ARKW	ETF	21.704	21.704	21.704	21.704	800.0
2015-10-07	ASEA	ETF	13.05	13.16	13.05	13.16	1600.0
2015-10-07	ASHR	ETF	34.6	34.7	34.26	34.52	3143100.0
2015-10-07	ASHS	ETF	39.51	39.51	38.54	38.84	132800.0
2015-10-07	ATMP	ETF	23.02	23.52	23.02	23.49	116200.0
2015-10-07	AWAY	ETF	27.46	27.94	26.92	27.71	1165112.0
2015-10-07	BAB	ETF	29.31	29.3107	29.2	29.23	80252.0
2015-10-07	BAL	ETF	41.66	41.66	41.27	41.51	9485.0
2015-10-07	BBC	ETF	26.832	28.0324	26.71	27.5001	7147.0
2015-10-07	BBH	ETF	114.14	117.26	112.48	116.2	298900.0
2015-10-07	BBP	ETF	27.74	29.01	27.64	28.55	15000.0
2015-10-07	BCM	ETF	27.5462	27.568	27.5462	27.56	3548.0
2015-10-07	BFOR	ETF	7.66	7.725	7.66	7.7	36000.0
2015-10-07	BIB	ETF	58.82	61.6699	56.35	60.22	1730487.0
2015-10-07	BICK	ETF	20.29	20.2963	20.29	20.2963	1000.0

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

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