Ramahartest $NEKO add profit
Updated 2023-02-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
›
⌄
With treasury_add as (select
tx_hash,
block_timestamp,
tx_signer,
tx,
tx:actions[0]:FunctionCall:method_name as actions,
tx:actions[0]:FunctionCall:deposit as deposit_type --24
from near.core.fact_transactions
where tx_receiver = 'cookie.nekotoken.near'
AND tx_status = 'Success'
--AND tx_signer != 'nekotoken.near'
and actions = 'add_neko_profit')
select
--a.tx_hash,
--a.block_timestamp,
sum(args:amount::float / POW(10,24)) AS token_amount
--tx_signer as receivers,
--actions
from near.core.fact_actions_events_function_call a
join treasury_add b ON a.tx_hash = b.tx_hash
where actions = 'add_neko_profit' --and a.tx_hash = 'HmXrRKFTMwZ5CgyaTUxZHaH8jHNeo9C3uLnrkExts427'
--and method_name = 'ft_transfer'
and tx_signer != 'treasury.nekotoken.near'
Run a query to Download Data