PREVIEW / etf_daily / 2021-04-27

all etf daily files

  file:    by_date/etf_daily/2021/2021-04-27.parquet
  size:    88 KB
  rows:    2,325

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
2021-04-27	SPY	ETF	417.93	418.14	416.3	417.52	51303100.0
2021-04-27	QQQ	ETF	341.93	342.15	339.17	340.15	33187183.0
2021-04-27	IWM	ETF	228.71	229.39	227.51	228.45	19648100.0
2021-04-27	DIA	ETF	339.6	340.43	338.7	339.83	2732700.0
2021-04-27	GLD	ETF	166.92	167.15	166.28	166.42	5363500.0
2021-04-27	TLT	ETF	139.59	139.82	138.53	138.64	14137300.0
2021-04-27	AAA	ETF	25.0352	25.04	25.035	25.035	1416.0
2021-04-27	AAAU	ETF	17.74	17.76	17.67	17.69	239500.0
2021-04-27	AADR	ETF	66.5	66.71	66.47	66.54	6900.0
2021-04-27	AAXJ	ETF	94.78	95.01	94.67	94.85	515800.0
2021-04-27	ABEQ	ETF	27.314	27.37	27.314	27.345	1800.0
2021-04-27	ACES	ETF	77.37	77.45	76.49	76.79	58000.0
2021-04-27	ACIO	ETF	29.645	29.69	29.61	29.69	8700.0
2021-04-27	ACSI	ETF	48.7473	48.7473	48.7473	48.7473	187.0
2021-04-27	ACTV	ETF	37.18	37.3097	37.1592	37.3097	5137.0
2021-04-27	ACVF	ETF	31.05	31.107	31.0	31.107	1400.0
2021-04-27	ACWF	ETF	37.99	38.12	37.99	38.08	6659.0
2021-04-27	ACWI	ETF	99.72	99.79	99.46	99.72	3614200.0
2021-04-27	ACWV	ETF	101.84	102.26	101.38	101.53	586800.0
2021-04-27	ACWX	ETF	57.08	57.18	57.0	57.12	467280.0
2021-04-27	ADFI	ETF	9.68	9.71	9.68	9.685	3400.0
2021-04-27	ADIV	ETF	19.0	19.021	18.98	19.021	1900.0
2021-04-27	ADME	ETF	38.79	38.87	38.75	38.85	7200.0
2021-04-27	ADRE	ETF	58.05	58.25	58.0	58.12	80632.0
2021-04-27	AESR	ETF	13.241	13.28	13.24	13.26	8300.0
2021-04-27	AFIF	ETF	9.715	9.72	9.65	9.71	200195.0
2021-04-27	AFK	ETF	22.14	22.14	21.97	22.02	8704.0
2021-04-27	AFLG	ETF	25.05	25.058	25.05	25.058	300.0
2021-04-27	AFMC	ETF	25.569	25.569	25.569	25.569	1000.0
2021-04-27	AFSM	ETF	26.317	26.317	26.317	26.317	100.0
2021-04-27	AFTY	ETF	22.7	22.7	22.665	22.672	800.0
2021-04-27	AGG	ETF	115.13	115.13	114.37	114.37	3823300.0
2021-04-27	AGGY	ETF	51.79	51.794	51.58	51.61	139300.0
2021-04-27	AGNG	ETF	29.255	29.33	29.211	29.287	15000.0
2021-04-27	AGQ	ETF	47.78	48.0	47.27	47.39	796300.0
2021-04-27	AGZ	ETF	118.24	118.24	118.0	118.02	1618692.0
2021-04-27	AGZD	ETF	23.565	23.585	23.485	23.535	286200.0
2021-04-27	AIA	ETF	94.19	94.33	93.83	93.98	1913518.0
2021-04-27	AIEQ	ETF	40.23	40.23	39.95	40.085	20500.0
2021-04-27	AIQ	ETF	29.94	29.94	29.762	29.85	163679.0
2021-04-27	AIRR	ETF	41.98	42.186	41.7	41.93	67900.0
2021-04-27	AIVI	ETF	43.41	43.53	43.4	43.53	5300.0
2021-04-27	ALTL	ETF	40.3942	40.69	40.23	40.5255	9048.0
2021-04-27	ALTY	ETF	13.32	13.33	13.2	13.25	31400.0
2021-04-27	AMJ	ETF	17.52	17.6	17.38	17.58	387929.0
2021-04-27	AMLP	ETF	32.5	32.58	32.13	32.35	1693500.0
2021-04-27	AMNA	ETF	30.5992	30.5992	30.5992	30.5992	0.0
2021-04-27	AMND	ETF	32.58	32.6081	32.47	32.6081	815.0
2021-04-27	AMOM	ETF	35.72	35.75	35.17	35.69	18100.0
2021-04-27	AMPS	ETF	9.92	9.97	9.92	9.97	6688.0

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

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