Fund liquidity — fund_liquidity_YYYYMMDD.txt.gz
One file of the SQXray data dictionary. Field list (.csv)
Fund liquidity — fund_liquidity_YYYYMMDD.txt.gz
A daily compressed file that shows, for each fund share class, how it would be sold, how long it takes to fully exit at normal size, the estimated cost of exiting at various position sizes, and the identifier linking it back to the holdings data.
| Field | Type | Nullable | Description | Example |
|---|---|---|---|---|
analysis_date | DATE | never blank | The date for which the row was computed. | 2026-08-13 |
fund_isin | VARCHAR(12) | never blank (key) | The share class's ISIN and this file's key: one row per fund_isin. The JOIN key for the fund reference file and every other share-class file. | US31635T5424 |
portfolio_id | BIGINT UNSIGNED | never blank | The identifier for the portfolio the holdings attach to. The JOIN key for the portfolio holdings and fund reference files. | 20834 |
net_assets | DECIMAL(22,2) | may be blank | Net assets from the fund's newest N-PORT Part A or sponsor file, in the currency beside it. A portfolio figure repeated on every share class of the portfolio: deduplicate by portfolio_id before summing. | 895915673.56 |
monthly_sales | DECIMAL(22,2) | may be blank | Shares sold in the newest filed month (N-PORT Part B or the sponsor's flow record), in the currency beside it. A portfolio figure repeated on every share class. Blank where no monthly flow is filed. | 500000000.00 |
monthly_redemptions | DECIMAL(22,2) | may be blank | Shares redeemed in the newest filed month, in the currency beside it; over 21 trading days it is the fund's daily redemption capacity. A portfolio figure repeated on every share class. Blank where unfiled. | 400000000.00 |
net_flow | DECIMAL(22,2) | may be blank | monthly_sales less monthly_redemptions for the same month, in the currency beside it. Negative is a net outflow. Blank where either side is unfiled. | 100000000.00 |
currency | CHAR(3) | may be blank | ISO 4217 code of the currency net_assets, monthly_sales, monthly_redemptions and net_flow are stated in: the filing's reporting currency, not the class's trading currency. Blank where the row has no filing behind it. | USD |
fx_rate | DECIMAL(18,9) | may be blank | Units of currency per 1 U.S. dollar, the rate behind this row's *_usd columns. A native figure divided by it is dollars. Blank where currency is blank or USD, and where no rate was found. | 159.085000000 |
exit_channel | ENUM | never blank | How this holder exits: on the exchange, at NAV, into a sponsor's bid, through a tender window, or at termination. | nav_redemption |
liquidity_tier | ENUM | never blank | The liquidity bucket for this exit channel. | thin |
exit_days_typical | DECIMAL(12,2) | may be blank | Days to be flat where size does not bind. Empty on the exchange and terminal channels. | 1.00 |
exit_capacity_usd_per_day | DECIMAL(22,2) | may be blank | Dollars of exit the venue absorbs per trading day: mean daily volume over the class's trailing 90 venue days on its own venue, times the price, in U.S. dollars. Exchange channel only; a wider net than stress_adv_usd. | 852793.37 |
exit_cost_status | ENUM | may be blank | Whether a cost curve could be built, else which input was missing, in precedence order. no_composite_tape: no U.S. composite print; awaiting_adv_history: volume history too short; fx_unavailable fires on no row today. | no_curve |
stress_adv_usd | DECIMAL(22,2) | may be blank | Stressed dollar ADV: p20 of trailing composite-tape daily dollar volume (~90 trading days); the curve conditioning. | 318571.00 |
daily_return_vol | DECIMAL(10,6) | may be blank | Realized daily close-close log-return stdev over the same window (fraction, not %). | 0.009003 |
exit_cost_bps_10k | DECIMAL(10,2) | may be blank | Cost to liquidate a $10,000 position under stress, in basis points. Exchange channel only, where exit_dtl_10k is a day count. Never above 10,000 bps: past the position's own value the cell censors. | 0.00 |
exit_dtl_10k | VARCHAR(24) | may be blank | Trading days to liquidate a $10,000 position under stress. A day count, '>250d', 'n/a: exceeds fund size', or 'n/a: cost exceeds value'. | 1 |
exit_cost_bps_100k | DECIMAL(10,2) | may be blank | Cost to liquidate a $100,000 position under stress, in basis points. Exchange channel only, where exit_dtl_100k is a day count. Never above 10,000 bps: past the position's own value the cell censors. | 0.00 |
exit_dtl_100k | VARCHAR(24) | may be blank | Trading days to liquidate a $100,000 position under stress. A day count, '>250d', 'n/a: exceeds fund size', or 'n/a: cost exceeds value'. | 1 |
exit_cost_bps_1m | DECIMAL(10,2) | may be blank | Cost to liquidate a $1 million position under stress, in basis points. Exchange channel only, where exit_dtl_1m is a day count. Never above 10,000 bps: past the position's own value the cell censors. | 0.00 |
exit_dtl_1m | VARCHAR(24) | may be blank | Trading days to liquidate a $1 million position under stress. A day count, '>250d', 'n/a: exceeds fund size', or 'n/a: cost exceeds value'. | 1 |
exit_cost_bps_10m | DECIMAL(10,2) | may be blank | Cost to liquidate a $10 million position under stress, in basis points. Exchange channel only, where exit_dtl_10m is a day count. Never above 10,000 bps: past the position's own value the cell censors. | 0.00 |
exit_dtl_10m | VARCHAR(24) | may be blank | Trading days to liquidate a $10 million position under stress. A day count, '>250d', 'n/a: exceeds fund size', or 'n/a: cost exceeds value'. | 1 |
exit_cost_bps_100m | DECIMAL(10,2) | may be blank | Cost to liquidate a $100 million position under stress, in basis points. Exchange channel only, where exit_dtl_100m is a day count. Never above 10,000 bps: past the position's own value the cell censors. | 0.00 |
exit_dtl_100m | VARCHAR(24) | may be blank | Trading days to liquidate a $100 million position under stress. A day count, '>250d', 'n/a: exceeds fund size', or 'n/a: cost exceeds value'. | 1 |
exit_cost_bps_1b | DECIMAL(10,2) | may be blank | Cost to liquidate a $1 billion position under stress, in basis points. Exchange channel only, where exit_dtl_1b is a day count. Never above 10,000 bps: past the position's own value the cell censors. | 0.00 |
exit_dtl_1b | VARCHAR(24) | may be blank | Trading days to liquidate a $1 billion position under stress. A day count, '>250d', 'n/a: exceeds fund size', or 'n/a: cost exceeds value'. | n/a: exceeds fund size |
next_liquidity_window_date | DATE | may be blank | The date the next repurchase window is expected to open. | 2026-09-30 |
per_window_capacity_pct | DECIMAL(8,4) | may be blank | Share of net assets that has cleared per repurchase window, averaged over recent windows. | 2.2168 |
capacity_cadence | VARCHAR(13) | may be blank | How often the exit channel delivers capacity. | monthly |
sponsor_bid_observed | TINYINT(1) | may be blank | 1 where a sponsor bid was seen in the mark window, 0 where none was. | 0 |
days_to_termination | INT | may be blank | Days to the fund's scheduled termination. Negative once it has passed. | -252 |
data_source | VARCHAR(32) | may be blank | Where the holdings behind this row came from: SEC for a filing, edinet for a Japanese filing, structural for a book derived from the product's structure, or a sponsor file (web:ishares). Same value as the holdings file. | web:ishares |
data_source_date | DATE | may be blank | The date the source is as of. | 2026-06-30 |
staleness_days | SMALLINT | may be blank | How old the newest holdings filing behind this row is, in days: the age of data_source_date. Blank where no filing exists; never published without data_source. No maximum age is applied; a client gates on it. | 194 |
liquidity_status | VARCHAR(32) | may be blank | The state of the liquidity measures, one slot in precedence order (the worst applicable value); read exit_cost_status too. net_assets_unknown, negative_flow and fx_unavailable are defined but fire on no row today. | no_filing |
Appendix: canonical values
| Field | Values |
|---|---|
liquidity_tier | deep, normal, thin, impaired, active, stressed, dormant, n/a, unrated |
capacity_cadence | daily, monthly, quarterly, discretionary, terminal |
exit_channel | exchange, nav_redemption, periodic_tender, sponsor_market, terminal |
exit_cost_status | no_curve, net_assets_unknown, fx_unavailable, no_composite_tape, awaiting_adv_history, awaiting_vol_history, ok |
liquidity_status | matured, no_filing, net_assets_unknown, awaiting_adv_history, no_flow_data, negative_flow, fx_unavailable, no_current_mark, sponsor_priced, ok |