PREVIEW / etf_daily / 2023-01-12

all etf daily files

  file:    by_date/etf_daily/2023/2023-01-12.parquet
  size:    108 KB
  rows:    2,915

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-01-12	SPY	ETF	396.67	398.49	392.42	396.96	90157700.0
2023-01-12	QQQ	ETF	278.12	280.1	273.74	279.05	60599953.0
2023-01-12	IWM	ETF	183.57	185.95	181.92	185.83	29650800.0
2023-01-12	DIA	ETF	340.88	343.0	337.95	342.0	4332600.0
2023-01-12	GLD	ETF	176.01	176.71	174.88	176.64	6936900.0
2023-01-12	TLT	ETF	105.82	107.81	104.56	107.76	32029600.0
2023-01-12	AAA	ETF	24.42	24.44	24.4199	24.44	989.0
2023-01-12	AAAU	ETF	18.77	18.85	18.66	18.84	625000.0
2023-01-12	AADR	ETF	49.55	49.55	49.38	49.38	400.0
2023-01-12	AAPB	ETF	15.8	16.18	15.75	16.0743	3619.0
2023-01-12	AAPD	ETF	29.28	29.82	29.21	29.42	224010.0
2023-01-12	AAPU	ETF	17.4	17.43	16.9	17.29	75464.0
2023-01-12	AAXJ	ETF	70.06	70.29	69.34	70.23	1037300.0
2023-01-12	ABEQ	ETF	28.64	28.99	28.64	28.914	8800.0
2023-01-12	ACES	ETF	49.65	50.66	48.84	50.62	26800.0
2023-01-12	ACIO	ETF	29.32	29.39	29.18	29.35	27400.0
2023-01-12	ACSI	ETF	43.6384	43.6384	43.6384	43.6384	30.0
2023-01-12	ACT	ETF	23.86	24.31	23.86	24.21	59153.0
2023-01-12	ACTV	ETF	31.17	31.36	31.1	31.36	9120.0
2023-01-12	ACVF	ETF	30.75	30.95	30.73	30.828	2700.0
2023-01-12	ACWF	ETF	33.12	33.24	33.05	33.1725	3962.0
2023-01-12	ACWI	ETF	89.12	89.53	88.11	89.29	5230700.0
2023-01-12	ACWV	ETF	96.97	97.2	96.35	96.94	296300.0
2023-01-12	ACWX	ETF	48.48	48.805	47.99	48.72	1440841.0
2023-01-12	ADFI	ETF	8.55	8.59	8.55	8.59	13300.0
2023-01-12	ADME	ETF	34.13	34.13	33.85	33.99	19400.0
2023-01-12	ADPV	ETF	25.15	25.3	25.15	25.2	55505.0
2023-01-12	ADRE	ETF	41.38	42.1822	41.38	42.06	11213.0
2023-01-12	AEMB	ETF	38.66	39.04	38.66	39.035	300.0
2023-01-12	AESR	ETF	11.675	11.75	11.67	11.7	21300.0
2023-01-12	AFIF	ETF	8.82	8.835	8.82	8.835	23659.0
2023-01-12	AFK	ETF	17.05	17.3	17.05	17.25	7493.0
2023-01-12	AFLG	ETF	23.83	23.96	23.79	23.883	3000.0
2023-01-12	AFMC	ETF	23.32	23.32	23.23	23.286	300.0
2023-01-12	AFSM	ETF	23.67	23.705	23.67	23.705	700.0
2023-01-12	AFTY	ETF	17.124	17.124	17.124	17.124	100.0
2023-01-12	AGG	ETF	99.84	100.53	99.49	100.29	8342700.0
2023-01-12	AGGH	ETF	22.86	22.86	22.86	22.86	121.0
2023-01-12	AGGY	ETF	43.92	44.13	43.835	44.04	144800.0
2023-01-12	AGNG	ETF	26.66	26.874	26.64	26.874	152800.0
2023-01-12	AGOV	ETF	81.1913	81.1913	81.1913	81.1913	68.0
2023-01-12	AGOX	ETF	21.37	21.55	21.28	21.46	11600.0
2023-01-12	AGQ	ETF	31.76	31.92	30.9	31.44	807300.0
2023-01-12	AGZ	ETF	107.97	108.22	107.8	108.22	13885.0
2023-01-12	AGZD	ETF	21.845	21.885	21.8	21.885	234400.0
2023-01-12	AHHX	ETF	8.66	8.719	8.65	8.7051	2909.0
2023-01-12	AHYB	ETF	44.52	44.595	44.52	44.595	800.0
2023-01-12	AIA	ETF	63.58	63.876	62.93	63.74	101958.0
2023-01-12	AIEQ	ETF	30.65	30.98	30.229	30.971	3900.0
2023-01-12	AIQ	ETF	21.7	21.92	21.55	21.73	23325.0

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

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