connorhchecking
    Updated 2021-06-30
    WITH dups AS (
    SELECT hour, token_address, COUNT(1) AS N
    FROM ethereum.token_prices_hourly
    WHERE hour >= CURRENT_DATE - 60
    GROUP BY 1,2
    HAVING N > 1)

    SELECT MIN(hour) AS dup_start, MAX(hour) AS dup_end, SUM(N) AS n_dups, COUNT(DISTINCT token_address) AS n_toks
    FROM dups

    Run a query to Download Data