PREVIEW / etf_daily / 2022-03-17

all etf daily files

  file:    by_date/etf_daily/2022/2022-03-17.parquet
  size:    100 KB
  rows:    2,663

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
2022-03-17	SPY	ETF	433.59	441.07	433.19	441.07	102676900.0
2022-03-17	QQQ	ETF	338.37	344.5	337.0406	344.44	67809951.0
2022-03-17	IWM	ETF	200.77	205.21	200.3	205.11	25783100.0
2022-03-17	DIA	ETF	339.94	345.59	339.61	345.45	6032900.0
2022-03-17	GLD	ETF	181.16	182.03	180.65	180.89	10954100.0
2022-03-17	TLT	ETF	132.82	133.34	131.07	131.83	19330600.0
2022-03-17	AAA	ETF	24.86	24.89	24.86	24.89	614.0
2022-03-17	AAAU	ETF	19.29	19.38	19.24	19.26	617700.0
2022-03-17	AADR	ETF	57.26	58.63	57.1	58.48	8300.0
2022-03-17	AAXJ	ETF	75.17	75.32	74.17	75.24	3273900.0
2022-03-17	ABEQ	ETF	29.139	29.43	29.139	29.43	12800.0
2022-03-17	ACES	ETF	58.69	60.95	58.69	60.89	172000.0
2022-03-17	ACIO	ETF	30.79	30.94	30.63	30.94	36200.0
2022-03-17	ACSI	ETF	49.2252	49.2252	49.2252	49.2252	26.0
2022-03-17	ACT	ETF	22.08	22.39	21.75	21.88	95888.0
2022-03-17	ACTV	ETF	35.25	35.5441	35.18	35.5441	3936.0
2022-03-17	ACTX	ETF	0.78	0.78	0.78	0.78	122.0
2022-03-17	ACVF	ETF	32.72	33.11	32.7	33.11	2200.0
2022-03-17	ACWF	ETF	36.29	36.65	36.29	36.5828	12440.0
2022-03-17	ACWI	ETF	96.39	97.85	96.21	97.85	3482600.0
2022-03-17	ACWV	ETF	102.29	103.49	102.08	103.43	171100.0
2022-03-17	ACWX	ETF	51.21	51.88	51.17	51.82	2761385.0
2022-03-17	ADFI	ETF	9.055	9.055	9.055	9.055	100.0
2022-03-17	ADIV	ETF	15.31	15.419	15.31	15.419	400.0
2022-03-17	ADME	ETF	39.8	40.15	39.711	40.094	25300.0
2022-03-17	ADRE	ETF	42.74	43.0316	42.165	42.95	8584.0
2022-03-17	AEMB	ETF	42.61	43.079	42.56	43.079	1300.0
2022-03-17	AESR	ETF	12.81	13.0	12.81	12.99	5600.0
2022-03-17	AFIF	ETF	9.25	9.25	9.24	9.245	5561.0
2022-03-17	AFK	ETF	20.99	20.99	20.72	20.95	6912.0
2022-03-17	AFLG	ETF	26.07	26.159	26.07	26.159	200.0
2022-03-17	AFTY	ETF	18.23	18.23	18.03	18.11	1200.0
2022-03-17	AGG	ETF	107.85	108.06	107.73	107.86	8035400.0
2022-03-17	AGGY	ETF	48.19	48.36	48.17	48.24	173900.0
2022-03-17	AGNG	ETF	27.665	27.91	27.665	27.91	2500.0
2022-03-17	AGOV	ETF	83.7927	83.7927	83.7927	83.7927	5.0
2022-03-17	AGOX	ETF	23.497	23.79	23.29	23.67	29300.0
2022-03-17	AGQ	ETF	40.26	41.11	40.12	40.17	869400.0
2022-03-17	AGZ	ETF	113.52	113.56	113.26	113.39	25127.0
2022-03-17	AGZD	ETF	23.09	23.255	23.09	23.2	85200.0
2022-03-17	AHHX	ETF	9.46	9.56	9.45	9.4805	28479.0
2022-03-17	AHYB	ETF	47.36	47.536	47.36	47.536	700.0
2022-03-17	AIA	ETF	68.75	69.04	67.9	68.9	73946.0
2022-03-17	AIEQ	ETF	35.86	36.46	35.789	36.432	11500.0
2022-03-17	AIQ	ETF	25.7	26.13	25.7	26.123	13024.0
2022-03-17	AIRR	ETF	43.39	43.91	43.33	43.83	10900.0
2022-03-17	AIVI	ETF	39.94	40.44	39.94	40.32	10600.0
2022-03-17	AIVL	ETF	96.54	97.9	96.54	97.82	9100.0
2022-03-17	ALTL	ETF	42.94	43.9199	42.8672	43.8677	57027.0
2022-03-17	ALTY	ETF	12.55	12.72	12.55	12.693	10500.0

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

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