PREVIEW / etf_daily / 2017-03-22

all etf daily files

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

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-22	SPY	ETF	233.77	234.61	233.05	234.28	97569200.0
2017-03-22	QQQ	ETF	129.89	130.82	129.68	130.69	29177883.0
2017-03-22	IWM	ETF	133.71	134.31	132.78	134.0	46332600.0
2017-03-22	DIA	ETF	205.96	206.57	205.5	206.41	3898500.0
2017-03-22	GLD	ETF	118.87	119.15	118.68	118.83	7287400.0
2017-03-22	TLT	ETF	120.72	121.17	120.43	120.62	11661400.0
2017-03-22	AADR	ETF	46.09	46.09	45.67	46.03	60700.0
2017-03-22	AAXJ	ETF	62.86	63.29	62.81	63.2	490100.0
2017-03-22	ACSI	ETF	27.62	27.65	27.62	27.65	1200.0
2017-03-22	ACTX	ETF	100.3009	104.4309	98.5309	98.7669	666.0
2017-03-22	ACWI	ETF	62.83	63.06	62.67	63.03	1795200.0
2017-03-22	ACWV	ETF	77.21	77.4	77.08	77.38	153300.0
2017-03-22	ACWX	ETF	43.24	43.43	43.16	43.4	494828.0
2017-03-22	ADRE	ETF	36.23	36.352	36.23	36.34	3055.0
2017-03-22	AFK	ETF	21.08	21.87	21.08	21.13	10297.0
2017-03-22	AFTY	ETF	13.77	13.77	13.77	13.77	900.0
2017-03-22	AGG	ETF	108.44	108.54	108.36	108.42	2643600.0
2017-03-22	AGGY	ETF	49.859	49.865	49.75	49.84	13100.0
2017-03-22	AGQ	ETF	38.27	38.48	38.07	38.31	118100.0
2017-03-22	AGZ	ETF	113.23	113.23	112.95	112.95	118553.0
2017-03-22	AGZD	ETF	24.065	24.065	24.065	24.065	800.0
2017-03-22	AIA	ETF	52.85	53.315	52.83	53.22	38143.0
2017-03-22	AIQ	ETF	10.2	10.25	9.8	9.85	10106.0
2017-03-22	AIRR	ETF	23.0	23.138	22.78	22.99	84000.0
2017-03-22	AIVI	ETF	39.32	39.53	39.32	39.52	15000.0
2017-03-22	ALTY	ETF	15.3	15.436	15.26	15.26	7800.0
2017-03-22	AMJ	ETF	31.4	31.45	31.19	31.37	1380049.0
2017-03-22	AMLP	ETF	62.3	62.5	62.2	62.4	957900.0
2017-03-22	AMZA	ETF	108.0	108.6	107.8	108.42	58030.0
2017-03-22	ANGL	ETF	28.91	29.05	28.78	29.04	451700.0
2017-03-22	AOA	ETF	49.51	49.68	49.47	49.62	38400.0
2017-03-22	AOK	ETF	33.09	33.2099	33.09	33.2	52782.0
2017-03-22	AOM	ETF	36.17	36.2654	36.1596	36.21	50403.0
2017-03-22	AOR	ETF	42.13	42.2	42.0107	42.2	87665.0
2017-03-22	ARGT	ETF	27.11	27.29	26.99	27.21	104100.0
2017-03-22	ARKG	ETF	19.88	19.88	19.75	19.83	2100.0
2017-03-22	ARKK	ETF	23.0	23.02	22.87	23.02	5200.0
2017-03-22	ARKQ	ETF	23.64	23.78	23.64	23.756	5000.0
2017-03-22	ARKW	ETF	28.168	28.168	27.97	28.049	4600.0
2017-03-22	ASEA	ETF	14.05	14.05	13.93	14.0	1200.0
2017-03-22	ASET	ETF	26.24	26.3	26.15	26.2998	4882.0
2017-03-22	ASHR	ETF	25.1	25.22	25.06	25.21	532500.0
2017-03-22	ASHS	ETF	34.35	34.39	34.29	34.38	9000.0
2017-03-22	ASHX	ETF	19.57	19.61	19.57	19.61	261.0
2017-03-22	ATMP	ETF	22.96	23.18	22.96	23.16	222600.0
2017-03-22	BAB	ETF	29.39	29.42	29.29	29.35	124054.0
2017-03-22	BAL	ETF	50.3489	50.66	50.3489	50.365	1131.0
2017-03-22	BBC	ETF	22.72	22.74	22.4036	22.74	25239.0
2017-03-22	BBH	ETF	117.0	117.7	116.98	117.65	46200.0
2017-03-22	BBP	ETF	36.78	37.11	36.5	37.064	17700.0

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

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