PREVIEW / etf_daily / 2021-02-03

all etf daily files

  file:    by_date/etf_daily/2021/2021-02-03.parquet
  size:    85 KB
  rows:    2,242

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-02-03	SPY	ETF	382.44	383.7	380.48	381.85	52427100.0
2021-02-03	QQQ	ETF	329.82	330.195	326.32	326.38	24824518.0
2021-02-03	IWM	ETF	213.7	214.74	211.59	214.25	23923200.0
2021-02-03	DIA	ETF	306.1	307.94	305.18	307.26	2087800.0
2021-02-03	GLD	ETF	172.36	172.59	171.5	171.85	4658100.0
2021-02-03	TLT	ETF	150.43	150.59	149.58	149.68	9633100.0
2021-02-03	AAA	ETF	25.2	25.4	25.12	25.12	1169.0
2021-02-03	AAAU	ETF	18.29	18.32	18.22	18.25	538600.0
2021-02-03	AADR	ETF	63.82	63.89	63.73	63.82	3000.0
2021-02-03	AAXJ	ETF	98.19	98.31	97.65	98.11	1507200.0
2021-02-03	ABEQ	ETF	25.87	25.87	25.5	25.65	4100.0
2021-02-03	ACES	ETF	95.12	96.38	94.239	95.95	139000.0
2021-02-03	ACIO	ETF	27.58	27.68	27.58	27.64	33600.0
2021-02-03	ACSI	ETF	44.2	44.2	44.081	44.081	304.0
2021-02-03	ACTV	ETF	34.1286	34.28	34.1286	34.17	3959.0
2021-02-03	ACTX	ETF	4.55	4.7	4.325	4.55	1726.0
2021-02-03	ACVF	ETF	28.3	28.31	28.215	28.287	3500.0
2021-02-03	ACWF	ETF	34.89	34.89	34.7446	34.75	10134.0
2021-02-03	ACWI	ETF	93.37	93.66	93.01	93.31	2321800.0
2021-02-03	ACWV	ETF	96.72	96.83	96.35	96.48	323900.0
2021-02-03	ACWX	ETF	54.89	54.98	54.68	54.92	1111483.0
2021-02-03	ADFI	ETF	9.861	9.861	9.861	9.861	100.0
2021-02-03	ADME	ETF	36.68	36.68	36.15	36.15	34900.0
2021-02-03	ADRE	ETF	62.49	63.04	62.115	62.23	18996.0
2021-02-03	AESR	ETF	12.093	12.15	12.093	12.117	8700.0
2021-02-03	AFIF	ETF	9.7317	9.76	9.73	9.745	89649.0
2021-02-03	AFK	ETF	20.99	21.34	20.95	21.12	12754.0
2021-02-03	AFLG	ETF	22.867	22.867	22.867	22.867	100.0
2021-02-03	AFMC	ETF	22.533	22.533	22.533	22.533	100.0
2021-02-03	AFSM	ETF	24.22	24.22	24.178	24.178	300.0
2021-02-03	AFTY	ETF	24.81	24.82	24.66	24.82	3500.0
2021-02-03	AGG	ETF	116.97	116.99	116.87	116.91	5492400.0
2021-02-03	AGGY	ETF	53.1	53.15	53.07	53.1	106700.0
2021-02-03	AGNG	ETF	28.88	28.88	28.599	28.746	5600.0
2021-02-03	AGQ	ETF	50.89	51.39	50.05	50.53	1178400.0
2021-02-03	AGZ	ETF	119.27	119.3537	119.23	119.31	30879.0
2021-02-03	AGZD	ETF	23.58	23.695	23.58	23.67	20600.0
2021-02-03	AIA	ETF	98.62	98.62	97.93	98.31	194691.0
2021-02-03	AIEQ	ETF	39.83	39.96	39.44	39.81	44100.0
2021-02-03	AIQ	ETF	29.2	29.22	29.005	29.13	112300.0
2021-02-03	AIRR	ETF	36.36	36.36	35.69	36.122	41500.0
2021-02-03	AIVI	ETF	41.33	41.44	41.33	41.36	35100.0
2021-02-03	ALTL	ETF	33.1793	33.5796	33.1793	33.5516	31719.0
2021-02-03	ALTY	ETF	12.05	12.05	11.97	12.05	16800.0
2021-02-03	AMJ	ETF	15.08	15.145	14.87	15.08	959504.0
2021-02-03	AMLP	ETF	27.51	27.99	27.45	27.85	2484300.0
2021-02-03	AMNA	ETF	26.8982	26.8982	26.8982	26.8982	3.0
2021-02-03	AMND	ETF	28.5587	28.5587	28.5587	28.5587	0.0
2021-02-03	AMOM	ETF	32.93	32.95	32.9	32.933	2300.0
2021-02-03	AMPS	ETF	10.35	10.53	10.35	10.41	20665.0

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

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