Sbhn_NPslim-fuchsia
Updated 2024-12-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
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