TRANSACTIONS | USER_ADDRESS | AMOUNT | MAXIMUM_AMOUNT | MINIMUM_AMOUNT | AVERAGE_AMOUNT | |
|---|---|---|---|---|---|---|
1 | 111638 | 109379 | 72306767.6741021 | 4555698.09058724 | 0.0007493395485 | 647.689565149 |
freemartianTotal Claimes
Updated 1 hour ago
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
29
30
31
32
33
34
35
36
›
⌄
with
steal as (
select * , ROW_NUMBER() OVER (PARTITION BY tx_hash ORDER BY event_index) AS row_num
from ethereum.core.ez_token_transfers
where origin_from_address = '0xfde0d1575ed8e06fbf36256bcdfa1f359281455a'
and origin_to_address = '0x80bf7db69556d9521c03461978b8fc731dbbd4e4'
and origin_function_signature = '0x9846cd9e'
and contract_address = '0x28d38df637db75533bd3f71426f3410a82041544'
and block_timestamp::date >= '2025-04-10'
),
claims as (
select *, 1 as row_num
from ethereum.core.ez_token_transfers
where contract_address = '0x28d38df637db75533bd3f71426f3410a82041544'
and from_address = '0x77a6149395ca96b13df5bbd634965bcfbeedb1c9'
and origin_function_signature = '0xcfd2afa9'
and block_timestamp >= '2025-04-10 12:00:00.000'
-- and tx_hash not in (select tx_hash from steal)
union all
select * , 1 as row_num
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'
union all
select * , ROW_NUMBER() OVER (PARTITION BY tx_hash ORDER BY event_index) AS row_num
from ethereum.core.ez_token_transfers
where origin_from_address = '0xfde0d1575ed8e06fbf36256bcdfa1f359281455a'
and origin_to_address = '0x80bf7db69556d9521c03461978b8fc731dbbd4e4'
and origin_function_signature = '0x9846cd9e'
Last run: about 1 hour agoAuto-refreshes every 1 hour
1
81B
5s