jackguyBase_ez_5 copy
Updated 2023-09-29
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
›
⌄
-- forked from Base_ez_5 @ https://flipsidecrypto.xyz/edit/queries/a61b81a6-9169-44f9-890e-a4aa512de172
with tab1 as (
SELECT
DISTINCT sender as users
FROM axelar.core.ez_squid
WHERE DESTINATION_CHAIN LIKE 'base'
OR SOURCE_CHAIN LIKE 'base'
)
SELECT
avg(active_days),
median(active_days)
FROM (
SELECT
from_address,
count(DISTINCT tx_hash) as events,
count(DISTINCT date_trunc('day', block_timestamp)) as active_days
FROM base.core.fact_transactions
GROUP BY 1
)
WHERE from_address in (SELECT * FROM tab1)
Run a query to Download Data