Datafi2023-05-04 03:48 PM
Updated 2023-05-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
select
'arbitrum' as chain,
date_trunc('day',block_timestamp) as date,--1
count(distinct from_address) as active_user, --2
count(tx_hash) as no_txs,
count(tx_hash)/count(distinct from_address) as freq
from arbitrum.core.fact_transactions
where block_timestamp >= current_date - interval '365 days'
and status = 'success'
group by 1,2
union all
select
'bsc' as chain,
date_trunc('day',block_timestamp) as date,--1
count(distinct from_address) as active_user, --2
count(tx_hash) as no_txs,
count(tx_hash)/count(distinct from_address) as freq
from bsc.core.fact_transactions
where block_timestamp >= current_date() - interval '365 days'
and status
group by 1,2
Run a query to Download Data