PREVIEW / etf_daily / 2022-04-18

all etf daily files

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

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-04-18	SPY	ETF	436.81	439.75	435.61	437.97	66002500.0
2022-04-18	QQQ	ETF	337.35	341.04	335.791	338.69	58560555.0
2022-04-18	IWM	ETF	198.46	199.18	196.53	197.62	22246400.0
2022-04-18	DIA	ETF	343.87	346.07	342.63	344.1	3939000.0
2022-04-18	GLD	ETF	185.95	186.1	184.39	184.61	8886700.0
2022-04-18	TLT	ETF	120.87	121.08	119.69	120.15	18784300.0
2022-04-18	AAA	ETF	24.8883	24.91	24.8611	24.8683	904.0
2022-04-18	AAAU	ETF	19.79	19.81	19.64	19.65	513600.0
2022-04-18	AADR	ETF	58.14	59.5	58.14	59.5	2600.0
2022-04-18	AAXJ	ETF	72.75	73.23	72.51	72.87	1471700.0
2022-04-18	ABEQ	ETF	30.085	30.11	29.98	30.03	7300.0
2022-04-18	ACES	ETF	57.2	57.2	55.99	56.33	45700.0
2022-04-18	ACIO	ETF	30.86	31.06	30.86	30.995	28000.0
2022-04-18	ACSI	ETF	49.0066	49.0066	49.0066	49.0066	53.0
2022-04-18	ACT	ETF	21.95	23.19	21.02	23.19	92181.0
2022-04-18	ACTV	ETF	35.0	35.0	34.775	34.8699	6574.0
2022-04-18	ACTX	ETF	1.0	1.0	1.0	1.0	1320.0
2022-04-18	ACVF	ETF	32.94	32.941	32.78	32.864	4200.0
2022-04-18	ACWF	ETF	36.0	36.195	35.9689	36.0	10129.0
2022-04-18	ACWI	ETF	96.92	97.39	96.54	96.95	1674800.0
2022-04-18	ACWV	ETF	104.97	105.43	104.37	104.61	118700.0
2022-04-18	ACWX	ETF	51.0	51.27	50.86	50.96	2237354.0
2022-04-18	ADFI	ETF	8.82	8.82	8.813	8.813	10400.0
2022-04-18	ADIV	ETF	15.27	15.305	15.27	15.305	600.0
2022-04-18	ADME	ETF	39.48	39.87	39.48	39.74	30400.0
2022-04-18	ADRE	ETF	41.79	41.9888	41.6599	41.9402	5168.0
2022-04-18	AEMB	ETF	41.885	41.885	41.885	41.885	100.0
2022-04-18	AESR	ETF	13.02	13.03	12.97	13.014	10700.0
2022-04-18	AFIF	ETF	9.21	9.25	9.2	9.2248	16160.0
2022-04-18	AFK	ETF	21.34	21.4	21.27	21.27	7250.0
2022-04-18	AFLG	ETF	26.218	26.218	26.218	26.218	100.0
2022-04-18	AFMC	ETF	24.189	24.189	24.189	24.189	100.0
2022-04-18	AFSM	ETF	25.087	25.087	25.087	25.087	200.0
2022-04-18	AFTY	ETF	18.23	18.242	18.22	18.242	1100.0
2022-04-18	AGG	ETF	103.97	104.02	103.61	103.65	8633000.0
2022-04-18	AGGY	ETF	46.23	46.29	46.04	46.04	96600.0
2022-04-18	AGNG	ETF	28.71	28.71	28.4	28.69	19900.0
2022-04-18	AGOV	ETF	83.47	83.47	82.0	82.985	1741.0
2022-04-18	AGOX	ETF	22.94	23.29	22.94	23.128	36500.0
2022-04-18	AGQ	ETF	42.62	42.91	41.65	41.85	781200.0
2022-04-18	AGZ	ETF	110.99	111.0419	110.83	110.9	38392.0
2022-04-18	AGZD	ETF	23.15	23.2	23.115	23.125	95000.0
2022-04-18	AHHX	ETF	9.2	9.27	9.2	9.235	12990.0
2022-04-18	AHYB	ETF	46.36	46.424	46.33	46.365	1800.0
2022-04-18	AIA	ETF	65.37	65.8771	65.311	65.52	56327.0
2022-04-18	AIEQ	ETF	35.92	36.05	35.76	35.83	8700.0
2022-04-18	AIQ	ETF	24.78	24.95	24.57	24.8	31589.0
2022-04-18	AIRR	ETF	40.46	40.9	40.421	40.59	16800.0
2022-04-18	AIVI	ETF	39.59	39.71	39.49	39.53	18000.0
2022-04-18	AIVL	ETF	98.93	98.93	98.03	98.25	8000.0

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

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