PREVIEW / etf_daily / 2022-03-14

all etf daily files

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

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-14	SPY	ETF	420.89	424.55	415.79	417.0	95729200.0
2022-03-14	QQQ	ETF	323.13	326.59	317.45	318.17	79802606.0
2022-03-14	IWM	ETF	197.24	197.44	191.88	192.71	34969500.0
2022-03-14	DIA	ETF	331.75	334.6	328.79	330.07	5640600.0
2022-03-14	GLD	ETF	183.03	183.29	181.95	182.3	13186400.0
2022-03-14	TLT	ETF	132.7	132.89	131.72	131.76	24385000.0
2022-03-14	AAA	ETF	24.9	24.935	24.8766	24.8766	697.0
2022-03-14	AAAU	ETF	19.48	19.51	19.37	19.41	468500.0
2022-03-14	AADR	ETF	55.05	55.48	54.63	54.63	5900.0
2022-03-14	AAXJ	ETF	70.3	70.95	69.22	69.43	1882700.0
2022-03-14	ABEQ	ETF	28.781	28.939	28.65	28.75	21000.0
2022-03-14	ACES	ETF	58.42	58.42	55.46	55.74	91400.0
2022-03-14	ACIO	ETF	30.35	30.35	29.86	29.96	21700.0
2022-03-14	ACSI	ETF	47.24	47.24	46.5293	46.5293	441.0
2022-03-14	ACT	ETF	21.11	21.77	20.97	21.24	201967.0
2022-03-14	ACTV	ETF	34.11	34.165	33.68	34.078	3510.0
2022-03-14	ACTX	ETF	1.0	1.0	1.0	1.0	401.0
2022-03-14	ACVF	ETF	31.71	31.852	31.25	31.428	16400.0
2022-03-14	ACWF	ETF	35.19	35.3	34.69	34.7643	7862.0
2022-03-14	ACWI	ETF	93.18	93.78	92.01	92.25	1827000.0
2022-03-14	ACWV	ETF	100.34	100.76	99.47	99.73	216400.0
2022-03-14	ACWX	ETF	49.32	49.54	48.75	48.85	3482205.0
2022-03-14	ADFI	ETF	8.98	8.98	8.927	8.927	2800.0
2022-03-14	ADIV	ETF	14.82	14.82	14.679	14.679	600.0
2022-03-14	ADME	ETF	38.88	39.0	38.614	38.66	20800.0
2022-03-14	ADRE	ETF	39.36	39.6696	38.61	38.66	20288.0
2022-03-14	AEMB	ETF	42.038	42.1	41.996	41.996	1800.0
2022-03-14	AESR	ETF	12.46	12.53	12.35	12.36	6000.0
2022-03-14	AFIF	ETF	9.23	9.23	9.2099	9.2099	9687.0
2022-03-14	AFK	ETF	20.59	20.6	20.0	20.05	19420.0
2022-03-14	AFLG	ETF	25.15	25.162	25.034	25.034	1500.0
2022-03-14	AFMC	ETF	23.77	23.802	23.77	23.802	900.0
2022-03-14	AFSM	ETF	24.78	24.79	24.65	24.711	15900.0
2022-03-14	AFTY	ETF	17.58	17.58	17.241	17.256	5900.0
2022-03-14	AGG	ETF	107.79	107.82	107.36	107.36	10961600.0
2022-03-14	AGGY	ETF	48.18	48.19	48.015	48.02	200200.0
2022-03-14	AGNG	ETF	26.49	26.676	26.215	26.22	6900.0
2022-03-14	AGOV	ETF	83.725	83.934	83.51	83.51	5842.0
2022-03-14	AGOX	ETF	22.7	22.98	22.42	22.5	28000.0
2022-03-14	AGQ	ETF	40.56	40.56	39.34	39.69	1182800.0
2022-03-14	AGZ	ETF	113.69	113.805	113.56	113.58	31251.0
2022-03-14	AGZD	ETF	23.025	23.13	23.025	23.075	139000.0
2022-03-14	AHHX	ETF	9.6095	9.65	9.57	9.57	2376.0
2022-03-14	AHYB	ETF	46.537	46.537	46.305	46.305	500.0
2022-03-14	AIA	ETF	63.15	63.75	62.0	62.17	120337.0
2022-03-14	AIEQ	ETF	34.24	34.75	33.85	34.011	9500.0
2022-03-14	AIQ	ETF	24.24	24.3	23.55	23.61	77897.0
2022-03-14	AIRR	ETF	42.64	42.66	41.79	42.0	70700.0
2022-03-14	AIVI	ETF	39.01	39.34	38.9	38.97	60100.0
2022-03-14	AIVL	ETF	94.3	94.72	93.44	93.71	6900.0

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

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