adriaparcerisasdogeswap 4
Updated 2025-04-22
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select trunc(block_timestamp,'day') as date,
count(distinct tx_hash) as withdrawns,
sum(withdrawns) over (order by date) as total_withdrawns,
count(distinct args:withdraw:receiver_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 signer_id='intents.near' and action_name='FunctionCall' and method_name='do_native_withdraw'
and receipt_succeeded='TRUE' and block_timestamp<current_date
group by 1 order by 1 desc
QueryRunArchived: QueryRun has been archived