PREVIEW / etf_daily / 2020-02-20

all etf daily files

  file:    by_date/etf_daily/2020/2020-02-20.parquet
  size:    74 KB
  rows:    1,958

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-02-20	SPY	ETF	337.74	338.64	333.68	336.95	74163400.0
2020-02-20	QQQ	ETF	236.46	236.95	231.88	234.78	42604016.0
2020-02-20	IWM	ETF	167.9	169.11	166.59	168.81	20383800.0
2020-02-20	DIA	ETF	293.56	294.29	290.17	292.78	3493900.0
2020-02-20	GLD	ETF	152.0	152.83	151.95	152.41	8457300.0
2020-02-20	TLT	ETF	146.08	146.94	146.0	146.67	9332900.0
2020-02-20	AAAU	ETF	16.11	16.19	16.11	16.16	70200.0
2020-02-20	AADR	ETF	57.27	57.27	56.49	56.84	4000.0
2020-02-20	AAXJ	ETF	72.48	72.51	71.66	71.84	3066400.0
2020-02-20	ABEQ	ETF	25.12	25.19	25.06	25.129	41300.0
2020-02-20	ACES	ETF	43.58	43.737	42.41	43.51	163500.0
2020-02-20	ACIO	ETF	25.135	25.21	25.135	25.189	9100.0
2020-02-20	ACSI	ETF	37.615	37.842	37.59	37.7169	1115.0
2020-02-20	ACTX	ETF	6.8264	7.2335	6.8264	7.0211	165.0
2020-02-20	ACWF	ETF	31.8199	31.8199	31.5399	31.6471	4003.0
2020-02-20	ACWI	ETF	81.2	81.42	80.39	80.99	2419300.0
2020-02-20	ACWV	ETF	99.09	99.09	98.19	98.8	166100.0
2020-02-20	ACWX	ETF	48.6	48.6697	48.18	48.43	1284583.0
2020-02-20	ADME	ETF	31.66	31.83	31.66	31.81	16200.0
2020-02-20	ADRE	ETF	43.68	43.68	42.9743	43.1373	4680.0
2020-02-20	AESR	ETF	10.495	10.527	10.495	10.527	300.0
2020-02-20	AFIF	ETF	9.7517	9.76	9.69	9.745	193689.0
2020-02-20	AFK	ETF	19.47	19.58	19.24	19.28	14206.0
2020-02-20	AFMC	ETF	20.903	20.903	20.903	20.903	100.0
2020-02-20	AFTY	ETF	16.641	16.645	16.48	16.513	10700.0
2020-02-20	AGG	ETF	114.53	114.68	114.49	114.67	4056000.0
2020-02-20	AGGY	ETF	53.39	53.46	53.386	53.45	144300.0
2020-02-20	AGNG	ETF	24.91	25.009	24.572	24.74	9100.0
2020-02-20	AGQ	ETF	32.86	33.3	32.8	33.12	389900.0
2020-02-20	AGZ	ETF	117.2	117.33	117.1675	117.3	45804.0
2020-02-20	AGZD	ETF	24.075	24.135	24.065	24.085	19200.0
2020-02-20	AIA	ETF	65.38	65.48	64.69	64.9	31955.0
2020-02-20	AIEQ	ETF	30.32	30.36	30.0	30.217	17500.0
2020-02-20	AIQ	ETF	19.87	19.93	19.53	19.76	10258.0
2020-02-20	AIRR	ETF	29.18	29.328	29.17	29.205	9000.0
2020-02-20	AIVI	ETF	41.57	41.57	41.24	41.42	2300.0
2020-02-20	ALTY	ETF	15.03	15.045	15.0	15.045	7000.0
2020-02-20	AMJ	ETF	20.42	20.605	20.32	20.34	2563935.0
2020-02-20	AMLP	ETF	39.05	39.2	38.6	38.6	7142780.0
2020-02-20	AMOM	ETF	27.89	27.89	27.89	27.89	100.0
2020-02-20	AMUB	ETF	12.88	12.96	12.81	12.8366	23600.0
2020-02-20	AMZA	ETF	39.6	39.6	39.1	39.2	70960.0
2020-02-20	ANGL	ETF	30.41	30.48	30.37	30.48	401200.0
2020-02-20	AOA	ETF	59.13	59.18	58.65	59.0	102500.0
2020-02-20	AOK	ETF	36.91	36.96	36.83	36.94	57178.0
2020-02-20	AOM	ETF	40.95	40.98	40.76	40.91	113131.0
2020-02-20	AOR	ETF	48.65	48.83	48.5	48.63	122522.0
2020-02-20	ARCM	ETF	100.09	100.15	100.09	100.15	40000.0
2020-02-20	ARGT	ETF	26.23	26.69	26.23	26.37	31700.0
2020-02-20	ARKF	ETF	27.51	27.735	27.0	27.42	85800.0

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

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