PREVIEW / etf_daily / 2021-12-07

all etf daily files

  file:    by_date/etf_daily/2021/2021-12-07.parquet
  size:    97 KB
  rows:    2,590

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-12-07	SPY	ETF	464.41	468.88	458.65	468.28	95484700.0
2021-12-07	QQQ	ETF	393.03	398.46	392.99	397.83	56005264.0
2021-12-07	IWM	ETF	222.14	226.04	221.98	224.1	44679200.0
2021-12-07	DIA	ETF	355.93	358.61	355.79	357.74	5271500.0
2021-12-07	GLD	ETF	166.2	167.08	166.18	166.81	4900700.0
2021-12-07	TLT	ETF	151.72	152.53	150.86	151.0	22115900.0
2021-12-07	AAA	ETF	25.0	25.025	25.0	25.015	367.0
2021-12-07	AAAU	ETF	17.68	17.77	17.68	17.74	160500.0
2021-12-07	AADR	ETF	63.25	63.5	63.09	63.25	6700.0
2021-12-07	AAXJ	ETF	85.0	85.25	84.86	85.2	1420200.0
2021-12-07	ABEQ	ETF	27.7	27.7	27.633	27.633	3200.0
2021-12-07	ACES	ETF	70.08	71.67	70.08	70.69	75800.0
2021-12-07	ACIO	ETF	32.05	32.2	32.05	32.155	46500.0
2021-12-07	ACSI	ETF	52.0589	52.0589	52.0589	52.0589	34.0
2021-12-07	ACT	ETF	21.5	21.55	20.94	21.4	177750.0
2021-12-07	ACTV	ETF	38.65	38.74	38.4911	38.4911	4130.0
2021-12-07	ACTX	ETF	1.245	1.245	1.2	1.2	300.0
2021-12-07	ACVF	ETF	34.88	35.02	34.765	34.933	17600.0
2021-12-07	ACWF	ETF	38.46	38.79	38.46	38.71	22286.0
2021-12-07	ACWI	ETF	104.69	105.64	104.69	105.6	6047800.0
2021-12-07	ACWV	ETF	105.95	106.23	105.77	106.2	177000.0
2021-12-07	ACWX	ETF	55.89	56.305	55.89	56.305	2693802.0
2021-12-07	ADFI	ETF	9.66	9.66	9.64	9.64	1400.0
2021-12-07	ADIV	ETF	16.07	16.16	16.07	16.115	1200.0
2021-12-07	ADME	ETF	42.47	42.67	42.37	42.59	69600.0
2021-12-07	ADRE	ETF	47.34	47.5511	47.2123	47.46	8974.0
2021-12-07	AEMB	ETF	48.565	48.565	48.565	48.565	100.0
2021-12-07	AESR	ETF	14.65	14.77	14.65	14.74	8900.0
2021-12-07	AFIF	ETF	9.57	9.585	9.57	9.57	17173.0
2021-12-07	AFK	ETF	20.53	20.53	20.3599	20.4744	27871.0
2021-12-07	AFLG	ETF	27.599	27.599	27.52	27.529	1500.0
2021-12-07	AFMC	ETF	26.36	26.36	26.297	26.297	300.0
2021-12-07	AFTY	ETF	21.39	21.44	21.39	21.433	1000.0
2021-12-07	AGG	ETF	114.52	114.71	114.45	114.49	6786900.0
2021-12-07	AGGY	ETF	52.01	52.04	51.9	51.92	152400.0
2021-12-07	AGNG	ETF	27.78	28.23	27.78	28.07	4900.0
2021-12-07	AGOV	ETF	97.8	97.9555	97.8	97.9555	2252.0
2021-12-07	AGOX	ETF	25.51	25.63	25.406	25.48	57300.0
2021-12-07	AGQ	ETF	32.12	32.85	32.04	32.58	705900.0
2021-12-07	AGZ	ETF	117.54	117.5683	117.371	117.47	17549.0
2021-12-07	AGZD	ETF	23.275	23.385	23.275	23.365	152200.0
2021-12-07	AHHX	ETF	10.4	10.43	10.295	10.315	7980.0
2021-12-07	AHYB	ETF	50.084	50.084	50.084	50.084	100.0
2021-12-07	AIA	ETF	78.98	79.37	78.94	79.11	181708.0
2021-12-07	AIEQ	ETF	42.16	42.659	42.153	42.483	10600.0
2021-12-07	AIQ	ETF	31.63	32.2	31.63	32.13	23240.0
2021-12-07	AIRR	ETF	45.6	46.083	45.44	45.552	27800.0
2021-12-07	AIVI	ETF	41.2	41.27	41.2	41.27	3200.0
2021-12-07	ALTL	ETF	45.9	46.475	45.4	45.84	223826.0
2021-12-07	ALTY	ETF	13.355	13.39	13.35	13.36	8100.0

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

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