PREVIEW / etf_daily / 2021-02-25

all etf daily files

  file:    by_date/etf_daily/2021/2021-02-25.parquet
  size:    86 KB
  rows:    2,266

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-25	SPY	ETF	390.41	391.88	380.78	382.33	146670500.0
2021-02-25	QQQ	ETF	321.39	324.03	311.24	312.83	110182582.0
2021-02-25	IWM	ETF	226.79	227.59	218.01	218.61	49961400.0
2021-02-25	DIA	ETF	319.71	319.92	312.96	313.98	7648600.0
2021-02-25	GLD	ETF	166.92	167.66	165.45	165.82	16359400.0
2021-02-25	TLT	ETF	139.52	139.92	136.61	138.54	52621700.0
2021-02-25	AAA	ETF	25.07	25.08	25.07	25.075	533.0
2021-02-25	AAAU	ETF	17.73	17.81	17.57	17.62	1380100.0
2021-02-25	AADR	ETF	64.25	64.25	63.19	63.2	20000.0
2021-02-25	AAXJ	ETF	98.1	98.16	95.79	95.98	908400.0
2021-02-25	ABEQ	ETF	26.0	26.0	25.6	25.65	5300.0
2021-02-25	ACES	ETF	84.98	84.98	79.64	80.08	169100.0
2021-02-25	ACIO	ETF	27.746	27.746	27.46	27.49	14300.0
2021-02-25	ACSI	ETF	44.5912	44.5912	44.5912	44.5912	194.0
2021-02-25	ACTV	ETF	35.1	35.105	34.5926	34.5926	3733.0
2021-02-25	ACTX	ETF	5.25	6.5	5.25	5.25	5749.0
2021-02-25	ACVF	ETF	29.2	29.2	28.45	28.535	3600.0
2021-02-25	ACWF	ETF	35.91	35.91	35.1065	35.1065	8234.0
2021-02-25	ACWI	ETF	95.32	95.63	93.05	93.34	3548400.0
2021-02-25	ACWV	ETF	95.97	96.48	94.94	95.12	1562500.0
2021-02-25	ACWX	ETF	56.27	56.39	55.02	55.13	1600413.0
2021-02-25	ADFI	ETF	9.668	9.668	9.668	9.668	600.0
2021-02-25	ADME	ETF	36.74	36.74	35.77	35.83	10400.0
2021-02-25	ADRE	ETF	62.64	62.765	60.26	60.43	18643.0
2021-02-25	AESR	ETF	12.38	12.38	12.07	12.1	3600.0
2021-02-25	AFIF	ETF	9.68	9.69	9.63	9.65	15681.0
2021-02-25	AFK	ETF	22.14	22.14	21.21	21.21	26885.0
2021-02-25	AFLG	ETF	23.06	23.1	22.91	22.91	3000.0
2021-02-25	AFMC	ETF	23.215	23.215	23.215	23.215	100.0
2021-02-25	AFSM	ETF	24.66	24.726	24.66	24.726	300.0
2021-02-25	AFTY	ETF	24.76	24.775	24.38	24.38	6500.0
2021-02-25	AGG	ETF	115.01	115.29	114.2	114.41	14926900.0
2021-02-25	AGGY	ETF	51.92	51.929	51.5	51.595	169800.0
2021-02-25	AGNG	ETF	28.46	28.54	27.95	28.03	112400.0
2021-02-25	AGQ	ETF	53.89	54.82	52.1	52.11	2143200.0
2021-02-25	AGZ	ETF	118.46	118.4755	118.0	118.19	31220.0
2021-02-25	AGZD	ETF	23.595	23.74	23.57	23.67	50600.0
2021-02-25	AIA	ETF	97.96	98.169	95.58	95.8	215028.0
2021-02-25	AIEQ	ETF	39.88	40.12	38.01	38.14	41000.0
2021-02-25	AIQ	ETF	29.54	29.7	28.565	28.65	105487.0
2021-02-25	AIRR	ETF	40.03	40.03	38.7	38.865	40300.0
2021-02-25	AIVI	ETF	43.0	43.0	42.16	42.3	29000.0
2021-02-25	ALTL	ETF	39.12	39.12	37.7414	37.7414	12685.0
2021-02-25	ALTY	ETF	12.5	12.579	12.32	12.325	20300.0
2021-02-25	AMJ	ETF	16.67	16.73	15.99	16.12	1306700.0
2021-02-25	AMLP	ETF	30.0	30.23	28.85	29.26	3284500.0
2021-02-25	AMNA	ETF	28.6216	28.6216	28.6216	28.6216	0.0
2021-02-25	AMND	ETF	30.3017	30.3017	30.3017	30.3017	0.0
2021-02-25	AMOM	ETF	33.32	33.32	32.036	32.036	3200.0
2021-02-25	AMPS	ETF	10.58	10.65	10.46	10.51	55869.0

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

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