ko_izi

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
gunluk AS (
    SELECT
        date,
        toFloat64(any(open))  AS acilis,
        toFloat64(any(close)) AS kapanis
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'KO'
      AND date >= '2021-01-01'
    GROUP BY date
),
onceki AS (
    SELECT
        date,
        acilis,
        lagInFrame(kapanis) OVER (ORDER BY date
                                  ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS onceki_kapanis
    FROM gunluk
),
temettuler AS (
    SELECT
        ex_dividend_date,
        max(toFloat64(cash_amount)) AS tutar
    FROM global_markets.stocks_dividends
    WHERE ticker = 'KO'
      AND currency = 'USD'
      AND cash_amount > 0
      AND ex_dividend_date >= '2021-01-01'
    GROUP BY ex_dividend_date
)
SELECT
    toString(o.date)                                   AS ex_date,
    concat(toString(toDayOfMonth(o.date)), ' ',
           arrayElement(['Oca','Şub','Mar','Nis','May','Haz','Tem','Ağu','Eyl','Eki','Kas','Ara'],
                        toMonth(o.date)), ' ',
           toString(toYear(o.date)))                   AS ex_gunu,
    round(t.tutar / o.onceki_kapanis * 100, 3)         AS temettu_orani_pct,
    round((o.acilis / o.onceki_kapanis - 1) * 100, 3)  AS acilis_degisim_pct
FROM onceki AS o
INNER JOIN temettuler AS t ON t.ex_dividend_date = o.date
WHERE o.onceki_kapanis > 0
ORDER BY o.date