ArioSWEAT Details - Number of wallets created
    Updated 2022-09-20
    with wallets as (
    select
    TX_HASH,
    tx_signer,
    tx_receiver as wallets,
    deposit/1e24 as adjusted_deposit
    FROM near.core.fact_Transfers
    WHERE (tx_signer = 'sweat_welcome.near'
    or tx_signer like '%sweat_oracle_%')
    AND adjusted_deposit < 0.06
    and status = TRUE
    )
    SELECT
    count(distinct wallets) as N_wallets_created
    FROM wallets


    Run a query to Download Data