PREVIEW / etf_daily / 2017-08-23

all etf daily files

  file:    by_date/etf_daily/2017/2017-08-23.parquet
  size:    56 KB
  rows:    1,432

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-08-23	SPY	ETF	244.33	245.05	244.16	244.56	50203800.0
2017-08-23	QQQ	ETF	142.5	143.01	142.38	142.69	25702324.0
2017-08-23	IWM	ETF	135.53	136.57	135.21	136.07	18381900.0
2017-08-23	DIA	ETF	218.01	218.46	217.84	217.92	3660200.0
2017-08-23	GLD	ETF	122.58	122.69	122.31	122.67	5038400.0
2017-08-23	TLT	ETF	127.04	127.31	126.76	127.3	7446400.0
2017-08-23	AADR	ETF	51.69	51.95	51.65	51.84	54100.0
2017-08-23	AAXJ	ETF	71.13	71.55	71.11	71.47	369100.0
2017-08-23	ACSI	ETF	28.74	28.78	28.7236	28.78	14619.0
2017-08-23	ACTX	ETF	76.7007	77.2907	75.5207	75.5207	133.0
2017-08-23	ACWF	ETF	27.942	27.95	27.9071	27.91	2836.0
2017-08-23	ACWI	ETF	66.77	66.97	66.68	66.83	864300.0
2017-08-23	ACWV	ETF	80.84	80.91	80.75	80.84	341700.0
2017-08-23	ACWX	ETF	46.9	47.11	46.86	47.04	355763.0
2017-08-23	ADRE	ETF	42.13	42.5	42.13	42.49	9237.0
2017-08-23	AFK	ETF	23.19	23.3999	23.1669	23.33	7261.0
2017-08-23	AFTY	ETF	16.61	16.61	16.52	16.56	6800.0
2017-08-23	AGG	ETF	110.08	110.19	110.01	110.18	1894900.0
2017-08-23	AGGY	ETF	50.78	50.82	50.722	50.81	13700.0
2017-08-23	AGNG	ETF	18.636	18.636	18.6	18.6	800.0
2017-08-23	AGQ	ETF	35.2	35.22	34.74	35.16	59100.0
2017-08-23	AGZ	ETF	114.165	114.27	114.15	114.258	6387.0
2017-08-23	AGZD	ETF	24.0	24.0	23.9	23.955	7400.0
2017-08-23	AIA	ETF	60.36	60.68	60.23	60.57	141617.0
2017-08-23	AIRR	ETF	22.38	22.69	22.38	22.63	18700.0
2017-08-23	AIVI	ETF	41.6	41.76	41.6	41.76	4900.0
2017-08-23	ALTY	ETF	15.67	15.67	15.545	15.58	1800.0
2017-08-23	AMJ	ETF	27.38	28.01	27.3173	27.86	2494598.0
2017-08-23	AMLP	ETF	53.55	54.5	53.3	54.35	2218940.0
2017-08-23	AMZA	ETF	87.3	89.3	87.0	88.8	89680.0
2017-08-23	ANGL	ETF	29.77	29.85	29.72	29.84	308600.0
2017-08-23	AOA	ETF	52.19	52.29	52.15	52.25	26700.0
2017-08-23	AOK	ETF	34.13	34.23	34.11	34.23	42615.0
2017-08-23	AOM	ETF	37.45	37.54	37.43	37.5	76911.0
2017-08-23	AOR	ETF	43.87	44.02	43.87	43.97	68702.0
2017-08-23	ARGT	ETF	29.24	29.44	29.14	29.42	41100.0
2017-08-23	ARKG	ETF	22.41	22.66	22.38	22.49	10500.0
2017-08-23	ARKK	ETF	31.3	31.55	31.15	31.49	74200.0
2017-08-23	ARKQ	ETF	29.13	29.3	28.978	29.278	15500.0
2017-08-23	ARKW	ETF	38.71	39.09	38.61	39.01	52000.0
2017-08-23	ASEA	ETF	15.44	15.49	15.39	15.39	17100.0
2017-08-23	ASET	ETF	27.94	27.94	27.9389	27.9389	735.0
2017-08-23	ASHR	ETF	28.46	28.46	28.39	28.42	320100.0
2017-08-23	ASHS	ETF	34.56	34.59	34.53	34.57	5000.0
2017-08-23	ASHX	ETF	21.23	21.23	21.18	21.18	1201.0
2017-08-23	ATMP	ETF	20.63	21.12	20.63	21.08	25800.0
2017-08-23	BAB	ETF	30.44	30.55	30.4	30.55	101313.0
2017-08-23	BAL	ETF	45.8199	45.82	45.2975	45.2975	4282.0
2017-08-23	BBC	ETF	24.23	24.8559	24.23	24.78	3340.0
2017-08-23	BBH	ETF	126.49	126.92	126.44	126.45	9100.0

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

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