Afonso_DiazTop Projects
    Updated 2025-04-19
    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 finance1033
    2
    burrow177
    3
    astro stakers127
    4
    proximity102
    5
    near social26
    6
    aurora 25
    7
    meme cooking20
    8
    binance11
    9
    pyth11
    10
    zavodil8
    11
    paras4
    12
    here wallet4
    13
    keypom3
    14
    learn near club3
    15
    here pool2
    16
    coinbase1
    17
    learnnear1
    18
    near testnet faucet1
    18
    310B
    714s