PREVIEW / etf_daily / 2017-12-21

all etf daily files

  file:    by_date/etf_daily/2017/2017-12-21.parquet
  size:    60 KB
  rows:    1,549

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-21	SPY	ETF	267.74	268.39	267.3	267.58	67032300.0
2017-12-21	QQQ	ETF	157.73	158.25	157.37	157.55	18638679.0
2017-12-21	IWM	ETF	153.24	154.02	153.08	153.47	16772600.0
2017-12-21	DIA	ETF	247.73	248.29	247.42	247.66	2446700.0
2017-12-21	GLD	ETF	120.07	120.45	120.0	120.31	4823700.0
2017-12-21	TLT	ETF	124.03	124.86	124.0	124.6	7026900.0
2017-12-21	AADR	ETF	58.84	58.9	58.66	58.67	48400.0
2017-12-21	AAXJ	ETF	74.74	75.2	74.72	75.01	2325800.0
2017-12-21	ACSI	ETF	31.305	31.3999	31.305	31.3999	862.0
2017-12-21	ACTX	ETF	79.0607	93.2208	73.1607	84.9608	2650.0
2017-12-21	ACWF	ETF	30.5	30.52	30.49	30.49	2556.0
2017-12-21	ACWI	ETF	71.83	72.1	71.8	71.92	2240200.0
2017-12-21	ACWV	ETF	83.86	83.88	83.67	83.76	117400.0
2017-12-21	ACWX	ETF	49.37	49.62	49.37	49.52	656624.0
2017-12-21	ADRE	ETF	42.72	42.954	42.72	42.86	11045.0
2017-12-21	AFK	ETF	24.54	24.59	24.39	24.42	16143.0
2017-12-21	AFTY	ETF	17.679	17.72	17.679	17.72	5400.0
2017-12-21	AGG	ETF	108.76	108.87	108.73	108.82	2374500.0
2017-12-21	AGGY	ETF	50.47	50.57	50.437	50.545	82800.0
2017-12-21	AGNG	ETF	19.46	19.468	19.43	19.43	1800.0
2017-12-21	AGQ	ETF	30.76	31.2	30.69	30.81	87800.0
2017-12-21	AGZ	ETF	112.75	112.7647	112.7052	112.71	24120.0
2017-12-21	AGZD	ETF	24.14	24.21	24.11	24.195	3400.0
2017-12-21	AIA	ETF	64.65	64.93	64.54	64.76	107959.0
2017-12-21	AIEQ	ETF	25.93	26.2	25.93	26.12	91800.0
2017-12-21	AIRR	ETF	27.55	27.769	27.473	27.71	37600.0
2017-12-21	AIVI	ETF	43.25	43.48	43.25	43.42	6200.0
2017-12-21	ALTY	ETF	15.34	15.34	15.27	15.298	5900.0
2017-12-21	AMJ	ETF	26.96	27.48	26.83	27.15	5435827.0
2017-12-21	AMLP	ETF	53.5	54.35	53.15	53.55	4943440.0
2017-12-21	AMZA	ETF	84.9	86.3	84.6	85.4	94080.0
2017-12-21	ANGL	ETF	29.91	29.98	29.88	29.91	228300.0
2017-12-21	AOA	ETF	55.73	55.83	55.64	55.75	56900.0
2017-12-21	AOK	ETF	34.48	34.6	34.48	34.5	117626.0
2017-12-21	AOM	ETF	38.65	38.7	38.58	38.65	287035.0
2017-12-21	AOR	ETF	46.1	46.18	46.06	46.14	138697.0
2017-12-21	ARCM	ETF	100.36	100.36	100.36	100.36	100.0
2017-12-21	ARGT	ETF	35.39	35.63	35.39	35.46	48200.0
2017-12-21	ARKG	ETF	24.69	24.85	24.655	24.78	28100.0
2017-12-21	ARKK	ETF	38.4	38.4	37.65	37.75	370800.0
2017-12-21	ARKQ	ETF	34.56	34.56	33.94	33.95	49800.0
2017-12-21	ARKW	ETF	48.05	48.05	46.93	47.06	297200.0
2017-12-21	ASEA	ETF	16.87	16.94	16.7	16.94	5000.0
2017-12-21	ASET	ETF	28.6887	28.719	28.6887	28.69	4310.0
2017-12-21	ASHR	ETF	30.93	31.08	30.92	31.07	851500.0
2017-12-21	ASHS	ETF	34.49	34.59	34.49	34.5	4300.0
2017-12-21	ATMP	ETF	20.47	20.72	20.39	20.54	397100.0
2017-12-21	BAB	ETF	30.37	30.42	30.31	30.39	375132.0
2017-12-21	BAL	ETF	50.941	51.61	50.94	51.5528	2677.0
2017-12-21	BAR	ETF	12.647	12.6697	12.647	12.663	12770.0

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

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