PREVIEW / etf_daily / 2017-12-15

all etf daily files

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

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-15	SPY	ETF	265.45	267.04	265.39	266.51	144610300.0
2017-12-15	QQQ	ETF	156.49	157.82	156.23	157.65	49816151.0
2017-12-15	IWM	ETF	151.05	153.25	150.58	152.24	42851600.0
2017-12-15	DIA	ETF	246.21	246.7	245.82	246.25	5862800.0
2017-12-15	GLD	ETF	119.41	119.5	118.97	119.18	7532000.0
2017-12-15	TLT	ETF	127.81	128.59	127.56	128.35	7239400.0
2017-12-15	AADR	ETF	57.03	57.22	56.69	57.22	32800.0
2017-12-15	AAXJ	ETF	75.44	75.59	75.21	75.47	2177600.0
2017-12-15	ACSI	ETF	31.129	31.2	31.129	31.164	1670.0
2017-12-15	ACTX	ETF	70.8006	86.7308	70.8006	83.7808	1823.0
2017-12-15	ACWF	ETF	30.42	30.5382	30.395	30.5382	2001.0
2017-12-15	ACWI	ETF	71.88	72.12	71.79	71.97	1700700.0
2017-12-15	ACWV	ETF	84.68	85.04	84.66	84.89	61000.0
2017-12-15	ACWX	ETF	49.46	49.53	49.32	49.45	647813.0
2017-12-15	ADRE	ETF	42.35	42.35	42.0641	42.2399	4997.0
2017-12-15	AFK	ETF	24.51	24.52	24.07	24.38	4838.0
2017-12-15	AFTY	ETF	17.03	17.035	16.97	16.98	13100.0
2017-12-15	AGG	ETF	109.42	109.55	109.32	109.47	2403700.0
2017-12-15	AGGY	ETF	50.83	50.905	50.805	50.89	79600.0
2017-12-15	AGNG	ETF	19.42	19.57	19.42	19.57	32400.0
2017-12-15	AGQ	ETF	30.55	30.61	30.28	30.52	137900.0
2017-12-15	AGZ	ETF	113.32	113.37	113.237	113.35	14450.0
2017-12-15	AGZD	ETF	24.205	24.25	24.16	24.23	14400.0
2017-12-15	AIA	ETF	64.88	64.9475	64.65	64.91	48914.0
2017-12-15	AIEQ	ETF	25.55	25.739	25.421	25.69	55500.0
2017-12-15	AIRR	ETF	26.59	27.0	26.59	26.8	29400.0
2017-12-15	AIVI	ETF	42.81	42.93	42.81	42.93	31700.0
2017-12-15	ALTY	ETF	15.38	15.41	15.37	15.39	17700.0
2017-12-15	AMJ	ETF	27.5	27.5	27.09	27.24	4597672.0
2017-12-15	AMLP	ETF	54.4	54.55	53.55	53.8	4050180.0
2017-12-15	AMZA	ETF	86.5	86.7	84.58	85.3	103040.0
2017-12-15	ANGL	ETF	29.95	29.99	29.95	29.97	214300.0
2017-12-15	AOA	ETF	55.29	55.48	55.25	55.35	54600.0
2017-12-15	AOK	ETF	34.59	34.6396	34.4301	34.54	59305.0
2017-12-15	AOM	ETF	38.6	38.66	38.55	38.64	97995.0
2017-12-15	AOR	ETF	45.88	46.0197	45.85	45.92	98785.0
2017-12-15	ARCM	ETF	100.21	100.21	100.21	100.21	160000.0
2017-12-15	ARGT	ETF	34.82	34.82	34.46	34.63	113700.0
2017-12-15	ARKG	ETF	24.15	24.48	23.81	24.41	58600.0
2017-12-15	ARKK	ETF	37.99	38.53	37.716	38.45	392700.0
2017-12-15	ARKQ	ETF	33.96	34.6	33.96	34.6	49400.0
2017-12-15	ARKW	ETF	47.75	48.39	47.525	48.3	195900.0
2017-12-15	ASEA	ETF	16.88	16.93	16.62	16.9	2800.0
2017-12-15	ASET	ETF	28.78	28.825	28.78	28.82	430.0
2017-12-15	ASHR	ETF	30.5	30.54	30.43	30.44	989800.0
2017-12-15	ASHS	ETF	34.37	34.37	34.3	34.33	9100.0
2017-12-15	ASHX	ETF	22.46	22.62	22.46	22.6	401.0
2017-12-15	ATMP	ETF	20.74	20.74	20.49	20.51	276600.0
2017-12-15	BAB	ETF	30.72	30.81	30.67	30.76	56527.0
2017-12-15	BAL	ETF	50.5	50.935	50.18	50.22	5942.0

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

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