Total Transactions | Total Deposit Txs | Total Withdraw Txs | Unique Depositors | Unique Withdrawers | Withdrawers % | |
|---|---|---|---|---|---|---|
1 | 62327 | 42609 | 20160 | 33994 | 15528 | 45.6786 |
hbd19940. ovr
Updated 8 days ago
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
27
28
29
30
31
32
›
⌄
with base as (
select
case
when to_address = '0x8bc93498b861fd98277c3b51d240e7e56e48f23c' then 'Deposit'
else 'Withdraw' end as action,
BLOCK_TIMESTAMP,
TX_HASH,
ORIGIN_FROM_ADDRESS,
ORIGIN_TO_ADDRESS,
CONTRACT_ADDRESS,
SYMBOL,
FROM_ADDRESS,
TO_ADDRESS,
CASE
WHEN ACTION = 'Deposit' then AMOUNT
else AMOUNT * (-1) end as volume,
CASE
WHEN ACTION = 'Deposit' then AMOUNT_USD
else AMOUNT_USD * (-1) end as volume_usd
from ethereum.core.ez_token_transfers
where (to_address = '0x8bc93498b861fd98277c3b51d240e7e56e48f23c' or from_address = '0x8bc93498b861fd98277c3b51d240e7e56e48f23c')
and symbol != 'BTCN')
select
COUNT(DISTINCT TX_HASH) as "Total Transactions",
count(distinct case when action = 'Deposit' then tx_hash end) as "Total Deposit Txs",
count(distinct case when action = 'Withdraw' then tx_hash end) as "Total Withdraw Txs",
count(distinct ORIGIN_FROM_ADDRESS) as "Unique Depositors",
count(distinct case when action = 'Withdraw' then ORIGIN_FROM_ADDRESS end) as "Unique Withdrawers",
"Unique Withdrawers" / "Unique Depositors" * 100 as "Withdrawers %"
from base
Last run: 8 days agoAuto-refreshes every 12 hours
1
41B
21s