PREVIEW / etf_daily / 2017-08-22

all etf daily files

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

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-22	SPY	ETF	243.57	245.62	243.55	245.44	63140100.0
2017-08-22	QQQ	ETF	141.8	143.35	141.76	143.2	36294232.0
2017-08-22	IWM	ETF	135.26	136.45	135.14	136.29	25170600.0
2017-08-22	DIA	ETF	217.41	218.85	217.3	218.69	2423200.0
2017-08-22	GLD	ETF	122.56	122.56	121.85	122.21	6493900.0
2017-08-22	TLT	ETF	126.79	126.81	126.27	126.44	6140700.0
2017-08-22	AADR	ETF	51.48	52.09	51.42	51.77	18500.0
2017-08-22	AAXJ	ETF	70.96	71.36	70.9	71.35	809400.0
2017-08-22	ACSI	ETF	28.7055	28.7968	28.7055	28.7968	11074.0
2017-08-22	ACTX	ETF	77.2907	82.3057	73.7507	77.2907	278.0
2017-08-22	ACWF	ETF	27.86	27.955	27.85	27.91	2615.0
2017-08-22	ACWI	ETF	66.63	66.99	66.59	66.94	1013700.0
2017-08-22	ACWV	ETF	80.78	80.96	80.72	80.95	103900.0
2017-08-22	ACWX	ETF	46.89	47.03	46.86	47.03	583945.0
2017-08-22	ADRE	ETF	41.88	42.3	41.88	42.19	8861.0
2017-08-22	AFK	ETF	23.0	23.19	23.0	23.19	2229.0
2017-08-22	AFTY	ETF	16.35	16.45	16.35	16.45	4500.0
2017-08-22	AGG	ETF	109.99	110.02	109.87	109.93	1992300.0
2017-08-22	AGGY	ETF	50.733	50.734	50.676	50.698	5700.0
2017-08-22	AGNG	ETF	18.618	18.618	18.618	18.618	200.0
2017-08-22	AGQ	ETF	35.11	35.24	34.36	34.82	70700.0
2017-08-22	AGZ	ETF	114.1	114.14	114.0401	114.1	14410.0
2017-08-22	AGZD	ETF	23.995	23.995	23.9	23.995	2400.0
2017-08-22	AIA	ETF	60.22	60.505	60.22	60.43	41103.0
2017-08-22	AIRR	ETF	22.49	22.68	22.49	22.66	46700.0
2017-08-22	AIVI	ETF	41.61	41.69	41.61	41.65	4400.0
2017-08-22	ALTY	ETF	15.67	15.67	15.5	15.547	2600.0
2017-08-22	AMJ	ETF	27.14	27.54	27.12	27.51	3847993.0
2017-08-22	AMLP	ETF	52.8	53.65	52.8	53.5	2655620.0
2017-08-22	AMZA	ETF	85.7	87.6	85.7	87.5	118670.0
2017-08-22	ANGL	ETF	29.69	29.79	29.63	29.78	193700.0
2017-08-22	AOA	ETF	52.11	52.32	51.99	52.3	65900.0
2017-08-22	AOK	ETF	34.1365	34.2075	34.1171	34.14	44263.0
2017-08-22	AOM	ETF	37.43	37.52	37.4212	37.45	130788.0
2017-08-22	AOR	ETF	43.83	44.0	43.83	43.98	85706.0
2017-08-22	ARGT	ETF	29.12	29.33	29.1	29.14	100900.0
2017-08-22	ARKG	ETF	22.05	22.529	22.04	22.49	9800.0
2017-08-22	ARKK	ETF	30.87	31.34	30.87	31.32	58200.0
2017-08-22	ARKQ	ETF	28.76	29.15	28.76	29.15	19700.0
2017-08-22	ARKW	ETF	38.56	38.84	38.33	38.8	44000.0
2017-08-22	ASEA	ETF	15.35	15.49	15.35	15.48	23500.0
2017-08-22	ASET	ETF	27.95	27.97	27.9111	27.9498	3892.0
2017-08-22	ASHR	ETF	28.43	28.5	28.43	28.48	337900.0
2017-08-22	ASHS	ETF	34.9	34.92	34.9	34.9	2100.0
2017-08-22	ASHX	ETF	21.3245	21.3245	21.28	21.28	900.0
2017-08-22	ATMP	ETF	20.56	20.83	20.55	20.8	12900.0
2017-08-22	BAB	ETF	30.43	30.4657	30.34	30.35	63740.0
2017-08-22	BAL	ETF	44.745	44.75	44.65	44.68	2117.0
2017-08-22	BBC	ETF	23.56	24.41	23.56	24.3351	2572.0
2017-08-22	BBH	ETF	125.73	127.42	125.73	127.18	13500.0

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

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