PREVIEW / etf_daily / 2017-03-23

all etf daily files

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

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-23	SPY	ETF	234.28	235.34	233.6	234.03	100410300.0
2017-03-23	QQQ	ETF	130.52	130.88	130.14	130.36	20311655.0
2017-03-23	IWM	ETF	134.0	135.7	133.64	134.78	37764600.0
2017-03-23	DIA	ETF	206.03	207.3	205.91	206.31	3840000.0
2017-03-23	GLD	ETF	119.15	119.25	118.32	118.67	6201100.0
2017-03-23	TLT	ETF	120.83	121.02	120.06	120.45	6746500.0
2017-03-23	AADR	ETF	46.12	46.21	46.01	46.12	14200.0
2017-03-23	AAXJ	ETF	63.05	63.46	63.04	63.24	1451900.0
2017-03-23	ACSI	ETF	27.65	27.7999	27.61	27.61	2563.0
2017-03-23	ACTX	ETF	101.4809	104.4309	100.0059	100.8909	817.0
2017-03-23	ACWF	ETF	25.8888	25.8888	25.8387	25.8387	545.0
2017-03-23	ACWI	ETF	62.94	63.31	62.89	63.06	3562700.0
2017-03-23	ACWV	ETF	77.33	77.64	77.2	77.28	152400.0
2017-03-23	ACWX	ETF	43.35	43.611	43.32	43.49	672292.0
2017-03-23	ADRE	ETF	36.34	36.52	36.3165	36.47	7100.0
2017-03-23	AFK	ETF	21.43	21.4899	21.21	21.4	5965.0
2017-03-23	AFTY	ETF	13.75	13.79	13.68	13.76	13500.0
2017-03-23	AGG	ETF	108.44	108.51	108.26	108.45	2071400.0
2017-03-23	AGGY	ETF	49.8	49.83	49.74	49.74	14100.0
2017-03-23	AGQ	ETF	38.83	38.92	38.35	38.52	115400.0
2017-03-23	AGZ	ETF	113.0281	113.1	112.849	113.08	8047.0
2017-03-23	AGZD	ETF	24.05	24.07	24.05	24.055	3800.0
2017-03-23	AIA	ETF	52.97	53.22	52.8576	52.9909	22979.0
2017-03-23	AIQ	ETF	10.05	10.1	10.05	10.05	511.0
2017-03-23	AIRR	ETF	23.01	23.37	23.01	23.24	35800.0
2017-03-23	AIVI	ETF	39.3	39.68	39.3	39.58	34400.0
2017-03-23	ALTY	ETF	15.353	15.353	15.353	15.353	300.0
2017-03-23	AMJ	ETF	31.26	31.79	31.1952	31.48	639591.0
2017-03-23	AMLP	ETF	62.45	63.05	62.3	62.7	1494440.0
2017-03-23	AMZA	ETF	108.5	109.78	108.4	108.9	52490.0
2017-03-23	ANGL	ETF	29.05	29.05	28.97	29.02	114700.0
2017-03-23	AOA	ETF	49.62	49.82	49.58	49.71	74700.0
2017-03-23	AOK	ETF	33.22	33.2473	33.1407	33.16	34862.0
2017-03-23	AOM	ETF	36.29	36.3065	36.14	36.19	64126.0
2017-03-23	AOR	ETF	42.2	42.27	42.119	42.19	131825.0
2017-03-23	ARGT	ETF	27.22	27.47	27.13	27.34	41300.0
2017-03-23	ARKG	ETF	19.9	20.09	19.87	19.87	2600.0
2017-03-23	ARKK	ETF	22.93	23.17	22.93	23.025	1800.0
2017-03-23	ARKQ	ETF	23.78	23.935	23.742	23.935	2800.0
2017-03-23	ARKW	ETF	27.99	28.205	27.99	28.205	6700.0
2017-03-23	ASEA	ETF	14.0	14.04	13.96	14.01	3600.0
2017-03-23	ASHR	ETF	25.23	25.23	25.15	25.21	301400.0
2017-03-23	ASHS	ETF	34.35	34.4	34.35	34.35	2900.0
2017-03-23	ATMP	ETF	23.12	23.41	23.12	23.21	29100.0
2017-03-23	BAB	ETF	29.42	29.43	29.34	29.3896	187092.0
2017-03-23	BAL	ETF	50.37	50.48	50.1	50.1	2292.0
2017-03-23	BBC	ETF	22.83	23.0	22.78	22.79	9882.0
2017-03-23	BBH	ETF	117.75	118.15	116.9	117.14	30500.0
2017-03-23	BBP	ETF	37.01	37.32	37.01	37.1	1900.0
2017-03-23	BCM	ETF	26.5799	26.5799	26.5676	26.5676	1167.0

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

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