PREVIEW / etf_daily / 2020-10-16

all etf daily files

  file:    by_date/etf_daily/2020/2020-10-16.parquet
  size:    80 KB
  rows:    2,119

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-10-16	SPY	ETF	348.96	350.75	347.1	347.29	89501900.0
2020-10-16	QQQ	ETF	291.8	293.269	288.15	288.51	40570702.0
2020-10-16	IWM	ETF	163.21	163.7	162.31	162.35	17637900.0
2020-10-16	DIA	ETF	286.24	288.37	285.89	285.97	2409300.0
2020-10-16	GLD	ETF	179.22	179.32	178.13	178.3	7260700.0
2020-10-16	TLT	ETF	161.66	162.32	161.1	161.39	8416300.0
2020-10-16	AAA	ETF	24.906	24.91	24.9	24.91	609.0
2020-10-16	AAAU	ETF	19.02	19.02	18.91	18.93	710400.0
2020-10-16	AADR	ETF	57.76	57.95	57.38	57.5	5800.0
2020-10-16	AAXJ	ETF	79.69	79.95	79.44	79.64	749300.0
2020-10-16	ABEQ	ETF	23.89	23.95	23.886	23.916	10700.0
2020-10-16	ACES	ETF	60.98	61.0	60.05	60.11	63900.0
2020-10-16	ACIO	ETF	27.2	27.26	27.16	27.16	15300.0
2020-10-16	ACSI	ETF	39.4707	39.4707	39.4707	39.4707	100.0
2020-10-16	ACWF	ETF	31.07	31.07	30.8913	30.8913	3570.0
2020-10-16	ACWI	ETF	82.72	83.11	82.45	82.45	3083400.0
2020-10-16	ACWV	ETF	93.48	93.89	93.46	93.47	109200.0
2020-10-16	ACWX	ETF	47.06	47.24	46.97	47.07	1149347.0
2020-10-16	ADME	ETF	34.935	34.945	34.71	34.72	7700.0
2020-10-16	ADRE	ETF	49.63	49.6802	49.338	49.5325	8163.0
2020-10-16	AESR	ETF	11.35	11.35	11.307	11.307	7500.0
2020-10-16	AFIF	ETF	9.797	9.81	9.77	9.77	71360.0
2020-10-16	AFK	ETF	17.91	18.2	17.91	18.12	4271.0
2020-10-16	AFLG	ETF	21.08	21.08	20.979	20.979	500.0
2020-10-16	AFSM	ETF	19.329	19.329	19.329	19.329	100.0
2020-10-16	AFTY	ETF	20.49	20.55	20.49	20.55	1100.0
2020-10-16	AGG	ETF	117.99	118.08	117.88	117.89	3931500.0
2020-10-16	AGGY	ETF	53.76	53.88	53.73	53.78	180200.0
2020-10-16	AGNG	ETF	26.34	26.34	26.159	26.159	4300.0
2020-10-16	AGQ	ETF	45.91	46.17	44.66	44.67	912000.0
2020-10-16	AGZ	ETF	121.04	121.04	120.92	121.0	27658.0
2020-10-16	AGZD	ETF	23.42	23.5	23.42	23.47	22600.0
2020-10-16	AIA	ETF	74.81	74.84	74.46	74.64	60133.0
2020-10-16	AIEQ	ETF	32.78	32.78	32.355	32.359	14100.0
2020-10-16	AIQ	ETF	24.79	24.88	24.66	24.6728	16327.0
2020-10-16	AIRR	ETF	28.16	28.337	28.14	28.2	8100.0
2020-10-16	AIVI	ETF	36.31	36.5	36.31	36.44	37400.0
2020-10-16	ALTL	ETF	25.865	25.865	25.7861	25.7861	3761.0
2020-10-16	ALTY	ETF	10.81	10.81	10.742	10.75	3700.0
2020-10-16	AMJ	ETF	11.9	12.017	11.72	11.72	750414.0
2020-10-16	AMLP	ETF	22.22	22.27	21.72	21.79	2860300.0
2020-10-16	AMNA	ETF	22.46	22.49	22.2692	22.2692	700.0
2020-10-16	AMND	ETF	23.41	23.4291	23.41	23.4291	200.0
2020-10-16	AMOM	ETF	36.975	36.975	36.975	36.975	200.0
2020-10-16	AMUB	ETF	7.43	7.5	7.405	7.4086	8164.0
2020-10-16	AMZA	ETF	15.4	15.449	14.94	14.94	361400.0
2020-10-16	ANEW	ETF	40.08	40.3	39.94	39.94	7532.0
2020-10-16	ANGL	ETF	30.14	30.14	29.96	29.98	696000.0
2020-10-16	AOA	ETF	59.47	59.66	59.34	59.35	26800.0
2020-10-16	AOK	ETF	37.65	37.67	37.55	37.6	461256.0

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

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