PREVIEW / etf_daily / 2017-02-03

all etf daily files

  file:    by_date/etf_daily/2017/2017-02-03.parquet
  size:    54 KB
  rows:    1,355

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
2017-02-03	SPY	ETF	228.82	229.55	228.46	229.34	80563200.0
2017-02-03	QQQ	ETF	125.49	125.81	125.33	125.68	16957154.0
2017-02-03	IWM	ETF	135.99	136.98	135.51	136.87	24534100.0
2017-02-03	DIA	ETF	199.58	200.57	199.44	200.38	4857300.0
2017-02-03	GLD	ETF	115.73	116.37	115.71	116.13	9455500.0
2017-02-03	TLT	ETF	119.44	119.87	118.47	119.0	10275600.0
2017-02-03	AADR	ETF	45.88	45.88	44.82	44.96	6200.0
2017-02-03	AAXJ	ETF	59.39	59.6	59.29	59.55	638300.0
2017-02-03	ACSI	ETF	27.2099	27.2099	27.2	27.2	3550.0
2017-02-03	ACTX	ETF	197.9468	198.2418	106.791	159.3014	29643.0
2017-02-03	ACWF	ETF	25.9	25.9	25.41	25.46	608.0
2017-02-03	ACWI	ETF	61.26	61.41	61.15	61.35	1997700.0
2017-02-03	ACWV	ETF	74.31	74.43	74.13	74.34	424400.0
2017-02-03	ACWX	ETF	42.1	42.22	42.0455	42.15	541232.0
2017-02-03	ADRE	ETF	35.3	35.3878	35.225	35.2933	3622.0
2017-02-03	AFK	ETF	21.5	21.92	21.215	21.3828	4507.0
2017-02-03	AFTY	ETF	13.788	13.84	13.788	13.81	8400.0
2017-02-03	AGG	ETF	108.12	108.28	107.86	108.01	2728400.0
2017-02-03	AGGY	ETF	49.67	49.722	49.49	49.53	13200.0
2017-02-03	AGNG	ETF	16.05	16.05	16.05	16.05	100.0
2017-02-03	AGQ	ETF	38.1	38.71	38.01	38.35	128000.0
2017-02-03	AGZ	ETF	112.89	113.0	112.64	112.77	18560.0
2017-02-03	AGZD	ETF	24.015	24.08	24.0	24.08	2200.0
2017-02-03	AIA	ETF	49.83	50.07	49.83	49.97	16813.0
2017-02-03	AIQ	ETF	10.0	10.25	9.95	10.2	32406.0
2017-02-03	AIRR	ETF	24.16	24.45	24.13	24.399	143700.0
2017-02-03	AIVI	ETF	38.46	38.51	38.35	38.44	8900.0
2017-02-03	ALTY	ETF	15.41	15.41	15.28	15.32	3800.0
2017-02-03	AMJ	ETF	33.9	34.13	33.78	34.03	2014636.0
2017-02-03	AMLP	ETF	66.45	66.55	66.1	66.45	1787580.0
2017-02-03	AMZA	ETF	113.0	113.8	112.9	113.8	46070.0
2017-02-03	ANGL	ETF	29.36	29.37	29.32	29.34	285300.0
2017-02-03	AOA	ETF	48.53	48.59	48.37	48.59	93600.0
2017-02-03	AOK	ETF	32.69	32.8499	32.69	32.77	36216.0
2017-02-03	AOM	ETF	35.71	35.75	35.64	35.7	213507.0
2017-02-03	AOR	ETF	41.43	41.43	41.2801	41.35	195329.0
2017-02-03	ARGT	ETF	26.42	26.61	26.35	26.49	77400.0
2017-02-03	ARKG	ETF	18.23	18.24	18.15	18.15	2000.0
2017-02-03	ARKK	ETF	22.29	22.38	22.28	22.38	8000.0
2017-02-03	ARKQ	ETF	23.65	23.79	23.635	23.708	1600.0
2017-02-03	ARKW	ETF	27.8	27.8	27.53	27.6	2700.0
2017-02-03	ASET	ETF	25.898	25.99	25.898	25.985	2678.0
2017-02-03	ASHR	ETF	24.7	24.84	24.69	24.78	430900.0
2017-02-03	ASHS	ETF	33.34	33.43	33.28	33.32	11000.0
2017-02-03	ASHX	ETF	19.12	19.2309	19.0501	19.2309	15400.0
2017-02-03	ATMP	ETF	24.7	25.01	24.7	24.89	47200.0
2017-02-03	BAB	ETF	29.15	29.194	29.03	29.04	91097.0
2017-02-03	BAL	ETF	50.9	50.9	50.3701	50.39	7641.0
2017-02-03	BBC	ETF	19.98	20.42	19.96	20.42	4850.0
2017-02-03	BBH	ETF	115.69	116.07	115.0	116.05	40600.0

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

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