PREVIEW / etf_daily / 2022-03-18

all etf daily files

  file:    by_date/etf_daily/2022/2022-03-18.parquet
  size:    100 KB
  rows:    2,670

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
2022-03-18	SPY	ETF	438.0	444.86	437.22	444.52	106345500.0
2022-03-18	QQQ	ETF	342.74	351.79	341.55	351.49	85446347.0
2022-03-18	IWM	ETF	204.21	207.45	204.0	207.27	37092200.0
2022-03-18	DIA	ETF	343.62	347.44	342.65	347.19	5903900.0
2022-03-18	GLD	ETF	179.93	180.93	179.04	179.3	13996500.0
2022-03-18	TLT	ETF	132.57	133.54	132.57	133.44	55891700.0
2022-03-18	AAA	ETF	24.875	24.88	24.8254	24.88	2514.0
2022-03-18	AAAU	ETF	19.16	19.26	19.06	19.08	737600.0
2022-03-18	AADR	ETF	58.09	58.3	58.09	58.3	700.0
2022-03-18	AAXJ	ETF	74.77	76.72	74.5	76.58	1624700.0
2022-03-18	ABEQ	ETF	29.31	29.37	29.22	29.37	13200.0
2022-03-18	ACES	ETF	60.44	61.97	60.44	61.58	449400.0
2022-03-18	ACIO	ETF	30.58	31.18	30.58	31.18	69500.0
2022-03-18	ACSI	ETF	49.47	49.7594	49.47	49.7594	172.0
2022-03-18	ACT	ETF	21.87	22.14	21.49	21.95	121596.0
2022-03-18	ACTV	ETF	35.47	35.94	35.425	35.9319	4478.0
2022-03-18	ACTX	ETF	1.0	1.0	0.9894	0.99	1400.0
2022-03-18	ACVF	ETF	33.17	33.448	33.17	33.448	3400.0
2022-03-18	ACWF	ETF	36.7095	37.1484	36.7095	37.1484	3096.0
2022-03-18	ACWI	ETF	97.14	99.03	97.14	98.93	3076400.0
2022-03-18	ACWV	ETF	102.9	104.14	102.9	104.12	75300.0
2022-03-18	ACWX	ETF	51.37	52.46	51.34	52.39	3157790.0
2022-03-18	ADFI	ETF	9.065	9.08	9.05	9.08	3700.0
2022-03-18	ADIV	ETF	15.39	15.656	15.39	15.656	400.0
2022-03-18	ADME	ETF	40.29	40.68	40.11	40.68	57200.0
2022-03-18	ADRE	ETF	43.11	44.485	43.11	44.14	11453.0
2022-03-18	AEMB	ETF	42.92	43.1	42.92	43.073	3600.0
2022-03-18	AESR	ETF	13.08	13.18	13.07	13.17	9300.0
2022-03-18	AFIF	ETF	9.251	9.28	9.251	9.27	23878.0
2022-03-18	AFK	ETF	20.99	21.25	20.8201	21.1	16859.0
2022-03-18	AFLG	ETF	26.16	26.47	26.16	26.451	1000.0
2022-03-18	AFMC	ETF	25.094	25.249	25.094	25.249	800.0
2022-03-18	AFSM	ETF	26.2	26.341	26.17	26.341	300.0
2022-03-18	AFTY	ETF	18.02	18.47	18.02	18.46	2200.0
2022-03-18	AGG	ETF	107.93	108.14	107.92	108.1	7864100.0
2022-03-18	AGGH	ETF	24.6363	24.6579	24.6363	24.6579	415.0
2022-03-18	AGGY	ETF	48.28	48.42	48.28	48.41	111900.0
2022-03-18	AGNG	ETF	27.78	28.12	27.78	28.12	2200.0
2022-03-18	AGOV	ETF	84.44	86.18	84.43	86.18	3947.0
2022-03-18	AGOX	ETF	23.75	24.02	23.576	23.92	22300.0
2022-03-18	AGQ	ETF	39.22	39.7	38.74	38.93	862200.0
2022-03-18	AGZ	ETF	113.45	113.52	113.34	113.34	42480.0
2022-03-18	AGZD	ETF	23.17	23.22	23.15	23.18	57200.0
2022-03-18	AHHX	ETF	9.47	9.56	9.46	9.4908	5729.0
2022-03-18	AHYB	ETF	47.45	47.672	47.45	47.672	700.0
2022-03-18	AIA	ETF	68.34	70.69	68.25	70.41	64628.0
2022-03-18	AIEQ	ETF	36.34	36.999	36.34	36.979	15300.0
2022-03-18	AIQ	ETF	26.02	26.9256	26.02	26.85	20830.0
2022-03-18	AIRR	ETF	43.55	44.2	43.51	44.2	68000.0
2022-03-18	AIVI	ETF	40.1	40.51	40.07	40.51	3300.0

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

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