PREVIEW / etf_daily / 2017-12-13

all etf daily files

  file:    by_date/etf_daily/2017/2017-12-13.parquet
  size:    59 KB
  rows:    1,522

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-12-13	SPY	ETF	267.06	267.56	266.65	266.75	102905400.0
2017-12-13	QQQ	ETF	156.28	156.49	155.76	155.99	24418479.0
2017-12-13	IWM	ETF	150.81	152.71	150.81	151.78	30082600.0
2017-12-13	DIA	ETF	245.69	246.99	245.65	246.3	3748700.0
2017-12-13	GLD	ETF	118.19	119.35	118.01	119.17	10086700.0
2017-12-13	TLT	ETF	126.81	127.39	126.59	127.33	8532900.0
2017-12-13	AADR	ETF	56.99	57.25	56.92	57.06	34400.0
2017-12-13	AAXJ	ETF	75.73	76.33	75.73	76.18	1869300.0
2017-12-13	ACSI	ETF	31.111	31.125	31.09	31.09	1239.0
2017-12-13	ACTX	ETF	70.8006	73.7507	63.7206	70.2106	210.0
2017-12-13	ACWF	ETF	30.43	30.5899	30.43	30.51	1673.0
2017-12-13	ACWI	ETF	72.04	72.22	71.99	72.05	1855700.0
2017-12-13	ACWV	ETF	84.71	84.89	84.55	84.65	1406700.0
2017-12-13	ACWX	ETF	49.6	49.84	49.59	49.7	699142.0
2017-12-13	ADRE	ETF	42.43	42.5	42.1901	42.3284	5731.0
2017-12-13	AFK	ETF	24.09	26.0	23.9635	24.6	20626.0
2017-12-13	AFTY	ETF	18.55	18.558	18.55	18.558	1600.0
2017-12-13	AGG	ETF	109.23	109.55	109.14	109.41	3109500.0
2017-12-13	AGGY	ETF	50.72	50.83	50.66	50.818	101200.0
2017-12-13	AGNG	ETF	19.66	19.71	19.639	19.687	1400.0
2017-12-13	AGQ	ETF	29.35	30.83	29.12	30.51	371200.0
2017-12-13	AGZ	ETF	113.21	113.4	113.194	113.36	35908.0
2017-12-13	AGZD	ETF	24.125	24.18	24.12	24.17	15200.0
2017-12-13	AIA	ETF	65.37	65.8269	65.37	65.7	67781.0
2017-12-13	AIEQ	ETF	25.8	25.8	25.61	25.62	96800.0
2017-12-13	AIRR	ETF	26.71	26.99	26.71	26.83	42500.0
2017-12-13	AIVI	ETF	43.15	43.28	43.04	43.23	13300.0
2017-12-13	ALTY	ETF	15.37	15.37	15.36	15.36	1300.0
2017-12-13	AMJ	ETF	27.21	27.41	27.055	27.29	4445455.0
2017-12-13	AMLP	ETF	53.75	54.2	53.5	54.05	4128940.0
2017-12-13	AMZA	ETF	84.6	85.9	84.21	85.6	391800.0
2017-12-13	ANGL	ETF	30.04	30.08	29.96	29.98	916600.0
2017-12-13	AOA	ETF	55.35	55.5	55.3	55.43	81300.0
2017-12-13	AOK	ETF	34.57	34.6599	34.5	34.61	83440.0
2017-12-13	AOM	ETF	38.54	38.67	38.508	38.57	115792.0
2017-12-13	AOR	ETF	45.95	46.02	45.89	45.98	83237.0
2017-12-13	ARGT	ETF	34.5	35.08	34.5	35.0	78500.0
2017-12-13	ARKG	ETF	24.25	24.529	24.0	24.36	38500.0
2017-12-13	ARKK	ETF	37.69	37.889	37.126	37.6	380100.0
2017-12-13	ARKQ	ETF	33.94	34.32	33.94	34.054	29200.0
2017-12-13	ARKW	ETF	47.08	47.65	46.54	47.15	226600.0
2017-12-13	ASEA	ETF	16.81	16.81	16.73	16.8	600.0
2017-12-13	ASET	ETF	28.829	28.91	28.8283	28.91	570.0
2017-12-13	ASHR	ETF	30.89	31.04	30.89	31.02	784200.0
2017-12-13	ASHS	ETF	34.39	34.62	34.39	34.6	2800.0
2017-12-13	ASHX	ETF	22.8301	22.85	22.8301	22.85	705.0
2017-12-13	ATMP	ETF	20.44	20.59	20.38	20.52	506100.0
2017-12-13	BAB	ETF	30.67	30.74	30.62	30.74	81031.0
2017-12-13	BAL	ETF	48.985	49.06	48.985	48.995	509.0
2017-12-13	BAR	ETF	12.434	12.455	12.434	12.445	18000.0

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

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