eferzkSync daily bridge
Updated 2023-04-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
CAST(DATE_TRUNC('day', BLOCK_TIMESTAMP) AS DATE) AS date,
COUNT(DISTINCT ETH_FROM_ADDRESS) AS senders,
SUM(AMOUNT) AS eth,
sum(eth) over (ORDER BY date ASC ROWS BETWEEN unbounded preceding AND CURRENT ROW) AS cumulative,
sum(senders) over (ORDER BY date ASC ROWS BETWEEN unbounded preceding AND CURRENT ROW) AS cumulative_depositors
FROM ethereum.core.ez_eth_transfers
WHERE ETH_TO_ADDRESS = '0xabea9132b05a70803a4e85094fd0e1800777fbef'
-- AND AMOUNT > 0
AND date > CURRENT_DATE - 60
AND ORIGIN_FUNCTION_SIGNATURE = '0x2d2da806'
GROUP BY date
ORDER BY date DESC
Run a query to Download Data