flipside

    Sunloan payments: all
    adriaparcerisasSunloan payments: all
    Updated 2024-01-30

    with
    eth_data as (
    select
    'ETH' as symbol,
    amount,
    amount_usd,
    block_timestamp,
    tx_hash
    from ethereum.core.ez_eth_transfers
    where origin_to_address = lower('0xEF0B56692F78A44CF4034b07F80204757c31Bcc9')
    and eth_from_address='0xef0b56692f78a44cf4034b07f80204757c31bcc9'
    -- 0xd75233704795206de38Cc58B77a1f660B5C60896
    UNION
    select
    symbol,
    amount,
    amount_usd,
    block_timestamp,
    tx_hash
    from ethereum.core.ez_token_transfers
    where origin_to_address = lower('0xEF0B56692F78A44CF4034b07F80204757c31Bcc9')
    and from_address='0xef0b56692f78a44cf4034b07f80204757c31bcc9'

    ),
    eth as (
    SELECT
    symbol as "Symbol", --case when tx_hash in (select distinct tx_hash from nfts) then 'NFT' else 'Others' end as "Payment type",
    amount as "Amount in native tokens",
    amount_usd as "USD equivalent amount",
    block_timestamp as "Date time"
    from eth_data where amount_usd is not NULL
    and amount<1e9
    --and symbol in (select symbol from ethereum.price.ez_hourly_token_prices)
    order by 4 desc

    Last run: about 1 year agoAuto-refreshes every 3 hours
    CHAIN
    Symbol
    Amount in native tokens
    USD equivalent amount
    Date time
    1
    		EthereumETH0.01534.572024-01-29 21:55:59.000
    2
    		PolygonMATIC2016.272024-01-29 21:54:19.000
    3
    		PolygonMATIC1512.22024-01-29 21:50:44.000
    4
    		PolygonMATIC2016.272024-01-29 21:47:34.000
    5
    		EthereumETH0.042597.942024-01-29 21:31:23.000
    6
    		EthereumETH0.1098253.032024-01-29 21:23:59.000
    7
    		EthereumETH0.057131.362024-01-29 21:23:23.000
    8
    		EthereumETH0.054899126.512024-01-29 21:04:59.000
    9
    		EthereumETH0.008920.472024-01-29 20:51:23.000
    10
    		EthereumETH0.042998.662024-01-29 20:48:35.000
    10
    574B
    502s