PREVIEW / etf_daily / 2020-05-20

all etf daily files

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

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-20	SPY	ETF	295.82	297.87	295.57	296.93	85861700.0
2020-05-20	QQQ	ETF	229.48	231.76	229.48	231.39	37417000.0
2020-05-20	IWM	ETF	132.73	134.98	132.38	134.0	35901300.0
2020-05-20	DIA	ETF	245.4	246.58	244.73	245.73	3280600.0
2020-05-20	GLD	ETF	164.54	164.96	163.89	164.65	10666100.0
2020-05-20	TLT	ETF	163.17	164.7	162.88	164.15	10927300.0
2020-05-20	AAAU	ETF	17.45	17.53	17.39	17.51	377400.0
2020-05-20	AADR	ETF	48.2	48.69	48.09	48.27	4400.0
2020-05-20	AAXJ	ETF	65.84	66.07	65.25	65.61	1159000.0
2020-05-20	ABEQ	ETF	22.125	22.29	22.05	22.08	26900.0
2020-05-20	ACES	ETF	36.82	36.82	35.25	35.4	22700.0
2020-05-20	ACIO	ETF	24.35	24.36	24.256	24.32	12300.0
2020-05-20	ACSI	ETF	31.4326	31.4326	31.4326	31.4326	284.0
2020-05-20	ACTX	ETF	4.7832	5.1006	4.13	4.6905	518.0
2020-05-20	ACWF	ETF	26.79	26.9661	26.79	26.85	4079.0
2020-05-20	ACWI	ETF	70.32	70.76	70.23	70.49	5505300.0
2020-05-20	ACWV	ETF	87.17	87.26	86.68	86.79	221900.0
2020-05-20	ACWX	ETF	40.98	41.16	40.79	40.92	1617091.0
2020-05-20	ADME	ETF	31.37	31.445	31.3	31.361	7000.0
2020-05-20	ADRE	ETF	36.92	37.0399	36.405	36.7079	5812.0
2020-05-20	AESR	ETF	9.53	9.54	9.47	9.508	10000.0
2020-05-20	AFIF	ETF	9.79	9.8429	9.79	9.82	34330.0
2020-05-20	AFK	ETF	15.25	15.4599	15.25	15.35	6806.0
2020-05-20	AFMC	ETF	16.222	16.222	16.222	16.222	100.0
2020-05-20	AFSM	ETF	15.851	15.851	15.851	15.851	100.0
2020-05-20	AFTY	ETF	16.055	16.118	16.01	16.055	13500.0
2020-05-20	AGG	ETF	117.03	117.34	117.0	117.29	4579200.0
2020-05-20	AGGY	ETF	53.1	53.31	53.09	53.3	137800.0
2020-05-20	AGNG	ETF	23.83	23.91	23.71	23.734	900.0
2020-05-20	AGQ	ETF	28.32	28.98	28.13	28.64	459200.0
2020-05-20	AGZ	ETF	120.93	121.05	120.73	120.96	52376.0
2020-05-20	AGZD	ETF	23.195	23.305	23.18	23.225	14200.0
2020-05-20	AIA	ETF	60.77	61.05	60.44	60.6	22315.0
2020-05-20	AIEQ	ETF	27.06	27.23	27.0	27.159	12300.0
2020-05-20	AIQ	ETF	19.06	19.315	19.06	19.2174	12938.0
2020-05-20	AIRR	ETF	21.78	22.075	21.718	21.88	6800.0
2020-05-20	AIVI	ETF	33.75	33.99	33.72	33.8	7800.0
2020-05-20	ALTY	ETF	10.34	10.348	10.26	10.32	7800.0
2020-05-20	AMJ	ETF	14.35	14.9	14.26	14.52	2583663.0
2020-05-20	AMLP	ETF	26.24	27.15	25.85	26.36	7750300.0
2020-05-20	AMOM	ETF	27.923	27.923	27.923	27.923	100.0
2020-05-20	AMUB	ETF	9.09	9.13	9.07	9.1288	3430.0
2020-05-20	AMZA	ETF	19.45	20.24	19.32	19.79	137600.0
2020-05-20	ANGL	ETF	27.26	27.52	27.21	27.51	1327800.0
2020-05-20	AOA	ETF	52.08	52.46	52.08	52.37	41000.0
2020-05-20	AOK	ETF	35.4	35.52	35.35	35.45	122691.0
2020-05-20	AOM	ETF	38.58	38.75	38.58	38.73	281905.0
2020-05-20	AOR	ETF	44.44	44.6599	44.4096	44.63	94414.0
2020-05-20	ARB	ETF	24.3	24.34	24.3	24.3	1707.0
2020-05-20	ARCM	ETF	102.12	102.12	100.19	100.62	1100.0

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

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