PREVIEW / etf_daily / 2023-12-15

all etf daily files

  file:    by_date/etf_daily/2023/2023-12-15.parquet
  size:    115 KB
  rows:    3,192

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-12-15	SPY	ETF	469.49	470.7	467.43	469.33	141319300.0
2023-12-15	QQQ	ETF	404.18	406.5399	403.57	405.34	62896645.0
2023-12-15	IWM	ETF	198.95	199.55	195.95	197.04	73854200.0
2023-12-15	DIA	ETF	371.74	373.39	371.33	372.63	6947600.0
2023-12-15	GLD	ETF	188.52	188.96	186.82	187.0	8323800.0
2023-12-15	TLT	ETF	98.69	99.35	98.58	99.15	59919700.0
2023-12-15	AAA	ETF	25.0	25.07	25.0	25.03	5600.0
2023-12-15	AAAU	ETF	20.15	20.19	19.97	19.99	1895300.0
2023-12-15	AADR	ETF	55.38	55.38	54.94	55.1	300.0
2023-12-15	AAPB	ETF	28.74	28.7587	28.48	28.48	10889.0
2023-12-15	AAPD	ETF	19.84	19.91	19.8	19.91	167107.0
2023-12-15	AAPU	ETF	28.84	28.9886	28.7	28.7	69545.0
2023-12-15	AAPY	ETF	27.21	27.2673	27.21	27.2673	653.0
2023-12-15	AAXJ	ETF	66.36	66.41	65.77	65.84	689900.0
2023-12-15	ABEQ	ETF	28.38	28.38	28.3	28.36	4600.0
2023-12-15	ACES	ETF	36.58	36.82	36.07	36.48	397300.0
2023-12-15	ACIO	ETF	32.9	32.99	32.85	32.95	207900.0
2023-12-15	ACT	ETF	28.65	28.79	28.31	28.5	502184.0
2023-12-15	ACTV	ETF	33.26	33.26	32.77	32.967	6000.0
2023-12-15	ACVF	ETF	35.96	36.22	35.96	36.146	24400.0
2023-12-15	ACWF	ETF	37.8502	37.855	37.75	37.762	4243.0
2023-12-15	ACWI	ETF	101.25	101.4	100.89	100.97	2759200.0
2023-12-15	ACWV	ETF	100.35	100.35	99.65	99.7	189700.0
2023-12-15	ACWX	ETF	50.66	50.74	50.37	50.37	1560300.0
2023-12-15	ADFI	ETF	8.58	8.58	8.55	8.565	11800.0
2023-12-15	ADIV	ETF	13.68	13.68	13.61	13.61	1100.0
2023-12-15	ADME	ETF	38.155	38.18	38.03	38.175	6400.0
2023-12-15	ADPV	ETF	24.38	24.38	24.32	24.3522	5752.0
2023-12-15	ADVE	ETF	30.92	30.92	30.83	30.83	4110.0
2023-12-15	AEMB	ETF	38.24	38.24	38.18	38.18	500.0
2023-12-15	AESR	ETF	13.65	13.69	13.61	13.63	30400.0
2023-12-15	AETH	ETF	33.39	33.5028	33.1467	33.5028	2845.0
2023-12-15	AFIF	ETF	8.96	9.0	8.96	8.96	10000.0
2023-12-15	AFK	ETF	13.99	14.07	13.91	14.04	5500.0
2023-12-15	AFLG	ETF	27.35	27.35	27.29	27.294	1100.0
2023-12-15	AFSM	ETF	26.88	26.88	26.88	26.88	600.0
2023-12-15	AFTY	ETF	13.38	13.38	13.32	13.32	300.0
2023-12-15	AGG	ETF	98.8	98.88	98.59	98.69	10079100.0
2023-12-15	AGGH	ETF	22.15	22.22	22.07	22.22	13713.0
2023-12-15	AGGY	ETF	43.95	44.02	43.9	43.95	138500.0
2023-12-15	AGNG	ETF	27.94	27.94	27.76	27.81	2600.0
2023-12-15	AGOX	ETF	24.14	24.26	24.09	24.215	29200.0
2023-12-15	AGQ	ETF	27.75	27.86	27.19	27.37	1506800.0
2023-12-15	AGQI	ETF	13.05	13.075	12.99	13.005	18035.0
2023-12-15	AGZ	ETF	107.9	108.03	107.87	108.0	41100.0
2023-12-15	AGZD	ETF	21.99	22.01	21.77	21.95	134100.0
2023-12-15	AHLT	ETF	23.8399	23.8399	23.74	23.763	1720.0
2023-12-15	AHOY	ETF	21.5389	21.5389	21.4627	21.4627	101.0
2023-12-15	AHYB	ETF	45.375	45.385	45.32	45.341	1100.0
2023-12-15	AIA	ETF	57.41	57.66	57.08	57.16	12800.0

> showing 50 of 3,192 rows — these rows as CSV

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