PREVIEW / etf_daily / 2023-08-11

all etf daily files

  file:    by_date/etf_daily/2023/2023-08-11.parquet
  size:    107 KB
  rows:    2,985

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-08-11	SPY	ETF	443.97	446.7	443.35	445.65	68664600.0
2023-08-11	QQQ	ETF	365.99	368.0	364.69	366.24	48707187.0
2023-08-11	IWM	ETF	189.92	191.69	189.74	190.99	21789000.0
2023-08-11	DIA	ETF	351.19	353.72	350.61	353.0	2601900.0
2023-08-11	GLD	ETF	177.7	178.36	177.49	177.6	5289400.0
2023-08-11	TLT	ETF	95.3	95.87	95.2	95.37	26747800.0
2023-08-11	AAA	ETF	24.75	24.78	24.75	24.78	200.0
2023-08-11	AAAU	ETF	18.98	19.03	18.95	18.97	871700.0
2023-08-11	AADR	ETF	51.45	51.45	51.36	51.36	400.0
2023-08-11	AAPB	ETF	24.66	25.04	24.5918	24.92	10123.0
2023-08-11	AAPD	ETF	22.03	22.095	21.85	21.93	83031.0
2023-08-11	AAPU	ETF	25.26	25.55	25.1811	25.4	155166.0
2023-08-11	AAXJ	ETF	66.53	66.79	66.13	66.36	459900.0
2023-08-11	ABEQ	ETF	28.11	28.17	28.07	28.159	11200.0
2023-08-11	ACES	ETF	42.63	42.781	42.25	42.65	47100.0
2023-08-11	ACIO	ETF	31.14	31.307	31.14	31.22	165200.0
2023-08-11	ACSI	ETF	47.067	47.067	47.067	47.067	100.0
2023-08-11	ACT	ETF	28.77	29.11	28.69	28.96	133009.0
2023-08-11	ACTV	ETF	32.17	32.24	32.17	32.24	9400.0
2023-08-11	ACVF	ETF	34.186	34.24	34.1	34.154	9800.0
2023-08-11	ACWF	ETF	35.44	35.51	35.39	35.5	3913.0
2023-08-11	ACWI	ETF	95.92	96.39	95.8	96.11	912800.0
2023-08-11	ACWV	ETF	98.02	98.5	98.02	98.43	113000.0
2023-08-11	ACWX	ETF	49.16	49.35	49.07	49.17	889000.0
2023-08-11	ADFI	ETF	8.39	8.39	8.38	8.385	13300.0
2023-08-11	ADIV	ETF	13.607	13.607	13.607	13.607	100.0
2023-08-11	ADME	ETF	36.565	36.565	36.39	36.44	239900.0
2023-08-11	ADPV	ETF	25.1699	25.27	25.1101	25.1233	2456.0
2023-08-11	AEMB	ETF	37.46	37.47	37.333	37.36	800.0
2023-08-11	AESR	ETF	12.71	12.78	12.71	12.743	16700.0
2023-08-11	AFIF	ETF	8.88	8.96	8.88	8.93	22100.0
2023-08-11	AFK	ETF	15.32	15.48	15.12	15.12	2200.0
2023-08-11	AFLG	ETF	25.552	25.552	25.552	25.552	100.0
2023-08-11	AFMC	ETF	25.188	25.188	25.188	25.188	400.0
2023-08-11	AFSM	ETF	25.385	25.385	25.349	25.349	200.0
2023-08-11	AFTY	ETF	15.14	15.21	15.14	15.2	2500.0
2023-08-11	AGG	ETF	96.12	96.42	96.07	96.07	9016700.0
2023-08-11	AGGH	ETF	22.05	22.22	22.03	22.21	36535.0
2023-08-11	AGGY	ETF	42.47	42.57	42.461	42.47	78800.0
2023-08-11	AGNG	ETF	27.59	27.59	27.5	27.58	1900.0
2023-08-11	AGOV	ETF	74.75	74.75	74.75	74.75	3.0
2023-08-11	AGOX	ETF	23.44	23.51	23.4	23.43	17700.0
2023-08-11	AGQ	ETF	26.24	26.63	26.15	26.26	371000.0
2023-08-11	AGZ	ETF	106.32	106.45	106.32	106.34	14400.0
2023-08-11	AGZD	ETF	22.14	22.29	22.11	22.16	55000.0
2023-08-11	AHOY	ETF	20.64	20.6714	20.64	20.6714	304.0
2023-08-11	AHYB	ETF	43.94	43.971	43.94	43.971	200.0
2023-08-11	AIA	ETF	59.03	59.08	58.62	58.73	17200.0
2023-08-11	AIEQ	ETF	31.82	32.1	31.82	32.011	7500.0
2023-08-11	AIQ	ETF	27.67	27.76	27.525	27.59	236700.0

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

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