PREVIEW / etf_daily / 2023-03-27

all etf daily files

  file:    by_date/etf_daily/2023/2023-03-27.parquet
  size:    109 KB
  rows:    2,948

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-03-27	SPY	ETF	398.12	398.92	395.56	396.49	74010400.0
2023-03-27	QQQ	ETF	311.6	312.7	307.89	308.76	50287407.0
2023-03-27	IWM	ETF	173.84	174.73	172.36	173.7	33880600.0
2023-03-27	DIA	ETF	324.59	325.57	323.3	324.31	3550900.0
2023-03-27	GLD	ETF	181.15	182.15	180.69	181.95	6925000.0
2023-03-27	TLT	ETF	105.05	105.76	104.33	104.34	22224500.0
2023-03-27	AAA	ETF	24.525	24.525	24.525	24.525	3.0
2023-03-27	AAAU	ETF	19.34	19.44	19.28	19.41	2664400.0
2023-03-27	AADR	ETF	46.04	46.69	46.03	46.52	4800.0
2023-03-27	AAPB	ETF	21.55	21.55	21.1189	21.1189	957.0
2023-03-27	AAPD	ETF	24.34	24.65	24.24	24.63	149689.0
2023-03-27	AAPU	ETF	22.3	22.45	21.87	21.96	96468.0
2023-03-27	AAXJ	ETF	66.32	66.36	65.99	66.3	256400.0
2023-03-27	ABEQ	ETF	27.45	27.57	27.45	27.483	6200.0
2023-03-27	ACES	ETF	44.42	44.42	43.41	43.83	110000.0
2023-03-27	ACIO	ETF	29.68	29.75	29.64	29.66	20500.0
2023-03-27	ACSI	ETF	43.0353	43.0353	43.0353	43.0353	26.0
2023-03-27	ACT	ETF	22.59	22.8	22.37	22.58	70280.0
2023-03-27	ACTV	ETF	28.565	28.785	28.5101	28.6643	3945.0
2023-03-27	ACTX	ETF	0.2935	0.2935	0.2935	0.2935	253.0
2023-03-27	ACVF	ETF	30.6	30.6	30.477	30.477	3600.0
2023-03-27	ACWF	ETF	32.78	32.78	32.62	32.6719	2607.0
2023-03-27	ACWI	ETF	88.48	88.66	88.06	88.37	1570500.0
2023-03-27	ACWV	ETF	95.28	95.3	94.98	95.11	173700.0
2023-03-27	ACWX	ETF	47.3	47.43	47.15	47.4	1141662.0
2023-03-27	ADFI	ETF	8.47	8.47	8.455	8.455	2300.0
2023-03-27	ADIV	ETF	13.669	13.669	13.669	13.669	100.0
2023-03-27	ADME	ETF	34.07	34.08	33.89	33.92	6600.0
2023-03-27	ADPV	ETF	22.79	22.8	22.78	22.789	20007.0
2023-03-27	ADRE	ETF	38.12	38.24	38.015	38.24	25234.0
2023-03-27	AESR	ETF	11.64	11.67	11.585	11.64	6300.0
2023-03-27	AFIF	ETF	8.71	8.76	8.71	8.72	17649.0
2023-03-27	AFK	ETF	15.51	15.51	15.31	15.41	16939.0
2023-03-27	AFLG	ETF	23.28	23.28	23.262	23.262	200.0
2023-03-27	AFMC	ETF	22.47	22.47	22.43	22.43	400.0
2023-03-27	AFSM	ETF	22.779	22.779	22.779	22.779	200.0
2023-03-27	AFTY	ETF	15.97	16.037	15.97	16.037	800.0
2023-03-27	AGG	ETF	99.39	99.52	99.07	99.08	6823400.0
2023-03-27	AGGH	ETF	22.96	22.96	22.93	22.9555	3009.0
2023-03-27	AGGY	ETF	43.61	43.62	43.45	43.47	125700.0
2023-03-27	AGNG	ETF	26.35	26.421	26.35	26.386	900.0
2023-03-27	AGOV	ETF	77.645	77.645	76.0	76.5123	1880.0
2023-03-27	AGOX	ETF	21.03	21.23	21.03	21.133	25200.0
2023-03-27	AGQ	ETF	28.39	28.78	28.2	28.75	394000.0
2023-03-27	AGZ	ETF	108.18	108.36	108.09	108.14	73524.0
2023-03-27	AGZD	ETF	21.72	21.74	21.62	21.715	94800.0
2023-03-27	AHHX	ETF	8.38	8.38	8.3	8.34	888.0
2023-03-27	AHYB	ETF	43.294	43.294	43.148	43.148	500.0
2023-03-27	AIA	ETF	59.72	59.86	59.4	59.645	20854.0
2023-03-27	AIEQ	ETF	28.6	28.6	27.9	28.054	17000.0

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

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