bachizksync distinct wallets
Updated 2022-06-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
⌄
/*SELECT
date(block_timestamp) as day,
round(sum(eth_value),2) as ETH_deposited,
count(distinct from_address) as total_wallets
from flipside_prod_db.ethereum_core.fact_transactions
WHERE date(block_timestamp) >= dateadd(day, -60, getdate())
And to_Address = '0xabea9132b05a70803a4e85094fd0e1800777fbef'
AND eth_value > 0 and eth_value is not null
GROUP BY day
ORDER BY day DESC*/
select date(block_timestamp) as day,
round(sum(amount),2) as ETH_deposited,
round(sum(amount_usd),2) as ETH_deposited_usd,
count(distinct eth_from_address) as total_wallets
from ethereum.core.ez_eth_transfers
WHERE date(block_timestamp) >= dateadd(day, -60, getdate())
And eth_to_address = '0xabea9132b05a70803a4e85094fd0e1800777fbef'
AND amount > 0 and amount is not null
AND amount_usd > 0 and amount_usd is not null
GROUP BY day
ORDER BY day DESC
Run a query to Download Data