Calculations › Market Discovery
Show all currency pairs tracked on the platform
The query
-- table market-wide: all currency pairs tracked
WITH latest AS (
SELECT DISTINCT ON (tp.ticketnameid) tp.ticketnameid, tp.price
FROM ticketprice tp JOIN ticketname tn ON tn.id = tp.ticketnameid
WHERE tn.tickettype = 'currency'
ORDER BY tp.ticketnameid, tp.datetime DESC
)
SELECT tn.ticket AS symbol, sm.currency_pair_base, sm.currency_pair_quote, l.price
FROM latest l
JOIN ticketname tn ON tn.id = l.ticketnameid
LEFT JOIN symbolmetadata sm ON sm.ticketnameid = l.ticketnameid
ORDER BY tn.ticket;
Runs against Cryptobi's market tables — ticketname (symbols),
ticketprice (daily prices and volume) and symbolmetadata
(sector, exchange, market cap and other reference fields).
Current output
| Symbol | Currency pair base | Currency pair quote | Price |
|---|---|---|---|
| AUDCAD=X | — | — | 0.99 |
| AUDEUR=X | EUR | USD | 0.61 |
| AUDUSD=X | AUD | USD | 0.69 |
| BRLUSD=X | BRL | USD | 0.19 |
| CADEUR=X | EUR | USD | 0.62 |
| CADSEK=X | — | — | 7.03 |
| CADUSD=X | CAD | USD | 0.70 |
| CHFUSD=X | CHF | USD | 1.20 |
| CNYUSD=X | CNY | USD | 0.15 |
| DKKUSD=X | DKK | USD | 0.15 |
| EURCAD=X | EUR | USD | 1.61 |
| EURSEK=X | EUR | USD | 11.34 |
| EURUSD=X | EUR | USD | 1.13 |
| GBPCAD=X | GBP | USD | 1.89 |
| GBPEUR=X | EUR | USD | 1.17 |
Live output, first 15 rows, refreshed periodically. Model estimates are trend projections from recent prices, not financial advice.
Run this on your own holdings, change it, or write your own in SQL or Python — then put it on a dashboard or have it emailed on a schedule. Free, no credit card.
Sign Up Free