badboyUntitled Query
Updated 2022-10-17
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
›
⌄
select
count
(distinct transactions.tx_hash) as "Transactions",
count (distinct transactions.tx_signer) as "Stakers",
SUM(TRY_PARSE_JSON(calls.args):amount / POW(10,18)) as "Volume"
from
(near.core.fact_transactions transactions)
join
(near.core.fact_actions_events_function_call calls)
ON
(transactions.tx_hash = calls.tx_hash)
where transactions.block_timestamp::date >= CURRENT_DATE - 90
and left
(SPLIT_PART(transactions.tx:receipt[0]:outcome:status, '"', 2), 7) = 'Success'
and transactions.tx_receiver = 'contract.main.burrow.near'
and calls.method_name = 'account_stake_booster'
Run a query to Download Data