PREVIEW / etf_daily / 2015-10-15

all etf daily files

  file:    by_date/etf_daily/2015/2015-10-15.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-15	SPY	ETF	200.08	202.36	199.64	202.35	134142200.0
2015-10-15	QQQ	ETF	106.32	107.675	106.18	107.67	38393838.0
2015-10-15	IWM	ETF	113.19	115.57	112.66	115.57	42503400.0
2015-10-15	DIA	ETF	169.4	171.32	169.19	171.32	9637200.0
2015-10-15	GLD	ETF	113.2	113.99	112.94	113.29	14083900.0
2015-10-15	TLT	ETF	124.31	124.46	123.78	123.89	6924300.0
2015-10-15	AADR	ETF	37.79	37.79	37.79	37.79	100.0
2015-10-15	AAXJ	ETF	57.62	58.11	57.45	58.11	1280200.0
2015-10-15	ACTX	ETF	10.6201	12.3901	10.0301	11.8001	1537.0
2015-10-15	ACWI	ETF	56.94	57.56	56.87	57.56	1542700.0
2015-10-15	ACWV	ETF	69.64	70.17	69.5	70.09	44000.0
2015-10-15	ACWX	ETF	41.71	42.09	41.6919	42.08	648901.0
2015-10-15	ADRE	ETF	30.07	30.372	30.07	30.32	5808.0
2015-10-15	AFK	ETF	21.25	21.47	21.06	21.38	59074.0
2015-10-15	AFTY	ETF	15.95	16.21	15.95	16.2	19600.0
2015-10-15	AGG	ETF	109.93	110.05	109.79	109.88	2044800.0
2015-10-15	AGQ	ETF	37.18	37.64	36.96	37.34	136400.0
2015-10-15	AGZ	ETF	114.26	114.31	114.05	114.18	21730.0
2015-10-15	AGZD	ETF	24.02	24.02	23.92	23.95	5000.0
2015-10-15	AIA	ETF	46.11	46.38	46.0099	46.378	11892.0
2015-10-15	AIQ	ETF	10.09	10.58	9.98	10.53	20523.0
2015-10-15	AIRR	ETF	16.42	16.64	16.306	16.64	8900.0
2015-10-15	AIVI	ETF	40.9	41.35	40.9	41.29	13100.0
2015-10-15	AMJ	ETF	33.63	34.21	33.29	34.18	2532045.0
2015-10-15	AMLP	ETF	68.85	69.8	68.05	69.8	1127100.0
2015-10-15	AMZA	ETF	146.5	150.0	144.7	149.4	1500.0
2015-10-15	ANGL	ETF	26.05	26.12	26.02	26.12	21600.0
2015-10-15	AOA	ETF	45.35	45.76	45.3	45.76	32700.0
2015-10-15	AOK	ETF	32.09	32.19	31.9901	32.19	23628.0
2015-10-15	AOM	ETF	34.5	34.69	34.48	34.69	97208.0
2015-10-15	AOR	ETF	39.26	39.54	39.26	39.54	41793.0
2015-10-15	ARGT	ETF	17.66	17.66	17.59	17.62	2500.0
2015-10-15	ARKG	ETF	19.24	19.31	19.24	19.31	400.0
2015-10-15	ARKK	ETF	19.525	19.525	19.525	19.525	100.0
2015-10-15	ARKQ	ETF	18.54	18.54	18.29	18.29	300.0
2015-10-15	ARKW	ETF	21.8	21.8	21.8	21.8	300.0
2015-10-15	ASEA	ETF	13.51	13.52	13.49	13.52	6500.0
2015-10-15	ASHR	ETF	35.31	35.84	35.25	35.77	4276100.0
2015-10-15	ASHS	ETF	42.99	42.99	42.09	42.7	46700.0
2015-10-15	ATMP	ETF	22.89	23.44	22.89	23.43	20300.0
2015-10-15	AWAY	ETF	28.41	29.02	28.25	29.0	869356.0
2015-10-15	BAB	ETF	29.36	29.36	29.2052	29.26	76452.0
2015-10-15	BAL	ETF	42.34	42.36	42.26	42.36	5232.0
2015-10-15	BBC	ETF	25.88	28.2	25.88	28.1655	16434.0
2015-10-15	BBH	ETF	113.38	118.88	113.38	118.88	143600.0
2015-10-15	BBP	ETF	28.07	29.74	28.07	29.74	10700.0
2015-10-15	BCHP	ETF	18.65	18.65	18.65	18.65	127.0
2015-10-15	BCM	ETF	27.34	27.51	27.3291	27.51	2389.0
2015-10-15	BFOR	ETF	7.665	7.7625	7.6375	7.755	64400.0
2015-10-15	BIB	ETF	56.45	62.81	56.2148	62.79	1654139.0

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

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