jackguyBase 100
Updated 2023-09-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with tab1 as (
SELECT
DISTINCT sender as users
FROM axelar.core.ez_squid
WHERE DESTINATION_CHAIN LIKE 'base'
OR SOURCE_CHAIN LIKE 'base'
)
SELECT
date_trunc('day', block_timestamp) as day,
count(DISTINCT tx_hash) as Transactions,
count(DISTINCT from_address) as active_users
FROM base.core.fact_transactions
WHERE from_address in (SELECT * FROM tab1)
GROUP BY 1
Run a query to Download Data