ELAYNumber of users in contracts
Updated 2022-10-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with metapool as ( select count(distinct tx_signer),date_trunc('day', block_timestamp)
from near.core.fact_transactions
where date_trunc('day', block_timestamp) > current_date - 90
and tx_receiver='meta-pool.near'
group by date_trunc('day', block_timestamp))
,contractmainburrow as (select count(distinct tx_signer),date_trunc('day', block_timestamp)
from near.core.fact_transactions
where date_trunc('day', block_timestamp) > current_date - 90
and tx_receiver='contract.main.burrow.near'
group by date_trunc('day', block_timestamp) )
select 'meta-pool.near' , *
from metapool
UNION ALL
select 'contract.main.burrow.near' , *
from contractmainburrow
Run a query to Download Data