Total deposits | Total deposit tx | Total unique depositors | |
|---|---|---|---|
1 | 1120780717735.19 | 1790 | 1233 |
MrftiHONEY-WETH-LP copy
Updated 9 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- forked from HONEY-WETH-LP @ https://flipsidecrypto.xyz/studio/queries/9d36f063-9a72-4fc0-bf09-19dbbd1ed76d
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 ('0xA9480499b1fAeAf225cEb88ADe69de10b7f86c1e') -- HONEY-WETH-LP
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: 9 days agoAuto-refreshes every 12 hours
1
30B
102s