Afonso_DiazTop Projects
    Updated 2025-03-29
    with

    main as (
    select
    tx_hash,
    tx_receiver as wallet_address,
    block_timestamp
    from
    near.core.ez_actions
    where
    receipt_signer_id ilike '%eth-wallet%'
    and not wallet_address ilike '%.near'
    and wallet_address like '0x%'
    and tx_succeeded
    and year(block_timestamp) >= 2024

    union all

    select
    tx_hash,
    receipt_predecessor_id as wallet_address,
    block_timestamp
    from
    near.core.ez_actions
    where
    receipt_signer_id ilike '%eth-wallet%'
    and not wallet_address ilike '%.near'
    and wallet_address like '0x%'
    and tx_succeeded
    and year(block_timestamp) >= 2024
    ),

    final as (
    select
    tx_hash,
    block_timestamp,
    Last run: 19 days ago
    PROJECT_NAME
    TRANSACTIONS
    1
    ref finance949
    2
    burrow152
    3
    astro stakers113
    4
    proximity92
    5
    aurora 25
    6
    near social23
    7
    meme cooking20
    8
    binance11
    9
    zavodil8
    10
    pyth6
    11
    paras4
    12
    here wallet4
    13
    learn near club3
    14
    keypom3
    15
    here pool2
    16
    coinbase1
    17
    near testnet faucet1
    18
    learnnear1
    18
    307B
    445s