Follow the example
Choose a step to follow the example. Opening a request lets you review it; it does not submit a job or change your account.
Keep the full pair
Read the base and quote currencies on this page. A USD price and an ETH price have different units; carry this exact pair into every indicator and action.
A catalog observation date and source, not an unqualified live-price claim.
Inspect dated price rows
Use the SQL below to inspect opening, high, low, close and volume over one explicit month. Check the first and last returned dates before choosing a test window.
- Trading pair
- BTC-GBP
- Historical source
- polygon
- Pair catalog last observed
- 2026-10-10
Dated data rows for this pair, or a visible missing-coverage result.
SELECT symbol, date, openingPrice, highestPrice, lowestPrice, closingPrice, tradingVolume
FROM lake.crypto_daily
WHERE symbol = 'BTC-GBP'
AND date >= TIMESTAMP '2024-01-01'
AND date < TIMESTAMP '2024-02-01'
ORDER BY date
LIMIT 31;Choose an existing tested rule
Open a completed strategy for this pair when one is linked. For a new idea, request an inactive preview with explicit entry, exit, capital and fees.
A relevant saved example or a proposed draft. Missing pair-specific backtest evidence stays missing.
Trading pair overview
Bitcoin (BTC) is a digital currency transferred over a peer-to-peer network. Transactions are recorded on a public blockchain and confirmed through mining. Wallets use private keys to authorize transfers. This pair quotes BTC in GBP.
Read the trading pair
BTC-GBP prices one unit of BTC in GBP. A price in a USD pair and a price in an ETH pair use different units. Keep this exact pair in the data query, strategy and test.
The pair catalog records flat-file data presence and the date the pair was observed. Inspect dated price rows to choose a test window.
Inspect BTC-GBP daily price rows
This query reads one stated month from the daily dataset. Change the dates to your proposed test window, then inspect the first and last returned dates and daily closes. The query is an inspection example; opening this page does not submit it.
SELECT symbol, date, openingPrice, highestPrice, lowestPrice, closingPrice, tradingVolume
FROM lake.crypto_daily
WHERE symbol = 'BTC-GBP'
AND date >= TIMESTAMP '2024-01-01'
AND date < TIMESTAMP '2024-02-01'
ORDER BY date
LIMIT 31;Test explicit strategy rules
Choose the pair, observation interval, starting capital, entry rules and exit rules before comparing historical results. Report the tested window and modeled fees with the result.