adriaparcerisasdogeswap 1
Updated 2025-04-22
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select trunc(block_timestamp,'day') as date,
count(distinct tx_hash) as deposits,
sum(deposits) over (order by date) as total_deposits,
count(distinct signer_id) as active_user
--count(distinct predecessor_id) as assets,
--sum(args:amount) as amount,
--avg(args:amount) as avg_amount
from near.core.fact_actions_events_function_call
where block_timestamp>'2024-12-01' and receiver_id='intents.near' and action_name='FunctionCall' and method_name='ft_on_transfer'
and receipt_succeeded='TRUE' and block_timestamp<current_date
group by 1 order by 1 desc
QueryRunArchived: QueryRun has been archived