PREVIEW / etf_daily / 2021-03-01

all etf daily files

  file:    by_date/etf_daily/2021/2021-03-01.parquet
  size:    86 KB
  rows:    2,280

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-03-01	SPY	ETF	385.59	390.92	380.57	389.58	105348800.0
2021-03-01	QQQ	ETF	319.27	323.94	317.935	323.59	49164518.0
2021-03-01	IWM	ETF	223.48	226.71	222.94	226.07	26161000.0
2021-03-01	DIA	ETF	313.48	316.92	313.45	315.59	4749700.0
2021-03-01	GLD	ETF	163.03	163.35	161.16	161.53	13828300.0
2021-03-01	TLT	ETF	140.66	141.41	140.09	141.06	22048000.0
2021-03-01	AAA	ETF	25.05	25.0532	25.041	25.05	785.0
2021-03-01	AAAU	ETF	17.3	17.35	17.12	17.16	505500.0
2021-03-01	AADR	ETF	63.4	64.45	63.4	64.3	3400.0
2021-03-01	AAXJ	ETF	96.56	97.47	96.3	97.34	582300.0
2021-03-01	ABEQ	ETF	25.59	25.84	25.571	25.66	37500.0
2021-03-01	ACES	ETF	84.0	85.11	83.0	85.11	260700.0
2021-03-01	ACIO	ETF	27.47	27.89	27.47	27.83	17700.0
2021-03-01	ACSI	ETF	45.82	45.82	45.7183	45.7183	2189.0
2021-03-01	ACTV	ETF	35.2359	35.44	35.1768	35.2672	5764.0
2021-03-01	ACVF	ETF	28.69	29.105	28.69	29.01	1800.0
2021-03-01	ACWF	ETF	35.32	35.86	35.32	35.73	24580.0
2021-03-01	ACWI	ETF	93.84	94.93	93.83	94.64	2072400.0
2021-03-01	ACWV	ETF	94.73	95.68	94.73	95.32	304500.0
2021-03-01	ACWX	ETF	55.12	55.57	55.11	55.47	1469661.0
2021-03-01	ADFI	ETF	9.72	9.73	9.71	9.71	204200.0
2021-03-01	ADME	ETF	36.26	36.4	36.2	36.33	13600.0
2021-03-01	ADRE	ETF	61.14	61.42	60.87	61.24	44538.0
2021-03-01	AESR	ETF	12.31	12.42	12.31	12.365	1428900.0
2021-03-01	AFIF	ETF	9.77	9.77	9.67	9.705	23814.0
2021-03-01	AFK	ETF	21.51	21.59	21.13	21.41	15379.0
2021-03-01	AFLG	ETF	23.17	23.47	23.17	23.374	900.0
2021-03-01	AFMC	ETF	24.02	24.02	23.917	23.917	1300.0
2021-03-01	AFSM	ETF	25.431	25.431	25.431	25.431	100.0
2021-03-01	AFTY	ETF	24.312	24.5	24.312	24.445	4300.0
2021-03-01	AGG	ETF	114.97	115.59	114.89	115.09	13018100.0
2021-03-01	AGGY	ETF	52.01	52.05	51.973	52.05	87700.0
2021-03-01	AGNG	ETF	28.1	28.32	28.07	28.112	16900.0
2021-03-01	AGQ	ETF	50.2	50.63	48.61	48.85	1513000.0
2021-03-01	AGZ	ETF	118.29	118.38	118.24	118.38	48654.0
2021-03-01	AGZD	ETF	23.7	23.73	23.635	23.675	382400.0
2021-03-01	AIA	ETF	96.58	97.6	96.314	97.47	213923.0
2021-03-01	AIEQ	ETF	39.16	40.0	39.08	40.0	35700.0
2021-03-01	AIQ	ETF	29.05	29.5	28.9655	29.5	43936.0
2021-03-01	AIRR	ETF	38.98	39.988	38.98	39.7	32700.0
2021-03-01	AIVI	ETF	41.82	42.12	41.82	42.09	7100.0
2021-03-01	ALTL	ETF	38.47	38.6431	38.4654	38.4654	1971.0
2021-03-01	ALTY	ETF	12.4	12.49	12.39	12.41	8800.0
2021-03-01	AMJ	ETF	15.65	16.38	15.65	16.38	967028.0
2021-03-01	AMLP	ETF	28.94	30.19	28.94	29.95	4221200.0
2021-03-01	AMNA	ETF	28.6988	28.6988	28.6988	28.6988	0.0
2021-03-01	AMND	ETF	30.75	30.76	30.5888	30.5888	6876.0
2021-03-01	AMOM	ETF	32.63	33.043	32.63	33.043	1000.0
2021-03-01	AMPS	ETF	10.21	10.4	10.13	10.13	85075.0
2021-03-01	AMTR	ETF	33.0038	33.0038	33.0038	33.0038	30.0

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

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