PREVIEW / etf_daily / 2017-03-09

all etf daily files

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

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-03-09	SPY	ETF	236.7	237.24	235.74	236.86	90683900.0
2017-03-09	QQQ	ETF	130.71	131.02	130.14	130.84	20855253.0
2017-03-09	IWM	ETF	135.83	136.49	134.89	135.36	35223800.0
2017-03-09	DIA	ETF	208.74	209.09	207.87	208.67	4430100.0
2017-03-09	GLD	ETF	114.78	115.03	114.41	114.47	6410900.0
2017-03-09	TLT	ETF	117.34	117.48	116.77	116.84	10575400.0
2017-03-09	AADR	ETF	44.98	45.5	43.97	44.24	7700.0
2017-03-09	AAXJ	ETF	60.14	60.2	59.77	60.1	571200.0
2017-03-09	ACSI	ETF	27.84	27.8799	27.7834	27.7834	2750.0
2017-03-09	ACTX	ETF	97.3509	100.3009	93.5748	97.3509	930.0
2017-03-09	ACWF	ETF	25.3499	25.3499	25.3085	25.3085	1490.0
2017-03-09	ACWI	ETF	62.44	62.53	62.21	62.44	1679700.0
2017-03-09	ACWV	ETF	75.89	75.97	75.72	75.95	427100.0
2017-03-09	ACWX	ETF	42.3	42.32	42.14	42.27	402557.0
2017-03-09	ADRE	ETF	35.4	35.44	35.256	35.2765	24140.0
2017-03-09	AFK	ETF	20.28	20.3	20.0	20.0	4780.0
2017-03-09	AFTY	ETF	13.76	13.76	13.738	13.738	1100.0
2017-03-09	AGG	ETF	107.32	107.34	107.12	107.14	3527300.0
2017-03-09	AGGY	ETF	49.24	49.24	49.13	49.18	16600.0
2017-03-09	AGQ	ETF	37.08	37.15	35.82	35.82	227600.0
2017-03-09	AGZ	ETF	112.22	112.33	112.092	112.27	28562.0
2017-03-09	AGZD	ETF	24.075	24.075	24.075	24.075	400.0
2017-03-09	AIA	ETF	50.33	50.34	50.04	50.127	3306.0
2017-03-09	AIQ	ETF	9.94	10.2	9.7	9.85	9785.0
2017-03-09	AIRR	ETF	23.66	23.714	23.364	23.41	35700.0
2017-03-09	AIVI	ETF	38.57	38.63	38.51	38.61	9100.0
2017-03-09	ALTY	ETF	15.21	15.222	15.06	15.06	5400.0
2017-03-09	AMJ	ETF	32.08	32.17	31.5	32.02	2713631.0
2017-03-09	AMLP	ETF	63.5	63.7	62.75	63.4	3749420.0
2017-03-09	AMZA	ETF	111.0	111.0	109.1	110.5	100510.0
2017-03-09	ANGL	ETF	28.92	28.98	28.75	28.87	1056200.0
2017-03-09	AOA	ETF	49.24	49.27	49.06	49.24	43400.0
2017-03-09	AOK	ETF	32.95	32.95	32.79	32.87	40408.0
2017-03-09	AOM	ETF	35.96	35.98	35.811	35.85	54436.0
2017-03-09	AOR	ETF	41.82	41.83	41.67	41.78	129422.0
2017-03-09	ARGT	ETF	26.28	26.4	26.07	26.2	44000.0
2017-03-09	ARKG	ETF	20.36	20.44	20.305	20.393	9200.0
2017-03-09	ARKK	ETF	23.22	23.22	22.995	22.995	1300.0
2017-03-09	ARKQ	ETF	23.65	23.65	23.33	23.38	17000.0
2017-03-09	ARKW	ETF	28.24	28.24	28.03	28.17	5700.0
2017-03-09	ASEA	ETF	13.57	13.57	13.57	13.57	500.0
2017-03-09	ASET	ETF	25.83	25.8599	25.7298	25.82	3891.0
2017-03-09	ASHR	ETF	24.68	24.7	24.57	24.59	539500.0
2017-03-09	ASHS	ETF	33.95	33.95	33.67	33.76	8900.0
2017-03-09	ATMP	ETF	23.85	23.85	23.25	23.65	62100.0
2017-03-09	BAB	ETF	29.06	29.12	29.02	29.025	165184.0
2017-03-09	BAL	ETF	50.71	51.0	50.2267	50.5801	8325.0
2017-03-09	BBC	ETF	23.14	23.33	23.05	23.33	19375.0
2017-03-09	BBH	ETF	121.26	121.59	120.24	121.28	37800.0
2017-03-09	BBP	ETF	38.22	38.33	37.636	38.21	9400.0

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

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