mandate_track

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.

SELECT
    toString(c.month)                                                  AS month,
    concat(arrayElement(['Jan','Feb','Mac','Apr','Mei','Jun','Jul','Ogos','Sep','Okt','Nov','Dis'], toMonth(c.month)), ' ',
           toString(toYear(c.month)))                                  AS month_label,
    round(c.cpi_yoy_pct, 1)                                            AS cpi_yoy_pct,
    round(j.unemployment_pct, 1)                                       AS unemployment_pct
FROM
(
    SELECT
        toStartOfMonth(date)                              AS month,
        argMax(toFloat64(cpi_year_over_year), date)       AS cpi_yoy_pct
    FROM global_markets.inflation
    WHERE date >= '2021-01-01'
      AND toFloat64(cpi_year_over_year) != 0
    GROUP BY month
) AS c
INNER JOIN
(
    SELECT
        toStartOfMonth(date)                              AS month,
        argMax(toFloat64(unemployment_rate), date)        AS unemployment_pct
    FROM global_markets.labor_market
    WHERE date >= '2021-01-01'
      AND toFloat64(unemployment_rate) > 0
    GROUP BY month
) AS j ON c.month = j.month
ORDER BY c.month ASC