PREVIEW / etf_daily / 2021-02-04

all etf daily files

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

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-04	SPY	ETF	382.96	386.24	381.97	386.19	47142600.0
2021-02-04	QQQ	ETF	327.82	330.33	326.46	330.24	22350947.0
2021-02-04	IWM	ETF	215.09	218.83	215.08	218.62	25400800.0
2021-02-04	DIA	ETF	307.85	310.67	307.77	310.67	2638800.0
2021-02-04	GLD	ETF	168.29	168.4	167.34	168.15	13736600.0
2021-02-04	TLT	ETF	149.16	149.49	148.8	149.28	8262600.0
2021-02-04	AAA	ETF	24.84	25.15	24.84	25.13	10172.0
2021-02-04	AAAU	ETF	17.86	17.88	17.78	17.85	845700.0
2021-02-04	AADR	ETF	63.08	63.72	63.08	63.67	6100.0
2021-02-04	AAXJ	ETF	97.8	98.0	97.23	98.0	637300.0
2021-02-04	ABEQ	ETF	25.689	25.84	25.689	25.84	1200.0
2021-02-04	ACES	ETF	96.69	97.27	95.667	96.76	118400.0
2021-02-04	ACIO	ETF	27.53	27.82	27.53	27.82	23600.0
2021-02-04	ACSI	ETF	44.66	44.66	44.63	44.6593	5202.0
2021-02-04	ACTV	ETF	34.3396	34.3461	34.25	34.3461	3631.0
2021-02-04	ACTX	ETF	4.25	4.3	4.25	4.3	719.0
2021-02-04	ACVF	ETF	28.52	28.54	28.46	28.53	4500.0
2021-02-04	ACWF	ETF	34.83	34.96	34.695	34.9209	57326.0
2021-02-04	ACWI	ETF	93.47	94.0	93.33	93.95	2253100.0
2021-02-04	ACWV	ETF	96.2	96.8	96.2	96.8	185000.0
2021-02-04	ACWX	ETF	54.8	54.95	54.67	54.94	967285.0
2021-02-04	ADFI	ETF	9.853	9.853	9.853	9.853	100.0
2021-02-04	ADME	ETF	36.35	36.48	36.21	36.48	61600.0
2021-02-04	ADRE	ETF	62.7	62.7	62.255	62.66	15000.0
2021-02-04	AESR	ETF	12.17	12.23	12.17	12.225	1900.0
2021-02-04	AFIF	ETF	9.74	9.7573	9.74	9.74	17582.0
2021-02-04	AFK	ETF	21.14	21.18	21.0038	21.0664	8268.0
2021-02-04	AFLG	ETF	23.05	23.054	23.05	23.054	1400.0
2021-02-04	AFMC	ETF	22.84	22.84	22.8	22.8	900.0
2021-02-04	AFSM	ETF	24.68	24.68	24.646	24.646	500.0
2021-02-04	AFTY	ETF	24.77	24.903	24.77	24.903	1000.0
2021-02-04	AGG	ETF	116.75	116.89	116.69	116.86	5287400.0
2021-02-04	AGGY	ETF	53.02	53.16	53.005	53.12	408300.0
2021-02-04	AGNG	ETF	28.819	29.083	28.819	29.04	2100.0
2021-02-04	AGQ	ETF	48.2	48.82	46.99	48.6	2147600.0
2021-02-04	AGZ	ETF	119.17	119.32	119.17	119.32	22777.0
2021-02-04	AGZD	ETF	23.685	23.695	23.59	23.64	38600.0
2021-02-04	AIA	ETF	97.86	98.08	97.15	97.88	237760.0
2021-02-04	AIEQ	ETF	39.95	40.2	39.75	40.05	60000.0
2021-02-04	AIQ	ETF	29.08	29.27	29.005	29.26	82612.0
2021-02-04	AIRR	ETF	36.34	36.78	36.34	36.748	24500.0
2021-02-04	AIVI	ETF	41.3	41.45	41.25	41.44	5700.0
2021-02-04	ALTL	ETF	34.1	34.27	34.1	34.26	29918.0
2021-02-04	ALTY	ETF	12.1	12.13	12.05	12.11	18700.0
2021-02-04	AMJ	ETF	15.12	15.27	15.05	15.19	644545.0
2021-02-04	AMLP	ETF	28.03	28.22	27.81	27.97	2300500.0
2021-02-04	AMNA	ETF	26.9421	26.9421	26.9421	26.9421	2.0
2021-02-04	AMND	ETF	28.6222	28.6222	28.6222	28.6222	0.0
2021-02-04	AMOM	ETF	33.115	33.259	33.115	33.259	1500.0
2021-02-04	AMPS	ETF	10.56	10.675	10.33	10.34	31010.0

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

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