PREVIEW / etf_daily / 2020-06-17

all etf daily files

  file:    by_date/etf_daily/2020/2020-06-17.parquet
  size:    76 KB
  rows:    2,016

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
2020-06-17	SPY	ETF	314.07	314.39	310.86	311.66	83398900.0
2020-06-17	QQQ	ETF	244.4	245.5	242.73	243.62	34749268.0
2020-06-17	IWM	ETF	144.59	144.99	141.32	141.77	34811400.0
2020-06-17	DIA	ETF	264.61	264.7	261.26	261.82	3669300.0
2020-06-17	GLD	ETF	162.0	162.62	161.77	162.56	4758200.0
2020-06-17	TLT	ETF	160.27	160.77	159.34	160.56	7113900.0
2020-06-17	AAAU	ETF	17.19	17.25	17.16	17.25	155000.0
2020-06-17	AADR	ETF	51.28	51.74	51.27	51.38	1300.0
2020-06-17	AAXJ	ETF	68.54	68.95	68.5	68.67	759600.0
2020-06-17	ABEQ	ETF	22.485	22.499	22.38	22.403	1600.0
2020-06-17	ACES	ETF	38.92	39.07	37.77	37.94	24600.0
2020-06-17	ACIO	ETF	25.06	25.24	25.06	25.142	19400.0
2020-06-17	ACSI	ETF	33.7253	33.7253	33.7253	33.7253	134.0
2020-06-17	ACTX	ETF	4.071	4.248	4.071	4.13	778.0
2020-06-17	ACWF	ETF	27.98	28.0451	27.87	27.8761	19153.0
2020-06-17	ACWI	ETF	74.64	74.72	74.05	74.24	3125200.0
2020-06-17	ACWV	ETF	88.79	88.87	88.28	88.47	338600.0
2020-06-17	ACWX	ETF	43.71	43.76	43.435	43.55	1467097.0
2020-06-17	ADME	ETF	32.103	32.201	32.05	32.05	21800.0
2020-06-17	ADRE	ETF	39.96	40.2599	39.9	40.01	4365.0
2020-06-17	AESR	ETF	9.97	9.97	9.922	9.922	7000.0
2020-06-17	AFIF	ETF	9.805	9.8079	9.7777	9.795	9415.0
2020-06-17	AFK	ETF	16.36	16.38	16.23	16.23	13506.0
2020-06-17	AFLG	ETF	19.01	19.05	18.952	18.952	1300.0
2020-06-17	AFMC	ETF	17.17	17.17	17.16	17.16	300.0
2020-06-17	AFSM	ETF	16.83	16.83	16.779	16.779	100.0
2020-06-17	AFTY	ETF	16.365	16.366	16.365	16.366	300.0
2020-06-17	AGG	ETF	117.74	117.76	117.47	117.64	3696000.0
2020-06-17	AGGY	ETF	53.76	53.76	53.53	53.66	353900.0
2020-06-17	AGNG	ETF	24.73	24.73	24.44	24.546	2100.0
2020-06-17	AGQ	ETF	27.4	27.58	26.99	27.33	125800.0
2020-06-17	AGZ	ETF	120.81	121.12	120.63	120.78	44925.0
2020-06-17	AGZD	ETF	23.52	23.55	23.49	23.52	6000.0
2020-06-17	AIA	ETF	63.51	63.865	63.51	63.72	66541.0
2020-06-17	AIEQ	ETF	27.81	27.98	27.64	27.7	16500.0
2020-06-17	AIQ	ETF	20.46	20.54	20.34	20.37	13352.0
2020-06-17	AIRR	ETF	24.3	24.3	23.73	23.74	7100.0
2020-06-17	AIVI	ETF	36.31	36.45	36.21	36.24	5900.0
2020-06-17	ALTY	ETF	11.4	11.41	11.265	11.265	5500.0
2020-06-17	AMJ	ETF	15.08	15.31	14.8583	14.92	1181417.0
2020-06-17	AMLP	ETF	28.16	28.52	27.66	27.77	3071300.0
2020-06-17	AMOM	ETF	29.02	29.02	29.02	29.02	100.0
2020-06-17	AMUB	ETF	9.46	9.62	9.38	9.3964	5956.0
2020-06-17	AMZA	ETF	21.32	21.48	20.51	20.68	68700.0
2020-06-17	ANGL	ETF	29.15	29.21	29.0	29.07	908500.0
2020-06-17	AOA	ETF	55.4	55.43	55.07	55.07	29800.0
2020-06-17	AOK	ETF	36.38	36.47	36.301	36.31	301635.0
2020-06-17	AOM	ETF	40.0	40.1699	39.85	39.88	413748.0
2020-06-17	AOR	ETF	46.68	46.77	46.43	46.54	194285.0
2020-06-17	APRT	ETF	25.0753	25.0753	25.0753	25.0753	22.0

> showing 50 of 2,016 rows — these rows as CSV

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