AMOUNT | |
|---|---|
1 | 143.621039 |
csp88gLeft in pool
Updated 2025-05-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with prize_pool as (
select
AMOUNT_PRECISE as win_amount,
TO_ADDRESS as user,
*
from near.core.ez_token_transfers
where contract_address = '17208628f84f5d6ad33f0da3bbbeb27ffcb398eac501a31bd6ad2011e36133a1'
and FROM_ADDRESS = 'aa-harvest-moon.near'
and block_timestamp::date >= '2024-11-17'
and block_timestamp::date < '2024-12-17'
and transfer_type = 'nep141'
)
select 25000 - sum(win_amount) as Amount
from prize_pool
Last run: about 1 month ago
1
14B
6s