Symbol | Payment type | Amount in native tokens | USD equivalent amount | Date time | |
|---|---|---|---|---|---|
1 | ETH | Others | 0.01 | 22.68 | 2024-01-29 16:42:24.000 |
2 | ETH | Others | 0.00075 | 1.7 | 2024-01-29 16:42:24.000 |
3 | ETH | Others | 0.00025 | 0.57 | 2024-01-29 16:42:24.000 |
4 | ETH | Others | 0.009 | 20.42 | 2024-01-29 16:42:24.000 |
5 | ETH | NFT | 0.0666 | 150.18 | 2024-01-28 22:22:54.000 |
6 | ETH | NFT | 0.061605 | 138.92 | 2024-01-28 22:22:54.000 |
7 | ETH | NFT | 0.001665 | 3.75 | 2024-01-28 22:22:54.000 |
8 | ETH | NFT | 0.00333 | 7.51 | 2024-01-28 22:22:54.000 |
9 | ETH | NFT | 0.0005 | 1.1 | 2024-01-25 15:27:20.000 |
10 | ETH | NFT | 0.0195 | 43.06 | 2024-01-25 15:27:20.000 |
adriaparcerisasSunloan payments: Arbitrum
Updated 2024-01-30
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
nfts as (
select tx_hash,block_timestamp,'ETH' as symbol, amount
from arbitrum.core.ez_eth_transfers
where origin_to_address='0xef0b56692f78a44cf4034b07f80204757c31bcc9'
and origin_function_signature='0x88a7765b'
and eth_from_address='0xef0b56692f78a44cf4034b07f80204757c31bcc9'
union
select tx_hash,block_timestamp, case when symbol is null then 'CVPA' else symbol end as symbol, case when decimals is not null then raw_amount/pow(10,decimals) else raw_amount end as amount
from arbitrum.core.ez_token_transfers
where origin_to_address='0xef0b56692f78a44cf4034b07f80204757c31bcc9'
and origin_function_signature='0x88a7765b'
and from_address='0xef0b56692f78a44cf4034b07f80204757c31bcc9'
),
data as (
select
'ETH' as symbol,
amount,
amount_usd,
block_timestamp,
tx_hash
from arbitrum.core.ez_eth_transfers
where origin_to_address = lower('0xEF0B56692F78A44CF4034b07F80204757c31Bcc9')
-- 0xd75233704795206de38Cc58B77a1f660B5C60896
UNION
select
symbol,
amount,
amount_usd,
block_timestamp,
tx_hash
from arbitrum.core.ez_token_transfers
where origin_to_address = lower('0xEF0B56692F78A44CF4034b07F80204757c31Bcc9')
)
SELECT
symbol as "Symbol",
Last run: about 1 year agoAuto-refreshes every 3 hours
10
542B
106s