flipside

    Sunloan payments 2: Arbitrum
    adriaparcerisasSunloan payments 2: Arbitrum
    Updated 2024-01-30
    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')
    UNION
    select
    symbol,
    amount,
    amount_usd,
    block_timestamp,
    tx_hash
    from arbitrum.core.ez_token_transfers
    where origin_to_address = lower('0xEF0B56692F78A44CF4034b07F80204757c31Bcc9')
    )
    SELECT
    trunc(block_timestamp,'day') as "Date",
    case when tx_hash in (select distinct tx_hash from nfts) then 'NFT' else 'Others' end as "Payment type",
    Last run: about 1 year agoAuto-refreshes every 3 hours
    Date
    Payment type
    # of payments
    Volume amount (USD)
    1
    		2023-07-30 00:00:00.000NFT16.3
    2
    		2023-08-04 00:00:00.000NFT3544.28
    3
    		2023-08-05 00:00:00.000NFT3387.03
    4
    		2023-08-06 00:00:00.000NFT1657.89
    5
    		2023-08-08 00:00:00.000NFT2135.1
    6
    		2023-08-09 00:00:00.000NFT1390.42
    7
    		2023-08-10 00:00:00.000NFT19.26
    8
    		2023-08-11 00:00:00.000NFT1101.53
    9
    		2023-08-12 00:00:00.000NFT1516.66
    10
    		2023-08-14 00:00:00.000NFT11087.31
    11
    		2023-08-16 00:00:00.000NFT1216.22
    12
    		2023-08-17 00:00:00.000NFT116.84
    13
    		2023-08-19 00:00:00.000NFT1180.46
    14
    		2023-08-23 00:00:00.000NFT114.68
    15
    		2023-08-24 00:00:00.000NFT6742.89
    16
    		2023-08-25 00:00:00.000NFT565981.94
    17
    		2023-08-26 00:00:00.000NFT421940.8
    18
    		2023-08-26 00:00:00.000Others132884.8
    19
    		2023-08-27 00:00:00.000NFT281748.23
    20
    		2023-08-28 00:00:00.000NFT311584.92
    ...
    173
    7KB
    61s