tkvresearchLAYER 2 I txs + user
Updated 2024-07-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
WITH
A AS (
SELECT 'Arbitrum' as chain, block_timestamp, from_address, tx_hash, status FROM arbitrum.core.fact_transactions UNION ALL
SELECT 'Optimism' as chain, block_timestamp, from_address, tx_hash, status FROM optimism.core.fact_transactions UNION ALL
SELECT 'Base' as chain, block_timestamp, from_address, tx_hash, status FROM base.core.fact_transactions
)
select date_trunc('week',block_timestamp) as time, chain,
count(DISTINCT from_address) as "Weekly users",
count(DISTINCT tx_hash) as "Weekly transactions"
from A
where status = 'SUCCESS'
--and date_trunc('week',block_timestamp) != date_trunc('week',current_date())
and time >= date('2023-01-01')
group by 1,2
order by 1 desc
QueryRunArchived: QueryRun has been archived