PREVIEW / etf_daily / 2021-12-23

all etf daily files

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

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-23	SPY	ETF	468.75	472.19	468.64	470.6	56439700.0
2021-12-23	QQQ	ETF	394.31	398.425	394.14	396.92	29595536.0
2021-12-23	IWM	ETF	221.05	222.8	220.34	222.04	22125400.0
2021-12-23	DIA	ETF	358.39	360.5	358.16	359.36	2655000.0
2021-12-23	GLD	ETF	168.69	169.16	168.01	168.97	4551100.0
2021-12-23	TLT	ETF	149.59	149.6	148.03	148.52	11642500.0
2021-12-23	AAA	ETF	25.01	25.015	25.01	25.015	216.0
2021-12-23	AAAU	ETF	17.94	18.0	17.89	17.99	101400.0
2021-12-23	AADR	ETF	63.22	63.59	63.22	63.58	2100.0
2021-12-23	AAXJ	ETF	82.25	82.64	81.91	82.48	1072200.0
2021-12-23	ABEQ	ETF	28.15	28.21	28.15	28.195	7100.0
2021-12-23	ACES	ETF	64.33	65.0	63.55	64.57	137900.0
2021-12-23	ACIO	ETF	32.42	32.44	32.27	32.32	35000.0
2021-12-23	ACSI	ETF	52.63	52.74	52.63	52.74	180.0
2021-12-23	ACT	ETF	19.88	20.2075	19.88	20.01	67373.0
2021-12-23	ACTV	ETF	35.75	36.31	35.75	36.205	15206.0
2021-12-23	ACVF	ETF	35.27	35.45	35.255	35.358	3700.0
2021-12-23	ACWF	ETF	38.55	38.71	38.53	38.68	40359.0
2021-12-23	ACWI	ETF	104.66	105.4	104.61	105.1	3693300.0
2021-12-23	ACWV	ETF	106.9	107.2	106.78	106.92	166100.0
2021-12-23	ACWX	ETF	55.11	55.56	55.11	55.47	2846704.0
2021-12-23	ADFI	ETF	9.59	9.609	9.59	9.595	1000.0
2021-12-23	ADIV	ETF	16.27	16.27	16.27	16.27	100.0
2021-12-23	ADME	ETF	42.89	43.08	42.89	42.97	29500.0
2021-12-23	ADRE	ETF	44.94	45.4227	44.6325	45.21	16718.0
2021-12-23	AEMB	ETF	48.284	48.284	48.284	48.284	100.0
2021-12-23	AESR	ETF	13.77	13.919	13.77	13.89	10200.0
2021-12-23	AFIF	ETF	9.569	9.569	9.54	9.56	7282.0
2021-12-23	AFK	ETF	19.99	20.12	19.99	20.11	5703.0
2021-12-23	AFLG	ETF	27.7	27.71	27.7	27.7	500.0
2021-12-23	AFMC	ETF	26.147	26.147	26.147	26.147	100.0
2021-12-23	AFTY	ETF	21.095	21.141	21.095	21.141	400.0
2021-12-23	AGG	ETF	114.29	114.31	114.07	114.2	5506700.0
2021-12-23	AGGY	ETF	51.86	51.86	51.733	51.79	50600.0
2021-12-23	AGNG	ETF	28.849	28.96	28.75	28.905	3100.0
2021-12-23	AGOV	ETF	98.945	98.945	98.945	98.945	1.0
2021-12-23	AGOX	ETF	25.17	25.33	25.14	25.21	81500.0
2021-12-23	AGQ	ETF	33.33	33.7	32.88	33.57	460500.0
2021-12-23	AGZ	ETF	117.3	117.36	117.2	117.22	41774.0
2021-12-23	AGZD	ETF	23.39	23.415	23.35	23.365	32600.0
2021-12-23	AHHX	ETF	10.22	10.5	10.2	10.3547	6803.0
2021-12-23	AHYB	ETF	50.13	50.153	50.13	50.153	300.0
2021-12-23	AIA	ETF	76.08	76.91	76.04	76.79	96866.0
2021-12-23	AIEQ	ETF	41.99	42.255	41.91	42.155	19900.0
2021-12-23	AIQ	ETF	31.68	31.9698	31.64	31.9	40237.0
2021-12-23	AIRR	ETF	44.27	44.56	44.185	44.4	26000.0
2021-12-23	AIVI	ETF	41.8	42.07	41.8	42.07	14400.0
2021-12-23	ALTL	ETF	45.56	45.78	45.47	45.58	95380.0
2021-12-23	ALTY	ETF	13.415	13.43	13.35	13.39	9800.0
2021-12-23	AMAX	ETF	9.53	9.678	9.53	9.678	16000.0

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

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