PREVIEW / etf_daily / 2017-02-27

all etf daily files

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

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-27	SPY	ETF	236.64	237.31	236.35	237.11	56515400.0
2017-02-27	QQQ	ETF	130.02	130.43	129.8	130.42	12008672.0
2017-02-27	IWM	ETF	138.34	140.0	138.21	140.0	28269000.0
2017-02-27	DIA	ETF	207.73	208.37	207.61	208.29	3433700.0
2017-02-27	GLD	ETF	119.73	120.4	119.12	119.12	9263500.0
2017-02-27	TLT	ETF	121.81	121.9	121.23	121.29	11039800.0
2017-02-27	AADR	ETF	45.34	45.34	44.8	45.16	18300.0
2017-02-27	AAXJ	ETF	60.79	60.93	60.7	60.83	538000.0
2017-02-27	ACSI	ETF	28.11	28.16	28.11	28.16	1949.0
2017-02-27	ACTX	ETF	101.7759	128.6212	100.3009	120.9511	6807.0
2017-02-27	ACWI	ETF	62.48	62.63	62.41	62.63	1179700.0
2017-02-27	ACWV	ETF	76.5	76.58	76.38	76.39	121700.0
2017-02-27	ACWX	ETF	42.42	42.5254	42.38	42.47	292267.0
2017-02-27	ADRE	ETF	36.12	36.2559	36.12	36.18	6760.0
2017-02-27	AFK	ETF	21.17	21.52	21.0001	21.01	13040.0
2017-02-27	AFTY	ETF	13.945	13.99	13.92	13.92	5000.0
2017-02-27	AGG	ETF	108.95	108.98	108.77	108.8	1998200.0
2017-02-27	AGGY	ETF	50.0	50.019	49.93	49.93	10900.0
2017-02-27	AGNG	ETF	16.709	16.709	16.658	16.658	400.0
2017-02-27	AGQ	ETF	42.21	42.82	41.62	41.64	218600.0
2017-02-27	AGZ	ETF	113.39	113.555	113.07	113.15	38340.0
2017-02-27	AGZD	ETF	24.005	24.005	24.005	24.005	600.0
2017-02-27	AIA	ETF	51.09	51.09	50.9	50.93	25836.0
2017-02-27	AIQ	ETF	10.35	10.4	10.3	10.4	5307.0
2017-02-27	AIRR	ETF	24.25	24.57	23.745	24.54	39500.0
2017-02-27	AIVI	ETF	38.65	38.85	38.6	38.81	16700.0
2017-02-27	ALTY	ETF	15.61	15.65	15.47	15.63	12700.0
2017-02-27	AMJ	ETF	32.85	32.89	32.5	32.51	2618130.0
2017-02-27	AMLP	ETF	64.2	64.25	63.9	63.95	1894280.0
2017-02-27	AMZA	ETF	111.7	113.0	111.29	111.6	49190.0
2017-02-27	ANGL	ETF	29.58	29.59	29.54	29.56	215300.0
2017-02-27	AOA	ETF	49.42	49.47	49.37	49.45	47100.0
2017-02-27	AOK	ETF	33.19	33.2399	33.18	33.18	40863.0
2017-02-27	AOM	ETF	36.22	36.24	36.16	36.23	109853.0
2017-02-27	AOR	ETF	41.97	42.1352	41.9543	42.07	583207.0
2017-02-27	ARGT	ETF	26.67	26.67	26.36	26.4	43100.0
2017-02-27	ARKG	ETF	19.199	19.689	19.199	19.689	1700.0
2017-02-27	ARKK	ETF	22.93	23.27	22.86	23.27	2700.0
2017-02-27	ARKQ	ETF	24.0	24.14	23.91	24.097	9100.0
2017-02-27	ARKW	ETF	28.27	28.52	28.27	28.475	3000.0
2017-02-27	ASEA	ETF	13.54	13.62	13.54	13.62	1000.0
2017-02-27	ASET	ETF	26.46	26.46	26.43	26.456	1143.0
2017-02-27	ASHR	ETF	25.16	25.19	25.13	25.14	518900.0
2017-02-27	ASHS	ETF	34.25	34.25	33.98	34.0	10700.0
2017-02-27	ATMP	ETF	23.68	23.94	23.68	23.92	44200.0
2017-02-27	BAB	ETF	29.5	29.524	29.35	29.39	237233.0
2017-02-27	BAL	ETF	50.0368	50.1	49.3175	49.362	2939.0
2017-02-27	BBC	ETF	20.62	22.1876	20.62	22.1876	24014.0
2017-02-27	BBH	ETF	118.9	121.33	118.66	121.33	97500.0
2017-02-27	BBP	ETF	36.94	38.402	36.94	38.4	18900.0

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

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