PREVIEW / etf_daily / 2017-03-07

all etf daily files

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

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-07	SPY	ETF	237.36	237.77	236.76	237.0	65103700.0
2017-03-07	QQQ	ETF	130.45	131.08	130.28	130.51	15500945.0
2017-03-07	IWM	ETF	137.4	137.74	136.61	136.8	29711300.0
2017-03-07	DIA	ETF	209.21	209.66	208.98	209.17	2741000.0
2017-03-07	GLD	ETF	116.13	116.25	115.62	115.78	6846300.0
2017-03-07	TLT	ETF	118.48	118.68	118.25	118.42	7080100.0
2017-03-07	AADR	ETF	45.62	45.62	45.19	45.32	2500.0
2017-03-07	AAXJ	ETF	60.66	60.71	60.49	60.56	1058300.0
2017-03-07	ACSI	ETF	27.92	27.92	27.83	27.83	2141.0
2017-03-07	ACTX	ETF	97.3509	100.3009	94.4008	94.9909	915.0
2017-03-07	ACWF	ETF	25.3659	25.3659	25.3659	25.3659	126.0
2017-03-07	ACWI	ETF	62.64	62.73	62.54	62.61	1061500.0
2017-03-07	ACWV	ETF	76.05	76.2	76.02	76.04	173700.0
2017-03-07	ACWX	ETF	42.5	42.55	42.405	42.455	548753.0
2017-03-07	ADRE	ETF	35.83	35.869	35.6601	35.76	2400.0
2017-03-07	AFK	ETF	20.35	20.58	20.27	20.28	19202.0
2017-03-07	AGG	ETF	107.8	107.84	107.69	107.73	2237900.0
2017-03-07	AGGY	ETF	49.548	49.548	49.5	49.518	9700.0
2017-03-07	AGNG	ETF	16.61	16.705	16.59	16.705	900.0
2017-03-07	AGQ	ETF	38.55	38.78	38.11	38.16	200900.0
2017-03-07	AGZ	ETF	112.22	112.57	112.22	112.37	21040.0
2017-03-07	AGZD	ETF	24.1	24.1	24.015	24.045	28400.0
2017-03-07	AIA	ETF	50.68	50.75	50.645	50.645	8994.0
2017-03-07	AIQ	ETF	10.2	10.2	9.8008	9.95	9118.0
2017-03-07	AIRR	ETF	24.08	24.249	23.93	23.98	169400.0
2017-03-07	AIVI	ETF	38.83	38.99	38.81	38.89	42300.0
2017-03-07	ALTY	ETF	15.55	15.55	15.37	15.37	3900.0
2017-03-07	AMJ	ETF	33.13	33.14	32.765	32.92	716522.0
2017-03-07	AMLP	ETF	64.95	65.0	64.4	64.7	1432960.0
2017-03-07	AMZA	ETF	113.5	113.5	112.5	113.0	60390.0
2017-03-07	ANGL	ETF	29.4	29.4	29.12	29.2	1096100.0
2017-03-07	AOA	ETF	49.46	49.5	49.32	49.33	36200.0
2017-03-07	AOK	ETF	33.08	33.08	33.0	33.01	86734.0
2017-03-07	AOM	ETF	36.12	36.12	36.01	36.08	87383.0
2017-03-07	AOR	ETF	42.01	42.01	41.9	41.92	67059.0
2017-03-07	ARGT	ETF	26.63	26.65	26.46	26.48	9500.0
2017-03-07	ARKG	ETF	19.987	20.27	19.987	20.21	15000.0
2017-03-07	ARKK	ETF	23.15	23.28	23.15	23.245	1200.0
2017-03-07	ARKQ	ETF	23.79	23.79	23.57	23.59	5200.0
2017-03-07	ARKW	ETF	28.39	28.423	28.192	28.192	7100.0
2017-03-07	ASEA	ETF	13.61	13.62	13.59	13.62	2000.0
2017-03-07	ASET	ETF	26.17	26.18	26.14	26.14	2667.0
2017-03-07	ASHR	ETF	24.98	25.02	24.96	25.01	189900.0
2017-03-07	ASHS	ETF	34.33	34.33	34.29	34.32	5200.0
2017-03-07	ASHX	ETF	19.46	19.46	19.46	19.46	101.0
2017-03-07	ATMP	ETF	24.11	24.32	24.11	24.24	29300.0
2017-03-07	BAB	ETF	29.09	29.11	29.03	29.04	152414.0
2017-03-07	BAL	ETF	51.38	51.38	50.5287	50.5756	1108.0
2017-03-07	BBC	ETF	22.88	22.88	22.25	22.3135	7426.0
2017-03-07	BBH	ETF	120.6	121.08	119.94	120.13	54200.0

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

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