PREVIEW / etf_daily / 2022-03-09

all etf daily files

  file:    by_date/etf_daily/2022/2022-03-09.parquet
  size:    99 KB
  rows:    2,659

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-09	SPY	ETF	425.14	429.51	422.82	427.41	116990800.0
2022-03-09	QQQ	ETF	331.75	336.38	329.09	334.99	64723366.0
2022-03-09	IWM	ETF	198.22	201.0	197.62	200.28	29048000.0
2022-03-09	DIA	ETF	333.12	335.04	331.57	333.4	4669200.0
2022-03-09	GLD	ETF	186.04	187.23	184.76	185.82	26839700.0
2022-03-09	TLT	ETF	137.07	137.34	136.13	136.42	18819200.0
2022-03-09	AAA	ETF	24.915	24.915	24.8753	24.8753	717.0
2022-03-09	AAAU	ETF	19.8	19.93	19.67	19.79	1199000.0
2022-03-09	AADR	ETF	55.9	56.23	55.9	56.21	1300.0
2022-03-09	AAXJ	ETF	73.6	74.52	73.13	74.4	1901500.0
2022-03-09	ABEQ	ETF	28.66	28.925	28.66	28.85	13100.0
2022-03-09	ACES	ETF	59.74	60.41	58.85	59.98	107300.0
2022-03-09	ACIO	ETF	30.68	30.68	30.341	30.47	19700.0
2022-03-09	ACSI	ETF	47.68	47.68	47.6561	47.6561	240.0
2022-03-09	ACT	ETF	20.16	20.52	20.09	20.36	82037.0
2022-03-09	ACTV	ETF	34.23	34.44	34.22	34.2798	5712.0
2022-03-09	ACTX	ETF	1.0	1.0	1.0	1.0	371.0
2022-03-09	ACVF	ETF	31.82	32.18	31.82	32.065	4000.0
2022-03-09	ACWF	ETF	35.45	35.8656	35.43	35.7293	8396.0
2022-03-09	ACWI	ETF	94.11	95.26	93.7	94.9	3841700.0
2022-03-09	ACWV	ETF	100.42	101.36	100.12	100.89	431900.0
2022-03-09	ACWX	ETF	49.67	50.495	49.54	50.32	3067859.0
2022-03-09	ADFI	ETF	9.08	9.1	9.08	9.097	6700.0
2022-03-09	ADIV	ETF	15.18	15.27	15.18	15.27	1300.0
2022-03-09	ADME	ETF	39.29	39.48	39.176	39.4	23400.0
2022-03-09	ADRE	ETF	42.2	43.2916	42.2	42.7	12397.0
2022-03-09	AEMB	ETF	42.54	42.604	42.54	42.604	100.0
2022-03-09	AESR	ETF	12.495	12.58	12.48	12.53	15300.0
2022-03-09	AFIF	ETF	9.2999	9.31	9.28	9.3	40571.0
2022-03-09	AFK	ETF	20.43	20.56	20.28	20.5	10831.0
2022-03-09	AFLG	ETF	25.48	25.67	25.48	25.559	1000.0
2022-03-09	AFSM	ETF	25.21	25.314	25.18	25.226	1000.0
2022-03-09	AFTY	ETF	18.31	18.331	18.31	18.331	1800.0
2022-03-09	AGG	ETF	109.1	109.21	108.93	109.04	11192300.0
2022-03-09	AGGY	ETF	48.69	48.89	48.668	48.83	139900.0
2022-03-09	AGNG	ETF	26.56	26.865	26.56	26.756	2700.0
2022-03-09	AGOV	ETF	84.18	84.18	84.1697	84.1697	207.0
2022-03-09	AGOX	ETF	23.435	23.57	23.202	23.48	49400.0
2022-03-09	AGQ	ETF	43.23	43.99	41.23	42.1	1908300.0
2022-03-09	AGZ	ETF	114.42	114.47	114.36	114.46	36783.0
2022-03-09	AGZD	ETF	23.03	23.09	22.945	23.03	61800.0
2022-03-09	AHHX	ETF	9.69	9.69	9.58	9.6345	3488.0
2022-03-09	AHYB	ETF	47.4	47.545	47.4	47.545	1100.0
2022-03-09	AIA	ETF	66.92	67.95	66.68	67.93	73679.0
2022-03-09	AIEQ	ETF	34.43	35.139	34.43	34.84	11100.0
2022-03-09	AIQ	ETF	25.2	25.69	25.2	25.6	36853.0
2022-03-09	AIRR	ETF	42.39	42.675	42.21	42.43	13300.0
2022-03-09	AIVI	ETF	38.62	39.17	38.59	38.86	6300.0
2022-03-09	AIVL	ETF	95.39	96.11	95.39	95.46	9200.0
2022-03-09	ALTL	ETF	41.74	42.5765	41.74	42.41	485356.0

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

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