PREVIEW / etf_daily / 2023-05-15

all etf daily files

  file:    by_date/etf_daily/2023/2023-05-15.parquet
  size:    109 KB
  rows:    2,966

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-05-15	SPY	ETF	412.22	413.43	410.23	413.01	54289400.0
2023-05-15	QQQ	ETF	325.51	327.03	323.96	326.79	33375559.0
2023-05-15	IWM	ETF	173.31	175.71	172.82	174.83	24310000.0
2023-05-15	DIA	ETF	333.51	334.26	331.86	333.77	2171000.0
2023-05-15	GLD	ETF	187.3	187.88	187.03	187.21	5518100.0
2023-05-15	TLT	ETF	103.39	103.47	103.12	103.19	20085300.0
2023-05-15	AAA	ETF	24.55	24.55	24.55	24.55	845.0
2023-05-15	AAAU	ETF	19.99	20.05	19.97	19.98	768700.0
2023-05-15	AADR	ETF	47.36	48.01	47.36	48.01	1300.0
2023-05-15	AAPB	ETF	24.42	24.42	24.0137	24.17	7163.0
2023-05-15	AAPD	ETF	22.57	22.76	22.565	22.68	68108.0
2023-05-15	AAPU	ETF	24.93	24.93	24.57	24.69	37811.0
2023-05-15	AAXJ	ETF	65.94	66.72	65.92	66.72	1110300.0
2023-05-15	ABEQ	ETF	28.49	28.62	28.49	28.62	6400.0
2023-05-15	ACES	ETF	42.72	43.78	42.65	43.36	48200.0
2023-05-15	ACIO	ETF	30.02	30.16	30.0	30.1	37800.0
2023-05-15	ACSI	ETF	43.8124	43.8124	43.8124	43.8124	136.0
2023-05-15	ACT	ETF	23.91	24.0	23.7	23.74	350165.0
2023-05-15	ACTV	ETF	28.51	28.89	28.51	28.8791	8569.0
2023-05-15	ACTX	ETF	0.3	0.3	0.3	0.3	248.0
2023-05-15	ACVF	ETF	31.04	31.214	31.04	31.214	3500.0
2023-05-15	ACWF	ETF	33.87	34.09	33.87	34.04	4125.0
2023-05-15	ACWI	ETF	91.94	92.38	91.7	92.33	2903900.0
2023-05-15	ACWV	ETF	100.04	100.04	99.58	99.87	249800.0
2023-05-15	ACWX	ETF	49.49	49.79	49.44	49.79	713022.0
2023-05-15	ADFI	ETF	8.49	8.49	8.47	8.49	13200.0
2023-05-15	ADIV	ETF	13.65	13.65	13.65	13.65	100.0
2023-05-15	ADME	ETF	34.71	34.795	34.71	34.75	18200.0
2023-05-15	ADPV	ETF	23.39	23.39	23.28	23.3539	9978.0
2023-05-15	AEMB	ETF	37.385	37.385	37.385	37.385	100.0
2023-05-15	AESR	ETF	12.0	12.054	12.0	12.04	29800.0
2023-05-15	AFIF	ETF	8.86	8.86	8.81	8.84	38078.0
2023-05-15	AFK	ETF	15.26	15.282	15.22	15.22	2996.0
2023-05-15	AFLG	ETF	23.856	23.856	23.856	23.856	100.0
2023-05-15	AFMC	ETF	22.76	22.817	22.76	22.817	2500.0
2023-05-15	AFTY	ETF	15.97	16.075	15.97	16.075	400.0
2023-05-15	AGG	ETF	99.21	99.22	99.1	99.14	8532600.0
2023-05-15	AGGH	ETF	23.0484	23.1	23.0484	23.0688	1844.0
2023-05-15	AGGY	ETF	43.56	43.62	43.56	43.6	77900.0
2023-05-15	AGNG	ETF	28.412	28.5	28.412	28.48	1400.0
2023-05-15	AGOV	ETF	74.6	74.6	74.6	74.6	100.0
2023-05-15	AGOX	ETF	21.44	21.74	21.44	21.67	8200.0
2023-05-15	AGQ	ETF	30.78	31.03	30.46	30.67	529100.0
2023-05-15	AGZ	ETF	108.42	108.5166	108.42	108.513	14050.0
2023-05-15	AGZD	ETF	21.82	21.82	21.68	21.76	21800.0
2023-05-15	AHOY	ETF	19.21	19.2375	19.21	19.2375	183.0
2023-05-15	AHYB	ETF	43.638	43.65	43.638	43.642	400.0
2023-05-15	AIA	ETF	58.25	59.08	58.1555	58.96	15141.0
2023-05-15	AIEQ	ETF	27.24	28.069	27.065	27.99	27300.0
2023-05-15	AIQ	ETF	23.95	24.18	23.87	24.16	64488.0

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

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