connorhchecking
Updated 2021-06-30
99
1
2
3
4
5
6
7
8
9
10
›
⌄
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