배당락일에 주식을 매수하면 배당금을 받을 수 있을까

SELECT
    toString(m)                                            AS month,
    formatDateTime(m, '%b %Y')                             AS month_label,
    count()                                                AS dividend_count,
    round(avg(dateDiff('day', ex_dt, rec_dt)), 2)          AS avg_calendar_days_ex_to_record,
    round(100 * countIf(rec_dt = ex_dt) / count(), 1)      AS same_day_pct
FROM
(
    SELECT
        toStartOfMonth(any(ex_dividend_date)) AS m,
        any(ex_dividend_date)                 AS ex_dt,
        any(record_date)                      AS rec_dt
    FROM global_markets.stocks_dividends
    WHERE ticker IN ('AAPL', 'MSFT', 'KO', 'JNJ', 'PG', 'PEP', 'JPM', 'XOM', 'CVX', 'HD',
                     'MCD', 'WMT', 'IBM', 'CSCO', 'VZ', 'MRK', 'PFE', 'ABBV', 'TXN', 'LLY')
      AND ex_dividend_date >= '2023-06-01'
      AND ex_dividend_date <  today()
    GROUP BY id
)
WHERE rec_dt >= ex_dt
GROUP BY m
ORDER BY m

SELECT
    toString(d.ex_dt)                                    AS ex_date,
    formatDateTime(d.ex_dt, '%W')                        AS weekday,
    formatDateTime(d.decl_dt, '%b %e, %Y')               AS declared_label,
    formatDateTime(d.ex_dt, '%b %e, %Y')                 AS ex_label,
    formatDateTime(d.rec_dt, '%a, %b %e')                AS record_label,
    formatDateTime(d.pay_dt, '%b %e')                    AS pay_label,
    d.cash                                               AS cash_amount,
    dateDiff('day', d.ex_dt, d.rec_dt)                   AS days_ex_to_record,
    formatDateTime(px.prior_sess, '%a, %b %e')           AS last_session_with_dividend,
    formatDateTime(px.next_sess, '%a, %b %e')            AS buy_on_ex_settles,
    dateDiff('day', d.rec_dt, px.next_sess)              AS settles_days_after_record,
    dateDiff('day', d.rec_dt, d.pay_dt)                  AS days_record_to_pay
FROM
(
    SELECT
        any(ex_dividend_date)                 AS ex_dt,
        any(declaration_date)                 AS decl_dt,
        any(record_date)                      AS rec_dt,
        any(pay_date)                         AS pay_dt,
        round(toFloat64(any(cash_amount)), 4) AS cash
    FROM global_markets.stocks_dividends
    WHERE ticker = 'AAPL'
      AND ex_dividend_date >= '2024-06-01'
      AND ex_dividend_date <  today() - 3
    GROUP BY id
) AS d
INNER JOIN
(
    SELECT
        sess,
        lagInFrame(sess, 1)  OVER (ORDER BY sess ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS prior_sess,
        leadInFrame(sess, 1) OVER (ORDER BY sess ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS next_sess
    FROM
    (
        SELECT date AS sess
        FROM global_markets.stocks_daily_aggs
        WHERE ticker = 'AAPL'
          AND date >= '2024-05-01'
          AND date <  today()
        GROUP BY date
    )
) AS px ON px.sess = d.ex_dt
WHERE px.next_sess > px.sess
  AND px.prior_sess >= toDate('2024-05-01')
ORDER BY d.ex_dt DESC
LIMIT 8

SELECT
    arrayJoin([toString(d.sym), 'All 20 combined'])                                  AS label,
    count()                                                                          AS ex_date_count,
    round(avg(100 * toFloat64(d.cash) / toFloat64(px.prior_close)), 2)               AS avg_dividend_pct_of_price,
    round(avg(100 * (toFloat64(px.ex_open) / toFloat64(px.prior_close) - 1)), 2)     AS avg_close_to_open_pct
FROM
(
    SELECT
        any(ticker)           AS sym,
        any(ex_dividend_date) AS ex_dt,
        any(cash_amount)      AS cash
    FROM global_markets.stocks_dividends
    WHERE ticker IN ('AAPL', 'MSFT', 'KO', 'JNJ', 'PG', 'PEP', 'JPM', 'XOM', 'CVX', 'HD',
                     'MCD', 'WMT', 'IBM', 'CSCO', 'VZ', 'MRK', 'PFE', 'ABBV', 'TXN', 'LLY')
      AND ex_dividend_date >= '2024-06-01'
      AND ex_dividend_date <  today() - 3
    GROUP BY id
) AS d
INNER JOIN
(
    SELECT
        sym,
        sess,
        ex_open,
        lagInFrame(close_px, 1) OVER (PARTITION BY sym ORDER BY sess ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS prior_close
    FROM
    (
        SELECT
            ticker     AS sym,
            date       AS sess,
            any(open)  AS ex_open,
            any(close) AS close_px
        FROM global_markets.stocks_daily_aggs
        WHERE ticker IN ('AAPL', 'MSFT', 'KO', 'JNJ', 'PG', 'PEP', 'JPM', 'XOM', 'CVX', 'HD',
                         'MCD', 'WMT', 'IBM', 'CSCO', 'VZ', 'MRK', 'PFE', 'ABBV', 'TXN', 'LLY')
          AND date >= '2024-05-01'
          AND date <  today()
        GROUP BY sym, sess
    )
) AS px ON px.sym = d.sym AND px.sess = d.ex_dt
WHERE px.prior_close > 0
  AND px.ex_open > 0
GROUP BY label
ORDER BY (label = 'All 20 combined') DESC, avg_dividend_pct_of_price DESC