mrwildcatzksync: ETH deposited daily
Updated 2022-06-17
9
1
2
3
4
5
6
7
8
9
›
⌄
-- How much ETH was deposited by day?
--select count(DISTINCT(ETH_FROM_ADDRESS)) from ethereum.core.ez_eth_transfers where eth_to_address = lower('0xaBEA9132b05A70803a4E85094fD0e1800777fBEF')
--and block_timestamp >= CURRENT_DATE - INTERVAL '60 day'
SELECT date_trunc( 'day', block_timestamp ) AS date,
sum (CASE WHEN eth_to_address = lower('0xaBEA9132b05A70803a4E85094fD0e1800777fBEF') THEN amount END ) as eth_deposited
FROM ethereum.core.ez_eth_transfers
WHERE block_timestamp > CURRENT_DATE - INTERVAL '60 days'
GROUP BY date_trunc( 'day', block_timestamp )
Run a query to Download Data