mapato_miaka_mitano

Name: mapato_miaka_mitano
Creator: Strasmore
Published: 2026-09-24
License: https://www.strasmore.com/terms/

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-09-24, from index-funds-for-kenyan-investors.

as of 2026-09-24 table 4×7read in context →

mapato_miaka_mitano — 4 rows by 7 columns, computed 2026-09-24 from US exchange, SIP and OPRA data.
ticker	tarehe_mwanzo	tarehe_mwisho	bei_pct	gawio_pct	jumla_pct	jumla_baada_kodi_pct
QQQ	2020-09-24	2026-09-24	176.5	5.6	182.1	180.4
VOO	2020-09-24	2026-09-24	135.8	12.7	148.5	144.7
SPY	2020-09-24	2026-09-24	136.1	12.4	148.5	144.8
SCHD	2020-09-24	2026-09-24	86.3	30.8	117.1	107.9

Rows × columns: 4 × 7
Period covered: 2020-09-24
Computed: 2026-09-24
Completeness: No missing values
Source: US exchange, SIP and OPRA market data
Licence: Strasmore terms · free, no signup
Formats: JSON · CSV · the SQL below

What each column holds

Column definitions for mapato_miaka_mitano, derived from the stored result.
Column	Type	Range	Notes
`ticker`	text	4 distinct values (QQQ, SCHD, SPY…)
`tarehe_mwanzo`	date	2020-09-24
`tarehe_mwisho`	date	2026-09-24
`bei_pct`	number	86.3 to 176.5	percent
`gawio_pct`	number	5.6 to 30.8	percent
`jumla_pct`	number	117.1 to 182.1	percent
`jumla_baada_kodi_pct`	number	107.9 to 180.4	percent

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on 2026-09-24, and the query below is what returned them.

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 mwanzo AS
(
    SELECT
        ticker,
        argMin(toFloat64(close), date) AS bei_mwanzo,
        toString(min(date))            AS tarehe_mwanzo
    FROM global_markets.stocks_daily_aggs
    WHERE ticker IN ('VOO', 'SPY', 'QQQ', 'SCHD')
      AND date >= '2020-09-24'
      AND date <  '2020-10-06'
    GROUP BY ticker
),
mwisho AS
(
    SELECT
        ticker,
        argMax(toFloat64(close), date) AS bei_mwisho,
        toString(max(date))            AS tarehe_mwisho
    FROM global_markets.stocks_daily_aggs
    WHERE ticker IN ('VOO', 'SPY', 'QQQ', 'SCHD')
      AND date >= today() - 30
    GROUP BY ticker
),
gawio AS
(
    SELECT
        ticker,
        sum(kiasi) AS jumla_gawio
    FROM
    (
        SELECT
            ticker,
            id,
            max(ifNull(nullIf(toFloat64(split_adjusted_cash_amount), 0.), toFloat64(cash_amount))) AS kiasi
        FROM global_markets.stocks_dividends
        WHERE ticker IN ('VOO', 'SPY', 'QQQ', 'SCHD')
          AND ex_dividend_date >= '2020-09-24'
          AND ex_dividend_date <= today()
        GROUP BY ticker, id
    )
    GROUP BY ticker
)
SELECT
    m.ticker                                                                            AS ticker,
    m.tarehe_mwanzo                                                                     AS tarehe_mwanzo,
    w.tarehe_mwisho                                                                     AS tarehe_mwisho,
    round(100 * (w.bei_mwisho / m.bei_mwanzo - 1), 1)                                   AS bei_pct,
    round(100 * g.jumla_gawio / m.bei_mwanzo, 1)                                        AS gawio_pct,
    round(100 * ((w.bei_mwisho + g.jumla_gawio) / m.bei_mwanzo - 1), 1)                 AS jumla_pct,
    round(100 * ((w.bei_mwisho + 0.70 * g.jumla_gawio) / m.bei_mwanzo - 1), 1)          AS jumla_baada_kodi_pct
FROM mwanzo AS m
INNER JOIN mwisho AS w ON w.ticker = m.ticker
INNER JOIN gawio  AS g ON g.ticker = m.ticker
ORDER BY jumla_pct DESC

SQL to run

WITH mwanzo AS
(
    SELECT
        ticker,
        argMin(toFloat64(close), date) AS bei_mwanzo,
        toString(min(date))            AS tarehe_mwanzo
    FROM global_markets.stocks_daily_aggs
    WHERE ticker IN ('VOO', 'SPY', 'QQQ', 'SCHD')
      AND date >= '2020-09-24'
      AND date <  '2020-10-06'
    GROUP BY ticker
),
mwisho AS
(
    SELECT
        ticker,
        argMax(toFloat64(close), date) AS bei_mwisho,
        toString(max(date))            AS tarehe_mwisho
    FROM global_markets.stocks_daily_aggs
    WHERE ticker IN ('VOO', 'SPY', 'QQQ', 'SCHD')
      AND date >= today() - 30
    GROUP BY ticker
),
gawio AS
(
    SELECT
        ticker,
        sum(kiasi) AS jumla_gawio
    FROM
    (
        SELECT
            ticker,
            id,
            max(ifNull(nullIf(toFloat64(split_adjusted_cash_amount), 0.), toFloat64(cash_amount))) AS kiasi
        FROM global_markets.stocks_dividends
        WHERE ticker IN ('VOO', 'SPY', 'QQQ', 'SCHD')
          AND ex_dividend_date >= '2020-09-24'
          AND ex_dividend_date <= today()
        GROUP BY ticker, id
    )
    GROUP BY ticker
)
SELECT
    m.ticker                                                                            AS ticker,
    m.tarehe_mwanzo                                                                     AS tarehe_mwanzo,
    w.tarehe_mwisho                                                                     AS tarehe_mwisho,
    round(100 * (w.bei_mwisho / m.bei_mwanzo - 1), 1)                                   AS bei_pct,
    round(100 * g.jumla_gawio / m.bei_mwanzo, 1)                                        AS gawio_pct,
    round(100 * ((w.bei_mwisho + g.jumla_gawio) / m.bei_mwanzo - 1), 1)                 AS jumla_pct,
    round(100 * ((w.bei_mwisho + 0.70 * g.jumla_gawio) / m.bei_mwanzo - 1), 1)          AS jumla_baada_kodi_pct
FROM mwanzo AS m
INNER JOIN mwisho AS w ON w.ticker = m.ticker
INNER JOIN gawio  AS g ON g.ticker = m.ticker
ORDER BY jumla_pct DESC

⌘/Ctrl + Enter

Work with this data in your AI assistant

Opens ready to query, with this page's data. Free, no account.

Claude ChatGPT Gemini Muse Your own agent