Calculations › Market Trends

Show the price trend for a symbol in the market over the last 30 days (edit the symbol)

The query

SELECT to_timestamp(tp.datetime)::date AS date, tp.price
FROM ticketname tn JOIN ticketprice tp ON tp.ticketnameid = tn.id
WHERE tn.ticket = 'BTC-USD'
  AND tp.datetime >= EXTRACT(EPOCH FROM (NOW() - INTERVAL '30 days'))::bigint
ORDER BY date;

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

DatePrice
2026-09-01 77403.62
2026-09-02 77300.48
2026-09-03 81271.74
2026-09-04 79671.97
2026-09-05 79823.87
2026-09-06 80350.05
2026-09-07 79115.85
2026-09-08 78438.58
2026-09-09 78259.52
2026-09-10 76568.12
2026-09-11 77173.80
2026-09-12 77270.47
2026-09-13 76838.16
2026-09-14 78163.38
2026-09-15 75612.51

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

Related calculations