TRANSACTIONS | USERS | DIALY_AVERAGE_TXNS | DIALY_AVERAGE_USERS | |
|---|---|---|---|---|
1 | 2574763 | 111196 | 1898.792773 | 82.00295 |
Afonso_DiazTotal
Updated 2025-04-22
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
›
⌄
with
main as (
select
tx_id,
block_timestamp,
pool_address,
provider_address as user,
pool_name,
platform,
token_a_amount_usd + token_b_amount_usd as amount_usd,
action_type as event_name
from
solana.marinade.ez_liquidity_pool_actions
)
select
count(distinct tx_id) as transactions,
count(distinct user) as users,
transactions / count(distinct block_timestamp::date) as dialy_average_txns,
users / count(distinct block_timestamp::date) as dialy_average_users
from
main
Last run: about 1 month ago
1
39B
3s