TRANSACTIONS | USER_ADDRESS | AMOUNT | MAXIMUM_AMOUNT | MINIMUM_AMOUNT | AVERAGE_AMOUNT | |
|---|---|---|---|---|---|---|
1 | 105730 | 104576 | 17868208.7111679 | 916844.760603315 | 0.001124009323 | 168.998474522 |
freemartianTotal Claimes- BASE
Updated 45 minutes ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with claims as (
select *
from base.core.ez_token_transfers
where
contract_address = '0x30c7235866872213f68cb1f08c37cb9eccb93452'
and from_address = '0x7c8aa3dd42fc0c9646552c638af532eb56ccbea8'
and origin_function_signature = '0xcfd2afa9'
and block_timestamp >= '2025-04-10 12:00:00.000'
)
select
count(tx_hash) as transactions,
count(distinct to_address) as user_address,
SUM(amount) as amount,
MAX(amount) as maximum_amount,
MIN(amount) as minimum_amount,
AVG(amount) as average_amount
from claims
Last run: about 1 hour agoAuto-refreshes every 1 hour
1
80B
54s