PREVIEW / etf_daily / 2017-06-05

all etf daily files

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

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-06-05	SPY	ETF	243.97	244.3	243.76	243.99	44698800.0
2017-06-05	QQQ	ETF	143.44	143.68	143.23	143.43	15727526.0
2017-06-05	IWM	ETF	139.96	140.11	138.95	138.98	20808900.0
2017-06-05	DIA	ETF	211.86	212.21	211.64	211.86	1923000.0
2017-06-05	GLD	ETF	121.91	121.94	121.58	121.73	3979200.0
2017-06-05	TLT	ETF	124.9	125.16	124.78	124.84	6775500.0
2017-06-05	AADR	ETF	47.8	48.09	47.8	48.04	23100.0
2017-06-05	AAXJ	ETF	67.77	67.83	67.68	67.69	562700.0
2017-06-05	ACSI	ETF	29.13	29.13	28.909	28.909	1412.0
2017-06-05	ACTX	ETF	44.2504	53.6905	44.2504	53.1005	1055.0
2017-06-05	ACWF	ETF	27.447	27.4492	27.34	27.34	675.0
2017-06-05	ACWI	ETF	66.54	66.57	66.41	66.54	1609400.0
2017-06-05	ACWV	ETF	81.13	81.13	80.93	80.96	206700.0
2017-06-05	ACWX	ETF	46.52	46.52	46.43	46.5	319754.0
2017-06-05	ADRE	ETF	38.3	38.49	38.25	38.4	10833.0
2017-06-05	AFK	ETF	22.0	22.0	21.81	21.95	7973.0
2017-06-05	AFTY	ETF	14.645	14.665	14.645	14.65	1100.0
2017-06-05	AGG	ETF	109.66	109.74	109.6	109.67	2450600.0
2017-06-05	AGGY	ETF	50.68	50.71	50.633	50.663	10000.0
2017-06-05	AGNG	ETF	18.44	18.44	18.26	18.26	1000.0
2017-06-05	AGQ	ETF	38.02	38.32	37.8	37.93	74000.0
2017-06-05	AGZ	ETF	113.78	114.03	113.67	113.81	28516.0
2017-06-05	AGZD	ETF	23.945	23.965	23.945	23.95	6000.0
2017-06-05	AIA	ETF	57.15	57.159	57.03	57.12	34403.0
2017-06-05	AIQ	ETF	13.2499	13.25	13.2109	13.25	7929.0
2017-06-05	AIRR	ETF	23.44	23.538	23.354	23.36	30100.0
2017-06-05	AIVI	ETF	42.25	42.26	42.21	42.25	6200.0
2017-06-05	ALTY	ETF	15.51	15.51	15.51	15.51	1500.0
2017-06-05	AMJ	ETF	29.72	30.02	29.7	29.9	1012504.0
2017-06-05	AMLP	ETF	59.3	59.95	59.3	59.75	1480480.0
2017-06-05	AMZA	ETF	100.1	101.3	100.1	100.7	45170.0
2017-06-05	ANGL	ETF	29.7	29.71	29.62	29.64	301600.0
2017-06-05	AOA	ETF	52.11	52.11	51.93	51.93	52000.0
2017-06-05	AOK	ETF	34.13	34.13	34.04	34.08	58142.0
2017-06-05	AOM	ETF	37.41	37.425	37.32	37.4	58691.0
2017-06-05	AOR	ETF	43.84	43.85	43.76	43.76	71556.0
2017-06-05	ARCM	ETF	100.05	100.05	100.05	100.05	20.0
2017-06-05	ARGT	ETF	30.83	30.96	30.58	30.76	35500.0
2017-06-05	ARKG	ETF	21.35	21.35	20.718	20.791	8600.0
2017-06-05	ARKK	ETF	29.36	29.36	29.1	29.21	52100.0
2017-06-05	ARKQ	ETF	29.39	29.39	29.127	29.34	30900.0
2017-06-05	ARKW	ETF	35.94	36.245	35.92	36.19	156400.0
2017-06-05	ASEA	ETF	15.14	15.16	15.1	15.16	3300.0
2017-06-05	ASET	ETF	27.72	27.76	27.72	27.76	994.0
2017-06-05	ASHR	ETF	25.53	25.53	25.48	25.48	284000.0
2017-06-05	ASHS	ETF	30.94	31.05	30.94	31.05	2700.0
2017-06-05	ASHX	ETF	19.3888	19.47	19.3888	19.47	1560.0
2017-06-05	ATMP	ETF	22.11	22.2	22.09	22.13	62800.0
2017-06-05	BAB	ETF	30.08	30.14	30.03	30.07	89990.0
2017-06-05	BAL	ETF	48.63	48.63	48.45	48.46	5753.0

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

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