PREVIEW / etf_daily / 2023-02-17

all etf daily files

  file:    by_date/etf_daily/2023/2023-02-17.parquet
  size:    108 KB
  rows:    2,921

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-17	SPY	ETF	406.06	407.51	404.05	407.26	89257800.0
2023-02-17	QQQ	ETF	301.07	301.93	298.1	301.16	58230729.0
2023-02-17	IWM	ETF	191.88	193.37	190.97	193.13	23892200.0
2023-02-17	DIA	ETF	335.72	338.43	335.08	338.29	3034200.0
2023-02-17	GLD	ETF	169.87	171.47	169.52	171.26	4809800.0
2023-02-17	TLT	ETF	101.1	102.38	100.97	102.38	19560900.0
2023-02-17	AAA	ETF	24.69	24.69	24.69	24.69	114.0
2023-02-17	AAAU	ETF	18.11	18.29	18.09	18.27	757900.0
2023-02-17	AADR	ETF	49.74	49.74	49.25	49.25	1500.0
2023-02-17	AAPB	ETF	20.03	20.09	19.69	20.09	8969.0
2023-02-17	AAPD	ETF	25.74	25.97	25.64	25.71	173426.0
2023-02-17	AAPU	ETF	20.93	21.06	20.67	21.01	94007.0
2023-02-17	AAXJ	ETF	67.94	68.03	67.64	67.97	910000.0
2023-02-17	ABEQ	ETF	28.11	28.23	28.083	28.203	10000.0
2023-02-17	ACES	ETF	50.96	50.96	50.04	50.74	19000.0
2023-02-17	ACIO	ETF	29.795	29.86	29.695	29.86	63600.0
2023-02-17	ACSI	ETF	45.7595	45.7595	45.7595	45.7595	56.0
2023-02-17	ACT	ETF	24.49	24.73	24.35	24.6	101930.0
2023-02-17	ACTV	ETF	32.98	33.2447	32.98	33.2447	6890.0
2023-02-17	ACVF	ETF	31.29	31.47	31.29	31.427	4100.0
2023-02-17	ACWF	ETF	33.62	33.68	33.56	33.675	10270.0
2023-02-17	ACWI	ETF	90.42	90.76	90.05	90.71	4542000.0
2023-02-17	ACWV	ETF	95.12	95.89	95.0	95.86	224900.0
2023-02-17	ACWX	ETF	48.47	48.73	48.335	48.69	1213407.0
2023-02-17	ADFI	ETF	8.41	8.42	8.41	8.416	13000.0
2023-02-17	ADIV	ETF	13.972	14.0	13.972	14.0	300.0
2023-02-17	ADME	ETF	34.351	34.38	34.245	34.38	29300.0
2023-02-17	ADPV	ETF	25.4	25.41	25.31	25.38	28691.0
2023-02-17	ADRE	ETF	40.92	40.9292	40.66	40.89	11908.0
2023-02-17	AEMB	ETF	37.82	37.89	37.82	37.875	700.0
2023-02-17	AESR	ETF	11.74	11.85	11.73	11.85	56900.0
2023-02-17	AFIF	ETF	8.86	8.86	8.83	8.855	13850.0
2023-02-17	AFK	ETF	16.65	16.69	16.56	16.61	3757.0
2023-02-17	AFMC	ETF	24.34	24.34	24.34	24.34	100.0
2023-02-17	AFSM	ETF	24.65	24.86	24.65	24.84	1200.0
2023-02-17	AFTY	ETF	16.451	16.451	16.451	16.451	100.0
2023-02-17	AGG	ETF	97.53	98.01	97.53	98.0	5956300.0
2023-02-17	AGGH	ETF	22.36	22.36	22.34	22.34	2490.0
2023-02-17	AGGY	ETF	42.97	43.22	42.97	43.21	212200.0
2023-02-17	AGNG	ETF	26.61	26.84	26.61	26.84	1400.0
2023-02-17	AGOV	ETF	78.54	78.54	76.28	76.28	424.0
2023-02-17	AGOX	ETF	22.15	22.15	21.902	22.08	9000.0
2023-02-17	AGQ	ETF	24.69	25.89	24.58	25.79	584800.0
2023-02-17	AGZ	ETF	106.7976	107.01	106.7935	106.99	20294.0
2023-02-17	AGZD	ETF	21.95	22.0	21.935	21.935	161200.0
2023-02-17	AHHX	ETF	8.6056	8.6056	8.6056	8.6056	139.0
2023-02-17	AHYB	ETF	43.25	43.487	43.25	43.487	1000.0
2023-02-17	AIA	ETF	61.77	61.77	61.3	61.69	63843.0
2023-02-17	AIEQ	ETF	31.52	31.564	31.3	31.549	16700.0
2023-02-17	AIQ	ETF	23.38	23.39	23.02	23.2	27844.0

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

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