flipside

    tricky-plum copy
    Mrftitricky-plum copy
    Updated 2 hours ago
    -- forked from tricky-plum @ https://flipsidecrypto.xyz/studio/queries/31e4eca4-65fd-47db-aac5-9584c24c0809

    WITH assettbl AS (
    SELECT
    origin_from_address AS user,
    DATE_TRUNC('day', block_timestamp) AS date,
    CASE
    WHEN contract_name = 'EVK Vault eswETH-1' THEN 'SWETH'
    WHEN contract_name = 'EVK Vault epzETH-1' THEN 'PZETH'
    WHEN contract_name = 'EVK Vault eweETH-1' THEN 'WEETH'
    WHEN contract_name = 'EVK Vault eezETH-1' THEN 'EZETH'
    WHEN contract_name = 'EVK Vault eWETH-1' THEN 'WETH'
    WHEN contract_name = 'EVK Vault ersETH-1' THEN 'RSETH'
    WHEN contract_name = 'EVK Vault erswETH-1' THEN 'RSWETH'
    WHEN contract_name = 'EVK Vault ewstETH-1' THEN 'WSTETH'
    END AS token,
    contract_address,
    event_name,
    SUM(decoded_log:assets / POW(10, 18)) AS amount
    FROM
    swell.core.ez_decoded_event_logs
    WHERE
    event_name IN ('Deposit', 'Borrow', 'Repay', 'Withdraw')
    AND origin_to_address = '0x08739cbede6e28e387685ba20e6409bd16969cde'
    GROUP BY 1, 2, 3, 4, 5
    ),
    pricetbl AS (
    SELECT
    DATE_TRUNC('day', hour) AS date,
    symbol,
    AVG(price) AS price -- Using AVG to handle multiple hourly price records
    FROM
    crosschain.price.ez_prices_hourly
    WHERE
    blockchain = 'ethereum'
    GROUP BY 1, 2
    Last run: about 2 hours agoAuto-refreshes every 12 hours
    Total Users
    Total Volume (USD)
    1
    		190100055050.107576
    1
    24B
    6s