Moebeefy events 1
Updated 2023-08-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
WITH tab1 as (
SELECT
DISTINCT address
FROM avalanche.core.dim_labels
WHERE project_name LIKE 'beefy finance'
)
SELECT
-- date_trunc('week', block_timestamp) as date,
EVENT_NAME ,
COUNT(DISTINCT tx_hash) as transactions,
COUNT(DISTINCT origin_from_address) as users
FROM avalanche.core.ez_decoded_event_logs
WHERE contract_address in (SELECT * from tab1)
and block_timestamp >= CURRENT_DATE - {{days_back}}
and not event_name in ('Approval','Transfer')
GROUP BY 1 order by 2 desc limit 5
Run a query to Download Data