bachioptimism - dep vs wth
Updated 2022-06-17
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
⌄
/*select date(block_timestamp) as day, count(distinct from_address) as wallets
--'Deposit' as tran_type
from ethereum.core.ez_token_transfers where to_Address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'
and block_timestamp >= dateadd(day, -60, getdate())
group by day*/
select date(block_timestamp) as day, count(distinct to_address) as wallets
--'Deposit' as tran_type
from ethereum.core.ez_token_transfers where from_address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'
and block_timestamp >= dateadd(day, -60, getdate())
group by day
Run a query to Download Data