kontrata

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

WITH huling_araw AS
(
    SELECT
        ticker,
        max(date) AS araw
    FROM global_markets.stocks_daily_aggs
    WHERE ticker IN ('AAPL', 'MSFT', 'NVDA', 'KO', 'SPY')
      AND date >= today() - 21
    GROUP BY ticker
)
SELECT
    s.ticker                                                   AS symbol,
    formatDateTime(max(s.date), '%b %e, %Y')                   AS petsa_label,
    round(argMax(toFloat64(s.close), s._ingest_time), 2)       AS close_usd,
    round(argMax(toFloat64(s.close), s._ingest_time) * 100, 2) AS position_size_usd
FROM global_markets.stocks_daily_aggs AS s
INNER JOIN huling_araw AS h
    ON h.ticker = s.ticker AND h.araw = s.date
GROUP BY s.ticker
ORDER BY position_size_usd DESC