PREVIEW / etf_daily / 2018-08-02

all etf daily files

  file:    by_date/etf_daily/2018/2018-08-02.parquet
  size:    61 KB
  rows:    1,586

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-08-02	SPY	ETF	279.39	282.58	279.16	282.39	63426400.0
2018-08-02	QQQ	ETF	175.87	179.74	175.79	179.53	47178229.0
2018-08-02	IWM	ETF	164.96	167.21	164.94	166.97	18292200.0
2018-08-02	DIA	ETF	251.45	253.41	251.03	253.1	4132600.0
2018-08-02	GLD	ETF	115.17	115.23	114.42	114.52	6204200.0
2018-08-02	TLT	ETF	118.62	118.74	118.3	118.63	4451100.0
2018-08-02	AADR	ETF	53.15	53.15	52.55	53.06	14200.0
2018-08-02	AAXJ	ETF	70.96	71.45	70.74	71.34	2985800.0
2018-08-02	ACES	ETF	25.86	25.86	25.426	25.642	2100.0
2018-08-02	ACSI	ETF	32.75	33.0	32.7046	33.0	773.0
2018-08-02	ACTX	ETF	60.7705	61.9506	58.4105	58.4105	142.0
2018-08-02	ACWF	ETF	30.34	30.61	30.34	30.5628	77659.0
2018-08-02	ACWI	ETF	72.51	73.14	72.44	73.1	2475500.0
2018-08-02	ACWV	ETF	84.96	85.47	84.96	85.44	85700.0
2018-08-02	ACWX	ETF	47.85	48.02	47.73	48.0	314639.0
2018-08-02	ADRE	ETF	41.65	41.8116	41.23	41.8116	8664.0
2018-08-02	AFK	ETF	23.45	23.45	23.23	23.24	7219.0
2018-08-02	AFTY	ETF	14.38	14.47	14.34	14.47	9000.0
2018-08-02	AGG	ETF	105.76	105.76	105.65	105.74	3671900.0
2018-08-02	AGGY	ETF	48.46	48.53	48.45	48.52	55400.0
2018-08-02	AGNG	ETF	21.45	21.61	21.25	21.556	900.0
2018-08-02	AGQ	ETF	26.95	27.05	26.58	26.75	90900.0
2018-08-02	AGZ	ETF	110.6988	110.7526	110.68	110.68	30571.0
2018-08-02	AGZD	ETF	23.99	23.995	23.985	23.99	12000.0
2018-08-02	AIA	ETF	61.38	61.949	61.24	61.84	28949.0
2018-08-02	AIEQ	ETF	28.75	28.96	28.56	28.92	62000.0
2018-08-02	AIQ	ETF	14.96	15.1388	14.8797	15.1388	6865.0
2018-08-02	AIRR	ETF	27.4	27.731	27.4	27.7	6400.0
2018-08-02	AIVI	ETF	42.64	42.76	42.55	42.76	10000.0
2018-08-02	ALTY	ETF	15.3	15.38	15.28	15.38	13900.0
2018-08-02	AMJ	ETF	28.15	28.91	28.1018	28.76	3256093.0
2018-08-02	AMLP	ETF	54.9	56.0	54.8	55.8	4859360.0
2018-08-02	AMZA	ETF	78.1	79.7	77.77	79.5	148870.0
2018-08-02	ANGL	ETF	28.84	28.96	28.84	28.93	201700.0
2018-08-02	AOA	ETF	53.78	54.13	53.74	54.12	189600.0
2018-08-02	AOK	ETF	33.99	34.09	33.956	34.06	35988.0
2018-08-02	AOM	ETF	37.55	37.68	37.53	37.68	104627.0
2018-08-02	AOR	ETF	44.55	44.76	44.513	44.71	293024.0
2018-08-02	ARGT	ETF	28.68	29.16	28.68	28.95	578700.0
2018-08-02	ARKG	ETF	29.33	29.7	29.156	29.65	442300.0
2018-08-02	ARKK	ETF	44.77	45.94	44.63	45.87	500700.0
2018-08-02	ARKQ	ETF	35.04	36.24	35.04	36.16	87400.0
2018-08-02	ARKW	ETF	54.91	56.68	54.9	56.65	367600.0
2018-08-02	ARVR	ETF	20.55	20.676	20.5448	20.676	1088.0
2018-08-02	ASEA	ETF	16.15	16.15	15.96	16.04	12100.0
2018-08-02	ASET	ETF	28.05	28.18	28.05	28.169	11115.0
2018-08-02	ASHR	ETF	24.78	24.98	24.68	24.9	1874900.0
2018-08-02	ASHS	ETF	26.49	26.55	26.37	26.48	11900.0
2018-08-02	ASHX	ETF	17.64	17.71	17.64	17.71	351.0
2018-08-02	ATMP	ETF	21.5	22.01	21.5	21.94	47200.0

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

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