PREVIEW / etf_daily / 2023-06-06

all etf daily files

  file:    by_date/etf_daily/2023/2023-06-06.parquet
  size:    111 KB
  rows:    2,979

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-06-06	SPY	ETF	426.67	428.58	425.99	428.03	64022200.0
2023-06-06	QQQ	ETF	354.28	355.82	352.93	354.84	41390400.0
2023-06-06	IWM	ETF	178.93	184.96	178.93	184.31	58584500.0
2023-06-06	DIA	ETF	336.03	336.74	334.47	336.17	2824900.0
2023-06-06	GLD	ETF	182.36	182.65	181.52	182.34	4967200.0
2023-06-06	TLT	ETF	101.84	102.47	101.39	102.4	14332100.0
2023-06-06	AAA	ETF	24.46	24.5293	24.46	24.495	4161.0
2023-06-06	AAAU	ETF	19.46	19.49	19.38	19.47	1404100.0
2023-06-06	AADR	ETF	47.61	48.66	47.54	48.66	2400.0
2023-06-06	AAPB	ETF	25.5428	25.82	25.38	25.78	20736.0
2023-06-06	AAPD	ETF	21.78	22.0778	21.78	21.88	202909.0
2023-06-06	AAPU	ETF	26.29	26.3	25.74	26.13	135508.0
2023-06-06	AAXJ	ETF	66.64	67.47	66.62	67.36	559200.0
2023-06-06	ABEQ	ETF	28.08	28.18	28.07	28.18	10000.0
2023-06-06	ACES	ETF	44.02	45.18	44.01	44.967	14400.0
2023-06-06	ACIO	ETF	30.3	30.71	30.3	30.54	106100.0
2023-06-06	ACSI	ETF	45.4398	45.4398	45.4398	45.4398	16.0
2023-06-06	ACT	ETF	24.98	25.76	24.955	25.65	355750.0
2023-06-06	ACTV	ETF	29.93	30.45	29.93	30.3473	7561.0
2023-06-06	ACTX	ETF	0.0517	0.25	0.0517	0.25	1181.0
2023-06-06	ACVF	ETF	32.46	32.52	32.357	32.502	13900.0
2023-06-06	ACWF	ETF	34.56	34.7998	34.56	34.7998	4413.0
2023-06-06	ACWI	ETF	93.82	94.37	93.72	94.29	5434000.0
2023-06-06	ACWV	ETF	97.75	97.75	97.21	97.51	151800.0
2023-06-06	ACWX	ETF	49.18	49.57	49.14	49.53	1208698.0
2023-06-06	ADFI	ETF	8.44	8.45	8.44	8.45	17800.0
2023-06-06	ADIV	ETF	13.53	13.62	13.53	13.62	100.0
2023-06-06	ADME	ETF	35.3	35.38	35.21	35.38	161700.0
2023-06-06	ADPV	ETF	23.78	23.82	23.73	23.8	22534.0
2023-06-06	AEMB	ETF	37.275	37.374	37.275	37.374	200.0
2023-06-06	AESR	ETF	12.331	12.37	12.321	12.341	20100.0
2023-06-06	AFIF	ETF	8.83	8.84	8.8153	8.8153	60802.0
2023-06-06	AFK	ETF	15.39	15.39	15.24	15.35	1858.0
2023-06-06	AFLG	ETF	24.34	24.422	24.33	24.422	1400.0
2023-06-06	AFMC	ETF	23.62	23.7	23.62	23.7	300.0
2023-06-06	AFTY	ETF	14.96	14.98	14.96	14.98	100.0
2023-06-06	AGG	ETF	98.12	98.21	97.89	98.2	3816000.0
2023-06-06	AGGH	ETF	22.74	22.75	22.6823	22.6823	16056.0
2023-06-06	AGGY	ETF	43.16	43.19	43.077	43.189	145500.0
2023-06-06	AGNG	ETF	27.71	27.76	27.67	27.76	4400.0
2023-06-06	AGOV	ETF	76.7	77.31	76.7	77.175	1322.0
2023-06-06	AGOX	ETF	22.555	22.69	22.55	22.665	17700.0
2023-06-06	AGQ	ETF	29.07	29.3	28.54	29.17	306800.0
2023-06-06	AGZ	ETF	107.3	107.31	107.17	107.29	20683.0
2023-06-06	AGZD	ETF	21.865	21.96	21.865	21.895	25600.0
2023-06-06	AHYB	ETF	43.725	43.725	43.725	43.725	200.0
2023-06-06	AIA	ETF	59.95	60.9118	59.86	60.81	31854.0
2023-06-06	AIEQ	ETF	29.9	30.649	29.87	30.62	26000.0
2023-06-06	AIQ	ETF	26.68	26.93	26.5094	26.86	291415.0
2023-06-06	AIRR	ETF	49.72	51.317	49.61	51.11	103000.0

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

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