Sbhn_NPslim-fuchsia
    Updated 2024-12-22
    select date_trunc('day',block_timestamp) as date,
    count(DISTINCT from_address) as users,
    sum(amount) as gear,
    sum(amount_usd) as usd,
    sum(gear) over (order by date) as cumulative_gear,
    sum(usd) over (order by date) as cumulative_usd
    from near.core.ez_token_transfers
    where to_address = 'meme-farming_011.ref-labs.near'
    and contract_address = 'gear.enleap.near'
    and transfer_type = 'nep141'
    and date >= '2024-09-01'
    group by 1
    order by 1 desc
    QueryRunArchived: QueryRun has been archived