PREVIEW / etf_daily / 2020-12-04

all etf daily files

  file:    by_date/etf_daily/2020/2020-12-04.parquet
  size:    82 KB
  rows:    2,164

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
2020-12-04	SPY	ETF	367.32	369.85	367.22	369.85	50749900.0
2020-12-04	QQQ	ETF	304.33	305.67	303.63	305.52	19332081.0
2020-12-04	IWM	ETF	185.02	188.45	183.92	188.2	24415700.0
2020-12-04	DIA	ETF	300.74	302.59	300.6	302.59	2747300.0
2020-12-04	GLD	ETF	172.78	173.32	171.59	172.32	10098600.0
2020-12-04	TLT	ETF	155.69	155.79	154.77	155.2	12734500.0
2020-12-04	AAA	ETF	25.05	25.05	25.0487	25.05	905.0
2020-12-04	AAAU	ETF	18.34	18.39	18.22	18.3	379800.0
2020-12-04	AADR	ETF	58.47	58.69	58.47	58.67	8000.0
2020-12-04	AAXJ	ETF	87.8	88.06	87.68	88.06	975600.0
2020-12-04	ABEQ	ETF	25.315	25.37	25.315	25.364	300.0
2020-12-04	ACES	ETF	68.54	69.08	68.36	68.8	105700.0
2020-12-04	ACIO	ETF	27.68	27.68	27.48	27.58	22700.0
2020-12-04	ACSI	ETF	42.9112	42.9112	42.9112	42.9112	128.0
2020-12-04	ACTV	ETF	30.14	30.5454	30.1302	30.5454	2669.0
2020-12-04	ACTX	ETF	2.8	3.0	2.8	2.8	832.0
2020-12-04	ACVF	ETF	27.5	27.5	27.403	27.434	1700.0
2020-12-04	ACWF	ETF	33.0	33.139	32.9751	33.0921	7535.0
2020-12-04	ACWI	ETF	89.29	89.69	89.23	89.68	1982500.0
2020-12-04	ACWV	ETF	96.13	96.3	96.0	96.21	154000.0
2020-12-04	ACWX	ETF	52.37	52.53	52.37	52.52	1757975.0
2020-12-04	ADME	ETF	35.39	35.4	35.13	35.37	16800.0
2020-12-04	ADRE	ETF	54.9	55.1399	54.6601	55.0325	15660.0
2020-12-04	AESR	ETF	11.793	11.805	11.79	11.805	1600.0
2020-12-04	AFIF	ETF	9.7848	9.795	9.7655	9.771	6439.0
2020-12-04	AFK	ETF	20.49	20.715	20.49	20.64	31222.0
2020-12-04	AFLG	ETF	21.917	21.924	21.917	21.924	1300.0
2020-12-04	AFMC	ETF	20.75	20.75	20.75	20.75	100.0
2020-12-04	AFSM	ETF	21.048	21.048	21.048	21.048	100.0
2020-12-04	AFTY	ETF	22.51	22.52	22.426	22.52	9000.0
2020-12-04	AGG	ETF	117.9	117.9	117.51	117.59	5896100.0
2020-12-04	AGGY	ETF	53.61	53.7	53.61	53.67	109800.0
2020-12-04	AGNG	ETF	27.08	27.36	27.08	27.36	8000.0
2020-12-04	AGQ	ETF	43.04	43.73	42.42	43.22	917800.0
2020-12-04	AGZ	ETF	119.29	119.385	119.29	119.34	68945.0
2020-12-04	AGZD	ETF	23.65	23.655	23.555	23.645	25800.0
2020-12-04	AIA	ETF	84.85	85.4	84.85	85.37	410626.0
2020-12-04	AIEQ	ETF	34.28	34.66	34.28	34.6	12200.0
2020-12-04	AIQ	ETF	26.38	26.66	26.38	26.64	57867.0
2020-12-04	AIRR	ETF	32.08	32.759	32.08	32.759	6000.0
2020-12-04	AIVI	ETF	40.05	40.21	40.05	40.11	4500.0
2020-12-04	ALTL	ETF	32.07	32.5	32.07	32.5	5129.0
2020-12-04	ALTY	ETF	11.69	11.8	11.69	11.8	15200.0
2020-12-04	AMJ	ETF	14.96	15.45	14.935	15.29	1804847.0
2020-12-04	AMLP	ETF	27.65	28.7	27.58	28.34	5294400.0
2020-12-04	AMNA	ETF	27.14	27.17	27.14	27.17	250.0
2020-12-04	AMND	ETF	29.1342	29.1342	29.1342	29.1342	0.0
2020-12-04	AMOM	ETF	38.486	38.53	38.47	38.53	1200.0
2020-12-04	AMTR	ETF	30.76	30.76	30.58	30.6642	1304.0
2020-12-04	AMUB	ETF	9.6146	9.6146	9.6146	9.6146	109.0

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

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