PREVIEW / etf_daily / 2017-02-14

all etf daily files

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

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-14	SPY	ETF	232.56	233.71	232.16	233.7	71109000.0
2017-02-14	QQQ	ETF	128.15	128.535	127.74	128.53	16333480.0
2017-02-14	IWM	ETF	137.94	138.95	137.61	138.76	27145000.0
2017-02-14	DIA	ETF	204.06	205.18	203.95	205.17	3586600.0
2017-02-14	GLD	ETF	117.51	117.56	116.38	116.93	6927800.0
2017-02-14	TLT	ETF	120.24	120.3	118.83	119.51	13210500.0
2017-02-14	AADR	ETF	45.9	45.9	44.95	45.45	22000.0
2017-02-14	AAXJ	ETF	60.4	60.43	59.97	60.43	778200.0
2017-02-14	ACSI	ETF	27.79	27.83	27.7	27.83	4150.0
2017-02-14	ACTX	ETF	153.4014	153.4014	139.8313	147.5013	2020.0
2017-02-14	ACWF	ETF	25.37	25.4799	25.33	25.4799	9135.0
2017-02-14	ACWI	ETF	62.0	62.18	61.78	62.15	2269600.0
2017-02-14	ACWV	ETF	75.07	75.07	74.69	75.03	351500.0
2017-02-14	ACWX	ETF	42.4	42.46	42.2	42.45	475414.0
2017-02-14	ADRE	ETF	36.13	36.1656	35.9	36.15	28835.0
2017-02-14	AFK	ETF	21.93	21.95	21.47	21.63	18989.0
2017-02-14	AFTY	ETF	13.96	13.97	13.96	13.97	700.0
2017-02-14	AGG	ETF	108.3	108.3	107.91	108.06	2809500.0
2017-02-14	AGGY	ETF	49.56	49.72	49.52	49.646	9800.0
2017-02-14	AGNG	ETF	16.22	16.23	16.22	16.22	300.0
2017-02-14	AGQ	ETF	40.82	40.99	39.51	40.45	239300.0
2017-02-14	AGZ	ETF	112.81	112.8226	112.485	112.62	23944.0
2017-02-14	AGZD	ETF	24.09	24.14	24.035	24.115	8400.0
2017-02-14	AIA	ETF	50.4	50.41	50.0603	50.36	17169.0
2017-02-14	AIQ	ETF	10.25	10.303	10.2	10.3001	9897.0
2017-02-14	AIRR	ETF	24.31	24.31	24.0	24.21	104100.0
2017-02-14	AIVI	ETF	38.75	38.75	38.5	38.69	18700.0
2017-02-14	ALTY	ETF	15.7	15.7	15.42	15.42	9300.0
2017-02-14	AMJ	ETF	34.03	34.22	33.8	34.22	1892255.0
2017-02-14	AMLP	ETF	65.15	65.55	64.95	65.5	1333760.0
2017-02-14	AMZA	ETF	113.7	114.4	113.1	114.3	36200.0
2017-02-14	ANGL	ETF	29.47	29.49	29.38	29.49	231100.0
2017-02-14	AOA	ETF	49.04	49.06	48.8	49.06	62800.0
2017-02-14	AOK	ETF	33.02	33.02	32.8601	32.9443	74124.0
2017-02-14	AOM	ETF	35.79	35.93	35.79	35.92	97359.0
2017-02-14	AOR	ETF	41.68	41.73	41.5401	41.73	123825.0
2017-02-14	ARGT	ETF	26.97	27.0	26.73	27.0	81300.0
2017-02-14	ARKG	ETF	18.95	19.11	18.89	19.08	12800.0
2017-02-14	ARKK	ETF	23.13	23.22	23.11	23.22	11600.0
2017-02-14	ARKQ	ETF	24.54	24.63	24.51	24.58	12100.0
2017-02-14	ARKW	ETF	28.43	28.43	28.16	28.31	3800.0
2017-02-14	ASEA	ETF	13.62	13.62	13.51	13.56	3700.0
2017-02-14	ASET	ETF	26.07	26.195	26.0459	26.195	3727.0
2017-02-14	ASHR	ETF	25.03	25.05	24.94	25.05	459100.0
2017-02-14	ASHS	ETF	33.76	33.87	33.76	33.87	3700.0
2017-02-14	ATMP	ETF	24.79	25.71	24.52	24.84	157800.0
2017-02-14	BAB	ETF	29.38	29.45	29.332	29.43	167473.0
2017-02-14	BAL	ETF	50.65	50.8711	50.65	50.7708	12861.0
2017-02-14	BBC	ETF	20.7	21.18	20.7	21.18	9594.0
2017-02-14	BBH	ETF	117.98	118.87	117.17	118.73	57400.0

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

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