forgashBerachain Transfers (wETH, wBERA // Monad Metrics Guild)
Updated 2024-09-04
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
33
34
35
36
›
⌄
-- forked from nice-ivory @ https://flipsidecrypto.xyz/studio/queries/1d075237-14a1-41dd-a9b8-88c7deeaa477
with
token_transfers AS (
select
block_timestamp,
tx_hash,
contract_address,
contract_name,
decoded_log,
COALESCE(
decoded_log :from :: STRING,
decoded_log :src :: STRING
) AS from_address,
COALESCE(
decoded_log :to :: STRING,
decoded_log :dst :: STRING
) AS to_address,
COALESCE(
decoded_log :value :: DOUBLE,
decoded_log :wad :: DOUBLE,
decoded_log :amount :: DOUBLE
) AS transfer_value
from
berachain.testnet.ez_decoded_event_logs l
where l.block_timestamp >= sysdate() - interval '8 days'
and event_name in ('Deposit', 'Transfer')
and lower(contract_address) in (
lower('0x6e1e9896e93f7a71ecb33d4386b49deed67a231a'),
lower('0x767230a157d9a419d1bea97e0e37f9d2668f6b08'),
lower('0x7507c1dc16935B82698e4C63f2746A2fCf994dF8')
)
)
select
date_trunc('day', block_timestamp) as _date,
contract_address,
contract_name,
QueryRunArchived: QueryRun has been archived