RECEPIENTS | TOTAL_ETH_AMOUNT | TOTAL_USD_AMOUNT | |
|---|---|---|---|
1 | 1000 | 150 | 496424.78 |
Sandeshkaito-rewards
Updated 2025-02-21
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 kaito_rewards as (
with disperse_rewards as (
select
*
from
base.core.ez_native_transfers
where
1 = 1
and tx_hash in (
'0x2360798fd7cb4b006f958aaea0058b609a0156c99b734cf08a858b0102d700ec',
'0x4ea5f0d542e2bb877dded54546a1fda428b9888c9c3896203ee5ee4a0c47dc4a',
'0xdd6b5bce11a371c626abfeb92972cee4a59a77980039127ec8771ec24447be63'
)
and block_timestamp > '2025-01-09'
and to_address != '0xd152f549545093347a162dce210e7293f1452150'
and origin_from_address = '0x81f03983626e528f30da9776774e413f3e2b1e7c'
and origin_to_address = '0xd152f549545093347a162dce210e7293f1452150'
and from_address = '0xd152f549545093347a162dce210e7293f1452150'
),
singular_transaction_rewards as (
select
*
from
base.core.ez_native_transfers
where
1 = 1
and tx_hash in (
'0xc88b8ee10aa1018acb5055721be3364d7634db1538ebf2fe37379dc494b44534',
-- single txn not done through disperse
'0x9f493f4ae40c606cdb1eedca0fdb5141db3f37cd616dc9d2f989bacc4fc0cef4',
-- single txn not done through disperse
'0x3c22917ac72edb21821c93736f654a114f33c83b87058d910c85d3dfd05e9b71' -- single txn not done through disperse
)
and block_timestamp > '2025-01-09'
and to_address != '0xd152f549545093347a162dce210e7293f1452150'
)
Last run: about 2 months ago
1
22B
4s