delete_symbols

---

function backtide.storage.delete_symbols(symbol=None, interval=None, provider=None, series=None)

Delete bars (and orphaned dividends) from the database.

Accepts either individual arguments for a single symbol (or list of symbols), or a series list of (symbol, interval, provider) triples for bulk deletion. All deletions run in a single database transaction.

Parameters

symbol : str | list[str] | None = None One or more symbols to delete. Mutually exclusive with series. interval : str | Interval | None = None The bar interval to remove. Applies to every symbol when symbol is given. Ignored when series is given. provider : str | Provider | None = None The data provider to remove. Applies to every symbol when symbol is given. Ignored when series is given. series : list[tuple[str, str, str]] | None = None Explicit list of (symbol, interval, provider) triples to delete. Mutually exclusive with symbol.

Returns

int Number of bar rows deleted.

See Also

download_bars

Download OHLCV data for the instruments described in a list of profiles.

query_bars

Return stored OHLCV bars as a dataframe.

query_dividends

Return stored dividend events as a dataframe.

Example

>>> from backtide.storage import delete_symbols

>>> # Delete all stored data for a single symbol
>>> delete_symbols("AAPL")  

>>> # Delete daily bars for multiple symbols
>>> delete_symbols(["BTC-USDT", "ETH-USDT"], interval="1d")  

>>> # Bulk-delete specific series
>>> delete_symbols(series=[("AAPL", "1d", "yahoo"), ("MSFT", "1h", "yahoo")])