PREVIEW / etf_daily / 2015-10-12

all etf daily files

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

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-12	SPY	ETF	201.42	201.76	200.91	201.52	56395600.0
2015-10-12	QQQ	ETF	106.73	106.9899	106.35	106.79	16161955.0
2015-10-12	IWM	ETF	115.79	115.99	115.07	115.57	22984000.0
2015-10-12	DIA	ETF	170.73	171.23	170.47	171.17	2835800.0
2015-10-12	GLD	ETF	111.67	111.73	111.01	111.31	6257900.0
2015-10-12	TLT	ETF	123.03	123.43	122.91	123.21	4241000.0
2015-10-12	AADR	ETF	38.06	38.06	37.59	37.83	5600.0
2015-10-12	AAXJ	ETF	57.14	57.25	56.88	56.95	660500.0
2015-10-12	ACTX	ETF	8.5551	8.8501	7.0801	8.8501	2371.0
2015-10-12	ACWI	ETF	57.22	57.24	57.04	57.15	661600.0
2015-10-12	ACWV	ETF	69.4	69.63	69.21	69.54	60100.0
2015-10-12	ACWX	ETF	41.77	41.83	41.69	41.73	404592.0
2015-10-12	ADRE	ETF	30.5	30.89	30.212	30.25	6176.0
2015-10-12	AFK	ETF	21.31	21.4	21.27	21.33	12257.0
2015-10-12	AFTY	ETF	16.14	16.14	15.86	15.92	20700.0
2015-10-12	AGG	ETF	109.48	109.65	109.33	109.61	1268800.0
2015-10-12	AGGY	ETF	49.96	49.97	49.95	49.95	400.0
2015-10-12	AGQ	ETF	37.08	37.08	35.91	36.12	209500.0
2015-10-12	AGZ	ETF	113.74	114.07	113.6901	113.93	23609.0
2015-10-12	AGZD	ETF	24.02	24.02	24.01	24.02	1800.0
2015-10-12	AIA	ETF	45.37	45.4	45.2	45.23	8369.0
2015-10-12	AIQ	ETF	10.22	10.45	10.1	10.17	11273.0
2015-10-12	AIRR	ETF	16.964	16.964	16.76	16.8	48600.0
2015-10-12	AIVI	ETF	40.98	41.06	40.8	40.95	45900.0
2015-10-12	AMJ	ETF	34.7	34.7	33.84	34.07	1802244.0
2015-10-12	AMLP	ETF	70.6	70.85	69.2	69.75	1054460.0
2015-10-12	AMZA	ETF	152.4	152.4	148.71	149.8	1420.0
2015-10-12	ANGL	ETF	26.18	26.18	26.07	26.16	8300.0
2015-10-12	AOA	ETF	45.54	45.61	45.46	45.5	47200.0
2015-10-12	AOK	ETF	31.95	32.1499	31.95	32.13	31734.0
2015-10-12	AOM	ETF	34.55	34.64	34.5	34.58	118369.0
2015-10-12	AOR	ETF	39.43	39.44	39.33	39.44	112758.0
2015-10-12	ARGT	ETF	17.82	17.82	17.82	17.82	400.0
2015-10-12	ARKG	ETF	19.21	19.21	19.21	19.21	300.0
2015-10-12	ARKK	ETF	19.67	19.67	19.67	19.67	100.0
2015-10-12	ARKQ	ETF	18.4	18.4	18.4	18.4	100.0
2015-10-12	ARKW	ETF	22.14	22.14	22.088	22.088	400.0
2015-10-12	ASEA	ETF	13.63	13.63	13.5	13.5	4500.0
2015-10-12	ASHR	ETF	34.85	35.07	34.83	34.85	2083900.0
2015-10-12	ASHS	ETF	41.0	41.0	40.25	40.75	62800.0
2015-10-12	ATMP	ETF	23.67	23.67	23.12	23.36	16900.0
2015-10-12	AWAY	ETF	27.78	28.11	27.29	28.06	955850.0
2015-10-12	BAB	ETF	29.32	29.335	29.129	29.27	79778.0
2015-10-12	BAL	ETF	41.0694	41.18	41.01	41.18	2629.0
2015-10-12	BBC	ETF	27.59	27.694	27.0	27.0	3700.0
2015-10-12	BBH	ETF	117.13	117.71	115.82	116.68	185900.0
2015-10-12	BBP	ETF	28.83	29.2	28.59	28.8	4300.0
2015-10-12	BCHP	ETF	18.51	18.51	18.51	18.51	1177.0
2015-10-12	BCM	ETF	27.4336	27.4665	27.4336	27.4532	2421.0
2015-10-12	BFOR	ETF	7.825	7.825	7.78	7.8175	59600.0

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

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