PREVIEW / etf_daily / 2021-01-11

all etf daily files

  file:    by_date/etf_daily/2021/2021-01-11.parquet
  size:    84 KB
  rows:    2,229

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-01-11	SPY	ETF	377.85	380.58	377.72	378.69	51034700.0
2021-01-11	QQQ	ETF	315.98	317.19	313.75	314.42	32869095.0
2021-01-11	IWM	ETF	205.09	208.12	204.83	207.54	20945100.0
2021-01-11	DIA	ETF	308.49	311.0	308.42	310.17	2811400.0
2021-01-11	GLD	ETF	172.14	173.68	172.03	173.0	8571400.0
2021-01-11	TLT	ETF	151.0	151.21	150.49	151.07	8370700.0
2021-01-11	AAA	ETF	25.07	25.1	25.07	25.085	2079.0
2021-01-11	AAAU	ETF	18.27	18.44	18.27	18.38	441700.0
2021-01-11	AADR	ETF	62.17	63.0	62.17	62.8	14700.0
2021-01-11	AAXJ	ETF	94.22	94.4	93.89	94.02	2402700.0
2021-01-11	ABEQ	ETF	25.878	25.95	25.878	25.925	1500.0
2021-01-11	ACES	ETF	91.61	94.329	91.06	93.59	233400.0
2021-01-11	ACIO	ETF	28.08	28.08	27.87	27.87	29000.0
2021-01-11	ACSI	ETF	43.7988	43.7988	43.7988	43.7988	321.0
2021-01-11	ACTV	ETF	32.76	32.87	32.7102	32.7946	4069.0
2021-01-11	ACTX	ETF	2.7	3.05	2.63	2.65	1259.0
2021-01-11	ACVF	ETF	28.49	28.49	28.01	28.066	8300.0
2021-01-11	ACWF	ETF	34.82	34.93	34.815	34.9102	5192.0
2021-01-11	ACWI	ETF	92.37	93.03	92.32	92.62	3317200.0
2021-01-11	ACWV	ETF	97.32	97.85	97.32	97.57	303100.0
2021-01-11	ACWX	ETF	54.5	54.82	54.45	54.64	1604240.0
2021-01-11	ADFI	ETF	9.867	9.867	9.867	9.867	100.0
2021-01-11	ADME	ETF	36.44	36.44	36.21	36.26	61900.0
2021-01-11	ADRE	ETF	59.18	59.52	58.885	59.0987	23936.0
2021-01-11	AESR	ETF	12.059	12.06	12.011	12.011	4300.0
2021-01-11	AFIF	ETF	9.74	9.76	9.73	9.73	26573.0
2021-01-11	AFK	ETF	20.75	20.93	20.63	20.72	20521.0
2021-01-11	AFLG	ETF	22.785	22.82	22.758	22.758	3000.0
2021-01-11	AFMC	ETF	22.452	22.452	22.452	22.452	100.0
2021-01-11	AFSM	ETF	23.457	23.457	23.457	23.457	200.0
2021-01-11	AFTY	ETF	23.97	24.011	23.965	24.011	1500.0
2021-01-11	AGG	ETF	117.02	117.05	116.89	116.89	8610100.0
2021-01-11	AGGY	ETF	52.98	53.06	52.98	53.0	300500.0
2021-01-11	AGNG	ETF	28.58	28.8	28.51	28.69	12600.0
2021-01-11	AGQ	ETF	43.88	46.07	43.82	44.93	1765700.0
2021-01-11	AGZ	ETF	119.12	119.19	119.11	119.12	31162.0
2021-01-11	AGZD	ETF	23.57	23.61	23.515	23.61	6200.0
2021-01-11	AIA	ETF	93.15	93.59	92.94	93.36	394719.0
2021-01-11	AIEQ	ETF	37.58	37.957	37.15	37.66	59900.0
2021-01-11	AIQ	ETF	27.58	27.8707	27.4601	27.65	31604.0
2021-01-11	AIRR	ETF	36.04	36.499	36.029	36.499	51500.0
2021-01-11	AIVI	ETF	41.42	41.77	41.42	41.68	2400.0
2021-01-11	ALTL	ETF	33.7599	33.8811	33.68	33.8811	12018.0
2021-01-11	ALTY	ETF	11.84	11.84	11.76	11.79	14700.0
2021-01-11	AMJ	ETF	14.81	15.2199	14.81	15.09	793494.0
2021-01-11	AMLP	ETF	27.45	28.16	27.16	28.01	2537100.0
2021-01-11	AMNA	ETF	27.2293	27.2293	27.2293	27.2293	1.0
2021-01-11	AMND	ETF	28.9839	28.9839	28.9839	28.9839	1.0
2021-01-11	AMOM	ETF	32.51	32.99	32.51	32.694	2200.0
2021-01-11	AMTR	ETF	30.7437	30.7437	30.7437	30.7437	10.0

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

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