Mrftitricky-plum copy
    Updated 10 hours ago
    -- forked from tricky-plum @ https://flipsidecrypto.xyz/studio/queries/4486e2a6-3c7a-4a9f-bd79-e1ad1a68e6fc
    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
    FROM
    crosschain.price.ez_prices_hourly
    WHERE
    blockchain = 'ethereum'
    GROUP BY 1, 2
    )
    Last run: about 10 hours agoAuto-refreshes every 12 hours
    USER
    Total Events (USD)
    1
    0x1b648ade1ef219c87987cd60eba069a7faf1621f22488884.2022619
    2
    0x0c883bacaf927076c702fd580505275be44fb63e21832645.2506337
    3
    0x29dfdd80d6acc0f9028d8a6fa7d7d448342e25c17950718.97201739
    4
    0x5c0642fe68fc72cf03f676b28faf5cf97cc0b2655590283.39904498
    5
    0xfc88e456b3a5620e63a449ce429dccf2687cac264334455.02008888
    6
    0xa6086e3190c145f1b6b089de98b1866296137a504249811.9513994
    7
    0x19391f0a0d3b6409e57faef5f62bc509433b3d2e3713385.70289559
    8
    0xacae46375cef811bab8f3d572b2dab327085c6093492654.15906251
    9
    0xe641e37ea4846374c4b9347af6a4979acae79cbc2714566.73318527
    10
    0xbc3a058d1c919f6b1f48e8846246d04d467902c82534354.4971875
    11
    0xf91d92176255b58bb631e36973e44cae271570a52087582.93096338
    12
    0x5b9effdcbd65946f2b143725dc244563248aa4ee1740631.20007532
    13
    0x2d689f316cd3b7a0faa03f341ef0137fb0cdb70c1661613.0748412
    14
    0xcdbcf8b223e7b2612a394a83caf6052ff79d70301246613.46282814
    15
    0x1fe6eb1add4a58d9ca4fe68467492f9a1a350d4d799277.930325327
    16
    0x42ed8ca138de808fd22afc29928f09ad4a31e7c3782873.982359433
    17
    0x2ccebdf8f9d2da7ba0cdae60886cdac4f827a568703892.332446992
    18
    0xefc0f8be7afd2eb878956450d1f484cfb3368417668531.293557266
    19
    0x1d098a8d7fa63a39e0884b720f86f9ba8cbbeef1667607.112459411
    20
    0x4086f688855dcae061e7f68fc181566fffa856ea632192.13152387
    100
    6KB
    179s