PREVIEW / etf_daily / 2023-01-27

all etf daily files

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

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-27	SPY	ETF	403.66	408.16	403.44	405.68	68346200.0
2023-01-27	QQQ	ETF	292.0	298.26	291.88	296.26	56441939.0
2023-01-27	IWM	ETF	187.98	190.3	187.79	189.58	20019900.0
2023-01-27	DIA	ETF	339.4	341.54	338.16	339.61	2907400.0
2023-01-27	GLD	ETF	179.27	179.72	178.26	179.22	6052700.0
2023-01-27	TLT	ETF	106.19	106.96	106.11	106.71	11845500.0
2023-01-27	AAA	ETF	24.5879	24.5879	24.56	24.56	100.0
2023-01-27	AAAU	ETF	19.13	19.17	19.02	19.12	744800.0
2023-01-27	AADR	ETF	50.08	50.11	50.08	50.1	25000.0
2023-01-27	AAPB	ETF	18.31	18.93	18.31	18.6955	3782.0
2023-01-27	AAPD	ETF	27.42	27.42	26.67	26.9	211825.0
2023-01-27	AAPU	ETF	19.16	19.9371	19.16	19.68	116459.0
2023-01-27	AAXJ	ETF	72.85	73.03	72.53	72.83	1107100.0
2023-01-27	ABEQ	ETF	28.745	28.9	28.71	28.797	11900.0
2023-01-27	ACES	ETF	50.45	54.46	50.1	52.95	67600.0
2023-01-27	ACIO	ETF	29.79	29.87	29.701	29.753	31700.0
2023-01-27	ACSI	ETF	45.35	45.35	45.2255	45.2255	145.0
2023-01-27	ACT	ETF	24.76	25.1519	24.71	24.8	62195.0
2023-01-27	ACTV	ETF	31.76	32.1599	31.76	32.07	4969.0
2023-01-27	ACTX	ETF	0.4	0.4	0.4	0.4	2551.0
2023-01-27	ACVF	ETF	31.143	31.5	31.143	31.31	9700.0
2023-01-27	ACWF	ETF	33.89	34.03	33.87	33.95	6223.0
2023-01-27	ACWI	ETF	90.95	91.81	90.92	91.37	5553300.0
2023-01-27	ACWV	ETF	96.98	97.15	96.64	96.8	183300.0
2023-01-27	ACWX	ETF	49.8	50.01	49.68	49.9	1172390.0
2023-01-27	ADFI	ETF	8.6	8.61	8.585	8.585	5900.0
2023-01-27	ADIV	ETF	14.85	14.86	14.83	14.83	1100.0
2023-01-27	ADME	ETF	34.29	34.66	34.29	34.476	11300.0
2023-01-27	ADPV	ETF	25.15	25.165	25.15	25.165	52349.0
2023-01-27	ADRE	ETF	43.48	43.55	43.165	43.5	58449.0
2023-01-27	AEMB	ETF	39.51	39.51	39.46	39.46	400.0
2023-01-27	AESR	ETF	11.83	11.88	11.67	11.82	19500.0
2023-01-27	AFIF	ETF	8.875	8.89	8.87	8.87	10717.0
2023-01-27	AFK	ETF	17.5	17.5	17.35	17.35	6353.0
2023-01-27	AFMC	ETF	23.797	23.797	23.797	23.797	100.0
2023-01-27	AFSM	ETF	24.104	24.104	24.057	24.057	400.0
2023-01-27	AFTY	ETF	17.905	17.921	17.905	17.921	100.0
2023-01-27	AGG	ETF	99.96	100.14	99.91	100.08	5123100.0
2023-01-27	AGGH	ETF	22.639	22.639	22.6189	22.6189	1797.0
2023-01-27	AGGY	ETF	43.96	44.025	43.94	44.0	214200.0
2023-01-27	AGIH	ETF	24.78	24.78	24.78	24.78	101.0
2023-01-27	AGNG	ETF	26.955	26.955	26.943	26.943	150200.0
2023-01-27	AGOV	ETF	81.43	81.43	81.43	81.43	124.0
2023-01-27	AGOX	ETF	21.977	22.14	21.9	21.99	21600.0
2023-01-27	AGQ	ETF	30.78	30.98	29.99	30.76	757500.0
2023-01-27	AGZ	ETF	108.13	108.19	108.0903	108.18	15717.0
2023-01-27	AGZD	ETF	21.885	21.92	21.855	21.86	78000.0
2023-01-27	AHHX	ETF	8.715	8.715	8.6511	8.7039	2515.0
2023-01-27	AHYB	ETF	44.4	44.4	44.3	44.33	500.0
2023-01-27	AIA	ETF	67.35	67.4999	66.94	67.32	54002.0

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

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