mattkstewIOTW 4
Updated 2023-02-22
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
28
›
⌄
with tab1 as (
select
tx_hash
from near.core.fact_actions_events
where action_name like 'DeployContract'
and block_timestamp > current_date - 7
)
, tab2 as (
select
tx_signer
from near.core.fact_transactions
where tx_hash in (select tx_hash from tab1)
)
select
date_trunc('day', block_timestamp),
tx_signer as "Contract",
count(*) as "Transfers Sent",
sum(deposit/power(10,24)) as "Transfer Volume Sent"
from near.core.fact_transfers
where near.core.fact_transfers.tx_signer in (select * from tab2)
and near.core.fact_transfers.block_timestamp > current_date - 7
and tx_signer not like 'linguists.near'
group by 1,2
Run a query to Download Data