PREVIEW / etf_daily / 2022-11-14

all etf daily files

  file:    by_date/etf_daily/2022/2022-11-14.parquet
  size:    107 KB
  rows:    2,864

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-11-14	SPY	ETF	396.66	400.18	394.83	395.12	71903500.0
2022-11-14	QQQ	ETF	285.86	289.215	284.44	285.44	55080048.0
2022-11-14	IWM	ETF	185.79	187.79	184.63	184.81	26499600.0
2022-11-14	DIA	ETF	336.71	339.87	335.56	335.77	3303300.0
2022-11-14	GLD	ETF	164.2	165.24	164.15	164.92	6187600.0
2022-11-14	TLT	ETF	97.91	97.99	97.09	97.65	13741100.0
2022-11-14	AAA	ETF	24.19	24.19	24.15	24.15	13605.0
2022-11-14	AAAU	ETF	17.51	17.62	17.5	17.58	1826600.0
2022-11-14	AADR	ETF	49.0	49.0	48.77	48.77	1600.0
2022-11-14	AAPB	ETF	19.82	20.2247	19.76	19.8227	1680.0
2022-11-14	AAPD	ETF	26.59	26.9	26.42	26.7592	137417.0
2022-11-14	AAPU	ETF	20.93	21.07	20.544	20.76	46181.0
2022-11-14	AAXJ	ETF	63.26	63.66	63.06	63.2	823700.0
2022-11-14	ABEQ	ETF	27.92	27.94	27.696	27.696	14600.0
2022-11-14	ACES	ETF	56.67	56.77	55.235	56.26	76400.0
2022-11-14	ACIO	ETF	29.802	29.91	29.7	29.7	101800.0
2022-11-14	ACSI	ETF	44.0117	44.0117	44.0117	44.0117	89.0
2022-11-14	ACT	ETF	25.94	26.02	25.41	25.58	148273.0
2022-11-14	ACTV	ETF	30.72	30.9	30.489	30.489	7268.0
2022-11-14	ACTX	ETF	0.3051	0.45	0.3051	0.45	746.0
2022-11-14	ACVF	ETF	30.5	30.67	30.33	30.33	4700.0
2022-11-14	ACWF	ETF	33.14	33.45	33.0776	33.0776	5728.0
2022-11-14	ACWI	ETF	87.13	87.73	86.75	86.8	5329600.0
2022-11-14	ACWV	ETF	95.09	96.07	95.09	95.09	112900.0
2022-11-14	ACWX	ETF	45.39	45.65	45.29	45.31	3481130.0
2022-11-14	ADFI	ETF	8.35	8.35	8.335	8.335	4100.0
2022-11-14	ADIV	ETF	12.687	12.687	12.687	12.687	100.0
2022-11-14	ADME	ETF	35.09	35.27	35.02	35.02	141100.0
2022-11-14	ADPV	ETF	25.06	25.07	25.0	25.04	30834.0
2022-11-14	ADRE	ETF	36.33	36.49	36.33	36.44	6592.0
2022-11-14	AEMB	ETF	36.66	36.67	36.57	36.57	400.0
2022-11-14	AESR	ETF	11.786	11.87	11.729	11.729	11100.0
2022-11-14	AFIF	ETF	8.72	8.74	8.71	8.72	45384.0
2022-11-14	AFK	ETF	16.92	16.92	16.73	16.81	8489.0
2022-11-14	AFLG	ETF	24.21	24.21	23.948	23.948	1300.0
2022-11-14	AFSM	ETF	23.713	23.713	23.5	23.5	500.0
2022-11-14	AFTY	ETF	14.978	15.003	14.96	15.003	800.0
2022-11-14	AGG	ETF	96.43	96.45	96.18	96.24	7457600.0
2022-11-14	AGGY	ETF	42.35	42.37	42.27	42.31	175900.0
2022-11-14	AGNG	ETF	26.06	26.06	25.93	25.93	1200.0
2022-11-14	AGOV	ETF	80.46	81.0949	80.43	81.0	1070.0
2022-11-14	AGOX	ETF	21.4	21.54	21.29	21.339	67600.0
2022-11-14	AGQ	ETF	26.65	27.71	26.65	27.43	905300.0
2022-11-14	AGZ	ETF	106.32	106.47	106.28	106.39	30786.0
2022-11-14	AGZD	ETF	22.925	22.925	22.83	22.885	28800.0
2022-11-14	AHHX	ETF	8.58	8.58	8.5077	8.5077	5099.0
2022-11-14	AHYB	ETF	43.063	43.063	43.063	43.063	200.0
2022-11-14	AIA	ETF	54.27	54.7	54.035	54.14	49638.0
2022-11-14	AIEQ	ETF	31.935	31.974	31.64	31.711	8600.0
2022-11-14	AIQ	ETF	20.8	21.16	20.705	20.93	31286.0

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

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