Total deposits | Total deposit tx | Total unique depositors | |
|---|---|---|---|
1 | 247432629.640473 | 783892 | 225965 |
MrftibHONEY copy
Updated 2025-02-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
-- forked from bHONEY @ https://flipsidecrypto.xyz/studio/queries/576cd2f2-6c9e-4997-82f9-9186dd73f91a
with tbl AS
(
SELECT
block_timestamp,
tx_hash,
'0x' || SUBSTR(PARSE_JSON(TOPICS)[1]::string, -40) AS user_address,
utils.udf_hex_to_int(DATA)/pow (10,18) as amount
from berachain.testnet.fact_event_logs
where contract_address = lower ('0x7d91Bf5851B3A8bCf8C39A69AF2F0F98A4e2202A') -- bHONEY
and ORIGIN_FUNCTION_SIGNATURE = '0xa694fc3a'
order by 1 desc
)
SELECT
sum (amount) as "Total deposits",
count (DISTINCT tx_hash) as "Total deposit tx",
count (DISTINCT user_address) as "Total unique depositors"
from tbl
Last run: about 2 months ago
1
34B
539s