PREVIEW / etf_daily / 2023-05-01

all etf daily files

  file:    by_date/etf_daily/2023/2023-05-01.parquet
  size:    110 KB
  rows:    2,949

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-01	SPY	ETF	415.47	417.62	415.27	415.51	62122300.0
2023-05-01	QQQ	ETF	322.09	323.63	321.09	322.19	41013386.0
2023-05-01	IWM	ETF	175.0	177.34	174.76	175.3	27420100.0
2023-05-01	DIA	ETF	341.1	342.59	340.26	340.36	2296200.0
2023-05-01	GLD	ETF	186.05	186.22	183.91	183.97	7997700.0
2023-05-01	TLT	ETF	105.27	105.42	102.84	103.13	32487300.0
2023-05-01	AAA	ETF	24.55	24.55	24.515	24.515	127.0
2023-05-01	AAAU	ETF	19.86	19.87	19.63	19.64	1278000.0
2023-05-01	AADR	ETF	48.19	48.19	47.6	47.61	800.0
2023-05-01	AAPB	ETF	23.65	23.79	23.42	23.63	8195.0
2023-05-01	AAPD	ETF	23.11	23.165	22.9304	23.07	119957.0
2023-05-01	AAPU	ETF	24.14	24.345	23.999	24.19	137790.0
2023-05-01	AAXJ	ETF	66.49	66.98	66.46	66.47	211700.0
2023-05-01	ABEQ	ETF	29.0	29.02	28.951	28.97	5100.0
2023-05-01	ACES	ETF	42.45	42.45	41.45	41.64	47800.0
2023-05-01	ACIO	ETF	30.266	30.368	30.266	30.32	28100.0
2023-05-01	ACSI	ETF	44.1572	44.1572	44.1572	44.1572	59.0
2023-05-01	ACT	ETF	24.21	24.54	23.97	24.34	160423.0
2023-05-01	ACTV	ETF	29.69	29.77	29.46	29.5349	6826.0
2023-05-01	ACVF	ETF	31.53	31.78	31.53	31.685	2200.0
2023-05-01	ACWF	ETF	34.1058	34.26	34.0609	34.1162	6301.0
2023-05-01	ACWI	ETF	92.56	92.85	92.43	92.47	923000.0
2023-05-01	ACWV	ETF	99.38	99.94	99.38	99.67	169300.0
2023-05-01	ACWX	ETF	49.71	49.87	49.57	49.59	851801.0
2023-05-01	ADFI	ETF	8.495	8.51	8.475	8.475	5600.0
2023-05-01	ADIV	ETF	13.54	13.6	13.54	13.55	3500.0
2023-05-01	ADME	ETF	35.06	35.14	35.01	35.03	35700.0
2023-05-01	ADPV	ETF	22.9	22.935	22.88	22.935	1534.0
2023-05-01	AEMB	ETF	37.47	37.47	37.47	37.47	100.0
2023-05-01	AESR	ETF	12.17	12.23	12.17	12.17	19800.0
2023-05-01	AFIF	ETF	8.8	8.83	8.8	8.81	13731.0
2023-05-01	AFK	ETF	15.85	15.99	15.67	15.6747	4254.0
2023-05-01	AFLG	ETF	24.225	24.225	24.225	24.225	100.0
2023-05-01	AFMC	ETF	23.1	23.1	23.01	23.047	8800.0
2023-05-01	AFSM	ETF	22.93	22.93	22.855	22.855	100.0
2023-05-01	AFTY	ETF	16.024	16.024	16.024	16.024	100.0
2023-05-01	AGG	ETF	99.35	99.41	98.6	98.69	10631600.0
2023-05-01	AGGY	ETF	43.71	43.74	43.394	43.43	86000.0
2023-05-01	AGNG	ETF	28.24	28.3	28.24	28.26	52600.0
2023-05-01	AGOV	ETF	78.0305	78.0305	78.0305	78.0305	103.0
2023-05-01	AGOX	ETF	21.816	21.89	21.78	21.81	28700.0
2023-05-01	AGQ	ETF	35.56	35.58	33.04	33.17	1031000.0
2023-05-01	AGZ	ETF	108.13	108.13	107.8053	107.81	119435.0
2023-05-01	AGZD	ETF	21.79	21.815	21.72	21.8	114600.0
2023-05-01	AHYB	ETF	43.842	43.842	43.713	43.713	1500.0
2023-05-01	AIA	ETF	58.45	59.0799	58.45	58.59	21401.0
2023-05-01	AIEQ	ETF	27.32	27.56	27.25	27.35	19500.0
2023-05-01	AIQ	ETF	23.85	23.9	23.7	23.77	71849.0
2023-05-01	AIRR	ETF	46.07	46.489	46.068	46.24	13100.0
2023-05-01	AIVI	ETF	40.65	40.65	40.51	40.55	3900.0

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

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