flipside

    User Stats
    dannyamahUser Stats
    Updated 1 day ago
    WITH rain AS (
    SELECT
    live.udf_api(
    'GET'
    ,concat('https://api-v2.rain.fi/users/user?owner=','{{input_address}}')
    , { 'Content-Type': 'application/json' }
    , {}
    ) as response
    )

    select
    TO_TIMESTAMP(value:createdAt) AS date,
    value:owner AS user_address,
    value:totalVolumeBorrower AS total_borrow_volume,
    value:totalVolumePool AS total_pool_volume,
    value:totalLoan AS loans,
    value:currentLoan AS currentLoan,
    value:totalMortgage AS mortgages,
    value:totalLiquidation AS liquidations,
    value:hasPool AS Pool,
    value:droplets AS droplets,
    from rain,
    lateral flatten(input => response:data)
    WHERE date < date(current_date)
    AND date > '2023-10-01'
    ORDER BY date DESC
    Last run: 1 day ago
    DATE
    USER_ADDRESS
    TOTAL_BORROW_VOLUME
    TOTAL_POOL_VOLUME
    LOANS
    CURRENTLOAN
    MORTGAGES
    LIQUIDATIONS
    POOL
    DROPLETS
    1
    		2024-04-12 13:21:29.000
    7egMhjch4ECjBiWR7xVufidveuVSRg92LeQnmr8wYaYG
    3138
    0
    17
    0
    0
    0
    		FALSE
    182106.1
    1
    119B
    2s