PREVIEW / etf_daily / 2023-02-27

all etf daily files

  file:    by_date/etf_daily/2023/2023-02-27.parquet
  size:    109 KB
  rows:    2,941

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
2023-02-27	SPY	ETF	399.87	401.29	396.75	397.73	80444700.0
2023-02-27	QQQ	ETF	295.07	296.49	293.34	293.94	48995009.0
2023-02-27	IWM	ETF	189.13	190.2	187.6	188.17	17562900.0
2023-02-27	DIA	ETF	330.73	331.98	328.2	329.06	2887300.0
2023-02-27	GLD	ETF	168.88	169.23	168.55	169.01	4509200.0
2023-02-27	TLT	ETF	101.29	101.7	100.91	101.25	14209200.0
2023-02-27	AAA	ETF	24.63	24.63	24.63	24.63	12.0
2023-02-27	AAAU	ETF	18.02	18.06	17.98	18.02	559700.0
2023-02-27	AADR	ETF	48.38	48.65	48.38	48.5	700.0
2023-02-27	AAPB	ETF	19.01	19.19	18.93	18.9356	2147.0
2023-02-27	AAPD	ETF	26.52	26.56	26.3	26.52	122656.0
2023-02-27	AAPU	ETF	20.04	20.23	19.93	20.01	58002.0
2023-02-27	AAXJ	ETF	66.01	66.08	65.82	65.92	296700.0
2023-02-27	ABEQ	ETF	27.89	27.89	27.79	27.826	19500.0
2023-02-27	ACES	ETF	47.56	48.35	47.513	48.03	13600.0
2023-02-27	ACIO	ETF	29.58	29.58	29.42	29.47	21700.0
2023-02-27	ACSI	ETF	44.2944	44.2944	44.2944	44.2944	73.0
2023-02-27	ACT	ETF	24.62	24.9	24.255	24.3	87146.0
2023-02-27	ACTV	ETF	32.12	32.12	31.8299	31.8799	19686.0
2023-02-27	ACTX	ETF	0.44	0.44	0.438	0.438	451.0
2023-02-27	ACVF	ETF	31.06	31.06	30.73	30.758	6800.0
2023-02-27	ACWF	ETF	32.981	33.03	32.9365	32.9365	3268.0
2023-02-27	ACWI	ETF	88.95	89.24	88.51	88.68	2749900.0
2023-02-27	ACWV	ETF	93.93	94.32	93.58	93.76	189600.0
2023-02-27	ACWX	ETF	47.68	47.845	47.59	47.71	962266.0
2023-02-27	ADFI	ETF	8.38	8.38	8.36	8.37	14200.0
2023-02-27	ADIV	ETF	13.835	13.835	13.835	13.835	100.0
2023-02-27	ADME	ETF	33.821	33.86	33.75	33.8	17000.0
2023-02-27	ADPV	ETF	25.28	25.32	25.08	25.1	17942.0
2023-02-27	ADRE	ETF	39.1	39.1	38.78	38.93	3011.0
2023-02-27	AEMB	ETF	37.801	37.801	37.801	37.801	100.0
2023-02-27	AESR	ETF	11.6	11.62	11.56	11.575	17600.0
2023-02-27	AFIF	ETF	8.84	8.8443	8.82	8.8353	9949.0
2023-02-27	AFK	ETF	16.14	16.24	16.14	16.17	1965.0
2023-02-27	AFLG	ETF	23.86	23.86	23.796	23.796	100.0
2023-02-27	AFMC	ETF	23.782	23.782	23.782	23.782	100.0
2023-02-27	AFSM	ETF	24.371	24.371	24.371	24.371	100.0
2023-02-27	AFTY	ETF	16.2	16.271	16.2	16.271	1700.0
2023-02-27	AGG	ETF	97.41	97.49	97.22	97.32	5040000.0
2023-02-27	AGGY	ETF	42.77	42.81	42.705	42.76	90600.0
2023-02-27	AGNG	ETF	26.39	26.48	26.185	26.2	3800.0
2023-02-27	AGOV	ETF	72.83	74.6501	72.54	74.648	7216.0
2023-02-27	AGOX	ETF	21.71	21.71	21.58	21.66	12500.0
2023-02-27	AGQ	ETF	23.35	23.46	22.97	23.03	787700.0
2023-02-27	AGZ	ETF	106.63	107.15	106.56	106.7	70989.0
2023-02-27	AGZD	ETF	21.935	21.975	21.91	21.925	40200.0
2023-02-27	AHHX	ETF	8.48	8.48	8.48	8.48	911.0
2023-02-27	AHYB	ETF	43.376	43.454	43.376	43.454	200.0
2023-02-27	AIA	ETF	58.99	59.03	58.71	58.92	75726.0
2023-02-27	AIEQ	ETF	30.44	30.44	30.117	30.241	9500.0

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

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