PREVIEW / etf_daily / 2023-04-17

all etf daily files

  file:    by_date/etf_daily/2023/2023-04-17.parquet
  size:    109 KB
  rows:    2,954

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-04-17	SPY	ETF	412.37	413.96	411.09	413.94	66436400.0
2023-04-17	QQQ	ETF	318.15	319.1999	316.04	318.84	43007023.0
2023-04-17	IWM	ETF	176.97	178.86	176.75	178.78	22177300.0
2023-04-17	DIA	ETF	339.12	339.93	337.99	339.92	2226400.0
2023-04-17	GLD	ETF	185.89	185.93	184.1	185.53	7468100.0
2023-04-17	TLT	ETF	104.42	104.59	103.71	103.83	19528800.0
2023-04-17	AAA	ETF	24.52	24.52	24.52	24.52	103.0
2023-04-17	AAAU	ETF	19.84	19.85	19.65	19.8	2680000.0
2023-04-17	AADR	ETF	49.22	49.22	49.22	49.22	200.0
2023-04-17	AAPB	ETF	22.66	22.66	22.437	22.6251	4378.0
2023-04-17	AAPD	ETF	23.67	23.79	23.62	23.63	107309.0
2023-04-17	AAPU	ETF	23.3	23.33	23.08	23.3	89320.0
2023-04-17	AAXJ	ETF	68.3	68.35	68.02	68.27	495800.0
2023-04-17	ABEQ	ETF	28.607	28.69	28.59	28.69	25300.0
2023-04-17	ACES	ETF	44.52	45.449	44.52	45.35	130600.0
2023-04-17	ACIO	ETF	30.0	30.365	29.74	30.345	21400.0
2023-04-17	ACSI	ETF	44.5691	44.5691	44.5691	44.5691	51.0
2023-04-17	ACT	ETF	24.41	24.68	24.16	24.44	123644.0
2023-04-17	ACTV	ETF	29.22	29.58	29.22	29.5798	6513.0
2023-04-17	ACTX	ETF	0.3	0.3	0.3	0.3	350.0
2023-04-17	ACVF	ETF	31.36	31.6	31.36	31.58	7800.0
2023-04-17	ACWF	ETF	33.9861	34.1309	33.9861	34.1309	5259.0
2023-04-17	ACWI	ETF	92.22	92.47	91.92	92.47	3195200.0
2023-04-17	ACWV	ETF	98.65	98.98	98.56	98.98	103000.0
2023-04-17	ACWX	ETF	49.76	49.795	49.54	49.78	1712515.0
2023-04-17	ADFI	ETF	8.52	8.52	8.48	8.51	19500.0
2023-04-17	ADIV	ETF	13.96	13.96	13.96	13.96	100.0
2023-04-17	ADME	ETF	34.84	35.01	34.84	35.01	132100.0
2023-04-17	ADPV	ETF	23.25	23.2597	23.12	23.2597	1047.0
2023-04-17	AEMB	ETF	37.645	37.645	37.645	37.645	100.0
2023-04-17	AESR	ETF	12.135	12.135	12.06	12.126	22200.0
2023-04-17	AFIF	ETF	8.82	8.82	8.76	8.82	14471.0
2023-04-17	AFK	ETF	16.27	16.32	15.97	16.15	27307.0
2023-04-17	AFLG	ETF	24.04	24.161	24.04	24.161	300.0
2023-04-17	AFMC	ETF	23.01	23.15	23.01	23.15	200.0
2023-04-17	AFSM	ETF	23.3	23.398	23.3	23.398	500.0
2023-04-17	AFTY	ETF	16.414	16.414	16.414	16.414	100.0
2023-04-17	AGG	ETF	99.13	99.18	98.88	98.9	4441300.0
2023-04-17	AGGH	ETF	23.0	23.0237	23.0	23.0237	692.0
2023-04-17	AGGY	ETF	43.61	43.64	43.51	43.54	76600.0
2023-04-17	AGIH	ETF	24.709	24.71	24.6665	24.6665	1915.0
2023-04-17	AGNG	ETF	28.1	28.1	28.0	28.071	1700.0
2023-04-17	AGOV	ETF	76.46	79.05	76.46	77.0	1106.0
2023-04-17	AGOX	ETF	21.76	21.85	21.72	21.836	19400.0
2023-04-17	AGQ	ETF	34.56	34.62	33.04	33.64	898300.0
2023-04-17	AGZ	ETF	108.05	108.05	107.85	107.93	115674.0
2023-04-17	AGZD	ETF	21.845	21.86	21.775	21.83	76000.0
2023-04-17	AHYB	ETF	44.018	44.018	43.925	44.011	1700.0
2023-04-17	AIA	ETF	61.1	61.23	60.72	61.06	308861.0
2023-04-17	AIEQ	ETF	28.74	28.74	28.535	28.66	7200.0

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

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