One filer's reported Apple position, quarter by quarter

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
    period_end                                            AS date,
    formatDateTime(period_end, '%b %Y')                   AS quarter,
    round(argMax(acc_shares, (filed, acc)) / 1000000, 1)  AS shares_millions,
    formatDateTime(max(filed), '%b %e, %Y')               AS reported_on
FROM
(
    SELECT
        toDate(period)                              AS period_end,
        accession_number                            AS acc,
        max(toDate(filing_date))                    AS filed,
        sum(toFloat64(shares_or_principal_amount))  AS acc_shares
    FROM global_markets.stocks_13f_filings
    WHERE form_type = '13F-HR'
      AND cusip IN ('037833100', '37833100')
      AND filer_cik IN ('1067983', '0001067983')
      AND toDate(period) >= '2021-01-01'
    GROUP BY period_end, acc
)
GROUP BY period_end
ORDER BY period_end