PREVIEW / etf_daily / 2020-05-21

all etf daily files

  file:    by_date/etf_daily/2020/2020-05-21.parquet
  size:    75 KB
  rows:    1,984

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-05-21	SPY	ETF	296.79	297.67	293.69	294.88	78293900.0
2020-05-21	QQQ	ETF	231.49	232.135	228.34	228.87	43642908.0
2020-05-21	IWM	ETF	134.05	135.06	132.58	134.24	32716500.0
2020-05-21	DIA	ETF	245.55	247.38	243.88	245.02	3378200.0
2020-05-21	GLD	ETF	163.46	163.58	161.37	162.25	11791000.0
2020-05-21	TLT	ETF	164.86	165.36	164.29	164.56	8920000.0
2020-05-21	AAAU	ETF	17.34	17.35	17.12	17.21	377500.0
2020-05-21	AADR	ETF	47.89	47.89	47.26	47.56	2700.0
2020-05-21	AAXJ	ETF	64.85	64.99	64.18	64.35	793400.0
2020-05-21	ABEQ	ETF	21.98	22.01	21.898	21.94	67700.0
2020-05-21	ACES	ETF	35.54	35.54	34.64	35.02	41600.0
2020-05-21	ACIO	ETF	24.23	24.23	24.176	24.203	7800.0
2020-05-21	ACSI	ETF	31.52	31.53	31.3773	31.3773	1634.0
2020-05-21	ACTX	ETF	5.133	5.369	4.13	4.2185	1419.0
2020-05-21	ACWF	ETF	26.76	26.76	26.65	26.7401	11203.0
2020-05-21	ACWI	ETF	70.28	70.54	69.6	69.87	6890400.0
2020-05-21	ACWV	ETF	86.71	86.71	85.84	86.11	248700.0
2020-05-21	ACWX	ETF	40.74	40.88	40.325	40.51	2155878.0
2020-05-21	ADME	ETF	31.265	31.27	31.181	31.181	15200.0
2020-05-21	ADRE	ETF	36.49	36.6184	36.2001	36.295	5055.0
2020-05-21	AESR	ETF	9.435	9.435	9.435	9.435	100.0
2020-05-21	AFIF	ETF	9.8	9.86	9.79	9.8316	18107.0
2020-05-21	AFK	ETF	15.45	15.45	15.3	15.3	2167.0
2020-05-21	AFLG	ETF	18.017	18.017	18.017	18.017	100.0
2020-05-21	AFSM	ETF	15.899	15.899	15.899	15.899	100.0
2020-05-21	AFTY	ETF	15.835	15.93	15.793	15.828	6500.0
2020-05-21	AGG	ETF	117.35	117.48	117.32	117.38	5143700.0
2020-05-21	AGGY	ETF	53.39	53.41	53.32	53.36	454200.0
2020-05-21	AGNG	ETF	23.509	23.62	23.44	23.475	7600.0
2020-05-21	AGQ	ETF	27.98	28.03	26.14	26.68	558400.0
2020-05-21	AGZ	ETF	121.06	121.08	120.81	121.03	30297.0
2020-05-21	AGZD	ETF	23.3	23.34	23.27	23.29	11000.0
2020-05-21	AIA	ETF	59.99	59.99	59.18	59.4	182312.0
2020-05-21	AIEQ	ETF	27.05	27.15	26.8	26.88	10300.0
2020-05-21	AIQ	ETF	19.29	19.34	19.0	19.097	23715.0
2020-05-21	AIRR	ETF	22.07	22.11	21.8	21.96	6400.0
2020-05-21	AIVI	ETF	33.82	33.82	33.41	33.47	3100.0
2020-05-21	ALTY	ETF	10.35	10.43	10.301	10.394	7800.0
2020-05-21	AMJ	ETF	14.5	14.73	14.19	14.52	1553445.0
2020-05-21	AMLP	ETF	26.36	26.76	25.76	26.36	4405200.0
2020-05-21	AMOM	ETF	27.92	27.92	27.777	27.777	1300.0
2020-05-21	AMUB	ETF	9.47	9.47	8.98	9.1518	8435.0
2020-05-21	AMZA	ETF	19.95	20.025	19.15	19.62	79500.0
2020-05-21	ANGL	ETF	27.5	27.55	27.36	27.4	928700.0
2020-05-21	AOA	ETF	52.31	52.42	51.85	51.93	50100.0
2020-05-21	AOK	ETF	35.52	35.64	35.36	35.46	103207.0
2020-05-21	AOM	ETF	38.73	38.74	38.515	38.57	166318.0
2020-05-21	AOR	ETF	44.61	44.68	44.26	44.36	107672.0
2020-05-21	ARB	ETF	24.26	24.3	24.2	24.2235	4857.0
2020-05-21	ARGT	ETF	21.63	21.9	21.48	21.83	14400.0

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

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