PREVIEW / etf_daily / 2017-07-21

all etf daily files

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

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-21	SPY	ETF	246.44	246.91	246.18	246.88	82340800.0
2017-07-21	QQQ	ETF	143.62	144.11	143.35	144.11	39697094.0
2017-07-21	IWM	ETF	143.01	143.33	142.25	142.55	21662700.0
2017-07-21	DIA	ETF	215.19	215.55	214.76	215.53	2217300.0
2017-07-21	GLD	ETF	119.0	119.39	118.75	119.26	10135900.0
2017-07-21	TLT	ETF	125.73	126.03	125.57	125.69	6201500.0
2017-07-21	AADR	ETF	49.36	49.45	49.07	49.45	13900.0
2017-07-21	AAXJ	ETF	70.41	70.52	70.33	70.51	808200.0
2017-07-21	ACSI	ETF	29.0	29.03	28.85	29.03	3619.0
2017-07-21	ACTX	ETF	80.2407	80.8307	77.2907	79.6507	116.0
2017-07-21	ACWF	ETF	28.05	28.07	28.05	28.07	1015.0
2017-07-21	ACWI	ETF	67.02	67.11	66.88	67.11	881000.0
2017-07-21	ACWV	ETF	80.02	80.26	79.97	80.26	213100.0
2017-07-21	ACWX	ETF	46.93	46.93	46.77	46.92	195177.0
2017-07-21	ADRE	ETF	40.57	40.65	40.5	40.608	3265.0
2017-07-21	AFK	ETF	22.99	22.99	22.8111	22.95	3462.0
2017-07-21	AFTY	ETF	16.104	16.12	16.102	16.11	3000.0
2017-07-21	AGG	ETF	109.88	109.96	109.83	109.92	1531700.0
2017-07-21	AGGY	ETF	50.89	50.92	50.85	50.89	58500.0
2017-07-21	AGNG	ETF	19.31	19.33	19.231	19.3	5600.0
2017-07-21	AGQ	ETF	32.92	33.22	32.81	33.11	142400.0
2017-07-21	AGZ	ETF	113.95	113.97	113.9	113.92	28852.0
2017-07-21	AGZD	ETF	24.005	24.045	24.0	24.03	3000.0
2017-07-21	AIA	ETF	59.93	60.01	59.89	60.01	21619.0
2017-07-21	AIQ	ETF	13.2	13.25	13.2	13.25	44673.0
2017-07-21	AIRR	ETF	23.94	23.971	23.87	23.89	13900.0
2017-07-21	AIVI	ETF	41.72	41.75	41.6	41.74	14000.0
2017-07-21	ALTY	ETF	15.682	15.731	15.68	15.72	1700.0
2017-07-21	AMJ	ETF	29.89	30.05	29.69	29.73	1407120.0
2017-07-21	AMLP	ETF	59.75	60.05	59.5	59.5	1660340.0
2017-07-21	AMZA	ETF	97.3	97.6	96.1	96.5	90820.0
2017-07-21	ANGL	ETF	29.8	29.83	29.74	29.79	193200.0
2017-07-21	AOA	ETF	52.4	52.44	52.3	52.44	30000.0
2017-07-21	AOK	ETF	34.23	34.23	34.14	34.17	49595.0
2017-07-21	AOM	ETF	37.44	37.52	37.4	37.52	85990.0
2017-07-21	AOR	ETF	44.04	44.066	43.9608	44.01	70850.0
2017-07-21	ARCM	ETF	100.09	100.09	100.09	100.09	20.0
2017-07-21	ARGT	ETF	29.78	29.85	29.61	29.64	82600.0
2017-07-21	ARKG	ETF	22.549	22.598	22.5	22.5	9100.0
2017-07-21	ARKK	ETF	29.71	30.02	29.71	29.95	77100.0
2017-07-21	ARKQ	ETF	29.34	29.47	29.199	29.45	21000.0
2017-07-21	ARKW	ETF	37.1	37.32	37.086	37.21	39400.0
2017-07-21	ASEA	ETF	15.29	15.29	15.23	15.23	400.0
2017-07-21	ASET	ETF	27.679	27.7332	27.679	27.73	10831.0
2017-07-21	ASHR	ETF	28.01	28.04	27.93	27.94	337500.0
2017-07-21	ASHS	ETF	33.07	33.1	33.02	33.02	12600.0
2017-07-21	ASHX	ETF	21.19	21.2099	21.142	21.144	800.0
2017-07-21	ATMP	ETF	22.67	22.67	22.54	22.55	14900.0
2017-07-21	BAB	ETF	30.11	30.13	30.05	30.12	130643.0
2017-07-21	BAL	ETF	44.82	45.23	44.4467	44.97	13258.0

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

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