PREVIEW / etf_daily / 2018-10-02

all etf daily files

  file:    by_date/etf_daily/2018/2018-10-02.parquet
  size:    63 KB
  rows:    1,625

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-10-02	SPY	ETF	291.56	292.36	291.14	291.56	47258200.0
2018-10-02	QQQ	ETF	185.95	187.175	185.32	185.75	25618608.0
2018-10-02	IWM	ETF	166.18	166.53	164.18	164.53	28440300.0
2018-10-02	DIA	ETF	266.11	268.02	266.05	267.57	4553400.0
2018-10-02	GLD	ETF	113.7	114.33	113.61	113.87	10776700.0
2018-10-02	TLT	ETF	116.67	117.13	116.6	116.86	8266900.0
2018-10-02	AAAU	ETF	12.01	12.07	12.01	12.03	118700.0
2018-10-02	AADR	ETF	53.5	53.5	52.98	53.0	14400.0
2018-10-02	AAXJ	ETF	69.34	69.55	69.06	69.25	1035900.0
2018-10-02	ACES	ETF	25.86	25.99	25.86	25.97	1900.0
2018-10-02	ACSI	ETF	33.88	33.8999	33.88	33.8999	783.0
2018-10-02	ACTX	ETF	103.2509	171.1015	102.0709	119.9481	34380.0
2018-10-02	ACWF	ETF	30.7081	30.7081	30.612	30.65	4267.0
2018-10-02	ACWI	ETF	74.12	74.37	74.04	74.22	1416800.0
2018-10-02	ACWV	ETF	87.55	87.94	87.55	87.76	92700.0
2018-10-02	ACWX	ETF	47.43	47.55	47.32	47.44	406324.0
2018-10-02	ADRE	ETF	40.5	40.5142	40.2737	40.486	20940.0
2018-10-02	AFIF	ETF	10.0152	10.0242	10.01	10.0201	8983.0
2018-10-02	AFK	ETF	21.24	21.5	21.24	21.4765	4071.0
2018-10-02	AFTY	ETF	14.96	15.13	14.96	15.059	2300.0
2018-10-02	AGG	ETF	105.32	105.46	105.25	105.36	6912600.0
2018-10-02	AGGY	ETF	48.3	48.388	48.3	48.32	31400.0
2018-10-02	AGNG	ETF	22.51	22.51	22.243	22.243	800.0
2018-10-02	AGQ	ETF	24.6	24.99	24.12	24.2	302000.0
2018-10-02	AGZ	ETF	110.43	110.67	110.43	110.49	12985.0
2018-10-02	AGZD	ETF	23.965	24.015	23.945	23.975	4600.0
2018-10-02	AIA	ETF	61.33	61.58	61.17	61.36	46975.0
2018-10-02	AIEQ	ETF	29.43	29.468	29.28	29.35	59200.0
2018-10-02	AIQ	ETF	15.81	15.81	15.6256	15.6256	8155.0
2018-10-02	AIRR	ETF	27.5	27.57	27.39	27.46	7500.0
2018-10-02	AIVI	ETF	41.8	41.95	41.8	41.88	4300.0
2018-10-02	ALTY	ETF	15.1	15.17	15.1	15.146	15100.0
2018-10-02	AMJ	ETF	28.06	28.15	27.86	27.92	1524242.0
2018-10-02	AMLP	ETF	54.35	54.4	53.9	54.1	2267620.0
2018-10-02	AMZA	ETF	76.0	76.3	75.4	75.6	54750.0
2018-10-02	ANGL	ETF	29.02	29.05	29.01	29.02	409700.0
2018-10-02	AOA	ETF	54.44	54.54	54.36	54.41	45200.0
2018-10-02	AOK	ETF	34.07	34.1273	34.0227	34.04	38609.0
2018-10-02	AOM	ETF	37.68	37.718	37.6124	37.63	126078.0
2018-10-02	AOR	ETF	44.94	44.9714	44.83	44.89	80001.0
2018-10-02	ARGT	ETF	26.58	27.49	26.58	27.45	46300.0
2018-10-02	ARKG	ETF	32.81	32.81	31.68	31.76	269700.0
2018-10-02	ARKK	ETF	47.45	47.469	45.95	46.19	762900.0
2018-10-02	ARKQ	ETF	36.62	36.62	35.84	35.892	12400.0
2018-10-02	ARKW	ETF	57.8	57.97	56.94	57.11	123100.0
2018-10-02	ARVR	ETF	21.3297	21.45	21.28	21.45	684.0
2018-10-02	ASEA	ETF	16.2	16.2	16.17	16.17	2600.0
2018-10-02	ASET	ETF	27.7296	27.83	27.7296	27.7923	2587.0
2018-10-02	ASHR	ETF	24.89	25.01	24.86	24.88	1588700.0
2018-10-02	ASHS	ETF	25.13	25.14	25.1	25.12	2000.0

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

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