PREVIEW / etf_daily / 2017-05-01

all etf daily files

  file:    by_date/etf_daily/2017/2017-05-01.parquet
  size:    55 KB
  rows:    1,395

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-05-01	SPY	ETF	238.68	239.17	238.2	238.68	66882500.0
2017-05-01	QQQ	ETF	136.46	137.38	136.38	137.2	24815525.0
2017-05-01	IWM	ETF	139.64	140.29	138.78	139.86	20925200.0
2017-05-01	DIA	ETF	209.49	209.49	208.7	208.92	1886000.0
2017-05-01	GLD	ETF	120.21	120.75	119.35	119.67	9331800.0
2017-05-01	TLT	ETF	121.69	122.14	120.71	121.08	8795900.0
2017-05-01	AADR	ETF	47.68	47.68	47.18	47.34	6100.0
2017-05-01	AAXJ	ETF	64.46	64.64	64.29	64.42	744500.0
2017-05-01	ACSI	ETF	28.37	28.37	28.37	28.37	281.0
2017-05-01	ACTX	ETF	78.4707	93.8108	76.7007	81.4207	1006.0
2017-05-01	ACWI	ETF	64.44	64.58	64.35	64.45	1268500.0
2017-05-01	ACWV	ETF	78.15	78.15	77.8	77.9	109600.0
2017-05-01	ACWX	ETF	44.76	44.82	44.65	44.74	535154.0
2017-05-01	ADRE	ETF	36.98	37.1261	36.9001	37.073	7172.0
2017-05-01	AFK	ETF	21.4	21.4	21.06	21.17	16448.0
2017-05-01	AFTY	ETF	13.68	13.713	13.67	13.67	4900.0
2017-05-01	AGG	ETF	108.86	108.96	108.62	108.73	2510000.0
2017-05-01	AGGY	ETF	50.14	50.21	50.01	50.077	13800.0
2017-05-01	AGNG	ETF	17.62	17.62	17.62	17.62	300.0
2017-05-01	AGQ	ETF	36.32	36.6	34.93	35.29	358500.0
2017-05-01	AGZ	ETF	113.36	113.37	113.17	113.3	11952.0
2017-05-01	AGZD	ETF	23.965	23.99	23.93	23.94	4200.0
2017-05-01	AIA	ETF	53.84	54.12	53.832	53.96	14933.0
2017-05-01	AIQ	ETF	13.1	13.2	13.1	13.1	15769.0
2017-05-01	AIRR	ETF	24.46	24.615	24.259	24.489	14200.0
2017-05-01	AIVI	ETF	39.86	40.08	39.86	40.02	5700.0
2017-05-01	ALTY	ETF	15.714	15.714	15.691	15.691	700.0
2017-05-01	AMJ	ETF	31.89	32.01	31.81	31.94	1231696.0
2017-05-01	AMLP	ETF	63.2	63.3	62.9	63.1	1060880.0
2017-05-01	AMZA	ETF	105.5	105.78	105.1	105.5	26940.0
2017-05-01	ANGL	ETF	29.63	29.66	29.53	29.6	274600.0
2017-05-01	AOA	ETF	50.83	50.83	50.61	50.71	151400.0
2017-05-01	AOK	ETF	33.78	33.78	33.5764	33.63	26736.0
2017-05-01	AOM	ETF	36.64	36.73	36.64	36.73	208954.0
2017-05-01	AOR	ETF	42.78	42.89	42.78	42.84	135545.0
2017-05-01	ARCM	ETF	100.0	100.0	100.0	100.0	4000.0
2017-05-01	ARGT	ETF	28.75	29.0	28.72	28.92	30400.0
2017-05-01	ARKG	ETF	20.71	20.76	20.5	20.744	6300.0
2017-05-01	ARKK	ETF	25.48	25.71	25.35	25.71	36800.0
2017-05-01	ARKQ	ETF	26.77	26.91	26.597	26.84	19200.0
2017-05-01	ARKW	ETF	30.46	30.959	30.46	30.9	12300.0
2017-05-01	ASEA	ETF	14.59	14.59	14.47	14.47	1300.0
2017-05-01	ASET	ETF	26.88	26.91	26.85	26.91	3949.0
2017-05-01	ASHR	ETF	24.76	24.86	24.76	24.84	175600.0
2017-05-01	ASHS	ETF	32.43	32.58	32.43	32.58	2000.0
2017-05-01	ASHX	ETF	19.31	19.31	19.31	19.31	100.0
2017-05-01	ATMP	ETF	23.5	23.58	23.19	23.57	21400.0
2017-05-01	BAB	ETF	29.44	29.5	29.37	29.41	173865.0
2017-05-01	BAL	ETF	49.93	50.4	49.93	50.2	2158.0
2017-05-01	BBC	ETF	22.68	22.8224	22.4837	22.8224	17786.0

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

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