PREVIEW / etf_daily / 2017-07-28

all etf daily files

  file:    by_date/etf_daily/2017/2017-07-28.parquet
  size:    56 KB
  rows:    1,433

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-07-28	SPY	ETF	246.65	247.06	246.13	246.91	50088400.0
2017-07-28	QQQ	ETF	143.14	144.0752	142.87	143.84	38013176.0
2017-07-28	IWM	ETF	142.02	142.36	141.47	141.96	19933300.0
2017-07-28	DIA	ETF	217.53	218.16	217.3	218.02	2305000.0
2017-07-28	GLD	ETF	120.15	120.86	120.14	120.69	7393600.0
2017-07-28	TLT	ETF	123.27	123.99	123.26	123.89	5491800.0
2017-07-28	AADR	ETF	48.97	49.39	48.97	49.38	5700.0
2017-07-28	AAXJ	ETF	70.51	70.75	70.35	70.7	663600.0
2017-07-28	ACSI	ETF	29.01	29.0153	28.95	29.0153	29404.0
2017-07-28	ACTX	ETF	76.7007	76.7007	71.3906	73.1607	383.0
2017-07-28	ACWF	ETF	27.94	27.94	27.85	27.92	8735.0
2017-07-28	ACWI	ETF	67.03	67.24	66.99	67.2	1183300.0
2017-07-28	ACWV	ETF	80.26	80.37	80.07	80.37	98400.0
2017-07-28	ACWX	ETF	46.93	47.12	46.9	47.12	164661.0
2017-07-28	ADRE	ETF	41.0	41.55	41.0	41.4384	5556.0
2017-07-28	AFK	ETF	23.27	23.4587	23.27	23.41	4360.0
2017-07-28	AFTY	ETF	16.156	16.22	16.156	16.22	2000.0
2017-07-28	AGG	ETF	109.54	109.7	109.49	109.7	1894200.0
2017-07-28	AGGY	ETF	50.58	50.67	50.54	50.67	18900.0
2017-07-28	AGNG	ETF	19.0	19.13	18.95	19.01	11500.0
2017-07-28	AGQ	ETF	33.74	34.11	33.66	34.01	203700.0
2017-07-28	AGZ	ETF	113.7639	113.9	113.697	113.9	7171.0
2017-07-28	AGZD	ETF	23.975	23.975	23.975	23.975	400.0
2017-07-28	AIA	ETF	59.88	59.91	59.71	59.88	44178.0
2017-07-28	AIQ	ETF	13.25	13.25	13.2	13.25	15836.0
2017-07-28	AIRR	ETF	24.08	24.08	23.74	23.81	21600.0
2017-07-28	AIVI	ETF	41.63	41.72	41.58	41.7	3300.0
2017-07-28	ALTY	ETF	15.566	15.74	15.566	15.74	11600.0
2017-07-28	AMJ	ETF	29.91	30.11	29.91	29.95	649476.0
2017-07-28	AMLP	ETF	59.85	60.1	59.65	59.9	1411200.0
2017-07-28	AMZA	ETF	97.0	97.1	96.8	97.0	76690.0
2017-07-28	ANGL	ETF	29.89	29.97	29.89	29.96	102100.0
2017-07-28	AOA	ETF	52.47	52.49	52.34	52.49	48400.0
2017-07-28	AOK	ETF	34.16	34.2	34.0801	34.2	38072.0
2017-07-28	AOM	ETF	37.44	37.49	37.35	37.49	87861.0
2017-07-28	AOR	ETF	44.03	44.08	43.9456	44.08	46902.0
2017-07-28	ARCM	ETF	100.05	100.05	100.05	100.05	20.0
2017-07-28	ARGT	ETF	29.65	29.91	29.65	29.87	29200.0
2017-07-28	ARKG	ETF	22.49	22.58	22.36	22.57	10200.0
2017-07-28	ARKK	ETF	29.58	30.08	29.58	29.97	40800.0
2017-07-28	ARKQ	ETF	29.64	29.88	29.64	29.85	14400.0
2017-07-28	ARKW	ETF	36.67	37.332	36.67	37.169	34500.0
2017-07-28	ASEA	ETF	15.45	15.45	15.4	15.41	2300.0
2017-07-28	ASET	ETF	27.89	27.89	27.875	27.875	3873.0
2017-07-28	ASHR	ETF	27.94	28.06	27.92	28.03	363900.0
2017-07-28	ASHS	ETF	33.68	33.75	33.68	33.72	3800.0
2017-07-28	ASHX	ETF	21.134	21.134	21.116	21.116	475.0
2017-07-28	ATMP	ETF	22.73	22.85	22.73	22.75	11500.0
2017-07-28	BAB	ETF	29.95	30.0699	29.95	30.03	44362.0
2017-07-28	BAL	ETF	45.3	45.65	45.27	45.3786	16610.0

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

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