PREVIEW / etf_daily / 2018-05-02

all etf daily files

  file:    by_date/etf_daily/2018/2018-05-02.parquet
  size:    60 KB
  rows:    1,543

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
2018-05-02	SPY	ETF	264.76	265.68	262.76	263.2	86368900.0
2018-05-02	QQQ	ETF	163.1	163.57	161.63	161.82	38646842.0
2018-05-02	IWM	ETF	153.78	155.78	153.68	154.65	16786800.0
2018-05-02	DIA	ETF	240.61	241.7	238.72	239.11	2729400.0
2018-05-02	GLD	ETF	123.9	124.54	123.58	123.65	7614000.0
2018-05-02	TLT	ETF	118.64	118.87	118.26	118.28	4644000.0
2018-05-02	AADR	ETF	58.9	58.9	57.81	57.82	9900.0
2018-05-02	AAXJ	ETF	76.35	76.38	75.67	75.69	469100.0
2018-05-02	ACSI	ETF	30.86	31.119	30.86	30.9041	890.0
2018-05-02	ACTX	ETF	63.7206	64.9006	59.0005	61.0655	360.0
2018-05-02	ACWF	ETF	30.615	30.72	30.3989	30.3989	11705.0
2018-05-02	ACWI	ETF	72.08	72.22	71.52	71.61	1076500.0
2018-05-02	ACWV	ETF	83.15	83.15	82.43	82.53	96100.0
2018-05-02	ACWX	ETF	50.02	50.06	49.65	49.685	529430.0
2018-05-02	ADRE	ETF	43.77	43.77	43.3771	43.3771	2592.0
2018-05-02	AFK	ETF	25.02	25.121	25.0	25.0	14758.0
2018-05-02	AFTY	ETF	16.77	16.77	16.53	16.71	2600.0
2018-05-02	AGG	ETF	105.7	105.78	105.62	105.67	2560800.0
2018-05-02	AGGY	ETF	48.57	48.599	48.53	48.53	46800.0
2018-05-02	AGNG	ETF	19.582	19.765	19.582	19.765	400.0
2018-05-02	AGQ	ETF	31.17	31.6	30.87	30.98	243900.0
2018-05-02	AGZ	ETF	110.78	110.9485	110.76	110.8	14562.0
2018-05-02	AGZD	ETF	24.045	24.06	24.015	24.05	7000.0
2018-05-02	AIA	ETF	67.08	67.2	66.59	66.62	99842.0
2018-05-02	AIEQ	ETF	26.48	26.72	26.428	26.435	24400.0
2018-05-02	AIRR	ETF	25.13	25.369	25.08	25.22	7100.0
2018-05-02	AIVI	ETF	44.29	44.41	44.12	44.12	5400.0
2018-05-02	ALTY	ETF	14.58	14.58	14.57	14.58	1300.0
2018-05-02	AMJ	ETF	26.05	26.15	25.7	25.81	1668872.0
2018-05-02	AMLP	ETF	50.75	51.0	50.0	50.25	3622040.0
2018-05-02	AMZA	ETF	73.4	73.9	72.5	72.8	96440.0
2018-05-02	ANGL	ETF	28.98	29.03	28.89	28.89	344400.0
2018-05-02	AOA	ETF	53.47	53.6	53.2	53.25	34900.0
2018-05-02	AOK	ETF	33.96	33.97	33.8491	33.85	29707.0
2018-05-02	AOM	ETF	37.41	37.4743	37.3361	37.37	83317.0
2018-05-02	AOR	ETF	44.35	44.44	44.21	44.25	40701.0
2018-05-02	ARCM	ETF	99.96	99.96	99.96	99.96	100.0
2018-05-02	ARGT	ETF	34.65	34.73	34.0	34.0	49600.0
2018-05-02	ARKG	ETF	25.73	26.06	25.38	25.78	16700.0
2018-05-02	ARKK	ETF	39.49	39.956	39.14	39.55	162900.0
2018-05-02	ARKQ	ETF	32.61	32.874	32.55	32.56	14100.0
2018-05-02	ARKW	ETF	50.23	50.65	50.08	50.23	94000.0
2018-05-02	ASEA	ETF	17.64	17.65	17.55	17.59	7200.0
2018-05-02	ASET	ETF	27.855	27.979	27.855	27.97	2992.0
2018-05-02	ASHR	ETF	29.6	29.61	29.38	29.38	457400.0
2018-05-02	ASHS	ETF	33.55	33.55	33.24	33.27	3900.0
2018-05-02	ASHX	ETF	20.52	20.55	20.52	20.55	575.0
2018-05-02	ATMP	ETF	19.71	19.81	19.67	19.71	20400.0
2018-05-02	BAB	ETF	29.58	29.685	29.57	29.65	102520.0
2018-05-02	BAL	ETF	51.4	51.47	51.12	51.12	1847.0

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

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