PREVIEW / etf_daily / 2023-03-02

all etf daily files

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

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-03-02	SPY	ETF	392.68	398.69	392.33	397.81	85127800.0
2023-03-02	QQQ	ETF	288.66	294.43	288.37	293.61	53738557.0
2023-03-02	IWM	ETF	186.86	189.3	186.12	188.87	18104400.0
2023-03-02	DIA	ETF	327.57	331.2	326.8	330.44	3047500.0
2023-03-02	GLD	ETF	170.52	170.98	170.36	170.66	3950700.0
2023-03-02	TLT	ETF	99.06	99.65	98.88	99.48	23763600.0
2023-03-02	AAA	ETF	24.54	24.54	24.54	24.54	432.0
2023-03-02	AAAU	ETF	18.18	18.24	18.17	18.21	474100.0
2023-03-02	AADR	ETF	48.77	49.29	48.77	49.29	1200.0
2023-03-02	AAPB	ETF	18.1991	18.4963	18.1397	18.4963	1683.0
2023-03-02	AAPD	ETF	27.22	27.22	26.76	26.89	78320.0
2023-03-02	AAPU	ETF	19.29	19.72	19.22	19.58	49576.0
2023-03-02	AAXJ	ETF	66.64	67.43	66.52	67.36	706100.0
2023-03-02	ABEQ	ETF	27.87	27.96	27.85	27.96	7500.0
2023-03-02	ACES	ETF	47.17	47.516	46.671	47.5	12100.0
2023-03-02	ACIO	ETF	29.28	29.508	29.27	29.44	68600.0
2023-03-02	ACSI	ETF	43.5144	43.8595	43.5144	43.8595	286.0
2023-03-02	ACT	ETF	24.13	24.55	23.96	24.27	78722.0
2023-03-02	ACTV	ETF	31.2	31.57	31.13	31.54	6496.0
2023-03-02	ACTX	ETF	0.32	0.32	0.32	0.32	117.0
2023-03-02	ACVF	ETF	30.47	30.82	30.44	30.728	4900.0
2023-03-02	ACWF	ETF	32.71	32.99	32.71	32.99	7173.0
2023-03-02	ACWI	ETF	87.94	89.08	87.83	88.89	5607400.0
2023-03-02	ACWV	ETF	93.11	93.8	92.86	93.69	83300.0
2023-03-02	ACWX	ETF	47.52	48.015	47.51	47.95	783590.0
2023-03-02	ADFI	ETF	8.325	8.34	8.32	8.34	3200.0
2023-03-02	ADIV	ETF	14.025	14.051	14.025	14.051	300.0
2023-03-02	ADME	ETF	33.43	33.97	33.43	33.73	48200.0
2023-03-02	ADPV	ETF	25.12	25.34	25.06	25.34	15836.0
2023-03-02	ADRE	ETF	39.08	39.5862	39.03	39.58	8175.0
2023-03-02	AEMB	ETF	36.98	37.165	36.98	37.165	200.0
2023-03-02	AESR	ETF	11.47	11.57	11.38	11.56	77000.0
2023-03-02	AFIF	ETF	8.8277	8.86	8.81	8.84	18887.0
2023-03-02	AFK	ETF	16.44	16.44	16.25	16.32	7374.0
2023-03-02	AFLG	ETF	23.88	23.88	23.841	23.841	500.0
2023-03-02	AFMC	ETF	23.94	23.94	23.94	23.94	100.0
2023-03-02	AFSM	ETF	24.598	24.598	24.598	24.598	100.0
2023-03-02	AFTY	ETF	16.608	16.645	16.608	16.645	300.0
2023-03-02	AGG	ETF	96.15	96.35	96.11	96.32	9247400.0
2023-03-02	AGGH	ETF	21.83	21.93	21.83	21.9259	1445.0
2023-03-02	AGGY	ETF	42.36	42.455	42.35	42.44	119000.0
2023-03-02	AGNG	ETF	26.27	26.27	26.27	26.27	400.0
2023-03-02	AGOV	ETF	74.38	74.38	74.38	74.38	313.0
2023-03-02	AGOX	ETF	21.56	21.77	21.51	21.68	8800.0
2023-03-02	AGQ	ETF	23.24	23.78	23.18	23.76	704200.0
2023-03-02	AGZ	ETF	105.93	105.95	105.8101	105.95	47311.0
2023-03-02	AGZD	ETF	21.92	21.96	21.885	21.935	85200.0
2023-03-02	AHHX	ETF	8.4559	8.4937	8.44	8.4937	5853.0
2023-03-02	AHYB	ETF	43.12	43.15	43.12	43.15	200.0
2023-03-02	AIA	ETF	59.9	60.7	59.68	60.58	140410.0

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

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