PREVIEW / etf_daily / 2016-10-05

all etf daily files

  file:    by_date/etf_daily/2016/2016-10-05.parquet
  size:    52 KB
  rows:    1,295

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
2016-10-05	SPY	ETF	215.41	216.13	215.33	215.63	72816000.0
2016-10-05	QQQ	ETF	118.7	119.17	118.67	118.79	14481285.0
2016-10-05	IWM	ETF	123.69	124.68	123.65	123.95	24317300.0
2016-10-05	DIA	ETF	182.16	183.02	182.11	182.66	1818200.0
2016-10-05	GLD	ETF	121.33	121.59	120.4	120.78	14718100.0
2016-10-05	TLT	ETF	135.02	135.08	134.12	134.58	8917700.0
2016-10-05	AADR	ETF	40.21	40.39	40.21	40.33	1600.0
2016-10-05	AAXJ	ETF	60.82	61.09	60.7	61.04	719200.0
2016-10-05	ACTX	ETF	7.0801	7.6701	6.4901	6.4901	1515.0
2016-10-05	ACWI	ETF	58.95	59.19	58.95	59.09	710400.0
2016-10-05	ACWV	ETF	75.2	75.26	74.9	74.95	452700.0
2016-10-05	ACWX	ETF	41.47	41.635	41.42	41.6	1559461.0
2016-10-05	ADRE	ETF	35.22	35.4228	35.17	35.39	8946.0
2016-10-05	AFK	ETF	20.41	20.6999	20.265	20.6999	4594.0
2016-10-05	AFTY	ETF	13.46	13.47	13.4	13.44	5300.0
2016-10-05	AGG	ETF	111.69	111.74	111.51	111.56	3368700.0
2016-10-05	AGGY	ETF	51.7	51.79	51.62	51.63	7500.0
2016-10-05	AGQ	ETF	41.7	41.87	40.2	41.15	243400.0
2016-10-05	AGZ	ETF	115.28	115.2817	115.1	115.1	9417.0
2016-10-05	AIA	ETF	50.25	50.54	50.21	50.44	69181.0
2016-10-05	AIQ	ETF	6.93	7.35	6.93	7.225	15410.0
2016-10-05	AIRR	ETF	20.409	20.605	20.409	20.532	8800.0
2016-10-05	AIVI	ETF	38.83	38.95	38.78	38.88	21400.0
2016-10-05	ALTY	ETF	15.37	15.37	15.223	15.27	3200.0
2016-10-05	AMJ	ETF	31.11	31.51	30.88	30.98	2141205.0
2016-10-05	AMLP	ETF	63.05	63.25	62.55	63.0	1440060.0
2016-10-05	AMZA	ETF	109.2	109.5	108.6	109.0	24400.0
2016-10-05	ANGL	ETF	28.86	28.89	28.83	28.88	182200.0
2016-10-05	AOA	ETF	47.33	47.38	47.17	47.3	27300.0
2016-10-05	AOK	ETF	33.14	33.29	33.11	33.15	57842.0
2016-10-05	AOM	ETF	35.83	35.8899	35.75	35.79	62192.0
2016-10-05	AOR	ETF	41.0	41.0	40.7601	40.89	61483.0
2016-10-05	ARGT	ETF	24.18	24.36	24.05	24.27	18700.0
2016-10-05	ARKG	ETF	19.92	20.17	19.91	20.092	1600.0
2016-10-05	ARKK	ETF	22.33	22.41	22.319	22.393	7900.0
2016-10-05	ARKQ	ETF	22.49	22.49	22.49	22.49	300.0
2016-10-05	ARKW	ETF	25.82	25.82	25.69	25.71	17400.0
2016-10-05	ASEA	ETF	14.08	14.08	14.08	14.08	1300.0
2016-10-05	ASHR	ETF	24.45	24.53	24.45	24.52	776600.0
2016-10-05	ASHS	ETF	34.63	34.66	34.57	34.62	18500.0
2016-10-05	ATMP	ETF	23.18	23.18	22.97	23.04	106300.0
2016-10-05	BAB	ETF	31.2	31.2	31.09	31.1	81513.0
2016-10-05	BAL	ETF	45.42	45.66	44.55	44.7648	24643.0
2016-10-05	BBC	ETF	22.6163	23.104	22.6163	22.84	8518.0
2016-10-05	BBH	ETF	114.87	116.1	114.85	115.3	29600.0
2016-10-05	BBP	ETF	33.6	33.61	33.45	33.519	1200.0
2016-10-05	BCM	ETF	26.638	26.64	26.605	26.605	1282.0
2016-10-05	BFOR	ETF	8.03	8.115	8.03	8.08	15600.0
2016-10-05	BIB	ETF	48.32	49.55	48.14	48.92	381767.0
2016-10-05	BIL	ETF	91.44	91.46	91.44	91.46	518500.0

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

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