forgashBerachain Transfers (wETH, wBERA // Monad Metrics Guild)
    Updated 2024-09-04
    -- 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